About This Course
Course Curriculum
-
Introduction to Microsoft SQL
00:03:00 -
Difference between SQL and MySQL
00:09:00
-
Types of Databases
00:02:00 -
How a DBMS Works?
00:02:00 -
What is SQL?
00:02:00
-
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
-
Numeric data types
00:04:00 -
String data types
00:09:00 -
Data types
00:02:00
-
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:09: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
00:03:00