Learn SQL / MySQL database basics FOR FREE

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.

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.

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.