Video training course for the 98-364 Microsoft Technology Associate Database Administration Fundamentals exam. The perfect course for anyone interested in building a career in data platform administration or business intelligence. There is a heavy emphasis on SQL in this course but no previous knowledge is assumed. The course is based upon Microsoft SQL Server 2008 R2.
By the end of the course, you will be able to:
- Understand Core Database Concepts
- Create Database Objects
- Manipulate Data
- Understand Data Storage
- Administer a Database
Your Instructor
Lawrence ‘Toby’ Rose
Is a graduate of the University of London, and has a background in project management, software development and user training. He is a Microsoft Certified Professional with extensive experience across the whole of the Microsoft Office product set and with many Adobe products.Lawrence has worked in several countries and is a keen traveler.
| Module 1 | Course Introduction and Exam Information |
|---|---|
| Unit 1 | Welcome to the Course |
| Module 2 | Understanding Core Database Concepts |
| Unit 1 | Understand How Data is stored in Tables |
| Unit 2 | Understand Relational Database Concepts |
| Unit 3 | Understand Data Manipulation Language (DML) |
| Unit 4 | Understand Data Definition Language (DDL) |
| Module 3 | Creating Database Objects |
| Unit 1 | Choose Data Types - Part 1 |
| Unit 2 | Choose Data Types - Part 2 |
| Unit 3 | Understand Tables and How to Create Them |
| Unit 4 | Create Views |
| Unit 5 | Create Stored Procedures and Functions |
| Module 4 | Manipulating Data |
| Unit 1 | Select Data - Part 1 |
| Unit 2 | Select Data - Part 2 |
| Unit 3 | Insert and Update Data |
| Unit 4 | Delete Data |
| Module 5 | Understanding Data Storage |
| Unit 1 | Understand Normalization |
| Unit 2 | Understand Primary, Foreign and Composite Keys |
| Unit 3 | Understand Indexes |
| Module 6 | Administering a Database |
| Unit 1 | Understand Database Security Concepts |
| Unit 2 | Understand Database Backups and Restore |
| Module 7 | Bonus Exams |
| Unit 1 | Bonus Exam 1 |
| Unit 2 | Bonus Exam 2 |
