SQL Fundamentals with Microsoft SQL Server Training Course

Summary

Microsoft SQL Server Logo

SQL development (including SQL Server’s Transact SQL – a.k.a. TSQL) is broken down into two categories of language:

  • Data Manipulation Language (DML): SQL commands of type DML create new data rows, remove data rows, update data rows and query data rows. The DML related SQL commands include SELECT, DELETE, INSERT and UPDATE.
  • Data Definition Language (DDL): SQL command of type DDL create, alter and destroy SQL objects such as tables, indexes views and stored procedures.

This course addresses DML which includes covering the SELECT command which provides a means by which results can be queried. Also introduced will be the types of joins supported by TSQL (INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN and CROSS JOIN). Data creation (via INSERT), deletion (via DELETE) and modification (via UPDATE) will be presented. SQL Server 2008’s MERGE command which performs insert, update or delete operations a target table using the results of a join with a source table.

Duration

2 days

Audience

This course is for anyone who want to obtain a solid understanding of how SQL Database works. No previous experience with SQL is expected. Students will gain practical SQL skills to help them design and manage data in a database. Course will introduce you to the database query language, basic data structure definitions, database transaction management and performance tuning.

Outline

Building Database

  • Data Structures
  • Managing Database Objects
  • Manipulating Data
  • Managing Database Transactions

Database Query Results

  • Introduction to the Database Query
  • Using Operators to Categorize Data
  • Sorting and Grouping Data
  • Restructuring the Appearance of Data

Building Advanced Database Queries

  • Joining Tables in Queries
  • Combining Multiple Queries into One