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

by Catherine Yager

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

186 pages, Kindle Edition

First published July 19, 2013

Reviews

[Paul · Rating 1 out of 5]

Very plainly written, although unedited.

All of the essential information is included, however, the grammatical errors are distracting. If a product (ie: this book) is offered for sale, a review (ie: editor or peer) for quality purposes is warranted.