MySQL : Complete course

Explore how SQL powers relational databases to insert, update, delete, and retrieve data, and to create and modify structures, using a declarative, domain-specific language.

Install MySQL Workbench by downloading the MySQL community GPL installer, configure server 8.0.32 and MySQL Workbench, and set root password along with environment variables.

Explore SQL datatypes for columns, including integer, big int, float, double, decimal with precision, char vs varchar, blob, date, time, timestamp, and boolean, with practical format rules.

Learn to use MySQL Workbench to create databases and tables, log in, navigate the interface, and run the create database syntax, noting that sql is case insensitive.

Create a table with serial number int, name varchar, and marks varchar in a selected database, using create table and database.table syntax; then describe the table to view its structure.

Learn how to use alter table in MySQL to add, modify, rename, or drop columns, specifying table name, column name, and data type, with examples in MySQL Workbench.

Use the drop command to permanently delete a table or database, removing its structure, data, indexes, triggers, constraints, and permissions.

Use the truncate command to remove all rows from a table. The table structure remains intact, and all records are erased, as shown with the employee table.

Learn how to rename a table in mysql using the rename command, a data definition command, with an example renaming the employee table and verifying the new name.

Compare delete, truncate, and drop in MySQL: delete can be undone for specific rows, while truncate clears all rows preserving the table, and drop removes the entire table.

Learn to insert data into a table with insert into table values, optionally specify columns to skip or assign only certain attributes, and insert multiple rows in one statement.

Discover how to use the update command to modify table data with set and where clauses, update a city in the award table to Oslo, and manage safe update mode.

Learn how to delete rows in MySQL using the delete from table command, with optional where conditions to remove specific rows or all rows, demonstrated with an id 112 example.

Learn how commit, rollback, and save points control MySQL transactions by manually committing, undoing changes, and rolling back to a save point.

Learn how primary key constraints uniquely identify table rows and enforce not null and uniqueness. Explore how defaults influence key behavior and prevent duplicates in MySQL.

Explore how the unique constraint enforces distinct emails in the student table, with id as the primary key and duplicate entries triggering an error.

Apply the not null constraint to ensure attributes contain values, with primary keys formed by unique and not null constraints, then examine foreign keys and referential integrity.

Define a MySQL student table with a check constraint ensuring age is at least 16, then insert values to demonstrate constraint enforcement and error when age falls below 16.

Learn how foreign key constraints enforce referential integrity between the customer and order tables using customer_id as the primary and foreign key, with practical MySQL workbench examples.

Select data from a table using the select statement and filter results with the where clause, choosing specific columns or all columns as needed.

Sorts query results using the order by clause to arrange data in ascending or descending order by default, with syntax select columns from table order by column [direction].

Learn how the group by clause groups rows with the same values across columns, using sum and count to aggregate salaries, with where and order by.

Master the having clause in MySQL by filtering grouped data with aggregates like count(name) after using group by salary.

Learn how the distinct clause removes duplicate rows from a select result, returning unique names and salaries; this contrasts with projection and shows practical examples.

Demonstrate SQL functions on the employee table, including average, max, min, count, concatenate, uppercase, mid, and last inserted, plus sorting and limiting top or distinct salaries.

Explore logical operators in MySQL: and, or, and not, with practical examples using an employee table to filter by age and salary, including case sensitivity in comparisons.