Microsoft Transact-SQL Programming
Students Will Learn:
- SQL Statement Syntax
- Triggers and Stored Procedures
- Data Normalization
- Modifying Tables with DML
- Programming Features of T-SQL
- Complex Queries and Advanced Views
- Data Types and Functions
Course Description: This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course covers T-SQL programming constructs, predefined data types including XML, deployment of stored procedures and triggers, use of cursors, creating and using Views and user-defined functions, 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 triggers 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 2008 Courses: Microsoft SQL Server 2008 Administration, SQL Server 2008 Reporting Services, SQL Server 2008 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2008 Business Intelligence: Integration Services and Analysis Services
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
Microsoft Transact-SQL Programming Course Overview:
|Relational Database Fundamentals
Manipulating Query Results
|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
|Security in SQL Server
"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."