Microsoft Transact-SQL Programming
Click here for information regarding remote access training.
Students Will Learn:
- Design normalized table structures for relational databases
- Create databases and tables
- Using primary and foreign keys
- Writing SQL queries
- Using inner and outer joins
- Using set operators (UNION, INTERSECT, EXCEPT)
- Using DML for SELECT, INSERT, UPDATE, DELETE
- Using subqueries
- Using triggers and stored procedures
- Using aggregate functions to return totals and subtotals
- Programming features of T-SQL
- Common table expressions
- T-SQL specific data types and functions
- T-SQL cursors
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)
|T-SQL Code Constructs
||Working with Data Types and Functions
|Transactions and Locking
||Using T-SQL Cursors
|Working with Views
||Working with XML
"This was a fantastic course. Both the materials and presenter were received very well. The information was delivered in a logical straight forward manor. It was extremely useful to have the software to interact along with our instructor. I will be taking more learning class with HOTT in the future. Thank you."
K.T., Direct Energy
"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."