We have covered formatting numeric data types and table JOINs.
We will have quiz #1 on 07/20/2016 on section one of the Exam 98-364 MTA Database Administration Fundamentals (ISBN 9780470889169) book.
Download the class notes for day 3.
SQL
Database Administration Fundamentals (SF16SQL1001) – Day 2
So far, we have covered built-in (system native) functions and nested queries. Next Monday (07/18/2016) we will finish section Understanding Core Database Concepts from the syllabus and next Thursday (07/20/2016) we will have the first quiz.
Download the class notes for day 2.
Database Administration Fundamentals (SF16SQL1001) – Day 1
You have survived the first day of SF16SQL1001. So far, we have covered the basics of T-SQL (the version of SQL used in SQL Server)
SELECT [column(s)] FROM [table(s)]
and briefly jumped ahead to NULL and data types, which we will cover in detail later in the course. Download the class notes for day 1.
Database Administration Fundamentals (WS16SQL1006) – Day 10
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.
Database Administration Fundamentals (WS16SQL1006) – Day 9
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.
Database Administration Fundamentals (WS16SQL1006) – Day 8
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.
Database Administration Fundamentals (WS16SQL1006) – Day 7
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).
Database Administration Fundamentals (WS16SQL1006) – Day 6
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.
- https://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25108/xedev_programs.htm
- http://www.techonthenet.com/oracle/procedures.php
- http://www.techonthenet.com/oracle/functions.php
For MySQL and MariaDB, refer to the following URLs.
Database Administration Fundamentals (WS16SQL1006) – Day 5
Database Administration Fundamentals (WS16SQL1006) – Day 4
So far we have covered how to
- query databases as well as present data using built-in functions,
- create tables and views with the proper data types,
- modify tables adding, dropping or altering columns and data types
- and also destroy these database objects.
Download the class notes for day 4.
