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

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!

What you’ll 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

Requirements

  • No requirements needed

Who this course is for:

  • Beginner
  • Intermediate
  • Professional

Tags:

Tutorial Bar
Logo