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
How to Enroll SQL & SQLite – Your Pirate Adventure with Shady Deals & Rum! course?
How many members can access this course with a coupon?
SQL & SQLite – Your Pirate Adventure with Shady Deals & Rum! Course coupon is limited to the first 1,000 enrollments. Click 'Enroll Now' to secure your spot and dive into this course on Udemy before it reaches its enrollment limits!