SQLZap
Home
Playground
Lessons
Blog
Home
Playground
Lessons
Blog
Sponsored
TabLearn by Projects
— Programming tutorials for C, C#, Python, Javascript, Typescript, React, Go, HTML/CSS, Java, PHP and more
Show repository
/
Blog
/
operators
Blog - operators
December 23, 2023
SQL Like operator
How to use 'LIKE' operator
operators
SQLZap
.
©2026 SQLZap - Learn SQL Interactively
Twitter
SQL Lessons
Close panel
1
Introduction to SQL
History of SQL, importance of SQL, Relational databases.
2
SQL Database schema
What is a DB schema and which one we will use in this course.
3
SQL Basic syntax
Case sensitivity, statements, comments...
4
SQL Data types
Common datatypes used in SQL databases
5
SELECT statement
What is 'SELECT' statement and how to use it?
6
Constraining Queries with Conditions
Leveraging Operators and Logical Keywords to Filter Result Sets
7
Filtering and sorting SQL results
Leveraging Operators and Logical Keywords to Filter Result Sets
8
Querying multiple tables with joins
Mastering Data Relationships: The Art of SQL Joins Across Multiple Tables
9
Grouping Data and Aggregate Functions
GROUP BY and HAVING clauses and aggregate functions like COUNT, SUM, AVG..
10
Subqueries and common table expressions
Subqueries, Correlated subqueries and common table expressions (CTEs)
11
SQL functions and expressions
Built-in SQL functions: string functions, date functions, and more
12
Insert, Update and Delete
INSERT, UPDATE, DELETE statements
13
Create tables
How to create a table in SQL, data types and constraints
14
Alter tables
Add/rename/drop columns and foreign keys with ALTER TABLE statement
15
Drop tables
How to drop tables from the database
16
Indexes and performance tuning
What are indexes and how to tune them
TabLearn by Projects