Learn SQL / MySQL database basics FOR FREE

Install MySQL server and MySQL Workbench on Windows by downloading the installers and running setup. Configure port 3306, set and save your password, and open MySQL Workbench to manage connections.

Explore common data types used in sql databases, including integer, numeric, varchar, decimal, date, timestamp, and blob, and learn how size and precision affect storage.

Connect to MySQL Workbench, create databases with create database, switch between databases with use, create tables with create table, and view databases and tables with show databases and show tables.

Create and use the homework one database, then create product, people, and computer tables with defined columns such as id, name, and price (decimal(4,2)) to practice sql basics.

Learn how to delete and modify tables in SQL by using drop table, create table, alter table to add or drop columns, and verify changes with show tables and select.

Practice altering table structures by creating databases and tables, adding and dropping columns, and executing queries to manage product, people, and computer tables.

Learn to insert data into tables using insert into, specify table and columns, provide ordered values with single quotes for text, and understand default null when columns are omitted.

Master the read queries with select, retrieving all columns or specific fields such as first name and age from a student table, including creating the table and inserting sample values.

Learn the basics of SQL with practical exercises to create tables for products, people, and computers, insert five records each, and practice selecting all data and specific columns.

Filter student records with the where clause to select by criteria, such as name equals Andrew or age greater than 17, and read by primary key id.

Practice creating and querying SQL databases with where clauses, inserting data, and selecting results across product, people, and computer tables, including default descriptions and RAM filters.

Learn how to update data in SQL tables using the update statement, set, and where clauses to modify specific rows, with examples.

Practice updating data in sql databases by creating tables, inserting records, and applying updates with where and like clauses; upgrade prices, professions, and ram for select brands.

Learn to delete data in SQL using delete from with where for specific rows, or truncate to clear all data, and observe that IDs continue from the last counter.

Practice building and manipulating databases with sql: create and drop tables, insert and select data, and delete records using conditional where clauses, with primary key and unique constraints.