Why Take This Course?
If you want to have a practical, efficient, yet far from boring learning trajectory at a great cost, we encourage you to check out our courses section and also the reviews of our past students. Those who have already been in your shoes.
We design courses that are learning journeys, adventures for your mind, instead of lectures! Do you want to learn more?
Core Content
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 between Lightweight and Centralized Databases & How to find the right solution for yourself
Welcome To SQisLand
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 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 at Puerto de Graduacion and run it successfully
Ultimately create and run your own Rum Business!
Niklas Frieling
"Awesome course, humorous and competent instructor. The knowledge learned is deepened with practical examples of games and principles that everyone knows! Many thanks A. Abraham!"
Rahman Saleh
"The major difference between taking a course by Arnold and anyone else is that Arnold delivers the necessary information in a very interesting way. His sense of humor and enthusiasm for teaching makes the course very easy to take and really enjoyable to watch. The other major reason why I am giving this course 5 stars, is because the timely and detailed answers to any questions student post in the Q&A section. Can’t wait for future courses by Arnold."
Esther van der Vloet
"Really liked the storytelling behind this course. Everything was clear and great examples and exercises."
Curriculum
- Arriving at Fort Encargo - Data Types (5:12)
- Fort Encargo Command WHERE - Intro & Using with Numbers (4:46)
- Fort Encargo Command WHERE - Using with Numbers Part 2 (4:41)
- Fort Encargo Combine Queries with AND (3:45)
- Fort Encargo Query Conditions with OR (3:44)
- Fort Encargo Defining Lists for Matching with IN (3:31)
- Fort Encargo Command WHERE - Using on Text (3:48)
- Fort Encargo Command WHERE - Using on Text Part 2 (3:11)
- Fort Encargo Fuzzy Filter (2:53)
- Fort Encargo Fuzzy Filter Part 2 (4:21)
- Fort Encargo Quiz Time (0:10)
- Fort Encargo Command WHERE - Using on Boolean (2:55)
- Fort Encargo Handling The Data Type of NULL (2:09)
- Fort Encargo Grouping Conditions (5:45)
- Fort Encargo Grouping Conditions Part 2 (2:19)
- Leaving Fort Encargo - Summary (1:20)
- Arriving At Cloister Consilio (2:12)
- Cloister Consilio Aggregate Results with GROUP BY (6:50)
- Cloister Consilio Aggregate Results with GROUP BY Part 2 (2:10)
- Cloister Consilio Sort Results with ORDER BY (3:46)
- Cloister Consilio Sort Results with ORDER BY Part 2 & Assignment (0:29)
- Cloister Consilio Filter Results of WHERE with HAVING & Assignment (5:14)
- Cloister Consilio Display Only Unique Entries with DISTINCT (1:41)
- Cloister Consilio Display Only Unique Entries with DISTINCT Part 2 & Quiz (0:15)
- Cloister Consilio Intermediate Summary (0:44)
- Cloister Consilio Textual Representations with CASE (5:49)
- Cloister Consilio Textual Representations with CASE Part 2 (1:30)
- Cloister Consilio Textual Representations with CASE Part 3 (1:32)
- Cloister Consilio Crew Mood Assignment (0:15)
- Cloister Consilio Combine Tables with JOIN (11:42)
- Cloister Consilio Combine Tables with JOIN Part 2 (4:58)
- Cloister Consilio Combine Tables with JOIN Part 3 (2:15)
- Cloister Consilio Merge Tables And Results with UNION (7:59)
- Cloister Consilio Assignment - The XXX Files (0:18)
- Leaving Cloister Consilio - Summary (1:17)
- Arriving At Fuente El Vamos Intro & Assignment Rum Business - Sugar Plantation (8:41)
- Fuente El Vamos Summary & Create Tables with CREATE (6:08)
- Fuente El Vamos Create Tables with CREATE Part 2 (3:22)
- Fuente El Vamos Add Data with INSERT (3:32)
- Fuente El Vamos Add Entries with INSERT Part 2 (6:50)
- Fuente El Vamos Remove Entries with DELETE (2:23)
- Fuente El Vamos Update Entries with UPDATE (3:03)
- Fuente El Vamos Quiz Time (0:10)
- Fuente El Vamos Create Query Shortcuts with SQL Views (7:17)
- Leaving Fuente El Vamos & Quiz Time (0:54)
61 Video Chapters
- What is SQL for?
- Who is SQL for?
- Career Opportunities
- Database
- Install SQLite Studio
- Introduction to the Tools You Use
- Why separate tables?
- Choosing a database solution?
- Lightweight vs Centralised
- SELECT Command
- WHERE Command
- Query Numbers/ Text / NULL
- AND OR IN Statement
- Fuzzy Filter
- Grouping Conditions
- GROUP BY + COUNT
- ORDER BY
- HAVING
- CASE
- JOIN
- UNION
- CREATE
- DROP
- INSERT
- UPDATE
- DELETE
- SQL Views
- Primary and Foreign Keys
- Database Design & Questions
- Security Questions
and many more....
7 Assignments & 51 Examples
- The Proclamation
- The Payout
- The Deal
- The Crew Mood
- The XXX-Files
- The Rum Plantation
- The Rum Distillery
Too many examples to list them here...
30 Funny Quizzes
- Is SQL only for IT guys?
- What is SQL for?
- What are the basic components of a database?
- Spot the one that is not typical to use a database.
- What describes a relational database the best?
- Spot the origin idea to use relational databases.
- Why do we split tables at all?
- What is the main difference between a lightweight solution (SQLite) and a centralized one (MySQL)?
- What is the format SQLite stores a database?
- When do we use SQLite?
- What is SQLite Studio?
- How to get only the records of column name of inbounds table?
- How to get exactly the records of name & location of inbounds table?
- How to get exactly the records of name & entry of inbounds table?
- How to get all records/columns from inbounds table?
- Which fuzzy filter query is the right to find the guy named ‚Bl?ckb???’ ?
and many more...
Featured Products
You Will Learn Important Topics
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
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