SQLite & SQL - Pirate Adventure with Shady Deals & Rum!
- Description
- Curriculum
- FAQ
- Reviews
Welcome to SQisLand where a SQL Pirate Adventure awaits you!
Learn SQL while making short work of criminals with the Governor, helping the Lieutenant Commander to find convicted inmates and making a deal with the shady Padre Luigi. Ending in the ultimate construction of a sugar plantation with attached rum distillery!
You are going to be a SQL-Pirate and unlock the treasures of SQL! Yarr har fiddle dee dee, Do what you want cause a pirate is free, you are a pirate!
This course teaches you about:
Why learn SQL?, Who should learn SQL?, Difference of Lightweight and Centralized Databases, Choose a suitable Database Solution, Database Design, Relational Databases,
Filtering Records, Advanced Query Modifiers, Grouping Records, Sorting Records,
Aggregating Records, Filtering on already aggregated Records, Table Design, SQLite Studio
In this course you will live through the following adventures:
Start as a pirate candidate on your way to SQisLand
Uncover a riot on your ship on your way
Become a full SQL Pirate
Being captain of your own ship and crew
Discover the 7 tables of the world
Help the scattered Governor of OL’Tables, a little harbor city, to hunt down criminals
Help the scattered Governor of OL’Tables with his proclamation
Help the Lieutenant Commander of Fort Encargo to find convicted inmates in an overcrowded jail and meet the one or other famous pirate (LeChuck, Guybrush, Blackbeard and Jack Sparrow)
Help the Lieutenant Commander of Fort Encargo to find famous pirates in his prison (LeChuck, Guybrush, Blackbeard and Jack Sparrow)
Help the padre Luigi of Cloister Consilio to make shady deals and flip yourself a coin easily and meet even more famous pirates (LeChuck, Guybrush, Blackbeard and Jack Sparrow)
Use Padre Luigi to get yourself a nice cut-off from a payout deal
Make shady deals with the Luigi when emptying his rum Hideout
Find all criminals with the help of Lieutenant Commander and Padre Luigi and create a series of the XXX-Files
Build up your own sugar plantation in Fuente el Vamos and run it successfully
Build up your own rum distillery in Puerto de Graduacion and run it successfully
Ultimately create and run your own Rum Business!
This course teaches you following techniques & commands
SQL & SQLite, The SQL Query Pattern, Simple & Complex SQL Queries, Primary & Foreign Keys, SELECT Command, WHERE Command, AND, OR, IN Statements, CASE Command, JOIN Command, UNION Command, HAVING Command, ORDER BY Command, DROP Command, CREATE Command, INSERT Command, UPDATE Command, DELETE Command, SQL Views
Follow me on Instagram: Arnold.code ; Read my coding articles/tutorials on Medium: arnoldcode
-
1
Hello & Welcome to the SQL Pirate Adventure!Welcome to SQisLand where a SQL Pirate Adventure awaits you! Learn SQL while making quick work of criminals with the Governor, helping the Lieutenant Commander to find convicted inmates, and making a deal with the shady Padre Luigi. Ending in the ultimate construction of a sugar plantation with attached rum distillery!
You are going to be a SQL-Pirate and unlock the treasures of SQL! Yarr har fiddle Dee Dee, Do what you want cause a pirate is free, you are a pirate!Keep in touch with me on Medium - Arnoldcode.medium.com (coding related articles and tutorials) and on Instagram - Arnold.code (coding snippets, quizzes and coding fun facts!)
-
2
Sailing to SQisLand & Introduction to a new Isle
Meet the governor, he is a righteous man! Help him arrest the bad guys while you learn SQL!
The Lieutenant Commander is convinced that his prison is the best. Will you help him turn the prison around with your SQL skills?
Padre Luigi is a shady guy, but he can help you improve your SQL skills through nerve-wracking last-minute action and make a haul in the process!
Famous personalities are also represented, meet LeChuck, Guybrush, Blackbeard, and Jack Sparrow!
-
3
Why Learn SQL?
This chapter answers:
Why are you learning SQL in the first place?
Who is SQL suitable for?
-
4
Why Learn SQL? -
5
Databases
This chapter answers:
What is a database?
What are typical examples of using a database?
What is a relational database?
What are separated tables?
How do I choose a suitable database solution?
What is the difference between SQLite and SQL?
-
6
Databases
-
7
SQLite
This chapter answers:
What is SQLite?
When would we use SQLite?
How to import and navigate databases?
SQLite Studio can be found here: https://sqlitestudio.pl/
-
8
SQLite
-
9
SQLite Studio
This chapter is all about the question:
What is SQLite Studio?
-
10
OL'Tables Introduction and SELECT Command
This little town of SQisLand is overcrowded by pirates and the Governor wants you to help him find the bad guys! Maybe you are the bad guy?! Learn the basics of querying and the basics of SQLite Studio with the help of the Governor!
What is a query?
What is the query pattern?
Why is it a pattern?
The SELECT command
How do I get data?
What is the SQL Editor?
-
11
OL'Tables QuizTime
-
12
SELECT
-
13
Expressions with SELECT Command
Learn about what exactly are expressions and when and how to use them.
-
14
Expressions 2 with SELECT Command
Learn about enhanced usage of expressions.
-
15
Expressions 3 with SELECT Command
Final showoff and explanation about expressions in combination with the SELECT command.
-
16
Concatenation with SELECT Command
Learn about the meaning of concatenation and when and how to use it to profit from it.
-
17
Summary
Recap of the learned topics so far and en epilog for this chapter and your journey!
-
18
OL'Tables - The Governor and his Proclamamation
-
19
Fort Encargo Introduction and Data Types
Meet the Lieutenant Commander and filter out convicted inmates served for the death sentence! Learn about different usages of filtering by using the WHERE command and find the right inmates for the Lieutenant Commander!
-
20
WHERE Command used on numbers
WHERE can be used in combination with SELECT instructions. Expressions & functions are usable in any part of an SQL-Statement
-
21
WHERE Command used on numbers 2
Another way to find the inmates is the BETWEEN command and you'll learn about other comparing operators.
-
22
AND Statement
AND is used to set a query as an alternative to the BETWEEN command.
-
23
OR Statement
An OR is the best / shortest combiner to accomplish specific queries.
-
24
IN Statement
An IN statement converts queries in a fashionable and comprehensible way.
-
25
WHERE Command used on text
Using WHERE on text is possible, but the phrase must be in quotes and other occasions can happen.
-
26
WHERE Command used on text 2
-
27
LIKE Command alias Fuzzy Filtering
Fuzzy filtering is possible with LIKE but the phrase must be in single quotes and it needs an %-sign.
-
28
LIKE Command alias Fuzzy Filtering 2
-
29
Fuzzy Filter
-
30
Fort Encargo QuizTime
-
31
WHERE Command used on booleans
Learn about the usage of WHERE command with booleans.
-
32
WHERE Command Handling NULL
The data type NULL needs special care. Learn how to deal with it!
-
33
Grouping Conditions
We can group our conditions but attention, please!
-
34
Grouping Conditions 2
We can group our conditions but attention, please!
-
35
Summary
The recap of your learning so far and an epilog about this epic chapter of your journey!
-
36
Cloister Consilio Intro
Get to know Padre Luigi and his hideout. Make two or three shady deals with him to enrich yourself and buy a ship to sail the seven databases of SQL! Use enhanced query techniques to gather your knowledge and draw your advantage out of the deals!
-
37
GROUP BY Command
Aggregating data is the keyword of this chapter a.k.a. rolling up, grouping or summarising records.
-
38
GROUP BY Command 2
Aggregating data is the keyword of this chapter a.k.a. rolling up, grouping or summarising records.
-
39
ORDER BY Command
ORDER BY sort records in a column in ascending/descending order.
-
40
ORDER BY Command 2
ORDER BY sort records in a column in ascending/descending order.
-
41
Padre Luigi and the Payout
-
42
HAVING Command
Filtering out records based on an aggregated value? First thought: use the WHERE statement! Wrong!
-
43
Padre Luigi and the Shady Deal
-
44
DISTINCT Command
Distinct is used to get only different records of a column.
-
45
DISTINCT Command 2
Distinct is used to get only different records of a column.
-
46
DISTINCT
-
47
Cloister Consilio Part 1 Summary
The first part of Cloister Consilio is over. Time for a short recap, what you've learned so far!
-
48
CASE Statement
The CASE Statement is a very handy and powerful tool to replace numbers through various meaningful text constants. It is converting from numbers into text, just as an ENUM does.
-
49
CASE Statement 2
The CASE Statement is a very handy and powerful tool to replace numbers through various meaningful text constants. It is converting from numbers into text, just as an ENUM does.
-
50
CASE Statement 3
The CASE Statement is a very handy and powerful tool to replace numbers through various meaningful text constants. It is converting from numbers into text, just as an ENUM does.
-
51
Crew Mood - Just a riot or a mutiny?! Intro
-
52
Crew Mood - Just a riot or a mutiny?!
-
53
JOIN Command
Stitch back together two tables SIDE BY SIDE to create a new table. Especially useful when working with relational tables. Use JOIN to stitch them together. Normally used to combine split tables by PK and FK.
-
54
JOIN Command 2
Stitch back together two tables SIDE BY SIDE to create a new table. Especially useful when working with relational tables. Use JOIN to stitch them together. Normally used to combine split tables by PK and FK.
-
55
JOIN Command 3
Stitch back together two tables SIDE BY SIDE to create a new table. Especially useful when working with relational tables. Use JOIN to stitch them together. Normally used to combine split tables by PK and FK.
-
56
UNION Command
Use the UNION Command to merge tables vertically. Showoff in combination with the JOIN Command to create a FULL OUTER JOIN.
-
57
Assignment The XXX-Files Introduction
-
58
The XXX-Files - Murder joins the rum!
-
59
Cloister Consilio Summary
-
60
Fuente El Vamos Intro
Fuente el Vamos is the source of imagination. Build up your own database empire with a sugar plantation. Learn about database design and relational tables while setting up your own business! Filling up data and deleting unwanted tables and entries. I'll teach you very important questions about the database design part, which should be critically answered beforehand.
-
61
Rum Business - Your own Sugar Plantation
-
62
Summary and CREATE Command
Recap of the topics you've learned about database design and critical questions about it. Also showing the solution of the sugar plantation assignment. The CREATE command is used to create tables. Including the DROP command to drop entire tables.
-
63
CREATE Command 2
The CREATE command is used to create tables
-
64
INSERT Command
Used to insert data in tables.
-
65
INSERT Command 2
Used to INSERT data in tables.
-
66
DELETE Command
Use DELETE to delete records from tables.
-
67
UPDATE Command
Use UPDATE to update records from tables in combination with a WHERE Command.
-
68
Database Design Quiz Intro
-
69
Database Design
-
70
SQL Views
Store frequently used SELECT queries is a common thing. You also save quick links to your commonly used programs, don’t you? Saving one of these queries is called a „view“.
-
71
Epilog and Quiz
Recap about what you've learned so far and an epilog about this adventurous chapter of your journey!
-
72
SQL Views
