Introduction to SQL Databases (M10985) Course Details:

This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. Note:

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

    No classes are currenty scheduled for this course.

    Call (919) 283-1653 to get a class scheduled online or in your area!

1. Introduction to Databases

  • Relational databases
  • Other types of databases
  • Data analysis
  • Database languages in SQL Server

2. Data Modeling

  • Data modeling
  • ANSI/SPARC database model
  • Entity relationship modeling

3. Normalization

  • Fundamentals of Normalization
  • Normal from
  • Denormalization

4. Relationships

  • Introduction to relationships
  • Planning referential integrity

5. Performance

  • Indexing
  • Query performance
  • Concurrency

6. Database Objects

  • Tables
  • Views
  • Stored procedures, triggers and functions

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • Key database concepts in the context of SQL Server 2016
  • Database languages used in SQL Server 2016
  • Data modeling techniques
  • Normalization and denormalization techniques
  • Relationship types and effects in database design
  • Effects of database design on performance
  • Commonly used database objects

Lab 1: Exploring and querying SQL Server databases
Lab 2: Identify components in entity relationship modeling
Lab 3: Normalizing data
Lab 4: Planning and implementing referential integrity
Lab 5: Performance issues
Lab 6: Using SQL Server 

This is a foundation-level course and therefore only requires general computer literacy.

  • The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

Ready to Jumpstart Your IT Career?