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 | ||
Instructors
13 STUDENTS ENROLLED
Food Hygiene
Health & Safety
Safeguarding
First Aid
Business Skills
Personal Development



