SQL Database Design for Beginners

185 CQ
41 Lessons
Previous...
  • Playing
    4 CQ
    26. Using the Self Join in SQL
    A lesson with LearnToProgram
    View lesson

    Why would a developer be interested in joining a table to itself? This lesson answers just that question and demonstrates how to code for a SQL self join!

    Why would a developer be interested in joining a table to itself? This lesson answers just that question and demonstrates how to code for a SQL self join!

  • Playing
    9 CQ
    27. Joining Multiple Tables in SQL
    A lesson with LearnToProgram
    View lesson

    Ready to learn how to join multiple tables in SQL? Now that the basics have been covered, find out how to work with more complex table joins!

    Ready to learn how to join multiple tables in SQL? Now that the basics have been covered, find out how to work with more complex table joins!

  • Playing
    7 CQ
    28. Filtering with Subqueries in SQL
    A lesson with LearnToProgram
    View lesson

    In this lesson, learn how to use scalar and single column subqueries as filter conditions for a main query in the SQL programming language, using example code.

    In this lesson, learn how to use scalar and single column subqueries as filter conditions for a main query in the SQL programming language, using example code.

  • Playing
    4 CQ
    29. Using the Exists Clause in SQL
    A lesson with LearnToProgram
    View lesson

    Learn a way to easily check if a SQL database subquery returns a result or not! In this lesson, Learn to Program shows how to use the EXISTS clause.

    Learn a way to easily check if a SQL database subquery returns a result or not! In this lesson, Learn to Program shows how to use the EXISTS clause.

  • Playing
    4 CQ
    30. Joins vs. Subqueries in SQL
    A lesson with LearnToProgram
    View lesson

    Which is a better SQL method—a subquery or a join? Compare joins and subqueries with IN and EXISTS clauses to explore which is best for your database.

    Which is a better SQL method—a subquery or a join? Compare joins and subqueries with IN and EXISTS clauses to explore which is best for your database.

More...
  • Recommended Recommended
  • History & In Progress History
  • Browse Library
  • Most Popular Library

Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

Start Interview

You don't have any lessons in your history.
Just find something that looks interesting and start learning!

Comments
500 characters max