Understand the core concepts every IT professional should
know to start working with databases. This course, the first in a four-part
series with database consultant Adam Wilbert, is designed to provide a solid
foundation that will serve you throughout your IT career. Learn about the
different data storage models and find out how to build your first database
with SQL Server—the Express edition, which requires no hardware or special
connections for setup. Then discover how to create database objects with the
data definition language (DDL) and edit data in your tables with data
manipulation language (DML). Adam also covers critical relational database
concepts, such as relationships, indexes, and schemes.
Note: This course will also prepare certification candidates for the Microsoft Technology Associate Exam 98-364, Database Administration Fundamentals.
Note: This course will also prepare certification candidates for the Microsoft Technology Associate Exam 98-364, Database Administration Fundamentals.
Topics
include:
- Understanding flat file, hierarchical, and relational databases
- Installing SQL Server 2014 Express
- Creating your first database and tables
- Creating and editing database objects
- Writing commands in DML
- Selecting and inserting data
- Updating and deleting data
- Establishing relationships and file naming conventions
0 comments:
Post a Comment