Instructor-Led IT Training Across the Mid-Atlantic

A full-service provider of IT training throughout Maryland, New Jersey, North Carolina, Pennsylvania, and Virginia.

.NET Programming SQL/SQL Server HTML5, jQuery, PHP UNIX/Linux Mobile Programming Java Programming Python Programming SharePoint 2013

Microsoft Transact-SQL Programming

Length: 5 Days | Price: $2595

This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs, creation and use of stored procedures and user-defined functions, use of cursors and updateable views.

This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful stored procedures and views as well as complex queries and updates. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.

  • Introduction to Relational Databases and SQL
  • Structured Query Language (SQL)
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Syntax Categories
  • SQL Server Management Studio
  • Designing Relational Databases
  • Database Design Process
  • Designing Table Structures
  • Completing the Physical Model
  • Creating Databases and Tables
  • Creating Databases and Schemas
  • Data Definition Language (DDL)
  • Schemas on SQL Server
  • Creating and Modifying Tables
  • Creating Indexes
  • SQL Server Indexes
  • Dropping (Deleting) Objects
  • Working with Records
  • Data Manipulation Language (DML)
  • JOIN Statements
  • Using MIN(), MAX(),AVG(),SUM() and COUNT()
  • Stored Procedures and Custom Functions
  • Using IF…ELSE
  • Views and Triggers
  • Data Control Language (DCL)
  • Using Queries as Expressions
  • Writing Multi-Table Joins
  • Using Dynamic SQL
  • Returning Aggregated Data for Analysis
  • Data Types in SQL Server
  • Using Functions
  • Advanced Views and Stored Procedures
  • Transact-SQL Statements for Script Processing
  • Working with Variables and Temporary Tables
  • Advanced Scripting Techniques
  • Course materials include student guide, hands-on lab manual and USB flash drive containing examples and lab files
  • Students receive a certificate of completion at the end of class
  • Students can retake any portion of a class that has been completed, within 12 months at no extra cost
  • There are no registration fees or cancellation fees
  • Class sizes are kept small in order to provide you with more personalized attention
  • Our instructors have many years of training and industry experience working in their respective fields