Course Curriculum
| 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 |