3 semester credit hours
Affordability, functionality and scalability make SQL Server one of the best solutions for warehouse data critical to businesses. Post installation , Query Analyzer and Enterprise Manager will be used to configure, secure and administer SQL Server. An overview of databases, data types and database objects such as tables, constraints, indexes, triggers, stored procedures, views and functions will be covered. Data access and manipulation using transact SQL (TSQL) queries, linked servers, replication and data transfer methods will also be covered. Labs consist of assigned practice, projects and/or case studies relating to topics covered. Course contains 2 semester credit hours (30 clock hours) of lecture and 1 semester credit hour (30 clock hours) of laboratory work.
