Database Fundamentals (98-364)

104

Lessons

All

Skill Level

8:41m

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

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?

Learning Path

  • SELECT
  • FROM
  • WHERE
  • GROUP BY
  • HAVING and
  • ORDER BY
  • Data types
  • Creating our own tables
  • JOINing tables
  • Normalization
  • Primary and composite keys
  • Foreign keys and other constraints
  • Views, including WITH CHECK OPTION and WITH SCHEMABINDING
  • Stored Procedures
  • Functions
  • Triggers
  • UNION, INTERSECT and EXCEPT
  • Indexes
  • User accounts and roles,
  • Backups and restore

What people are saying

Are You Ready To Start?

More Courses

You might also be interested in these courses

Querying Microsoft SQL Server with T-SQL

Learning Database Fundamentals with Microsoft SQL Server

Querying Microsoft SQL Server with T-SQL

View Course

Microsoft SQL Server Reporting Services

Learn to create reports in SSRS

SQL Server Reporting Services

Learn how to create reports in SSRS
View Course