01-07-2024, 07:59 AM
SQL complete Bootcamp From Basics to Advanced,Sql interview
Every sql topic includithe most complex topics like triggers stored proc were explained easily for better understanding.
Rating: 4.6 out of 5
(46 ratings)
9,563 students
20 hours on-demand video
Description
Why SQL
Store large number of records
Share huge data set among many people
Add and edit data easily
Quick and easy to find information
RDBMS TERMINOLOGY
Column as Attribute
Row as Entity Instance
Table as Entity
AlternateKey as UniqueKey
RELATIONSHIPS Cardinality
90% of the tables in database will be linked with another tables.
10%of the tables will be independent.
There are three types of relationships between tables
one to one
one to many
many to many
Tables can have a single / multiple relationships or may not have relationships.
Structured data - 2 dimensional data Rows,Columns
PrimaryKey in one table will be given as ForiegnKey in another table to build relationship.
And much more...
https://www.udemy.com/course/sql-from-basics-to-advanced/?couponCode=9308345B2F78EF9AFF8C
Enjoy!
Every sql topic includithe most complex topics like triggers stored proc were explained easily for better understanding.
Rating: 4.6 out of 5
(46 ratings)
9,563 students
20 hours on-demand video
Description
Why SQL
Store large number of records
Share huge data set among many people
Add and edit data easily
Quick and easy to find information
RDBMS TERMINOLOGY
Column as Attribute
Row as Entity Instance
Table as Entity
AlternateKey as UniqueKey
RELATIONSHIPS Cardinality
90% of the tables in database will be linked with another tables.
10%of the tables will be independent.
There are three types of relationships between tables
one to one
one to many
many to many
Tables can have a single / multiple relationships or may not have relationships.
Structured data - 2 dimensional data Rows,Columns
PrimaryKey in one table will be given as ForiegnKey in another table to build relationship.
And much more...
https://www.udemy.com/course/sql-from-basics-to-advanced/?couponCode=9308345B2F78EF9AFF8C
Enjoy!