Intro to SQL - Querying and Managing Data (Khan Academy)

Learn the basics of SQL. SQL is a programming language used for managing and analyzing data in a relational database, and is used in almost every organization, company, and software product. This Action Plan Template breaks down the course material from the Khan Academy course "Intro to SQL: Querying and managing data" into an Action Plan that you can use to manage your progression through the class. All Actions link back to the course materials on the Khan Academy site. If you prefer not to use this Action Plan Template, you can access the full course yourself on the Khan Academy site. All Khan Academy content is available for free at www.khanacademy.org.

  • Welcome to SQL
    Sep 16, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/v/welcome-to-sql
  • Lesson: Creating a table and inserting data
    Sep 16, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/creating-a-table-and-inserting-data
  • Challenge: Book list database
    Sep 17, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pc/challenge-book-list-database
  • Lesson: Querying the table
    Sep 18, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/querying-the-table
  • Challenge: Box office hits database
    Sep 18, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/querying-the-table
  • Lesson: Aggregating data
    Sep 19, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/aggregating-data
  • Challenge: TODO list database stats
    Sep 19, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pc/challenge-todo-list-database-stats
  • Lesson: S-Q-L or SEQUEL?
    Sep 20, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/v/s-q-l-or-sequel
  • Project: Design a store database:
    Sep 21, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pp/project-design-a-store-database
  • Lesson: More complex queries with AND/OR
    Sep 22, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pt/more-complex-queries-with-andor
  • Challenge: Karaoke song selector
    Sep 22, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pc/challenge-karaoke-song-selector
  • Lesson: Querying IN subqueries
    Sep 23, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pt/querying-in-subqueries
  • Challenge: Playlist maker
    Sep 23, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pc/challenge-playlist-maker
  • Lesson: Restricting groups results with HAVING
    Sep 24, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pt/restricting-grouped-results-with-having
  • Challenge: The wordiest author
    Sep 24, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pc/challenge-the-wordiest-author
  • Lesson: Who issues SQL queries?
    Sep 25, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/a/who-issues-sql-queries
  • Lesson: Calculating Results with CASE
    Sep 25, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pt/calculating-results-with-case
  • Challenge: Gradebook
    Sep 25, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pc/challenge-gradebook
  • Project: Data dig
    Sep 26, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pp/project-data-dig
  • Lesson: Splitting data into related tables
    Sep 27, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/a/splitting-data-into-related-tables
  • Lesson: JOINing related tables
    Sep 27, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pt/joining-related-tables
  • Challenge: Bobby's Hobbies
    Sep 28, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pc/challenge-bobbys-hobbies
  • Lesson: Joining related tables with left outer joins
    Sep 29, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pt/joining-related-tables-with-left-outer-joins
  • Challenge: Customer's orders
    Sep 29, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pc/challenge-customers-orders
  • Lesson: Joining tables to themselves with sel-joins
    Sep 30, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pt/joining-tables-to-themselves-with-self-joins
  • Challenge: Sequels in SQL
    Sep 30, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pc/challenge-sequels-in-sql
  • Lesson: Combining multiple joins
    Oct 1, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pt/combining-multiple-joins
  • Challenge: FriendBook
    Oct 1, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pc/challenge-friendbook
  • Project: Famous People
    Oct 2, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/pp/project-famous-people
  • Lesson: More efficient SQL with query planning and optimization
    Oct 2, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/a/more-efficient-sql-with-query-planning-and-optimization
  • Lesson: Using SQL to update a database
    Oct 3, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/modifying-databases-with-sql/a/using-sql-to-update-a-database
  • Lesson: Changing rows with UPDATE and DELETE
    Oct 3, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/modifying-databases-with-sql/pt/changing-rows-with-update-and-delete
  • Challenge: Dynamic documents
    Oct 3, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/modifying-databases-with-sql/pc/challenge-dynamic-documents
  • Lesson: Altering tables after creation
    Oct 4, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/modifying-databases-with-sql/pt/altering-tables-after-creation
  • Challenge: Clothing Alterations
    Oct 4, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/modifying-databases-with-sql/pc/challenge-clothing-alterations
  • Lesson: Make your SQL safer
    Oct 5, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/modifying-databases-with-sql/a/make-your-sql-safer
  • Project: App imperonsator
    Oct 6, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/modifying-databases-with-sql/pp/project-app-impersonator
  • What to learn next?
    Oct 6, 2020
    https://www.khanacademy.org/computing/computer-programming/sql/further-learning-in-sql/a/further-learning-in-sql-what-to-learn-next
  •  

Equip yourself for success