Top Database Bundle: MySQL, PostgreSQL, SQLite3, SQL Server

Think of a database as a big spreadsheet: tables hold rows called records and columns enforce uniform data types, enabling add, update, remove, and retrieval across multiple tables.

Download and install python 3 or newer from python.org, ensure add python to path, so you can run python from anywhere; the video also introduces Sublime Text as an editor.

Install git bash on Windows to get a unix-like terminal for learning git. Download from git-scm.com, install with default vim, adjust path, and prepare for future MySQL work.

Insert many records into the users table using Python by building a list (array) of tuples, executing the insert with placeholders, and committing to reveal auto-incremented IDs.

Learn to pull data from a table using a cursor to execute a select, fetch results, loop through rows, and print names in a readable report.

Format query results into readable text reports by building a string with placeholders, interpolating row data, and using tabs to align name, email, age, and id.

This lecture demonstrates using the like clause and wildcards to search for names, showing how the wildcard percent enables prefix and substring matching with examples like John, Tim, and Tina.

Identify how to limit query results with limit and offset, and sort with order by name in ascending or descending order.

Delete records using a simple sql delete statement with a where clause, targeting the user_id primary key and committing changes to make the removal permanent.

Ask questions anytime and get quick help from the instructor as you learn to set up Postgres locally with PG Admin on Windows, Linux, and Mac.

Launch pgAdmin from the Postgres installation, view the web browser dashboard, create a new database named my database, then explore schemas and tables.

Discover how the PostgreSQL where clause narrows query results using comparison operators such as =, !=, >, <, >=, <=, and like, with practical examples on a customers table.

Explore how PostgreSQL wildcards in the where clause use the percent sign with like. Learn starts with, ends with, and middle searches with examples like John Elder and Smith.

Explore how to combine conditions in PostgreSQL using and, or, and not within where clauses, including practical examples with email patterns and id checks.

Learn to use the PostgreSQL delete from table with a precise where clause on the id to remove a specific row, and observe how the serial sequence advances after deletion.

demonstrates how postgresql uses the limit clause as a substitute for select top, shows selecting the top N records with limit and offset, and notes that percentage limits don't work.

Perform an inner join between the public customers table and the customer ages table on matching ids to display names and ages.

learn to back up and restore a PostgreSQL table by exporting to a csv file, saving it locally, and re-importing after recreating the table, with a note on database backups.

Install sublime text and the git bash terminal to set up your coding environment. Download, install, and launch these free tools on Windows or Mac.

Execute queries with a cursor to select all from the customers table, then fetchone, fetchmany, or fetchall, and print the results as a Python list for display.

Learn to fetch one or all records, access fields by index, and format results with loops, concatenation, and tabs in Python when working with SQL data.

Create a simple Python app by importing the database module, defining a show function, and querying the database to display all records, preparing for additional functions.

Create an add record function to insert a new customer into the database using a connection and cursor, placeholders for first name, last name, and email, then commit and close.

Learn to build an add many records function that uses execute many to insert into customers values. Create a two-record list and verify the bulk insert works.

Create a where clause function to look up emails by querying the customers table where email equals a provided value, then fetch and display the results.

Visualize a database as a collection of tables with rows and columns. Treat records as rows and fields as columns, using Excel as a familiar analogy.

Master using and, or, and not in where clauses to filter by age and first name, with examples of equals and like conditions.

Explore how to sort query results with order by, choosing ascending or descending order by last name or age, and understand default ordering.

Explore the top clause in SQL by selecting top N or top percent of records. Order by age or other fields to rank results, with examples like top five customers.

Learn how to use select distinct to retrieve unique records, such as states, and see Illinois duplicates collapse into a single result; the union operator comes next.

Explore common SQL functions such as data length, lower, upper, count, average, max, and sum, and learn how to apply mathematical operations and parameters in queries.

Master the update statement in sql by using set and where clauses to modify specific records, such as updating a customer's city and state.

Master changing nullability with alter table: switch city to allow nulls or not null, noting existing data can block not null, requiring drop and re-add or column alteration.

Create a table by naming it, defining columns with data types, and applying not null or default null, then execute the command to add it.

Learn the difference between delete and drop, how delete from with a where clause removes data, and how drop table removes the entire table.

Link two tables with an inner join to pull matching records from current customers and customer orders using the ID key, returning first names, last names, and widget orders.

Create and drop indexes to speed up searches on large tables, such as indexing the email column in current_customers.