98-364: Database Fundamentals
Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.
What’s included
- 27 : Lectures
- 3h 45m : Duration
$14.99/24.99
Core Database Concepts
| Lectures |
|---|
| 1. Introduction to Databases- 2m |
| 2. Types of Databases- 8m |
Relational Database Concepts
| Lectures |
|---|
| 1. Normalization- 11m |
| 2. Constraints- 5m |
| 3. Database Keys- 9m |
Querying and Manipulating Data
| Lectures |
|---|
| 1. Introduction to T-SQL- 6m |
| 2. SQL Server Data Types- 8m |
| 3. Introduction to SQL Server Management Studio- 7m |
| 4. Querying Databases- 5m |
| 5. Querying Databases - Aliasing- 5m |
| 6. Querying Databases - Filtering- 13m |
| 7. Querying Databases - Ordering- 5m |
| 8. Querying Databases - Aggregate Functions- 5m |
| 9. Querying Databases Grouping- 7m |
| 10. Querying Databases - Joins- 9m |
| 11. Querying Databases - SET Operators- 7m |
| 12. Manipulating Data - Inserting Data- 6m |
| 13. Manipulating Data - Updating Data- 3m |
| 14. Manipulating Data - Deleting Data- 5m |
Creating Database Objects
| Lectures |
|---|
| 1. Tables- 16m |
| 2. Views- 11m |
| 3. Functions- 13m |
| 4. Triggers- 5m |
| 5. Stored Procedures- 16m |
| 6. Introduction to Indexes- 12m |
Database Administration Fundamentals
| Lectures |
|---|
| 1. Securing a SQL Server Database- 16m |
| 2. Backing up and Restoring a SQL Server Database- 10m |
