PostgreSQL and MySQL for Beginners

Install PostgreSQL and Pgadmin from the official site, set up a database, connect securely, and write and run SQL using the Pgadmin query tool.

Celebrate this milestone in PostgreSQL and MySQL for beginners, and continue with motivated learning using subtitles, adjustable playback, offline downloads, Q&A, and an AI assistant.

Install and configure MySQL on Windows by setting up the server, shell, and Workbench, choosing custom options, and launching the Workbench to manage your tables.

Learn how to create and structure a PostgreSQL database by building a test database, adding tables for customers, products, and transactions, and writing create table statements with key constraints.

Create a training database, then define a customer table with customer ID, first name, last name, age, and email ID, using proper data types and character sizes.

Create a classroom database and a science class table with enrollment number (int), name (varchar), and signs marks (int), then test your sql skills.

Master inserting data into a PostgreSQL table using insert into, optional column lists, single or multi-row inserts, and handle not null constraints with the copy command for file import.

Insert data into a table using the insert command, including single and multiple rows, with or without column lists; understand nulls and type constraints when values mismatch.

Import data from a file into a PostgreSQL table using the copy command, handling csv and text files, delimiters, and optional headers, and compare with insert into.

Learn to import data from a csv file into a mysql table using load data in file, with path, fields terminated by comma, and ignore first row.

Insert three student scores into the science class table and import eight more from the student csv into the classroom database, using insert into and import techniques.

Use the select statement to retrieve data from a table, choosing specific columns or all columns with a wildcard, as shown on the customer table.

Learn to use the select statement to fetch data from a database table and return a result set. Use specific columns, from clause, and the star wildcard; apply distinct.

Learn how to use the distinct keyword in PostgreSQL to fetch unique rows, remove duplicates, and query single or multiple columns, including handling case differences and exact duplicates.

Learn how to use select distinct in MySQL to eliminate duplicate records and fetch unique values from a single column or from multiple columns in a table.

Learn how to retrieve data with conditions in PostgreSQL using the where clause, including numeric and textual comparisons, distinct values, and selecting specific columns.

Utilize the where clause to filter rows by conditions such as age equal to 25 or age greater than 25, and select specific columns from the customer table.

Master PostgreSQL queries by applying multiple conditions with and, or, and not to filter data precisely, including age between 20 and 30 and not equal to 25.

Learn how to use MySQL logical operators to combine conditions in select queries with and, or, and not. Build filters for age ranges and names to fetch targeted results.

Use select, where and logical operators to filter student data by score: retrieve names with more than 60, data for more than 35 but less than 60, and remaining students.

Learn how to perform updates in PostgreSQL by using the update syntax, set multiple columns, apply where conditions, and test changes with practical examples.

Learn how to update existing records in MySQL using the update command, including setting column values, applying conditions, and managing safe mode with sql_safe_updates.

Learn how to delete rows in PostgreSQL using delete from with a where clause, including single-row, multi-row, and full-table deletions, and verify results in PgAdmin.

Delete data in MySQL using delete from table where condition to remove specific rows or all rows. See examples by id and by age to illustrate affected rows.

Learn how to alter table structure in PostgreSQL using the alter table command, including adding, dropping, renaming columns, changing data types, and managing constraints and indexes on a customer table.

Add and drop not null and check constraints with alter table and alter column in PostgreSQL. Enforce primary and foreign keys, handle violations, and remove constraints to modify tables.

Explore how to alter tables in MySQL by adding, dropping, modifying, or renaming columns, and by applying constraints and indexes, with practical MySQL Workbench demos.

Update popeye's marks in the science class table, delete Rob's row, and rename the column from name to student_name.

Restore and back up a supermarket database using a provided backup file, create supermarket_db, and explore three tables: customer, product, and sales with their primary keys.

Diagnose and fix common database restoration issues in PostgreSQL using pgAdmin, including creating a new database, correcting binary paths, and selecting matching tar, backup, sql, or directory restoration methods.

Create a supermarket database by building customer, product, and sales tables in PostgreSQL, then load data from csv files using the copy command.

Back up the database into a tar file, drop the science class table by mistake, and restore from the backup to recover.

Import and export data in MySQL using MySQL Workbench by creating a database, importing dump structures and data from a file or folder, and exporting training data as a file.

Create a MySQL database from CSV files, define tables for customer, product, and sales with create table commands, and load data using load data infile in MySQL Workbench.

Explore using the in clause in PostgreSQL to filter results by multiple values, compare with or conditions, and prepare for subqueries while practicing select and where.

Explore how to use the in statement in MySQL to replace multiple or conditions in select, insert, update, or delete statements. See syntax and examples such as city in ('Philadelphia','Seattle').

Learn how to use the between condition in PostgreSQL to retrieve values within a range with inclusive lower and upper bounds, including age examples and ship date ranges.

Learn how to use the between operator in MySQL to filter records by ranges, including ages and dates, with between, not between, and equivalent comparisons.

Use the like condition in PostgreSQL to perform pattern matching with wildcards. Match starts, ends, or contained strings with percent and underscore, and escape literals with backslash.

Learn pattern matching with the like operator in MySQL, using percent and underscore wildcards, not like, and practical examples to filter names and cities.

Practice using in, between, and like with where clauses to query distinct cities in north or east regions, sales orders with values 100–500, and customer last names containing four characters.

Learn how to add multi-line and single-line comments in SQL queries, understand their syntax and execution effects, and recognize comment highlighting used to name the lecture.

Sort query results with the order by command in PostgreSQL, using ascending or descending order, multiple columns, or column numbers; apply to strings (city, customer name) and integers (age).

Master how the order by clause sorts select results, using ascending or descending order, with single or multi-column sorting by city, age, or customer name.

Use the limit statement in PostgreSQL to cap results and speed up queries on large datasets. Order by age and fetch the top eight oldest or ten youngest customers.

Learn to limit query results using the limit clause with order by, in descending or ascending order, to fetch top or least aged records.

Sort the result set by discount values in descending order, filter orders with discounts greater than zero, and display the top ten with the highest discounts.

Apply the as keyword to assign meaningful aliases to columns and tables, use double quotation marks for names with spaces, and prepare aliases to simplify complex queries and joins.

Learn how to use aliases in MySQL with the as keyword to rename columns and tables in queries. See examples like select customer_id as serial_number, customer_name as name.