TypeClassroom Training
REGISTER

 

Introduction to SQL Databases (M10985)

** Redeem Your Microsoft Vouchers(SATV) for Introduction to SQL Databases (M10985) Training Course & Certification **

Overview

Audience & Prerequisites

Course Outline

Schedule & Fees

Certification

M10985 – Introduction to SQL Databases Training

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.

Objectives

  • 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

Intended Audience

Individuals moving into a database role or whose role has expanded to include database technologies

Prerequisites

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

Course Outline                                             Duration: 3 Days

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

Please write to us at info@itstechschool.com & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

For more info kindly Contact Us.

Reviews