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

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

DATA STRUCTURES

JAVA PROGRAMMING

COMPILER DESIGN

AUTOMATA THEORY || THEORY OF COMPUTATION

R PROGRAMMING

HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS

LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS

JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT

XML (eXtensible Markup Language)

OPERATING SYSTEM

ETHICAL HACKING

VI EDITOR BASICS IN LINUX / UNIX || LEARN VI EDITOR COMMANDS || LINUX || UNIX

HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10

PYTHON PROGRAMS

C PROGRAMMING

CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS

PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)

PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)

PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU

PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE

MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)

PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL

DATA STRUCTURES USING PYTHON (ENGLISH)

----------------------------------------------------------------------------------------------

[rz]

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.

[diego]

You explain things in an excellent and easy to understand and remember way. Thank you for this tutorial

[rutujakamane]

I have understood everything and I must say you're very good teacher

[innocent]

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 .

[anirudhvakale]

You are the my favourite teacher ❤❤
जब से आपको देखा हैं आपके teaching का दिवाना हो गया हुं ❤❤

[bretthl]

best explanation I have seen. really good, thank you.

[vijjutherockstar]

Your teaching is so good sir I understood easily....

[VinodKumar-cqbp]

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.

[tobiawosola]

Well done, I like the Way you Explained the concepts.

[rajeshmay]

Thank you sir, worthful.
Pls upload sql, oracle video. Im non-IT guy. I have infoys interview .

[stanleyabrahampaul]

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...

[MariaJasmine-bxcv]

Best explanation I have seen thank you sir ☺️

[mohdaneeschaudhary]

sir please upload complete lecture of DBMS may help this lecture lots for job

[shakernawaabbolte]

Thank you soo much akka for all explanations of all subjects thank you ❤

[Mounica.vadithya]

Can u say the topics of triggers.. packages.. nd cursor

[Shravani]

Sir a request from my side please upload a videon on paper pattern and presentation (lenth of the answer in exam)
Important topics also

[ayaanali]

Me watching this just 2 hours before my exam .

[sowmiyap]

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

[GurubalaKumaresan-yhbm]

Sir any RDBMS example program upload the channel pls sir, for ex ticket reservation

[b.venkatasubbaiah]

videos upload cheyyandi sir related this