Database Foundations: Core Concepts

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.

Learning objectives

• 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