Microsoft SQL Server for Developers I, CMP985
MSSQL Server 2012, Microsoft’s database server, is in widespread use by companies to develop and manage large enterprise databases. Learn how MSSQL Server uses and handles Structured Query Language (SQL). Learn how to manage relational databases using MSSQL Server 2012 Management Studio; use SQL queries and subqueries 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. Prerequisites: 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 2012
- Use SQL Server 2012 Management Studio to manage databases
- Work with MS SQL Server 2012 queries, sub queries, insert, update, and delete data, and work with data types.