Database Fundamentals (98-364)
Share This Class:
This course is the foundation for the Microsoft Certificate 98-364 “Database Fundamentals”, and focuses on Microsoft SQL Server. Learn in just a few hours how to create tables, queries, views, procedures and more.
No prior knowledge is required – I’ll even show you how to install SQL Server on your computer for free!
There are regular quizzes to help you remember the information, so you can be sure that you are learning.
Once finished, you will have a good introductory knowledge of how databases work and be able to construct your own SELECT statements. And with some practice, you could even go for an official Microsoft certification – wouldn’t that look good on your CV or resume?
Completing this course will help you:
Who is the course for?
This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to learn T-SQL.
This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.
By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft’s official 98-364 exam.
Wouldn’t the “MTA: Database Fundamentals” certification look good on your CV or resume?
- GROUP BY
- HAVING and
- ORDER BY
- Data types
- Creating our own tables
- JOINing tables
- Primary and composite keys
- Foreign keys and other constraints
- Views, including WITH CHECK OPTION and WITH SCHEMABINDING
- Stored Procedures
- UNION, INTERSECT and EXCEPT
- User accounts and roles,
- Backups and restore