Introduction to SQL Databases (M10985)

Days: 3 day
Price: $2195

Course Details

In this course, you will learn fundamental database concepts for Microsoft SQL Server 2016, including database types, database languages and database designs.

This course incorporates material from the Official Microsoft Learning Product 10985: Introduction to SQL Databases.

Note:

  • Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session
  • Redeem three SATVs for an individual GK Digital Learning course plus digital Microsoft Official Courseware (dMOC)
  • Redeem two SATVs for an individual GK Digital Learning course

*For more information on Microsoft SATVs, click here.
GK Digital Learning is also available with digital Microsoft Official Courseware (dMOC). Click here to purchase.

Course Agenda

1. Introduction to Databases

  • Relational databases
  • Other types of databases
  • Data analysis
  • Database languages

2. Data Modeling

  • ANSI/SPARC database model
  • Entity relationship modeling

3. Normalization

  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization

4. Relationships

  • Schema mapping
  • Referential integrity

5. Performance

  • Indexing
  • Query performance
  • Concurrency

6. Database Objects

  • Tables
  • Views
  • Stored procedures
  • Other database objects

Details

Options