Introduction To SQL Databases Certification Training Course Overview

The introduction to SQL Databases training course is designed to train the learners on the fundamentals of database concepts. You will not only learn about the different types of databases, the languages and designs as well as describe important database concepts using SQL Server 2016. Anyone who is moving into a database role will benefit from taking this course.
After completing the introduction to SQL Databases certification course, you will also learn about the various data modeling techniques, effects of database design on performance, and how database design can have an impact on performance. Koenig Solutions is one of the fastest-growing IT training providers in India and has more than 350 certified trainers working for them. By signing up for this course, you will benefit from our world class training methods and expert trainers..
 
Audience:  The course targets participants interested into a database profile/role, or whose role has been widened to include database technologies.
Test your current knowledge Qubits42

Introduction To SQL Databases (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1150
01 - 03 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

08 - 10 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

15 - 20 Nov GTR 09:00 AM - 01:00 PM CST
(4 Hours/Day)

06 - 08 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1300
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Introduction to databases
  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages in SQL server
Module 2: Data Modelling
  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling
Module 3: Normalization
  • Fundamentals of Normalization
  • Normal form
  • Denormalization
Module 4: Relationships
  • Introduction to relationships
  • Planning referential integrity
Module 5: Performance
  • Indexing
  • Query performance
  • Concurrency
Module 6: Database Objects
  • Tables
  • Views
  • Stored procedures
  • Other database objects
Download Course Contents

Request More Information

Course Prerequisites

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

Upon Completion of this Course, you will accomplish following:-

  • 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 denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects

Give an edge to your career with Microsoft certification training courses. Students can join the classes for Introduction To SQL Databases Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.