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

Welcome to SQisLand the place a SQL Pirate Adventure awaits you!

Study SQL whereas making brief work of criminals with the Governor, serving to the Lieutenant Commander to search out convicted inmates and making a deal with the shady Padre Luigi. Ending within the final development of a sugar plantation with hooked up rum distillery!

You will be a SQL-Pirate and unlock the treasures of SQL! Yarr har fiddle dee dee, Do what you need trigger a pirate is free, you’re a pirate!

This course teaches you about:

Why study SQL?, Who ought to study SQL?, Distinction of Light-weight and Centralized Databases, Select an acceptable Database Answer, Database Design, Relational Databases,

Filtering Information, Superior Question Modifiers, Grouping Information, Sorting Information,

Aggregating Information, Filtering on already aggregated Information, Desk Design, SQLite Studio

On this course you’ll dwell via the next adventures:

Begin as a pirate candidate in your technique to SQisLand

Uncover a riot in your ship in your manner

Change into a full SQL Pirate

Being captain of your individual ship and crew

Uncover the 7 tables of the world

Assist the scattered Governor of OL’Tables, a bit harbor metropolis, to search out criminals
Assist the scattered Governor of OL’Tables with his proclamation

Assist the Lieutenant Commander of Fort Encargo to search out convicted inmates in an overcrowded jail and meet the one or different well-known pirate (LeChuck, Guybrush, Blackbeard and Jack Sparrow)

Assist the Lieutenant Commander of Fort Encargo to search out well-known pirates in his jail (LeChuck, Guybrush, Blackbeard and Jack Sparrow)

Assist the padre Luigi of Cloister Consilio to make shady offers and flip your self a coin simply and meet much more well-known pirates (LeChuck, Guybrush, Blackbeard and Jack Sparrow)

Use Padre Luigi to get your self a pleasant cut-off from a payout deal

Make shady offers with the Luigi when emptying his rum Hideout

Discover all criminals with the assistance of Lieutenant Commander and Padre Luigi and create a sequence of the XXX-Recordsdata

Construct up your individual sugar plantation in Fuente el Vamos and run it efficiently

Construct up your individual rum distillery in Puerto de Graduacion and run it efficiently

Finally create and run your individual Rum Enterprise!

This course teaches you following methods & instructions

SQL & SQLite, The SQL Question Sample, Easy & Advanced SQL Queries, Major & International 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

Observe me on Instagram: Arnold.code ; Learn my coding articles/tutorials on Medium: arnoldcode