Software Development Fundamentals: C# & Legacy MTA 98-361

Explore how the World Wide Web connects documents and resources via HTTP, with pages hosted on web servers and retrieved by browsers using URLs.

Explore how HTML describes web pages with markup tags, enables multimedia and scripts like JavaScript, and uses unique URLs that browsers read to render content.

Create your first web app with ASP.NET in Visual Studio, add a new web application, set a title, insert an h1 header and a paragraph, then view the page.

Convert text to hyperlinks with a tag and href, and use p element for paragraphs. Add images with img tag and src, using target to open in a new tab.

Learn to create and apply a css stylesheet in an asp.net web app, link it in the head, and style body and divs with fonts, sizes, and colors.

Learn how to add JavaScript to an ASP.NET web app by creating a button that displays the date and time when clicked, using a client-side script and document.getElementById.

Style an ASP.NET web app button with JavaScript by removing borders, setting white text, and adding padding, plus a hover effect that changes to blue via a CSS class.

Create and style multiple buttons with css and javascript, wiring a new demo function to button clicks, using a script tag, and using document.getElementById to update text and styles.

Learn how to add dynamic images with Javascript by toggling a light on and off with two images, using getElementById and DOM manipulation, and styling with a CSS stylesheet.

Store JavaScript in external files to improve maintainability and performance by reducing code repetition. Learn the difference between client-side and server-side programming, with browser JavaScript and asp.net-based web apps.

explains the hsp dot net infrastructure, including the web communication classes and the runtime worker process, and shows how asp.net requests flow through iis, compilation, and response.

Explore how a web page request executes in ASP.NET by examining network timing. Examine how the Bates class derives from System.Web.UI.Bates and exposes request, response, and session properties.

Explore how ASP.NET powers web forms and web services, and trace the page life cycle from initialization through loading, event handling, rendering, and unloading, including postback processing.

Understand state management in web development by comparing client-side and server-side techniques and learning how to preserve a web page’s state across round trips and user interactions.

Learn client side state management techniques such as query strings, cookies, and hidden fields to store state in the browser. See how these methods help maintain control state across postbacks.

Explore server side state management with session ids and cookies. Understand system and application state, shopping carts, and global data on a web farm.

Define variables as storage locations with symbolic names that hold values; show how values change during runtime, aliasing, and basic assignments in programming.

Explore common value types like bool, int, char, float, double, and string, and contrast strongly typed versus weakly typed languages while distinguishing assignment from equality in variables.

Learn how programs declare and update variables to store values. Explore arithmetic and remainder operators, string concatenation, and logical, relational, and conditional operators that produce boolean results.

Learn how conditional statements drive program flow using the selection structure. See a C-sharp example where a boolean condition selects add or subtract with if-else.

Explore loops as a fundamental programming structure, learn how while and do-while loops control repeated executions, manage conditions, and avoid endless loops using simple Hello World examples.

Explore how arrays in C store a fixed-size collection of integers, using a ten-element array, zero-based indexing, and a loop to initialize and print elements.

Explore how functions transform inputs into outputs through reusable code blocks and modularity. Gain insight into function headers, return types, parameters, and the role of main and built-in functions.

Explore file input and output fundamentals, including reading and writing files, and common modes such as read-only, write-only, read and write, and append, with examples in C++, Java, and Python.

Develop your first quiz game in C# by generating random arithmetic problems, enforcing a timer, and guiding flow with if statements while practicing the Random class and basic arithmetic operations.

Design a Windows Forms quiz interface in Visual Studio using C#, shaping the form with fixed 3d borders, adding labels and a numeric up-down control for the timer.

Add a start button, name it using camel case, and set its text to start the quiz. Set font to 14 and enable resize to fit.

Start coding by creating a randomizer, declare two integer variables, and display random numbers on the left and right labels when the start quiz button runs, preparing a timed quiz.

Add a countdown timer for the quiz using a time left variable and a timer control with a 1000 ms interval, updating the time label and stopping at zero.

Code the checkTheAnswer method to verify if add plus one plus two equals the sum from the numeric up-down control, returning true or false and triggering timer feedback.

