Databases!

This week we’ll look at what databases are popular and how databases are used in 2023. We’ll look at other RDBMSs, ACID compliance, NoSQL, GraphQL, and beyond.

This week we’ll look at user management and permissions in MySQL, including the GRANT, SET and ALTER commands.

This week we’ll look at procedures in MySQL and how to store them.

This week we’ll look at how to create triggers, and how to use conditions and loops in MySQL.

This week we’ll cover creating views and custom functions in MySQL

This week we’ll talk about general principles for designing a database. We’ll look at constraints, indexes, and how normalization works up to the 3rd normal form.

Our normal lecture time falls on a holiday this year, so we’ll take our lab time to review some of the answers to the quizzes and exercise questions we’ve done this far.

This week we’ll learn how to use commands from DML & DDL, including INSERT, UPDATE, DELETE, REPLACE, CREATE, ALTER and DROP. These commands are very powerful, but I think you’ll find them simple to use!

This week we’ll cover types of table relationships; using OUTER JOINs to retrieve rows from multiple tables along with the various set operators, including the use of a self-join. We’ll also discuss the various data types used in MySQL in preparation for learning about Data Manipulation Language starting next week.

This week we’ll cover coding INNER JOINs to retrieve rows from multiple tables; table aliases; JOIN with implicit INNER JOIN syntax.

This week we’ll begin looking at aggregate functions. This will involve discussing data types, and some new keywords, like HAVING and GROUP BY.

This week we’ll start by reviewing and expanding on SQL queries and their clauses. We’ll introduce the concept of functions, and look at scalar functions in SQL.

This week we’re starting! We’re going to start by reviewing the course outline. After that, we’ll learn: what a database is, and how databases are used in web development; what SQL is; basic SQL terms definitions; simple single-table queries.