Training

1. SQL Server Architecture, Scheduling, and Waits SQL Server Components and SQL OS Windows Scheduling vs. SQL Scheduling Waits and Queues 2. SQL Server I/O Core Concepts Storage Solutions I/O Setup and Testing 3. Database Structures Database Structure Int

Description: 

Prerequisites

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

Course Brief

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

 Course Outline

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

 

 

Training Type: 
Microsoft

  Subsidiaries of Totheburn Trading