4-in-1 bundle: MySQL, PostgreSQL, Microsoft SQL & Oracle SQL

Install PostgreSQL and Pgadmin to create and connect to a database, then use the query tool to write sql, manage databases, schemas, tables, and review query history.

Congratulate yourself on reaching this milestone as part of the top 50% of learners and staying committed to the course, and use playback controls, subtitles, and Q&A to continue.

Install and set up MySQL server, MySQL shell, and MySQL Workbench on Windows, using the installer and selecting only required components.

Install and set up Microsoft SQL Server 2019 express and SQL Server Management Studio, connect to the server, and create a test database to verify functionality.

Install Oracle express edition from the Oracle download, set up the express database on Windows or Linux, and install Oracle SQL Developer to create and test a connection.

Create a PostgreSQL database named training and design tables for customers, products, and transactions using create table syntax, with not null, default, unique, check, primary key, and foreign key constraints.

Set up a MySQL database and create a training database. Build a customer table with id, first name, last name, age, and email using appropriate data types and sizes.

Create a database named training and a customer table using a create command in MS SQL, with customer_id int, first_name varchar(30), last_name varchar(30), age int, and email varchar(30).

In Oracle SQL Express Edition, you cannot create a database; you connect to existing schemas. Create a training connection to access tables and import data from CSV.

Create a classroom database and a science class table with enrollment number (integer), name (varchar), and signs marks (integer), using the query tool as part of exercise 1.

Master inserting data into the customer table in PostgreSQL with insert into, including optional column names, single and multi-row inserts, and handling missing values.

Master the insert command in MySQL to add data to a table with single or multiple rows. Insert with or without column names by handling null values and data types.

Learn to insert data into a ms sql table using insert into and values. Practice inserting single and multiple rows with optional column lists and verify with top 1000 rows.

Master Oracle SQL inserts: use insert into with or without column names, handle nulls, ensure correct data types, and perform multi-row inserts with unions.

Import data into a PostgreSQL table using the copy command, handling csv and text files, delimiters, and headers, with file paths and column specifications.

Import data into MySQL customer table from a csv or text file using the load data in file command, with path, fields terminated by comma, and ignore the first row.

Import data into a MS SQL table using bulk insert from a csv file, specifying the table, csv format, header skip, and comma and newline terminators.

Learn to import data from csv and text files into Oracle SQL using Oracle SQL Developer, with utf-8 encoding, comma delimiters, header handling, and column mapping.

Insert three students' scores into the science class table using the insert into command, then import eight more scores from the student CSV file to complete the dataset.

Master the select command in PostgreSQL to fetch data from the customer table, choosing specific columns or using the wildcard to retrieve all columns and view result sets.

Master the select statement in MySQL to fetch data from a table, choosing specific columns or all columns with a wildcard, and view the resulting data set.

Learn how the select statement retrieves data from the customer table to visualize names, ages, and emails, using the star wildcard to display all values, including the top thousand rows.

Explore how the select statement queries data from a table, choosing specific columns or all columns with a star, and preview the upcoming distinct function to remove duplicates.

Use the distinct keyword in PostgreSQL to fetch only unique values and remove exact duplicates from queries on the customer table, including single or multiple columns.

Use the distinct keyword with select to eliminate duplicates and fetch unique values from a table, such as distinct first name from customer table, for a specific column.

Learn how to use distinct in MS SQL to remove duplicates and return unique first names from the customer table, then combine names with ages to show when duplicates appear.

Use select distinct in Oracle SQL to remove duplicates, selecting unique first names from the customer table, and learn how multiple columns yield unique first name and age combinations.

Use the where clause to filter data in PostgreSQL. Write queries with select, from, and conditions like age = 25 or age > 25, and explore distinct results.

Learn to filter data with the where clause in MySQL by applying conditions in select queries, using examples like age = 25 and age > 25.

Use the where clause in MS SQL to filter results by conditions in a select statement, such as age comparisons and name-based filters on the customer table.

Filter query results in Oracle SQL using the where clause to select rows by conditions such as age equals 25, age greater than 25, or last name equals IEEE.

Apply logical operators in PostgreSQL to retrieve data with multiple conditions using and, or, and not, including examples such as age between 20 and 30.

Explore how to use and, or, and not to combine conditions in MySQL queries, mastering select statements, syntax, and practical examples.

Learn to use logical operators in MS SQL to combine conditions with and, or, and not, filtering customers by age ranges and names in select queries.

Learn how logical operators in Oracle SQL combine conditions using and, or, and not to filter data, with age-based examples and not-equal exclusions.

Practice using select, where, and logical operators to filter student scores: retrieve names with more than 60, all data for scores between 35 and 60, and all other students.

Learn to update records in PostgreSQL using the update query by specifying the table, setting columns, and applying where conditions to modify ages, names, and emails for multiple targets.

Learn how to use the MySQL update command to modify existing rows with set clauses and conditions, handle multiple rows with OR, and manage safe mode with sql_safe_updates=0.

Learn to update records in MS SQL with the update statement, setting age and last name by customer ID and updating emails based on first name conditions.

Update in Oracle SQL demonstrates using update with set to modify age and last name in the customer table, and update email with case sensitivity, before moving to delete statements.

Master deleting rows in PostgreSQL with delete from customer table where condition, including single-row, multi-row, and full-table deletions. See practical examples deleting customers by age or ID and verifying results.

Delete data in MySQL using the delete query with a table and condition, such as id = 6 or age > 25, or delete all rows.

Use delete from in ms sql to remove specific rows with conditions, such as customer_id = 6 or age > 35, and demonstrate deleting all rows from a table.

Delete from table using where clause to remove rows, such as customer_id = 6 or age > 25, and note that omitting a condition deletes all rows in Oracle SQL.

Explore how to alter a PostgreSQL table: add, drop, modify, and rename columns; change data types; and manage constraints and indexes using the alter table command.

Learn how to alter tables in PostgreSQL to add or drop constraints such as not null, check, primary key, and foreign key, with hands-on examples and syntax.

Learn how to alter a table in mysql by adding, dropping, modifying, or renaming columns, and by adding or dropping constraints or indexes, with practical examples on a customer table.

Learn how to alter MS SQL tables to add, drop, or modify columns; rename objects; and add constraints such as not null, check, and primary key, plus indexing options.

Alter Oracle SQL tables by adding, dropping, renaming, or modifying columns, and apply constraints such as not null, check, primary key, and foreign key.

Learn to update Popeye's science score from 33 to 45, delete Rob's row, and rename the column from name to student underscore name in the science class table.

Learn to backup and restore a database by restoring supermarket db from a backup file, then work with three tables: customer, product, and sales, and run queries to verify data.

Debug PostgreSQL restoration issues by creating a new database before restore and ensuring backup compatibility with the target version. Use tar, backup, SQL, or directory methods and adjust binary paths.

Create customer, product, and sales tables and load data from CSV files using the COPY command in PostgreSQL, with primary keys for the customer and product tables.

Learn to back up a database into a tar file, make a mistaken drop of the science class table, and restore the database from the backup to recover data.

Learn how to import and export data in MySQL Workbench by importing SQL files or folders, creating a new database named Super DB, and exporting dumps.

Create a MySQL database named super mart db, define customer, product, and sales tables, and load data from provided CSV files using load data infile, verifying row counts.

Learn how to back up and restore an MS SQL database, including backup options, file paths, and restoring from devices for database named my DB.

Restore a database from backup, then create a new database from csv using create table and bulk insert to import customers, products, and sales data, and verify with select queries.