Learn to code a subtraction problem by creating two integer variables minus one and minus two, generating random numbers between 1 and 100, and validating the answer.

Enhance the quiz by adding multiplication and division problems using four new integer variables, randomize operands, and display results with asterisk and slash symbols, using a temp variable for division.

Customize the quiz by adjusting the time left display and color cues, and finalize its behavior with breakpoints and debug versus release builds in a C-sharp quiz program.

Learn object oriented programming as a paradigm of objects with attributes and methods that interact to form modular, reusable software.

Learn the fundamentals of object oriented programming by distinguishing objects from classes, where classes define data and methods and objects are their instances, illustrated by circles and shopping carts.

Explore object oriented concepts by defining a class instance and distinguishing class variables, instance variables, member variables, class methods, and instance methods.

Explore encapsulation and data hiding in object‑oriented programming, learning how binding data with methods protects internal data from outside interference, enables abstraction, and supports safe refactoring.

Understand how objects communicate via message passing and dynamic dispatch to select the correct method. Differentiate multiple dispatch from static module implementations and recognize uni directional messages between objects.

Explore inheritance as a mechanism to create derived classes from base classes, reusing attributes and methods while adding new ones, and understand single, multiple, multilevel, hierarchical, and hybrid inheritance.

Explore polymorphism in object-oriented programming by using subtyping across shapes like circle and square, where the same draw method behaves differently, enabling abstraction and the separation of concerns.

Learn how generalization forms a generalized superclass from subclasses and how specialization creates specialized subclasses from a superclass, establishing is-a relationships and guiding team coding decisions.

This lecture defines links and associations in object oriented programming, explains one-to-one, one-to-many, and many-to-many cardinalities, and shows how a link represents an instance of an association, with database implications.

Master SQL through a three-step process to retrieve and manage data across relational databases and the major relational database management systems.

Learn SQL, the standard language for relational databases, to store, manipulate, retrieve data, and define databases and tables. See why popular web and mobile apps rely on these databases.

Install a free cross-platform web server stack with Apache, MySQL/MariaDB, PHP, and Perl using XAMPP, then connect with SQLYOG as the database client.

Start and stop server modules to manage web and database services. Launch the Apache web server and the MySQL/MariaDB server, verify the process status and the default port 3306.

Connect to the local skill host, create a new test database with a query, and verify success; then view the empty object browser for tables, views, procedures, and more.

Use SQL queries to view, create, and drop databases; execute commands and refresh the browser to verify results, while understanding that dropping a database erases all data without backup.

Create a students table: id integer primary key, name varchar(30) not null, and grade decimal. Run the query, fix syntax errors, and verify the table by refreshing.

Drop a table using the drop table syntax, verify the result with a select, and insert new rows with the insert into statement in MTA 98-361.

Learn to construct insert into statements by listing table name, optional column names, and values, with examples inserting into a students table and refreshing data to verify results.

Create a new table from an existing table using the create table as select statement to copy all data, and understand that a select statement returns data as result sets.

Master the basic select statement syntax, using select * from table. Fetch specific fields, such as names and aids, from the students table by listing columns and executing.

Filter records with the where clause in select statements, such as selecting name and AIDS from students where AIDS equals 10, using quotes for string comparisons.

Explore SQL operators by filtering data with greater than, less than, and equal comparisons, then combine conditions using and and or to refine selects like name and age from students.

Use update queries to modify existing records by setting column values with a where condition, verify results with a select, and see how all rows can be updated.

Delete from students where name is equal to Chris demonstrates deleting specific records, then delete from students to remove all records without a where clause.

Explore the like operator in where clauses and how wildcard characters enable matches such as contains, starts with, and flexible name searches.

Learn how to limit data across MySQL, MSSQL, and Oracle using limit, top, and rownum, with cross-database examples to fetch the top three records from a table.

Use the order by clause to sort data in ascending or descending order on one or more columns, such as aides and names.

Use the group by clause with a select statement to group identical data before the order by clause, such as grouping by name and summing ages.

Master how to use the distinct keyword with select to return only unique values and eliminate duplicate records from query results.

learn how to delete all data from an existing table using delete from, drop table, and truncate table, with a hands-on example clearing the students table.