INTRODUCTION TO RDBMS & BASIC TERMINOLOGY OF RDBMS || RELATIONAL DATABASE MANAGEMENT SYSTEM || DBMS

  Рет қаралды 90,543

Sundeep Saradhi Kanthety

Sundeep Saradhi Kanthety

2 жыл бұрын

INTRODUCTIONT TO RDBMS
RDBMS - Relational Database Management System
BASIC TERMINOLOGY
Relation - Table
Tuple / Record - Rows
Attribute - Columns
Data Cell - Intersection between Tuple & Attribute
Degree - No. of Columns
Cardinality - No. of Rows
Domain - Possible values given for an Attribute
NULL Values - If data cell left blank during data insertion will filled with NULL
----------------------------------------------------------------------------------------------------------------
DATABASE MANAGEMENT SYSTEM
• DATABASE MANAGEMENT SY...
PYTHON PROGRAMS
• PYTHON PROGRAMS
C PROGRAMMING
• 01 - VARIABLES & CONST...
CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS
• CORE JAVA TUTORIAL FOR...
HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS
• HTML TUTORIALS WITH IM...
LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS
• LEARN CSS IN 3 HOURS |...
JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT
• JAVA SCRIPT FOR BEGINN...
PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)
• PYTHON TUTORIAL FOR BE...
PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)
• PYTHON - OOPS CONCEPTS...
PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU
• PYTHON NUMPY TUTORIAL ...
PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE
• PYTHON PANDAS TUTORIAL...
MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)
• MATPLOTLIB LIBRARY - P...
PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL
• PYTHON DATABASE CONNEC...
DATA STRUCTURES USING PYTHON (ENGLISH)
• DATA STRUCTURES USING ...
----------------------------------------------------------------------------------------------
Instagram : / sundeepsaradhikanthety

