Expand your skills in the use and
implementation of relational databases!
The courses in the SQL Server 2005/2008 for Developers Series are designed for developers, administrators and database managers. Earn an SQL Server Developer Certificate by completing three required courses.
implementation of relational databases!
- Introduction to SQL Server 2005/2008 and Transact SQL (required course) 1 credit
- Moving from MS Access to SQL Server
(optional course) 1 credit
- SQL Server 2005/2008 for Developers
- SQL Server 2005/2008 for Administrators
- SQL Server 2005/2008 Performance Tuning for Administrator and Developers
Learn key concepts in relational database models and develop basic SQL server skills. This class is the foundation for all other SQL Server classes listed below.
Gain skills to move data and applications from Microsoft Access over to Microsoft SQL Server.
(required option 1) 3 credits
Enhance your knowledge on queries, data types, joins, searching, preventing SQL injection, rolling a database to production and advanced Transact-SQL.
(required option 2) 3 credits
Learn what is needed to be a SQL Server Administrator. From the basics of installation of SQL Server 2005 and 2008 to more advanced topics including replication, reporting, SSIS, backup and recovery.
(required course) 1 credit
This session covers performance tuning for SQL Server 2005, and 2008. This includes detecting slow queries, adding indexes, tuning queries. The information covered will be good for both administrators and developers who want to do their part to speed up their SQL Server.
November 17, 6-7pm, 405 32nd Street, Room 360
December 15, 6-7pm, 405 32nd Street, Room 360
