[GET] SQL complete Bootcamp From Basics to Advanced,Sql interview

[mindpower]

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!