MOC 10985 - Introduction to SQL Databases

MOC 10985 - Introduction to SQL Databases

Course Length: 3 days
Delivery Methods: Multiple delivery options
Course Benefits
  • Learn to describe key database concepts in the context of SQL Server 2016.
  • Learn to describe database languages used in SQL Server 2016.
  • Learn to describe data modelling techniques.
  • Learn to describe normalization and denormalization techniques.
  • Learn to describe relationship types and effects in database design.
  • Learn to describe the effects of database design on performance.
  • Learn to describe commonly used database objects.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Course Overview

This Introduction to SQL Databases training class is aimed at people looking to move into a database 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.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Course Outline
  1. Introduction to Databases
    1. Introduction to relational databases
    2. Other types of database
    3. Data analysis
    4. Database languages in SQL Server
    5. Lab: Exploring and querying SQL Server databases
    6. Data Modelling
      1. Data modelling
      2. ANSI/SPARC database model
      3. Entity relationship modelling
      4. Lab: Identify components in entity relationship modellingAfter completing this module, you will be able to:
        1. • Understand the common data modelling techniques
        2. • Describe the ANSI/SPARC database model
        3. • Describe entity relationship modelling
    7. Normalization
      1. Fundamentals of Normalization
      2. Normal form
      3. Denormalization
      4. Lab: Normalizing data
      5. Relationships
        1. Introduction to relationships
        2. Planning referential integrity
        3. Lab: Planning and implementing referential integrity
        4. Performance
          1. Indexing
          2. Query performance
          3. Concurrency
          4. Lab: Performance issues
          5. Database Objects
            1. Tables
            3. Stored procedures, triggers and functions
            4. Lab: Using SQL server
            Class Materials

            Each student will receive a comprehensive set of materials, including course notes and all the class examples.

            Class Prerequisites

            Experience in the following is required for this SQL Server class:

            • This is a foundation level course and therefore only requires general computer literacy.
            Register for a Live Class
            Please select a class.
            Request a Private Class
            • Private Class for your Team
            • Online or On-location
            • Customizable
            • Expert Instructors
            Request Pricing