18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
United States
share button
Free Webinar: Database Recovery Models And Its Significance : July 29, 2020. 

10985: Introduction to SQL Databases Training


What 10985: Introduction to SQL Databases training is all about?

The three-day program led by experts is focused on individuals wanting to delve into the professional role of databases or someone looking to expand their role surrounding various database elements. The course explains fundamental concepts of databases including types, languages, and designs of databases.

  • START DATE
  • CLASS TIMINGS
  • DELIVERY MODE
  • PRICE
  • ACTION
  • 08/17/2020
  • 9:00 am - 5:00 pm EST
  • $ 1725
  • 10/05/2020
  • 9:00 am - 5:00 pm EST
  • $ 1725
  • 12/14/2020
  • 9:00 am - 5:00 pm EST
  • $ 1725
What are the course objectives for 10985: Introduction to SQL Databases training?
  • Describing key concepts of the database in SQL Server 2016.
  • Describing languages used in SQL Server 2016 database.
  • Describing techniques of data modelling.
  • Describing techniques to normalize and de-normalize data.
  • Describing types of relationships and effects in databases.
  • Describe how database design affects performance.
  • Describing frequently used objects in the database.
Who should attend 10985: Introduction to SQL Databases training?

The targeted audience for the course are newcomers wanting to move into a database-specific role or someone wanting to expand their role in database technologies.

What is the course outline for 10985: Introduction to SQL Databases training?
  • 1. Introduction to databases
  • a). Introduction to relational databases
  • b). Other types of database
  • c). Data analysis
  • d). Database languages in SQL Server
  • e). Lab : Exploring and querying SQL Server databases
  • 2. Data Modelling
  • a). Data modelling
  • b). ANSI/SPARC database model
  • c). Entity relationship modelling
  • d). Lab : Identify components in entity relationship modelling
  • 3. Normalization
  • a). Fundamentals of Normalization
  • b). Normal form
  • c). Denormalization
  • d). Lab : Normalizing data
  • 4. Relationships
  • a). Introduction to relationships
  • b). Planning referential integrity
  • c). Lab : Planning and implementing referential integrity
  • 5. Performance
  • a). Indexing
  • b). Query performance
  • c). Concurrency
  • d). Lab : Performance issues
  • 6. Database Objects
  • a). Tables
  • b). Views
  • c). Stored procedures, triggers and functions
  • d). Lab : Using SQL server
3 Days | $ 1725
Buy e-Learning @ $ 675
with 90 days access