• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/19/2018 11/21/2018
  • VLT
Live Online
12/17/2018 12/19/2018
  • VLT
Live Online
10/29/2018 10/31/2018
  • VLT
  • GTR
Live Online

10985: Introduction to SQL Databases Course Overview 

10985: Introduction to SQL Databases three-day teacher drove course is gone for individuals hoping to move into a database proficient part or whose occupation part is growing to include database components. The course depicts key database ideas including database sorts, database dialects, and database plans. 

10985: Introduction to SQL Databases Audience Profile 

The essential crowd for this course is individuals who are moving into a database part, or whose part has extended to incorporate database advances. 

  • 10985: Introduction to SQL Databases At course completion
  • Subsequent to finishing this course, understudies will have the capacity to: 
  • Depict enter database ideas with regards to SQL Server 2016 
  • Portray database dialects utilized as a part of SQL Server 2016 
  • Portray information demonstrating procedures 
  • Portray standardization and denormalization strategies 
  • Portray relationship sorts and impacts in database plan 
  • Portray the impacts of database plan on execution 
  • Portray usually utilized database objects 

10985: Introduction to SQL Databases Course Outline 

1 - Introduction to databases 

  • Prologue to social databases 
  • Different sorts of database 
  • Information investigation 
  • Database dialects 

2 - Data Modeling 

  • Information displaying 
  • ANSI/SPARC database show 
  • Substance relationship displaying 

3 - Normalization 

  • Why standardize information? 
  • Standardization terms 
  • Levels of standardization 
  • Denormalization 

4 - Relationships 

  • Construction mapping 
  • Referential trustworthiness 

5 - Performance 

  • Ordering 
  • Question execution 
  • Simultaneousness 

6 - Database Objects 

  • Tables 
  • Perspectives 
  • Put away strategies 
  • Other database objects

This is an establishment level course and along these lines just requires general PC proficiency.

Awards