Course Length: March 2 – August 26, 2021
Class Meetings: Tuesday – Thursday, 6:00 – 8:30 p.m.
Format: Virtual Instruction
Tuition: $5,000
This class is a broad overview of full stack software development with an emphasis on C# and SQL. The first priority is to build a strong foundation in programming using the C# programming language. Next, we learn how to work with relational databases using the SQL language. Finally, we learn the basics of building front-end web applications using html, css, and javascript.
Along the way students will work with common development tools such as Visual Studio Code, SQL Server Management Studio, and github. For C#, we cover variables, conditional logic, loops, the type system, classes, methods, and the principles of object oriented programming. For SQL, we cover select, group by, insert, update, delete, joins, table design, data normalization, and stored procedures. For web development, we introduce html, css, and javascript, and take a look at libraries and frameworks such as Bootstrap and React.
We learn how to connect a C# application to a database using the Entity Framework. We learn how to expose a C# application to the outside world by building a restful web API. We learn how to connect a web application to a backend web API using AJAX and JSON. By the end, the student will have solid experience programming in C# and SQL, and should be able to build a basic web application that interacts with a backend database.