you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

About this video

NetworkChuck teaches beginner SQL through a hands-on MySQL build. He frames databases as far more capable versions of a spreadsheet, made of tables with columns (fields) and rows (records), and explains that a database management system such as MySQL, Microsoft SQL Server, PostgreSQL or Oracle manages them all using SQL, the Structured Query Language, which is an ISO standard so skills transfer between systems. He distinguishes relational databases, where tables link to each other (his example coffee shop uses customers, coffees and orders tables tied together by ID references), from non-relational ones, which the video does not cover. Working in Ubuntu inside VirtualBox, he installs MySQL Server, confirms the service is active, and creates a database for his fictional NetworkChuck Coffee business. He then creates a coffee table defining columns with data types such as INT for numbers and VARCHAR with a 255-character limit for strings, inserts rows, and introduces the core CRUD operations: SELECT with the asterisk or named columns to read data, WHERE with AND, OR, NOT and comparison operators to filter it, DELETE with a WHERE clause to remove a stray record, UPDATE with SET to fix entries, and ORDER BY ascending or descending to sort results. He also adds a new column to an existing table with ALTER TABLE. He closes by noting what was deliberately left out, including building the orders table, primary and foreign keys, joins and views. A sponsor segment for Dashlane cites his own account showing 28 compromised passwords and two weak ones, and offers 50% off with his code.

Key takeaways

• SQL is the standard language for talking to database management systems, and its core operations are CRUD: create, read, update and delete data
• A relational database splits data across linked tables, using ID references in one table to point at records in another, unlike a single flat spreadsheet
• Every MySQL command ends with a semicolon; CREATE TABLE defines column names plus data types such as INT and VARCHAR(255) before any data is added
• SELECT combined with WHERE, AND/OR/NOT and comparison operators filters precisely, and ORDER BY sorts results ascending or descending
• DELETE and UPDATE should always be paired with a WHERE clause to avoid wiping or changing every row, and ALTER TABLE can add columns after creation

Episode details: published August 17, 2022 · 24:25 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are NetworkChuck’s own claims, shared for education — they are not typical or guaranteed.

← Previous: the 30 Day Cert Challenge · Next: a BASH script PUSH-UP counter (for #gains ) →

All NetworkChuck videos · NetworkChuck profile · NetworkChuck on YouTube