Upon completion of this course, the student will be able to: Write Transact-SQL based statements. Use data definition statements, data manipulation statements, and data control statements. Use the SELECT statement to query databases. Create, execute, and drop stored procedures. Use joins to combine data from tables. Monitor database performance.
Unit 1: Elements of Transact-SQL
- Transact-SQL
- Data Control Language Statements
- Data Definition Language Statements
- Data Manipulation Language Statements
Unit 2: The SELECT Statement
- WHERE Clause
- Other Uses of the SELECT Statement
Unit 3: Stored Procedures
- Overview of Stored Procedures
- Features of Stored Procedures
- Stored Procedure Syntax
- Viewing Stored Procedures
Unit 4: Monitoring Database Performance
- Documentation
- SQL Server Performance Tools