Using MS SQL Server, this course covers ANSI/SQL where students will learn, through hands-on tasks and lectures, the SQL statements to retrieve from and modify data in relational databases, aggregate and group data using summary functions; create stored procedures and triggers; data integrity and database normalization principles; query optimization and use of indexes; transaction management and locking schemes and learn to create a database and tables.
Prerequisite: Microsoft Windows and ability to type 20 WPM. Must have some programming experience or must have completed Beginning Programming course. Must be competent in navigating in Windows environment.
Required Materials: Text