Microsoft Transact-SQL Programming
Click here for information regarding remote access training.
Students Will Learn:
- SQL Statement Syntax
- Triggers and Stored Procedures
- Data Normalization
- Modifying Tables with DML
- Programming Features of T-SQL
- Common Table Expressions
- T-SQL Data Types and Functions
Course Description: 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, predefined data types including XML, creation and use of stored procedures and user-defined functions, use of cursors, updateable views, and transaction locking.
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.
Course Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.
Follow-up SQL 2012 Courses: Microsoft SQL Server 2012 Administration, SQL Server 2012 Reporting Services, SQL Server 2012 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2012 Business Intelligence: Integration Services and Analysis Services
Follow-up SQL 2014 Courses: Microsoft SQL Server 2014 Administration, SQL Server 2014 Reporting Services, SQL Server 2014 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2014 Business Intelligence: Integration Services and Analysis Services
Microsoft Transact-SQL Programming Course Overview:
|Relational Database Fundamentals
||Writing Basic SQL Queries
|Advanced Query Techniques
||Manipulating Table Data Using SQL's Data Manipulation Language (DML)
|Creating a Database
||Managing Database Objects
|T-SQL Code Constructs
||Working with Data Types and Functions
|Transactions and Locking
||More Stored Procedures
|Working with XML
"Instructor was very competent and presented the subject in such an organized and logical manner that something as intimidating as SQL was easily grasped by everyone in classroom. I acquired hands-on skill that will assist in my daily operations."
N.J., Shefsky and Froelich, LTD
"One of the best programming courses I have taken! The instructor was able to relate concepts to real world experiences and explain difficult concepts in simple terms understood by all."