Пікірлер: 47
@rz4562
@rz4562 10 ай бұрын
00:02 📚 Introduction to RDBMS and its Basic Terminology RDBMS stands for Relational Database Management System. Data is organized in tables (relations) composed of rows and columns. Modern software often utilizes RDBMS for data management. Key terminologies include relation (table), tuples (records), attributes (columns), data cells (intersections), and more. Understanding these basics is crucial for working with RDBMS. 02:00 🗂 Relations (Tables) in RDBMS In RDBMS, relations are synonymous with tables. Tables organize data into rows and columns. Each row represents a tuple or record. Example: A student table stores student IDs, names, and percentages. Tables make data organization and access efficient. 03:48 📦 Tuples (Records) in RDBMS Tuples are individual rows or records in a table. Tuples should not contain duplicate values. Each tuple follows a consistent format. Example: Student details are organized into tuples. Tuples are essential for data integrity and consistency. 05:41 📝 Attributes (Columns) in RDBMS Attributes are columns in a table. Each attribute must have a unique name. One attribute is designated as the primary key for uniqueness. Example: Student ID, Student Name, and Percentage are attributes. Attributes help define the structure of the data. 08:13 🧱 Data Cells (Intersections) in RDBMS Data cells are intersections of tuples and attributes. They contain actual data values. Data cells should be atomic, meaning they have a single value. Example: Each cell in the table represents a specific data point. Atomic data cells ensure consistency and simplicity. 10:18 📊 Cardinality and Degree in RDBMS Cardinality refers to the number of tuples or rows in a table. Degree is the number of attributes or columns in a table. Example: A student table may have a cardinality of 3 and a degree of 3. Cardinality and degree help describe the size and structure of the data. 12:07 🌐 Domain in RDBMS Domain represents the possible values an attribute can have. It defines the valid range of values for an attribute. Example: The domain for a percentage attribute is 0 to 100. Domains ensure data accuracy and integrity. 13:16 🚫 Null Values in RDBMS Null values represent missing or unspecified data. They are not the same as 0 or empty spaces. Null values indicate that data is not available. Example: If a cell is left blank during data insertion, it's considered a null value. Understanding null values is crucial for data quality assurance.
@divyadivya-ex5hq
@divyadivya-ex5hq Жыл бұрын
Sir you are the Savior
@diego16160
@diego16160 Жыл бұрын
You explain things in an excellent and easy to understand and remember way. Thank you for this tutorial
@anirudhvakale9012
@anirudhvakale9012 Жыл бұрын
You are the my favourite teacher ❤❤ जब से आपको देखा हैं आपके teaching का दिवाना हो गया हुं ❤❤
@rutujakamane2410
@rutujakamane2410 Жыл бұрын
I have understood everything and I must say you're very good teacher
@bretthl1
@bretthl1 Жыл бұрын
best explanation I have seen. really good, thank you.
@mini.vlogs.by.besties
@mini.vlogs.by.besties Жыл бұрын
Mind-blowing ✨👌
@jyothireddy8910
@jyothireddy8910 10 ай бұрын
Thanks for your wonderful teaching
@mdsalman3890
@mdsalman3890 Жыл бұрын
Thanks sir for simple explaination.
@b.venkatasubbaiah1648
@b.venkatasubbaiah1648 2 жыл бұрын
This will help to many people
@tobiawosola1602
@tobiawosola1602 6 ай бұрын
Well done, I like the Way you Explained the concepts.
@divyaroyals1652
@divyaroyals1652 Жыл бұрын
Very well explained thankyou sir...!
@mini.vlogs.by.besties
@mini.vlogs.by.besties Жыл бұрын
Amazing teaching
@user-mn2qs7fi5l
@user-mn2qs7fi5l 9 ай бұрын
Your explanation is Awesome sir
@MariaJasmine-bx5cv
@MariaJasmine-bx5cv 8 ай бұрын
Best explanation I have seen thank you sir ☺️
@vijjutherockstar4994
@vijjutherockstar4994 6 ай бұрын
Your teaching is so good sir I understood easily....
@innocent1040
@innocent1040 Жыл бұрын
you are really good in teaching things , but what i would recommend is that you keep things already written on whiteboard cause it will save time for us and you can explain us more about the topic in that time .
@micjessi3008
@micjessi3008 Жыл бұрын
Very helpful... ❤❤❤❤❤❤❤❤❤
@shakernawaabbolte1086
@shakernawaabbolte1086 Ай бұрын
Thank you soo much akka for all explanations of all subjects thank you ❤
@VinodKumar-cq3bp
@VinodKumar-cq3bp 2 жыл бұрын
Sir , please continue this Play list, as the first two videos of this playlist has very long gap to the third one. It will be very thankful if you continue this playlist.
@ajaygangarapu7798
@ajaygangarapu7798 Жыл бұрын
good explanation
@programer6522
@programer6522 Жыл бұрын
Thanks for helping us sir
@HelloVijju
@HelloVijju Жыл бұрын
Love you sir super 👌👌👌👌👌
@BilalMalik-px2gp
@BilalMalik-px2gp 6 ай бұрын
nicely explained
@DJBOY_DHAGAD_KAA_BAP
@DJBOY_DHAGAD_KAA_BAP Жыл бұрын
Super
@suyashshrouti
@suyashshrouti 6 ай бұрын
Thank you sir
@rajeshmay299
@rajeshmay299 2 жыл бұрын
Thank you sir, worthful. Pls upload sql , oracle video. Im non-IT guy. I have infoys interview .
@stanleyabrahampaul4798
@stanleyabrahampaul4798 Жыл бұрын
Thanks Sundeep Sir...! Learned about the Relational Database..!! Can you please advise the company's interview process and How to crack an interview without fear...
@fog2640
@fog2640 11 ай бұрын
finished watcing
@RAJUEDITS1
@RAJUEDITS1 Жыл бұрын
nice sir
@mohdaneeschaudhary8309
@mohdaneeschaudhary8309 2 жыл бұрын
sir please upload complete lecture of DBMS may help this lecture lots for job
@b.venkatasubbaiah1648
@b.venkatasubbaiah1648 2 жыл бұрын
as early as possible
@Shravani007
@Shravani007 Жыл бұрын
Sir a request from my side please upload a videon on paper pattern and presentation (lenth of the answer in exam) Important topics also
@yaseenka485
@yaseenka485 3 ай бұрын
Thank you sir🤍
@ayaanali7315
@ayaanali7315 2 ай бұрын
Me watching this just 2 hours before my exam .
@Mounica.vadithya
@Mounica.vadithya Жыл бұрын
Can u say the topics of triggers.. packages.. nd cursor
@b.venkatasubbaiah1648
@b.venkatasubbaiah1648 2 жыл бұрын
videos upload cheyyandi sir related this
@GurubalaKumaresan-yh9bm
@GurubalaKumaresan-yh9bm 7 ай бұрын
Sir any RDBMS example program upload the channel pls sir,for ex ticket reservation
@sowmiyap7190
@sowmiyap7190 3 ай бұрын
Hi sir I'm sowmiya Im having one assignment about er diagram i completed that but can you please once verify that I don't know whether I got correct or wrong one
@Wealthy_human
@Wealthy_human Жыл бұрын
Sir your videos are good but in 15min video i get 6 ad so its very disterbing
@muhammadhanifsoomro1121
@muhammadhanifsoomro1121 2 ай бұрын
What is tuples
@muhammadhanifsoomro1121
@muhammadhanifsoomro1121 2 ай бұрын
Sir ye clear karo tuples
@appuchannel3056
@appuchannel3056 10 ай бұрын
Hi Sir RDBMS Book english Medium Pdf send panuga sir
@krishnamyedukondalu6142
@krishnamyedukondalu6142 4 ай бұрын
Student name primary key auvtada
@krishnamyedukondalu6142
@krishnamyedukondalu6142 4 ай бұрын
In student names are same that time what will do in attributes
@destakeremela-pl4uh
@destakeremela-pl4uh 18 күн бұрын
thank you sir
@nanimms3826
@nanimms3826 Жыл бұрын
Super
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 56 МЛН
БОЛЬШОЙ ПЕТУШОК #shorts
00:21
Паша Осадчий
Рет қаралды 10 МЛН
SQL Index |¦| Indexes in SQL |¦| Database Index
9:57
Socratica
Рет қаралды 609 М.
What is a Relational Database?
7:54
IBM Technology
Рет қаралды 157 М.
Keys in RDBMS
22:49
Neso Academy
Рет қаралды 294 М.
What is ETL | What is Data Warehouse | OLTP vs OLAP
8:07
codebasics
Рет қаралды 407 М.
TYPES OF DATABASES - DATABASE MANAGEMENT SYSTEM
12:42
Sundeep Saradhi Kanthety
Рет қаралды 148 М.