Introduction to SQL Databases (M10985) Course Details:

This 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 designs. Note:

  • Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session
  • Redeem three SATVs for an individual GITT Digital Learning course plus digital Microsoft Official Courseware (dMOC)
  • Redeem two SATVs for an individual GITT Digital Learning course

    Oct 13 2021

    Date: 10/13/2021 - 10/15/2021 (Wednesday - Friday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Introduction to SQL Databases (M10985)

    October 13 - 15, 2021 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 29 2021

    Date: 11/29/2021 - 12/01/2021 (Monday - Wednesday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Introduction to SQL Databases (M10985)

    November 29 - December 1, 2021 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Dec 20 2021

    Date: 12/20/2021 - 12/22/2021 (Monday - Wednesday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Introduction to SQL Databases (M10985)

    December 20 - 22, 2021 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

1. Introduction to Databases

  • Relational databases
  • Other types of databases
  • Data analysis
  • Database languages in SQL Server

2. Data Modeling

  • Data modeling
  • ANSI/SPARC database model
  • Entity relationship modeling

3. Normalization

  • Fundamentals of Normalization
  • Normal from
  • Denormalization

4. Relationships

  • Introduction to relationships
  • Planning referential integrity

5. Performance

  • Indexing
  • Query performance
  • Concurrency

6. Database Objects

  • Tables
  • Views
  • Stored procedures, triggers and functions

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • 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

Lab 1: Exploring and querying SQL Server databases
Lab 2: Identify components in entity relationship modeling
Lab 3: Normalizing data
Lab 4: Planning and implementing referential integrity
Lab 5: Performance issues
Lab 6: Using SQL Server 

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

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

Ready to Jumpstart Your IT Career?

CONTACT US NOW!