Microsoft SQL Server for Developers I, CMP985
MS SQL Server 2008, Microsoft's database server is in widespread use by companies to develop and manage large enterprise databases. Learn how MS SQL Server uses and handles Structured Query Language (SQL). Learn how to manage relational databases using MS SQL Server 2008 Management Studio; use SQL queries and sub-queries to insert, update and delete data; and work with data types and functions. Data manipulation and aggregation will also be covered. This course supplements the Information Technology Institute's .NET course sequences, or can be taken independently.
Proficiency with Windows (Working with Windows) is required; MS Access Level I and knowledge of Access relational databases, or equivalent experience is strongly recommended.
Classroom Hours: 18
Technology update: Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.
- Use SQL commands
- Apply developer interface features between Visual Studio.NET and MS SQL Server 2008
- Use SQL Server 2008 Management Studio to manage databases
- Work with MS SQL Server 2008 queries, sub queries, insert, update, and delete data, and work with data types.