Microsoft Transact-SQL Programming
Length: 5 Days Price: Contact NETS for pricing.
This Transact-SQL training 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, CLR integration, use of the Service Broker, use of 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 triggers as well as complex queries and updates. Extensive hands on exercises are used throughout to reinforce learning and develop real competency.
Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.
Microsoft Transact-SQL Programming Training Overview
- 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
- Database Security and Transactions
- 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
- Transactions and Locking
- Advanced Views and Stored Procedures
- Transact-SQL Statements for Script Processing
- Working with Variables and Temporary Tables
- Advanced Scripting Techniques
- Working with XML
- Common Language Runtime (CLR) Integration
- Coding CLR Stored Procedures
- Service Broker Architecture
- Developing Applications with Service Broker
- SQL Server Security
