We have reached the end of the Database Administration Fundamentals course to prepare you for the Microsoft MTA Exam 98-364.

Download the answers to quiz #4. Remember that you should take my notes (my interpretation of how to best answer the questions in the quiz) as a reference and compare them to your code.

You can also download all files for this course under category WS16SQL1006 to continue studying/reviewing the material before taking the certification exam.

We have reached to the end of the course and next Monday we will have the fourth and last quiz.

Download the class notes for day 9 and the review for quiz #4.

We have covered normalization, primary keys (PK), foreign keys (FK) and composite primary keys (CPK).

Download the class notes for day 8 and theory regarding rights management (22 pages), which we will cover this coming Wednesday.

We had another quiz (#3) reviewing most of the material that we have covered in the past three and a half weeks. In the quiz, I offered you two options — creating a new database where you would put the three new tables (quiz #3a) or creating a schema in the same database to include these new tables (quiz #3b). Most of you decided to create a new database.

Download the XLS files to recreate databases AP and AP_Employees (latter used in quiz #3) as well as the class notes for day 7 (quiz #3a & quiz #3b).

We have covered parameters, functions and procedures. Do not forget that, if you are taking the certification exam, you must know about procedures.

Download the class notes for day 6.

Note that functions and procedures change from vendor to vendor. In this course, we are looking at Microsoft’s T-SQL for SQL Server.

If anyone if interested in functions and procedures in Oracle, refer to the following URLs.

1. https://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25108/xedev_programs.htm
2. http://www.techonthenet.com/oracle/procedures.php
3. http://www.techonthenet.com/oracle/functions.php

For MySQL and MariaDB, refer to the following URLs.

1. http://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
2. http://dev.mysql.com/doc/refman/5.7/en/create-function.html
3. http://dev.mysql.com/doc/refman/5.7/en/create-function-udf.html

We had the second quiz on sections one, most of two and three. Next week we will cover parameters, procedures and functions.

Download the class notes for day 5 (quiz 2).

So far we have covered how to

1. query databases as well as present data using built-in functions,
2. create tables and views with the proper data types,
3. modify tables adding, dropping or altering columns and data types
4. and also destroy these database objects.

Download the class notes for day 4.

We had our first quiz and most of you did great!

Download the class notes for day 3 (quiz 1). As I have mentioned, there is no single right answer. Use my answers to the quiz as a guide.

We have started getting creative displaying data returned from our queries using functions.

Download the class notes for day 2.

Since Monday 05/30/2016 is Memorial Day, we are not meeting till Wednesday. Therefore review all your notes and get ready for your first quiz.

View the updated syllabus for this course.

Download the class notes for day 1.