Microsoft Database Management
CNSE M35 -- 1.5 Units
Microsoft SQL Server Administration
Prerequisite: CNSE M31
Class Hours: 1 lecture & 1.5 lab
This course provides an overview of SQL Server, including installation; upgrading from previous versions;
system configuration and architecture; database files; transferring data; web publishing and full-text
indexing; backing up databases; restoring database s; logins, user accounts and user roles; permissions
and security planning; automating administrative tasks; monitoring and maintaining SQL Server; and
planning, setting up, and managing replication. Applies to Associate Degree.
CNSE M39 -- 1.5 Units
SQL Server Implementation
Prerequisite: CNSE M35
Class Hours: 1 lecture & 1.5 lab
This course provides an overview of SQL Server and Transact-SQL. Includes creating databases, creating
database objects; implementing data integrity; planning and creating indexes; maintaining indexes;
querying multiple tables and advanced query techniques; summarizing data; implementing views; managing
transactions and locks; working with distributed data; implementing stored procedures; and implementing
triggers. Applies to Associate Degree.
CNSE M48 -- 1.5 Units
Microsoft SQL Server Data Warehousing
Prerequisite: CNSE M35 & CNSE M39
Class Hours: 1 lecture & 1.5 lab
This course provides advanced level instruction in database management emphasizing data aggregation and
trend comprehension. This is the third in a three course series to provide comprehensive Microsoft
SQL Server Database Management skills. Applies to Associate Degree. Transfer Credit: CSU.
CNSE M49 -- 1.5 Units
Microsoft SQL Server Client Application Architecture
Prerequisite: CNSE M48
Recommended Preparation: CNSE M35 & CNSE M39
Class Hours: 1 lecture & 1.5 lab
This course provides advanced level instruction in database management emphasizing client-side programming
using Microsoft Access. This is the fourth course in a series to provide comprehensive Microsoft SQL
Server database management skills.
Applied to the Associate Degree. Transfer credit: CSU.
| 
