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