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
-
1Hello & Welcome to the SQL Pirate Adventure!Video lesson
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!)
-
2Sailing to SQisLand & Introduction to a new IsleVideo lesson
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!
-
3Why Learn SQL?Video lesson
This chapter answers:
Why are you learning SQL in the first place?
Who is SQL suitable for?
-
4Why Learn SQL?Quiz
-
5DatabasesVideo lesson
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?
-
6DatabasesQuiz
-
7SQLiteVideo lesson
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/
-
8SQLiteQuiz
-
9SQLite StudioVideo lesson
This chapter is all about the question:
What is SQLite Studio?
-
10OL'Tables Introduction and SELECT CommandVideo lesson
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?
-
11OL'Tables QuizTimeVideo lesson
-
12SELECTQuiz
-
13Expressions with SELECT CommandVideo lesson
Learn about what exactly are expressions and when and how to use them.
-
14Expressions 2 with SELECT CommandVideo lesson
Learn about enhanced usage of expressions.
-
15Expressions 3 with SELECT CommandVideo lesson
Final showoff and explanation about expressions in combination with the SELECT command.
-
16Concatenation with SELECT CommandVideo lesson
Learn about the meaning of concatenation and when and how to use it to profit from it.
-
17SummaryVideo lesson
Recap of the learned topics so far and en epilog for this chapter and your journey!
-
18OL'Tables - The Governor and his ProclamamationText lesson
-
19Fort Encargo Introduction and Data TypesVideo lesson
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!
-
20WHERE Command used on numbersVideo lesson
WHERE can be used in combination with SELECT instructions. Expressions & functions are usable in any part of an SQL-Statement
-
21WHERE Command used on numbers 2Video lesson
Another way to find the inmates is the BETWEEN command and you'll learn about other comparing operators.
-
22AND StatementVideo lesson
AND is used to set a query as an alternative to the BETWEEN command.
-
23OR StatementVideo lesson
An OR is the best / shortest combiner to accomplish specific queries.
-
24IN StatementVideo lesson
An IN statement converts queries in a fashionable and comprehensible way.
-
25WHERE Command used on textVideo lesson
Using WHERE on text is possible, but the phrase must be in quotes and other occasions can happen.
-
26WHERE Command used on text 2Video lesson
-
27LIKE Command alias Fuzzy FilteringVideo lesson
Fuzzy filtering is possible with LIKE but the phrase must be in single quotes and it needs an %-sign.
-
28LIKE Command alias Fuzzy Filtering 2Video lesson
-
29Fuzzy FilterQuiz
-
30Fort Encargo QuizTimeVideo lesson
-
31WHERE Command used on booleansVideo lesson
Learn about the usage of WHERE command with booleans.
-
32WHERE Command Handling NULLVideo lesson
The data type NULL needs special care. Learn how to deal with it!
-
33Grouping ConditionsVideo lesson
We can group our conditions but attention, please!
-
34Grouping Conditions 2Video lesson
We can group our conditions but attention, please!
-
35SummaryVideo lesson
The recap of your learning so far and an epilog about this epic chapter of your journey!
-
36Cloister Consilio IntroVideo lesson
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!
-
37GROUP BY CommandVideo lesson
Aggregating data is the keyword of this chapter a.k.a. rolling up, grouping or summarising records.
-
38GROUP BY Command 2Video lesson
Aggregating data is the keyword of this chapter a.k.a. rolling up, grouping or summarising records.
-
39ORDER BY CommandVideo lesson
ORDER BY sort records in a column in ascending/descending order.
-
40ORDER BY Command 2Video lesson
ORDER BY sort records in a column in ascending/descending order.
-
41Padre Luigi and the PayoutText lesson
-
42HAVING CommandVideo lesson
Filtering out records based on an aggregated value? First thought: use the WHERE statement! Wrong!
-
43Padre Luigi and the Shady DealText lesson
-
44DISTINCT CommandVideo lesson
Distinct is used to get only different records of a column.
-
45DISTINCT Command 2Video lesson
Distinct is used to get only different records of a column.
-
46DISTINCTQuiz
-
47Cloister Consilio Part 1 SummaryVideo lesson
The first part of Cloister Consilio is over. Time for a short recap, what you've learned so far!
-
48CASE StatementVideo lesson
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.
-
49CASE Statement 2Video lesson
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.
-
50CASE Statement 3Video lesson
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.
-
51Crew Mood - Just a riot or a mutiny?! IntroVideo lesson
-
52Crew Mood - Just a riot or a mutiny?!Text lesson
-
53JOIN CommandVideo lesson
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.
-
54JOIN Command 2Video lesson
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.
-
55JOIN Command 3Video lesson
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.
-
56UNION CommandVideo lesson
Use the UNION Command to merge tables vertically. Showoff in combination with the JOIN Command to create a FULL OUTER JOIN.
-
57Assignment The XXX-Files IntroductionVideo lesson
-
58The XXX-Files - Murder joins the rum!Text lesson
-
59Cloister Consilio SummaryVideo lesson
-
60Fuente El Vamos IntroVideo lesson
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.
-
61Rum Business - Your own Sugar PlantationText lesson
-
62Summary and CREATE CommandVideo lesson
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.
-
63CREATE Command 2Video lesson
The CREATE command is used to create tables
-
64INSERT CommandVideo lesson
Used to insert data in tables.
-
65INSERT Command 2Video lesson
Used to INSERT data in tables.
-
66DELETE CommandVideo lesson
Use DELETE to delete records from tables.
-
67UPDATE CommandVideo lesson
Use UPDATE to update records from tables in combination with a WHERE Command.
-
68Database Design Quiz IntroVideo lesson
-
69Database DesignQuiz
-
70SQL ViewsVideo lesson
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“.
-
71Epilog and QuizVideo lesson
Recap about what you've learned so far and an epilog about this adventurous chapter of your journey!
-
72SQL ViewsQuiz
-
73Puerto de Graduacion IntroductionVideo lesson
It is graduation time! Conquer the seven seas of rum by setting up your own rum distillery. Escape the plank by showing off what you’ve experienced about SQL in the last 4 epic stations of SQisLand!
-
74Graduation Exercise - Rum Business - Rum DistilleryText lesson
External Links May Contain Affiliate Links read more