March 17th-30th Assignments:
SQL Khan Academy
Login in to your cps email before you login to Khan Academy and then
login with your google (cps) email.
Go to
https://www.khanacademy.org/computing/computer-programming/sql
Click on home,
start learning,
Go to Computing
Go To Computer Programming
We will be working on the unit:
SQL basics
We'll show you the basics of creating tables and selecting data in various different ways.
Welcome to SQL
Creating a table and inserting data
Challenge: Book list database
Querying the table
Challenge: Box office hits database
Aggregating data
Challenge: TODO list database stats
S-Q-L or SEQUEL?
Project: Design a store database
More advanced SQL queries
Learn how to perform more advanced SQL queries using AND/OR, IN, LIKE, HAVING, and more.
More complex queries with AND/OR
Challenge: Karaoke song selector
Querying IN subqueries
Challenge: Playlist maker
Restricting grouped results with HAVING
Challenge: The wordiest author
Who issues SQL queries?
Calculating results with CASE
Challenge: Gradebook
Project: Data dig
Relational queries in SQL
Learn how to store related data in multiple tables and use joins to bring them together (inner joins, outer joins, and self joins).
Splitting data into related tables
JOINing related tables
Challenge: Bobby's Hobbies
Joining related tables with left outer joins
Challenge: Customer's orders
Joining tables to themselves with self-joins
Challenge: Sequels in SQL
Combining multiple joins
Challenge: FriendBook
Project: Famous people
More efficient SQL with query planning and optimization