SQL Server and T-SQL Lab

This course provides a comprehensive introduction to Microsoft SQL Server, utilizing the SQL Management Studio for administrative and development tasks. This course offers a solid foundation of the Transact-SQL (T-SQL) constructs that will enable students to build, query, maintain, and finetune SQL Server databases. The course focuses on basic to advanced queries including joins, functions, data types, stored procedures, declaration and execution, cursors, temp tables, triggers, error handling, transaction management, and security. This course also offers an introduction to common administrative and maintenance tasks, SQL Integration Services, SQL Analysis Services, and SQL Reporting Services are covered. Working in Microsoft SQL Server, students experience hands-on learning in weekly labs to prepare them for real-world situations. Prerequisite: Recommended ICT 4400.