MySQL on linux for beginners: SQL database crash course

Learn how to install MySQL on Linux (Ubuntu), run installation commands, set a root password, and start the MySQL service to begin using the database.

Explore MySQL structure: databases hold tables, and each table contains columns, illustrated by a sample database with film, actor, category, language, and inventory tables.

Learn how to view all databases, create databases, drop a database, and switch to a selected database to run queries in a MySQL environment.

Learn how to create, delete, update, and query MySQL tables. Understand data types, primary keys, and foreign keys, and learn how joins connect film and inventory tables.

Create, show, and alter tables in MySQL on Linux, including adding and dropping columns and viewing table schemas with show tables and show columns from.

a primary key is a unique, non-null value that identifies each row in a table; use the id column's auto increment to assign sequential values automatically.

See how a foreign key points to an employee table's primary key to link the salaries table, illustrating two-table design and a practical example with Bob's salary.

Define a date time column with a default current time in MySQL, so new rows automatically record creation timestamps. See inserts show the date column defaulting to the current time.

Learn how to insert data into a MySQL table by creating an employee table, defining an auto-increment primary key, and using insert into with name and salary values.

Learn how to retrieve data with the select statement in MySQL, selecting all columns or specific columns like id and name, and combining multiple columns for refined queries.

Learn how to use the where clause in MySQL to filter records with comparison operators, combine conditions with and/or, and use like for pattern matching.

Order by clause demonstrates how to sort query results by a column in ascending or descending order. Defaults to ascending, and you can specify descending for integers, salaries, and strings.

Use the limit and offset in MySQL to control query results, such as the first two rows or a range starting at a specific offset.

Use the update statement in MySQL to modify a column value in a specific row with a where clause. Prevent unintended updates by carefully specifying the table name and conditions.

Learn how to delete a record in MySQL by using the delete command, targeting the employee table with a where clause on the id to remove a row.

Explore inner join in MySQL by combining employee and salary tables to display only matching rows, using primary and foreign keys, on conditions, and selecting specific columns.

Learn how a right join returns all matching rows and all rows from the joined table, including non-matching right-side rows, using the on clause with salary and employee tables.