SQL & SQLite – Your Pirate Adventure with Shady Deals & Rum!

Learning SQL during a pirate Adventure and become the Captain of databases to discover the 7 great tables of the world!

What you’ll learn

Learn about how to install and use SQLite Studio on MAC – Windows – Linux
Learn to create simple & complex Queries and to create and design your own databases
Learn why you should learn SQL and to which positions and jobs this knowledge will carry you
Learn the difference of Lightweight and Centralized Databases & How to find the right solution for yourself
Simple SQL Queries
Complex SQL Queries
Primary & Foreign Keys Relationships
Create your own Sugar Plantation
Create your own Rum Business
Relational Databases
Choose a suitable Database Solution
Differences Between SQL and SQLite
The SQL Query Pattern
SQLite Studio
SELECT Command
WHERE Command
Filtering of Records
AND, OR, IN Statements
Advanced Query Modifiers
Grouping Records
Sorting Records
Aggregating Records
Filtering on already aggregated Records
CASE Command
JOIN Command
UNION Command
HAVING Command
ORDER BY Command
Table Design
DROP Command
CREATE Command
INSERT Command
UPDATE Command
DELETE Command
SQL Views