GRATIS Preview - SQL & SQLite The Pirate Learning Adventure

Learning SQL during a pirate Adventure and become the Captain of databases to discover the 7 great tables of the world!
Rating: 3.8 out of 5 (10 ratings)
4,280 students
English

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
Simple SQL Queries

Requirements

  • No requirements needed

Description

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,


In this course you will live through the following adventures:

Start as a pirate candidate on your way to SQisLand

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


This course teaches you the following techniques & commands

SQL & SQLite, The SQL Query Pattern, Simple & Complex SQL Queries, Primary & Foreign Keys, SELECT Command


I include the following in the ENTIRE SQisLand Adventure:

The entire course will teach you also about:

Advanced Query Modifiers, Grouping Records, Sorting Records,

Aggregating Records, Filtering on already aggregated Records, Table Design, SQLite Studio


In the entire course you will also live through the following adventures:

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 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!


The entire course teaches you the 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

Who this course is for:

  • Beginner
  • Intermediate
  • Professional

Course content

4 sections16 lectures1h 8m total length
  • Why This Part of the Course is Gratis
    01:03
  • Hello & Welcome to the SQL Pirate Adventure!
    03:25
  • Introduction to a new Isle
    01:51

Instructor

Diploma & Software Engineer passionated about Teaching
Arnold Abraham
  • 4.1 Instructor Rating
  • 104 Reviews
  • 28,792 Students
  • 5 Courses

I love to share knowledge and help the best I can! I want to spread my knowledge with fun and make courses that are journeys instead of lectures!

Graduated Engineer with several years of experience in the industry developing software for web/desktop and mobile area. Developing games for over 5 years as a passion and taught other students during my studies in physics and mathematics.
Writing medium articles, mainly about JavaScript.