← All courses
CS 330 · 3 credits
SQL & Databases
Learn SQL and relational databases from absolute zero. You start by understanding what a table really is, then write and run real SQLite queries in every lesson: filtering with WHERE, sorting, aggregating with GROUP BY, joining tables, inserting and updating data safely, designing schemas, speeding queries up with indexes, and keeping data safe with transactions. Every concept comes with a runnable query and a your-turn exercise.
Local progress0/29 lessons · 0%
What you'll learn
- ✓Read and write SELECT queries with WHERE, ORDER BY, LIMIT, and DISTINCT to answer real questions from data
- ✓Summarize data with COUNT, SUM, AVG, GROUP BY, and HAVING, and explain the difference between row filters and group filters
- ✓Combine tables with INNER JOIN, LEFT JOIN, multi-table joins, and self joins, and explain what a foreign key is
- ✓Use CASE expressions, subqueries, and WITH to compute labels and filter values inside a single query
- ✓Insert, update, and delete rows safely, and use constraints (PRIMARY KEY, NOT NULL, UNIQUE, CHECK) to protect data
- ✓Design a small schema with one-to-many and many-to-many relationships and normalize away duplicated data
- ✓Explain what an index is, when it speeds a query up, and what a transaction guarantees (ACID) in plain words
Unit 1What a Database Is
Unit 2SELECT Deeply: Filtering with WHERE
Unit 3Sorting and Limiting Results
Unit 4Aggregation: Turning Rows into Answers
Unit 5JOINs I: Connecting Tables
Unit 6JOINs II: LEFT, Multiple, and Self Joins
Unit 7Writing Data: INSERT, UPDATE, DELETE
Unit 8Schema Design: Types, Keys, Relationships
Unit 9Indexes: Why Queries Are Fast or Slow
Unit 10Transactions and the Real World
Reviews
—
0 ratings
5
0
4
0
3
0
2
0
1
0
- No reviews yet.
Discussion
- No comments yet. Sign in to comment.