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!