Database Fundamentals - MTA Microsoft Technology Associate Exam 98-364: 2015 edition

This book discusses database fundamentals and covers the objectives for the Microsoft Exam 98-364. It looks at learning what a table is, deciding on fields and, primary/foreign keys for your table. You learn how to create relationships and understand the resulting cardinality. You'll continue with taking your database and input it into SQL Server 2012 Express (free edition). That will be take one further by creating that same database design using SQL Language. Of course, you'll cover database administration and security. The book concludes with an explanation on how to install the free version of SQL Server 2012 Express.

The chapters include:

1. What is a database?
2. Anatomy of a Table
3. Normalization and Indices
4. DDL, DML & DCL
5. Creating and Manipulating Data
6. Database Security & Backup/Restore
Appendix - Installing SQL Sever 2012 Express