MySQL Tutorial for Beginners | Learn MySQL

Install MySQL on mac by downloading the macOS dmg from the MySQL site, running the installer, starting the server, and connecting to the database to view databases and tables.

Learn how to download and install MySQL on Windows using the MySQL Installer, choose the default developer installation, configure server features, create user credentials, and connect to a database.

Open the terminal on Ubuntu 18.04, run apt-get install mysql-server, enter your password and confirm prompts, noting the default user name is root for the MySQL setup.

Learn to create a MySQL database using MySQL Workbench, including setting up a connection, configuring the server, and running a create database query; manage and switch databases.

Learn how to create tables in MySQL by selecting a database, defining columns with data types, and setting a primary key. Explore SQL create table syntax.

Learn how to insert data into a MySQL table using insert into, specifying columns and values, including multiple records and single-column inserts, then verify with a select.

Learn how to use the select statement in mysql to query data, display all or specific columns from tables like restaurant, order results, and perform arithmetic and modulus expressions.

Learn how to retrieve unique values from a single column using the MySQL select distinct statement, with examples showing duplicates removed and only distinct names.

Explore how to use the MySQL where clause to filter records, display specific columns, and apply operators such as greater than, less than, equals, not, and in, including null handling.

Master how to use the and operator and the or operator to filter data with multiple criteria in sql, including greater than and less than comparisons.

Learn to use the or condition by examples in MySQL, compare with and, construct queries with multiple conditions, and apply operators like greater than, less than, equals, and between.

Explore the MySQL order by clause to sort query results by one or more columns in ascending or descending order, with examples on name and number sorting.

Learn how to use the MySQL limit clause to display a specific number of records, with examples showing five, three, and one-row results.

Explore how to use the MySQL update statement to modify table data, including setting new values, filtering with where clauses, and handling incremental updates.

Learn how to delete data from a table using the delete query, apply conditions with where clauses, and understand that omitting a where clause deletes all rows.

Discover how to truncate table in MySQL with examples, compare truncate table and delete, and learn why truncate is faster and drops and recreates data.

Explore the MySQL drop table statement and see how to delete a table from your database, including handling empty tables and verifying deletion.

Use the MySQL describe statement to view a table’s structure, including columns, data types, primary keys, nullability, and default values.

Learn how to alter table structures in MySQL by adding, modifying, and dropping columns, changing data types and constraints, and renaming tables or columns.

Learn how to use the MySQL between operator to fetch rows with values within a range. See how between replaces multiple conditions and avoids repeating the column name.

Learn how to use MySQL aliases to rename columns, concatenate names into a full name, and create a personal info alias.

Explore the MySQL in clause, which checks if a value matches any value in a specified set, with practical examples using select from student and listing possible values.

Learn how to use the MySQL like operator to filter records by pattern, using wildcards % and _ to match starts with, ends with, and contains patterns.

Explore how to copy data between tables in MySQL using insert into select, ensure source and target data types match, and choose between copying all columns or selecting specific columns.

Create a new table that mirrors an existing one by using create table new_table like existing_table, copying the schema without data. Describe the table to verify the copied structure.

Use the MySQL union operator to combine results from multiple select statements across tables, ensuring the same number and order of columns. Union returns distinct rows by default.

Learn how a primary key uniquely identifies each record in a table, preventing duplicates and enabling precise lookups; explore single and composite keys and their non-null requirements.

Explore the MySQL unique constraint, ensuring a column contains distinct values; learn how unique keys differ from primary keys and prevent duplicate entries through examples.

Learn to link tables with a foreign key in MySQL by creating a department table and a student table, using a foreign key constraint to enforce the relationship.

Learn how the not null constraint prevents null values, how primary keys imply not null, and how to enforce this in an employee table during inserts.

Learn how MySQL auto increment generates a unique number automatically for each new record, starting at 1 and incrementing by 1, and how to set a different start value.

Learn how to apply the default constraint to automatically populate fields with default values when no values are provided.

Discover how MySQL joins combine data from multiple tables using a common column, including left, right, inner, and full outer joins to retrieve matched and unmatched rows.

Learn how to use a MySQL inner join to combine employee and department data on a common field, and retrieve employees belonging to the IT department.

Explore how to use a MySQL left join to fetch all records from the left table, such as employees, with their departments, and compare left join with inner join.

Learn how to use a MySQL right join to fetch matching employee and department records, returning all department rows and their related employees where available.