SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

Install Microsoft SQL Server on Windows using the Express edition, verify prerequisites such as Windows 8 or 10, then install and launch SQL Server Management Studio to interact with databases.

Learn to upload the consumer complaints dataset into PostgreSQL using pgAdmin, create a database and table, import CSV data, fix file permissions, and leverage SQL for efficient data handling.

Explore pgAdmin 4, navigate databases and public schemas, run queries with the query tool, use explain to see how data is connected, and save or load queries.

Explore Microsoft SQL Server Management Studio to navigate Object Explorer, create new queries, execute them, and leverage drag-and-drop and shortcuts for efficient, well-organized work.

Understand theory of the select query, the SQL statement with mandatory select and from clauses, and learn to pull specific columns or all data with select star and where clauses.

Learn how to use comments in PostgreSQL, including single-line -- and multi-line /* */ syntax in pgadmin, to annotate code and aid debugging.

Explore the varchar data type in MS SQL Server and manipulate text in the console games table. Apply left, right, and reverse functions to extract and inspect game names.

Learn how to handle null values in MS SQL Server by deleting, updating, or filling in null data using practical examples on the console games table.

Explore the elements of a database, including tables, schemas, catalogs, and extensions, then examine relations, attributes, tuples, degree, cardinality, domains, and primary, foreign, or super keys.

Learners explore relational keys in SQL, including super keys, candidate keys, primary keys, and foreign keys, with examples using employee ID, first name, last name, and platform name.

Explore how duplicates in the join column of order numbers affect inner joins between orders and itemized orders, showing how multiple matches replicate rows and reveal paid versus unpaid status.

Upload csv files to a database, join pets with owners, map procedures to descriptions, handle nationwide vs clinic-specific datasets, and generate a two-column owners vs procedure prices table.

Upload the pet dataset into a PostgreSQL database using pgadmin 4, create the pets and owners tables, paste the upload code, and verify data with select queries.

Perform a left join to connect pets and their owners via the foreign key owner_id, preserving all pets while selecting precise fields from each table.

Discover practical tips for joins, including using table and column aliases to simplify complex queries, and understand how left and right joins relate for cleaner SQL.

Join the procedure history and procedure details tables on multiple fields, specifically procedure type and procedure sub code, to reveal complete procedure descriptions and prices.

Explore complex joins across pets, procedure history, and procedure details using inner joins and a left join to reveal which pets had procedures, and show procedure descriptions and costs.

Master the cross join in SQL, the Cartesian product of two tables, an advanced topic, and learn how to generate all possible combinations without an on clause.

Learn how to perform an inner join between the pets table and the procedures history table, and compare inner, left, and right joins with practical MS SQL examples.

Full outer join is demonstrated with a pets table and procedures history table, showing unmatched rows left blank and how it compares to left, right, and inner joins.

Learn how to create a PostgreSQL database using pgadmin four, including naming, connecting, and verifying schemas and tables. The session explains database versus data operations and shows GUI-generated SQL.

Use alter table to set country default USA and add a directors column, then update specific rows with proper constraints and case handling to reflect Christopher Nolan for Interstellar.

Delete specific rows, drop and alter columns, understand drop cascade, and remove databases using pgadmin to manage table structures and constraints.

Create your first database in SQL Server Management Studio by right-clicking databases and selecting new database, then name it and set file properties, owner, and version level.

Explore the first normal form (1NF) in database design, ensuring no duplicate rows and single-valued cells. See practical examples and a mnemonic to remember its criteria.

Explore normalizing a transactions table to first normal form by checking for unique rows and atomic values, and verify there are no duplicates using count and distinct.

Explore second normal form by identifying candidate keys and prime attributes in a transactions table. Learn how non-prime attributes must depend on whole key and how to split for 2NF.

Learn how to modify an MS SQL Server database to achieve second normal form by moving customer-specific columns from transactions to a new customers table with a foreign key.

Celebrate your completion of the SQL & database design A-Z course with a travel-inspired finale from Tasmania. Encourage learners to rate and review to help others discover the course quality.