Microsoft Transact-SQL Programming
Duration: 35 hours
Prerequisites: None.
Students Will Learn:
- Introduction to Relational Databases and SQL
- Designing Relational Databases
- Creating Databases and Tables
- Working with Records
- JOIN Statements
- Advanced SELECT Statements
- Understanding Subqueries
- SQL Procedural Programming
- Views and Triggers
- Database Security and Transactions
- Introduction to Transact-SQL Programming
- Working with Data Types and Functions
- SQL Server System Settings and Functions
- More with DML Statements
- More about Stored Procedures and Views
- Introduction to Cursors
- User-defined Functions
- Manipulating XML
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, 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 who need to exploit the power of 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 Overview:
Relational Database Fundamentals
|
Writing Basic SQL Queries
|
Creating a Database
|
Manipulating Query Results
|
Advanced Query Techniques
|
Manipulating Table Data Using SQL's Data Manipulation Language (DML)
|
User-Defined Functions
|
Stored Procedures
|
Triggers
|
Complex Queries
|
T-SQL Code Constructs
|
Working with Data Types and Functions
|
Using T-SQL Cursors
|
Working with Table Expressions
|
Related Bootcamps:
Track | Duration | Price |
---|---|---|
SQL Server Business Intelligence Developer | 4-course track | $4,800 |
SQL Server Administrator | 2-course track 3-course track |
$2,400 $3,600 |
Master SQL Server Developer | 5-course track 6-course track |
$6,000 $7,200 |