Microsoft SQL Server

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 design

DURATION:
3 Months

ADDRESS
Training @ any Bitbase Centers VIEW MAP >
CATEGORIES
Database Management , Microsoft

Course Objectives

After completing this course, students will be able to:
  • Describe key database concepts in the context of SQL Server 2016
  • Describe database languages used in SQL Server 2016
  • Describe data modelling techniques
  • Describe normalization and de-normalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects

Target Audience and Prerequisites

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

Course Content

+ 1 - INTRODUCTION TO DATABASES
  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages
  • Lab : Querying SQ Server
+ DATA MODELLING
  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling
  • Lab : Entity relationship modelling
+ 3 – NORMALIZATION
  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • De-normalization
  • Lab : Normalizing raw data
+ 4 – RELATIONSHIPS
  • Schema mapping
  • Referential integrity
  • Lab : Designing relationships
+ 5 – PERFORMANCE
  • Indexing
  • Query performance
  • Concurrency
  • Lab : Query performance
+ 6 – DATABASE OBJECTS
  • Tables
  • Views
  • Stored Procedures, Triggers and Functions
  • Lab : Using SQL Server
Related Course
Back-end Microsoft Azure Administrator (AZ104) JAVA-DEV Microsoft Azure Fundamentals (AZ900)

Bitbase Training Locations

Ojo Contact

148, Olojo Drive High Taste B/Stop, EIIT/FCMB Building, Ojo, Lagos State.

Satelite Town Contact

No 1 Community Road Abulado Satelite Town, Lagos State.

Lekki Contact

No 9, Otunba Adedoyin Ogungbe Crescent, Opposite ELIM Motors Lekki
Phase 1, Lagos State.