Course Code: 27401

Introduction to SQL Databases Course (10985WV) updated version of 55356

Class Dates:
10/28/2024
11/12/2024
12/19/2024
9/30/2024
Length:
2 Days
Cost:
$1695.00
Class Time:
Technology:
Database
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

  • Course Overview
  • This 2-day entry-level course examines the services and features of Microsoft SQL 2022. The content focuses on database tables, adding and changing data, creating and using stored procedures, entity relationships, and indexes.

    Why choose this course?

    Meticulous content relevance, tailored to Microsoft SQL 2022.
    Content on obsolete technology has been removed.
    Offers an array of demonstrations that bolster the learning material.
    Expert instructional design ensures a superior learning experience.
    Labs are developed by Waypoint in parallel with courseware, so they are 100% aligned.
    Benefits:
    Conceptualize data organization in a database.
    Identify various types of databases.
    Retrieve information from a database using SQL, Transact-SQL (T-SQL), and other languages
    . Normalize and denormalize data stored in a database
  • Audience
  • Who Can Benefit:
    The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.

Prerequisites

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

Course Disclaimer

*Course Cost listed does not include the cost of courseware or exam. Course is subject to a minimum enrollment to run. Course may run virtually as a Virtual Instructor-Led (VILT) class if the minimum enrollment is not met. If the course is under the minimum enrollment the course may run as 1 day class (Bootcamp Style). For more information, please contact learn@vtec.org or call 207-775-0244.

Course Details

  • Module 1: Introduction to databases
  • Introduction to relational databases
  • Retrieve data from a relational database by using SQL
  • Lab 1: Use the SELECT statement to retrieve data from a database
  • Module 2: Database tables
  • To create databases that are effective, usable, and more secure, it’s necessary for you to choose the types of data, properties, and constraints you implement in your database tables.
  • This module covers why it’s essential to use schemas and views to improve organization and security as you grow your database.
  • Identify and use Microsoft SQL Server data types
  • Create tables with SQL, Altering and dropping a table
  • Collect information from multiple tables by using joins and views
  • Lab 1: Create and alter a table in Microsoft SQL Server, Create and retrieve a view that uses the JOIN statement in Microsoft SQL Server
  • Lab 2: Create and alter a table in Microsoft SQL Server
  • Lab 3: Create and retrieve a view that uses the JOIN statement in Microsoft SQL Server
  • Module 3: Add and update data
  • This module covers using statements to add, alter, and remove rows in a table. It also covers creating stored procedures and using input parameters in stored procedures.
  • Insert, update, and delete information
  • Lab 1: Add and change data in SQL Server
  • Lab 2: Create and use stored procedures in Microsoft SQL Server
  • Module 4: Entity relationships
  • This module covers entities and the relationships between them. It also discusses using the various types of referential integrity.
  • Model entity relationships
  • Design for referential integrity What is referential integrity?
  • Lab 1: Create an entity relationship diagram in Microsoft SQL Server Management Studio
  • Module 5: Normalization and denormalization
  • This module covers normalization and denormalization in a database, their benefits, and when each should be used.
  • Normalization
  • Denormalization
  • Lab 1: Denormalize a table by adding a redundant column of computed data
  • Module 6: Query performance and safety
  • This module covers writing effective and performant queries and using clustered and non-clustered indexes. It also discusses concurrency issues and the transactions and isolation levels you can use to
  • address them.
  • Indexes
  • Write performant SQL code
  • Concurrency
  • Lab 1: Create indexes and consult execution plans in Microsoft SQL Server Management Studio