The goal of the Microsoft Certified Professional Developer program is to prepare students to work in the Information Technology field in a variety of positions working in software programming & development. Completers will be prepared to pass certification exams designed and administered by Microsoft. These certifications can be applied anywhere Microsoft operating systems are used, giving certification holders a great advantage in the competitive IT job market. This course combines MCPD competencies in Visual Studio Web Development & Windows Development.
Design & implement relational database models (both logical & physical) and database storage objects.-Program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR.
Retrieve & modify data using SQL queries
Tune & optimize queries.
The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.