Designed to provide specialized vocational preparation for entry-level IT roles in .NET development. Students build Windows Forms and Web-based .NET applications using C#, SQL Server, and Visual Studio, with emphasis on OOP, database programming, advanced C# features, and application deployment.

• Understand concepts and components of the .NET Framework 4.5
• Create simple C#.NET Windows Forms applications
• Create simple C#.NET Web Forms applications
• Create a complex .NET application that uses flat files and data streams
• Enhance .NET apps using LINQ with SQL Server; learn Entity Framework basics
• Develop web pages using HTML5 and CSS; understand MVC and build MVC applications
• Use WCF to develop Web Services; use WebAPI for RESTful services
• Learn JavaScript fundamentals and frameworks; understand Angular architecture

Textbooks, individual PCs.

• Murach’s ASP.NET 4.5 Web Programming with C# 2012 (7th Ed.) — ISBN 978-1943872534
• Murach’s ASP.NET 4.6 Web Programming with C# 2015 — ISBN 978-1890774950
• Murach’s SQL Server 2019 for Developers — ISBN 978-1943872572

Lecture instruction combined with lab application: lecture, coding demonstration, discussion, presentations, and practical application.

• Notify the school 24 hours in advance when unable to attend.
• Tardiness/partial absence is recorded in 15-minute increments.
• Three partial absences constitute one full absence.
• For further details, consult the current Catalog.

• Students must inquire about make-up work for lectures and labs.
• Instructor will not re-teach material.
• Refer to Make-Up Standards and Tutoring sections of the Catalog; fees may apply.

• Provide a course syllabus at the beginning of the course.
• Evaluate assignments/assessments/projects according to grading criteria.
• Maintain accurate attendance and grade records; report attendance each meeting; report grades mid-term and final.
• Unannounced quizzes and special projects may be administered at instructor discretion.
• Student–teacher ratio and maximum capacity: see current Catalog.

Vocational preparation for SQL DBA / SQL Developer roles: database fundamentals, T-SQL query writing, design and implementation in SQL Server, plus backup/recovery, reporting (SSRS) and integration (SSIS).

• Use SQL Server tools (SQL Server 2014 tools referenced in objectives).
• Apply SQL commands; work with SQL functions.
• Create/modify/use views and procedures; write complex queries.
• Develop a backup and recovery strategy.
• Overview of SSRS; migrate/transform data using SSIS.

Textbooks, individual PCs.

• Beginning SQL Server for Developers (4th ed.) — ISBN 978-1484202814
• Professional SQL Server 2014 Administration — ISBN 978-1118859131
• Learning SQL Server Reporting Services 2014 — ISBN 978-1849689922

Lecture + lab application: lecture, coding demonstration, discussion, presentations, practical application.

• Notify 24 hours in advance when unable to attend.
• Partial absence recorded in 15-minute increments; three partial absences = one full absence.
• Consult current Catalog for full policy.

• Students must inquire about make-up work; instructor will not re-teach material.
• Consult Make-Up Standards and Tutoring sections of the Catalog; fees may apply.

• Provide syllabus at beginning of course; evaluate work per published criteria.
• Maintain accurate attendance/grade records; report attendance each meeting; report grades mid-term and final.
• Unannounced quizzes and special projects may be given.
• Student–teacher ratio and capacity: consult current Catalog.

Covers fundamentals of Data Warehouses, ETL concepts, SQL Server Data Tools, and building SSIS solutions (sources/destinations/transformations), plus reporting (SSRS) and analytics (SSAS), KPIs, deployment, and incremental loads.

• Create an SSIS project and ETL packages; work with sources/destinations and transformations.
• Use OLE DB Command transformation; SSIS Control Flow tasks; security and deployment.
• Package configurations; incremental load; reporting with SSRS.
• Data mining, dimensions, cubes; define KPIs; deployment and security.

Textbooks, individual PCs.

• Professional Microsoft SQL Server 2014 Integration Services — ISBN 978-1118850879
• Professional Microsoft SQL Server 2012 Reporting Services — ISBN 978-1118101117

Lecture + lab application: lecture, coding demonstration, discussion, presentations, and practical application.

• Notify 24 hours in advance when unable to attend.
• Partial absence recorded in 15-minute increments; three partial absences = one full absence.
• Consult current Catalog for full policy.

• Students must inquire about make-up work; instructor will not re-teach material.
• Consult Make-Up Standards and Tutoring sections of the Catalog; fees may apply.

• Provide syllabus at course start; evaluate work per published criteria.
• Maintain attendance and grade records; report attendance each meeting; report grades mid-term and final.
• Unannounced quizzes and special projects may be given at instructor discretion.
• Student–teacher ratio and capacity: consult current Catalog.

Covers software testing/QA principles and practices (manual + automation), bug reporting, test plans/cases, and Selenium/WebDriver-based automation. Includes core testing concepts such as regression, black/white box, UAT, alpha/beta testing, test specification and reporting.

• Quality management processes; fundamentals of software testing; manual and automation testing.
• Segregate QA, quality control, and quality planning activities.
• Understand standards in quality management and their influence on the final product.
• Apply quality tools to support continuous improvement.
• Prepare for globally recognized QA certification programs.

• Learn Selenium: Build data-driven test frameworks (Selenium WebDriver 3) — ISBN 978-1838983048
• Unit Testing Principles, Practices, and Patterns (C# examples) — ISBN 978-1617296277

Lecture + lab application: lecture, coding demonstration, discussion, presentations, practical application.

• Notify 24 hours in advance when unable to attend.
• Partial absence recorded in 15-minute increments; three partial absences = one full absence.
• Consult current Catalog for full policy.

• Students must inquire about make-up work; instructor will not re-teach material.
• Consult Make-Up Standards and Tutoring sections of the Catalog; fees may apply.

• Provide syllabus at the beginning of the course; evaluate work per criteria.
• Maintain accurate attendance and grades; report attendance each meeting; report grades mid-term and final.
• Unannounced quizzes and special projects may be given.
• Student–teacher ratio and capacity: consult current Catalog.