Introduction to Web Development by Evan Gertis

Explore the differences between local storage and session storage in the browser, and learn how to set, get, remove, and clear items, while understanding data persistence across sessions.

Explore object oriented programming as a popular paradigm that uses classes, constructor functions, instantiation, and inheritance to model real world entities.

Discover how node.js powers scalable network applications, build a basic http server returning hello world on localhost:8000, and understand ltsc versus current 4.x and 5.0 version differences.

Explore the node path module to work with directories and file paths, and learn how path.parse returns an object with route, directory, base, name, and extension.

Explore the node filesystem module to work with your computer's file system, run the demo and view output in the browser, and rename files with fs.rename.

Learn to test a Node.js app with mocha, create tests, run mocha, and verify sum and product calculations, including a product function that returns 1 when no arguments are passed.

Explore SQL data types, including integer, date, date time, timestamp, bit, and varchar (variable length string), and learn to create tables, define column types, and insert data to see results.

Explore how XAMPP, a free Apache distribution with MariaDB, PHP, and Perl, helps you start and stop the Apache module and check the PHP version from the control panel.

Learn the four basic SQL operations—create, read, update, and delete—through hands-on use of insert into, select, update, delete, and alter table commands, plus dropping a database.

Explore advanced SQL selectors to control queries with order by ascending and descending, where, like and not like, in and between, plus creating and dropping indexes and using aliases.

Learn how primary keys uniquely identify records and cannot be null, how foreign keys link tables, and how inner, left, right, and full outer joins combine related data.

Explore sql functions, including counts, min, max, and string operations like cat to concatenate values, plus group by, aggregate functions such as sum, and pattern matching with percent and underscore.

Install EJS via npm, configure Express to use EJS as the view engine, and render templates by passing data with script tags for flow and output.

Explore agile development as an iterative, sprint-based alternative to waterfall, emphasizing adaptability and early problem detection through self-organizing cross-functional teams and collaboration, with a practical mock project example.

Learn how to group items using a list of values, convert between arrays and lists, and handle nulls with conditionals in a practical exercise using Visual Studio Code.

Master practical interviewing and job-hunting tips, from punctual arrival and knowing the interviewer's name to preparing questions, organizing resumes and transcripts, and following up with a thank-you note.