Udemy

Platform

English

Language

Programming Languages

Category

SQL & SQLite - Your Pirate Adventure with Shady Deals & Rum!

Learning SQL during a pirate Adventure and become the Captain of databases to discover the 7 great tables of the world!

4.41 (50 reviews)

SQL & SQLite - Your Pirate Adventure with Shady Deals & Rum!

Students

4 hours

Content

May 2021

Last Update
Regular Price

EXCLUSIVE SKILLSHARE OFFER
Exclusive SkillShare Offer
Unlimited access to 30 000 Premium SkillShare courses
40%OFF ANNUAL MEMBERSHIP

What you will learn

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 of Lightweight and Centralized Databases & How to find the right solution for yourself

Simple SQL Queries

Complex SQL Queries

Primary & Foreign Keys Relationships

Create your own Sugar Plantation

Create your own Rum Business

Relational Databases

Choose a suitable Database Solution

Differences Between SQL and SQLite

The SQL Query Pattern

SQLite Studio

SELECT Command

WHERE Command

Filtering of Records

AND, OR, IN Statements

Advanced Query Modifiers

Grouping Records

Sorting Records

Aggregating Records

Filtering on already aggregated Records

CASE Command

JOIN Command

UNION Command

HAVING Command

ORDER BY Command

Table Design

DROP Command

CREATE Command

INSERT Command

UPDATE Command

DELETE Command

SQL Views


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



Content

Introduction

Hello & Welcome to the SQL Pirate Adventure!

Sailing to SQisLand & Introduction to a new Isle

Sailing to SQisLand

Why Learn SQL?

Why Learn SQL?

Databases

Databases

SQLite

SQLite

SQLite Studio

OL'Tables

OL'Tables Introduction and SELECT Command

OL'Tables QuizTime

SELECT

Expressions with SELECT Command

Expressions 2 with SELECT Command

Expressions 3 with SELECT Command

Concatenation with SELECT Command

Summary

Fort Encargo

Fort Encargo Introduction and Data Types

WHERE Command used on numbers

WHERE Command used on numbers 2

AND Statement

OR Statement

IN Statement

WHERE Command used on text

WHERE Command used on text 2

LIKE Command alias Fuzzy Filtering

LIKE Command alias Fuzzy Filtering 2

Fuzzy Filter

Fort Encargo QuizTime

WHERE Command used on booleans

WHERE Command Handling NULL

Grouping Conditions

Grouping Conditions 2

Summary

Cloister Consilio

Cloister Consilio Intro

GROUP BY Command

GROUP BY Command 2

ORDER BY Command

ORDER BY Command 2

HAVING Command

DISTINCT Command

DISTINCT Command 2

DISTINCT

Cloister Consilio Part 1 Summary

CASE Statement

CASE Statement 2

CASE Statement 3

Crew Mood - Just a riot or a mutiny?! Intro

JOIN Command

JOIN Command 2

JOIN Command 3

UNION Command

Assignment The XXX-Files Introduction

Cloister Consilio Summary

Fuente El Vamos

Fuente El Vamos Intro

Summary and CREATE Command

CREATE Command 2

INSERT Command

INSERT Command 2

DELETE Command

UPDATE Command

Database Design Quiz Intro

Database Design

SQL Views

Epilog and Quiz

SQL Views

Puerto de Graduacion

Puerto de Graduacion Introduction

Outro & Thank you!

How to on? & Thank you

After Hour Quiz


Reviews

B
Blumentopfer29 March 2021

Great SQL course. I already knew some basics about mySQL, but this course gives you most valuable SQL knowledge in a playful way! Thanks!

R
Rahman18 March 2021

I just love Arnold's sense of humor during the course, it makes the learning very engaging. I also love the game style of explaining SQL. Keep up the good work Arnold.

W
Wieslaw18 March 2021

Great course! I am having fun watching. Arnold had made an exciting adventure out of learning SQL and databases. The idea of a pirate ship crew as a storyline is really great and creative. But, it is not only about the story or the fun of becoming an SQL Captain - there is real and serious knowledge behind it. Thus, the learning effect is huge. I think this course is suitable for all interested to sneak into the world of databases as well as for professionals seeking to refresh, structure, and review their knowledge (I am one ;)). On top of that - the recordings are of high quality (pictures, background, sound). The knowledge is well structured, the length appropriate. Arnold is very skilled in his matter, so thank you for this course and I am looking to see other courses of this guy!


Coupons

DateDiscountStatus
3/15/2021100% OFFExpired
4/4/202171% OFFExpired
4/23/2021100% OFFExpired

3887490

Udemy ID

3/3/2021

Course created date

3/15/2021

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram