Database Fundamentals (98-364)


arrow-left
Back To All Courses

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:

  • create tables in a database, normalize the tables, and ALTER columns in the table.
  • Know what data type to use in various situations.
  • retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
  • JOIN two tables together, finding missing data.
  • INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
  • Create constraints, views, procedures and triggers
  • Create backups and restore data, and investigate security

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

The SELECT statement

  • SELECT
  • FROM
  • WHERE
  • GROUP BY
  • HAVING and
  • ORDER BY

Tables

  • Data types
  • Creating our own tables
  • JOINing tables
  • Normalization
  • Primary and composite keys
  • Foreign keys and other constraints

Data Manipulation Language (DML)

  • INSERT
  • UPDATE
  • DELETE

Data Definition Language (DDL) and Other Topics

  • Views, including WITH CHECK OPTION and WITH SCHEMABINDING
  • Stored Procedures
  • Functions
  • Triggers
  • UNION, INTERSECT and EXCEPT
  • Indexes

Database security , backups and restore

  • User accounts and roles,
  • Backups and restore

What people are saying

“I purchased this course to initially learn about SQL Server, including T-SQL. As a result of completing this course, I then decided to undertake the 98-364 exam which I have successfully passed. I was a beginner at the time of starting this course, now I obtain knowledge about the fundamentals of SQL Server and T-SQL in general. Phillip is an excellent instructor, and I would highly recommend in investing in this course if you are a beginner and is looking to learn about SQL, as well as SQL Server. Many thanks Phillip!”
Kamal
“I initially gave this course 4 stars but now I changed it to 5 stars. The instructor really put a great effort into the course and after spending a couple of days an repeating his lectures few times, I was able to score 98% on the exam!! I’m really glad and grateful for this instructor!”
Mousa
“Great course covering all the fundamentals of SQL. I have a lot of experience and prior knowledge from using SQL a lot in my job and just wanted to verify that I am qualified to pass the MTA certificate, but this course really explained in detail some of the things I use on a regular basis but never really knew why. Great job!”
Mikko
“This course is definitely designed for the absolute beginner, just as it states. If you know absolutely nothing about SQL, T-SQL or databases as whole, then start with this course. As a bonus, this is the only entry level course (that I have found so far) that actually touches on “database security” and “database backup and restore”. A couple of sections that are missing in so many other courses but are required in daily work and for passing the certification exam.”
Aubrey
Previous
Next

Are You Ready To Start?


arrow-icon-size3
Get Started

More Courses

You might also be interested in these courses

T-SQL

Querying Microsoft SQL Server with T-SQL

Learning Database Fundamentals with Microsoft SQL Server

Querying Microsoft SQL Server with T-SQL

View Course

SSRS

Microsoft SQL Server Reporting Services

Learn to create reports in SSRS

SQL Server Reporting Services

Learn how to create reports in SSRS
View Course