Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

S2K20461-1 - Querying and Modifying Data in Microsoft SQL Server

In this one day custom course you will learn the skills necessary to manipulate data in Microsoft SQL Server. The course starts with basic select statements then progresses to more advanced queries joining multiple tables. This includes inner, outer, full and self-joins. This course also provides information on DML statements such as INSERT, DELETE and UPDATE statements that manipulate data. This course is designed for those individuals who need a quick start in manipulating SQL data.

Click here to print this page »

Prerequisites


Experience in SQL Server Management Studio and relational database design is helpful but not required.

Detailed Class Syllabus


Module 1: Introduction to T-SQL Querying


Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements

Module 2: Writing SELECT Queries


Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions

Module 3: Querying Multiple Tables


Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins

Module 4: Using DML to Modify Data


Inserting Data
Modifying and Deleting Data