
Master SQL through a three-step method that builds core concepts of structured query language across databases like MySQL, MariaDB, SQL Server, Oracle, and Postgres, emphasizing consistent logic despite small differences.
Explore how SQL, a structured query language, stores, defines, manipulates, and retrieves data in relational databases, and creates and drops databases and tables for web and mobile apps.
Install and configure a local web server stack with XAMPP, Apache, and MySQL or MariaDB, then use SQLYOG to manage databases.
Start and manage database services using a control panel, launching the Apache web server and the MySQL (MariaDB) server with the default port 3306, and monitor process IDs.
Connect to localhost on port 3306 as root, test the connection, and create your first database, for example my new test database, then verify it appears in the object browser.
Learn how to show databases, create and drop a database, and refresh the object browser, while understanding the data loss risk and the importance of backups.
Create your first database tables by defining an id integer, a name varchar(30) not null, and optional grade and degree fields, then set a primary key in a student table.
Master the drop table command by removing a table and verifying with a select. Then use insert into to add new rows to a table in your database.
Master the insert into syntax by specifying columns and values, or inserting into all columns, and practice populating a students table to see results after execution.
Create a new table from an existing one using a select statement to copy all data. Learn how the select returns a result set to populate the new table.
Master the basic select statement syntax by pulling all columns with select * from students and narrowing results with select name, ages from students to display specific fields.
Master the where clause to filter records in select statements, using conditions with integers and quoted strings to retrieve specific rows from a single table.
Master sql operators by using greater than, greater or equal, less than, and less or equal to filter data; combine conditions with and and or in select queries.
Learn how to update data with update queries in SQL, modify specific rows or all records using set and where conditions, with examples updating a student name and grade.
Learn to delete records with delete from students where name is equal to Chris, and also delete all records from a table by omitting the where clause.
Explore how the like operator uses wildcard patterns to match similar strings, including % for any characters, to find names starting with Chris or containing mal.
Learn how to limit query results across mysql, mssql, and oracle using limit, top, and rownum with the same underlying logic.
Learn how to use the order by clause to sort query results by one or more columns in ascending or descending order, with examples using AIDS and names.
Learn how the group by clause follows a select statement to group identical data by name and aggregate values, before applying the order by clause.
Master the distinct keyword to return only unique values and eliminate duplicate records using select distinct columns from table, with examples using students data.
Learn how to delete all data from an existing table using truncate table, delete from, or drop table, and observe the resulting empty set, preserved table structure, and draw conclusions.
Learn SQL by asking concrete questions of a MySQL database. This beginner course shows how to create and populate tables, retrieve useful information and inspect the effect of data changes, with a book-inventory practice lab to bring the ideas together.
Start with the demonstrated database tools and services, then create your first database and tables. Use INSERT and SELECT statements before adding conditions, operators, ordering, grouping and DISTINCT. The curriculum also covers updates, deletion and introductory programming concepts in later sections.
What you can practise
Turn a question about records into a SELECT statement.
Filter and sort results so they answer a specific request.
Group rows and explain what a summary represents.
Check which records a data-change statement is intended to affect.
The additional reading activities use a fictional book inventory and examine why a join can increase the number of returned rows. Compare an expected result with the actual dataset, rather than judging a query only by whether the database accepts it. This gives you a useful foundation for investigating duplicates and unexpected totals.
Choose this course if you are new to SQL, need a refresher in relational querying or want to understand the database language used alongside an application. Basic computer skills are enough to begin; practical access to a disposable learning database will help you follow the examples.
The recorded setup uses MySQL-related tools and interfaces from the time of filming. Check current installation documentation and the SQL dialect of your own system. Use the preview and curriculum to assess the pace, and leave time to write your own queries between demonstrations.
From a table of records to a useful answer
SQL is a practical language for asking precise questions about organised data. A small inventory, a list of customers or a set of transactions can contain the information you need, but the answer depends on the question you write. This course starts with MySQL setup and basic database structure, then works through the statements used to create, inspect and change records. The emphasis is introductory, so you can connect a query with the rows it should affect before moving toward more demanding database work.
Understanding the environment
The setup lessons introduce the database services and tools used in the recordings. Treat this stage as preparation for observing query behaviour. Know which sample database you are connected to and where you can safely experiment. Tool screens and local installation details may differ, but the important learning task is to create a place where a statement can be run and its result inspected. You do not need to begin with a production database or real business information. A small fictional dataset is easier to understand and easier to restore after a mistake.
Creating a useful structure
The database and table lessons introduce how records are organised. Before inserting data, think about what each row represents and why each column exists. A table becomes easier to query when its meaning is clear. The course's create and drop examples provide context for the structure, while insert statements populate it with values you can inspect. A productive study habit is to sketch a few expected rows first. You can then compare the database state with that sketch instead of assuming that a successful command necessarily created the structure you intended.
Selecting the right rows
SELECT and WHERE form an early turning point: you move from storing records to answering a question. A condition needs a reason. Are you looking for a particular category, a value above a threshold or a pattern in text? Write the business question in ordinary language before translating it into a query. Then inspect both the rows returned and the rows excluded. This helps you recognise whether an unexpected answer comes from the data, the filter or an assumption about what the question meant.
Refining a result
Ordering, limiting, pattern matching, grouping and distinct values each change how you inspect a dataset. They are useful for different purposes, so it is worth explaining the intention behind a clause. A sorted result can make a pattern visible; a limit can reduce the output you inspect; a distinct result can reveal the values present in a column. The recorded examples introduce these operations at a beginner level. Compare a query before and after one change so that the effect of that particular clause remains clear.
Changing data with care
UPDATE, DELETE and TRUNCATE appear in the curriculum because databases are not only read. When practising a change, describe which records should be affected before running it. Inspect the sample state afterwards and compare it with your expectation. A query that is valid SQL may still target more rows than intended. The course is not a production database-administration programme, but it offers a starting point for developing deliberate habits. Use a separate practice dataset and keep the difference between an exploratory exercise and a real operational change clear.
Applying the book-inventory lab
The reading lab provides a focused context for writing and checking queries against a small inventory. The useful skill is not memorising one book-related statement. It is translating a question into a selection or change and verifying the result. Row counts and expected values can expose an incorrect condition even when the output looks plausible at a glance. Keep the starting data, query and observed result together. This creates an explanation another learner could follow and gives you a straightforward way to compare two query attempts.
How the programming sections fit
Later sections discuss general programming logic and object-oriented vocabulary. They widen the introduction beyond MySQL, but the database work remains the main reason to choose this course. You can use those sections to recognise how an application might make decisions before or after it queries stored data. They are not a substitute for a dedicated course in a particular application language. Understanding that boundary helps you choose a sensible order of study rather than expecting every technology mentioned to be covered in equal depth.
A practical outcome to work toward
By the end of your own study, aim to explain a small table, write a query for a clear question and verify which records were returned or changed. That is a concrete foundation for further SQL practice. The course suits a database beginner, someone moving beyond spreadsheets or an early application developer. It does not promise exhaustive query optimisation, advanced database design or production administration. Choose it for the accessible examples and the opportunity to build careful habits around a result you can actually inspect.
Curriculum at a glance
Introduction to SQL
Setting up the Database, the Application Servers and Starting the DB Services
Creating our 1st Database
Creating & Dropping Tables in our Database
Inserting Data with Insert Statement and Cloning Tables
Select Statements and Where Clause in SQL
Update and Delete Data in SQL
Like Operators, Limiting Results and Ordering Datasets in SQL
Group Dataset based on a Condition in SQL and use Distinct to Extract the Unique
TRUNCATE TABLE Command to Delete the Data Inside a Table and Conclusions
General programming logic beyond the SQL examples
Advanced Programming Concepts
Additional practical SQL examples