Introduction | |||
Introduction to Microsoft SQL | 00:03:00 | ||
Difference between SQL and MySQL | 00:09:00 | ||
What is a DBMS? (Database Management System) | |||
Types of Databases | 00:02:00 | ||
How a DBMS Works? | 00:02:00 | ||
What is SQL? | 00:02:00 | ||
Tables, Relationships, and Installation | |||
Table data | 00:04:00 | ||
One-to-one Relationships | 00:03:00 | ||
One-to-many Relationships | 00:03:00 | ||
Many-to-many Relationships | 00:03:00 | ||
Installation of SQL Server | 00:06:00 | ||
Creating Tables in SQL Server | 00:07:00 | ||
Data Types in SQL server | |||
Numeric data types | 00:04:00 | ||
String data types | 00:09:00 | ||
Data types | 00:02:00 | ||
Basics of SQL server | |||
Insert key | 00:08:00 | ||
Select in SQL | 00:05:00 | ||
Avg, min, and max | 00:03:00 | ||
where class with logic | 00:05:00 | ||
order | 00:03:00 | ||
Null or Is not null | 00:04:00 | ||
Delete and Update | 00:04:00 | ||
Like Operator | 00:07:00 | ||
Wild operator | 00:08:00 | ||
Constraints | 00:10:00 | ||
Primary and Foreign key | 00:09:00 | ||
Joins | 00:05:00 | ||
Normalization | 00:17:00 | ||
Database Design | 00:10:00 | ||
Union, Intersect, or except | 00:10:00 | ||
Index | 00:11:00 | ||
Conclusion | |||
Conclusion | 00:03:00 |
No reviews found for this course.
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.