SQL Database Design for Beginners

185 CQ
41 Lessons
Course Info
Previous...
  • Playing
    3 CQ
    21. Using the Having Clause in SQL
    A lesson with LearnToProgram
    View lesson

    It’s time to start filtering consolidated data! Find out how to use the SQL having clause with SQL group by to filter information by criteria.

    Using the Having Clause in SQL
    with LearnToProgram

    It’s time to start filtering consolidated data! Find out how to use the SQL having clause with SQL group by to filter information by criteria.

  • Playing
    3 CQ
    22. SQL Grouping Do's and Don'ts
    A lesson with LearnToProgram
    View lesson

    Ready to learn more do’s and don’ts of SQL grouping? Find out how to avoid issues in data consolidation by using the SQL group by clause the right way!

    SQL Grouping Do's and Don'ts
    with LearnToProgram

    Ready to learn more do’s and don’ts of SQL grouping? Find out how to avoid issues in data consolidation by using the SQL group by clause the right way!

  • Playing
    4 CQ
    23. Creating Table Aliases in SQL
    A lesson with LearnToProgram
    View lesson

    Wondering how to create a SQL alias for a data table? This straightforward lesson offers a run-down on how to code table aliases and save a bunch of time!

    Creating Table Aliases in SQL
    with LearnToProgram

    Wondering how to create a SQL alias for a data table? This straightforward lesson offers a run-down on how to code table aliases and save a bunch of time!

  • Playing
    6 CQ
    24. Using the Inner Join in SQL
    A lesson with LearnToProgram
    View lesson

    Curious how to combine tables based on data? Try using an SQL inner join! This lesson shows how to code inner joins using the implicit and explicit methods.

    Using the Inner Join in SQL
    with LearnToProgram

    Curious how to combine tables based on data? Try using an SQL inner join! This lesson shows how to code inner joins using the implicit and explicit methods.

  • Playing
    7 CQ
    25. Using the Outer Join in SQL
    A lesson with LearnToProgram
    View lesson

    Now that the inner join has been covered, it’s time to dive into the SQL outer join! This lesson covers each type: left join, right join, and full join.

    Using the Outer Join in SQL
    with LearnToProgram

    Now that the inner join has been covered, it’s time to dive into the SQL outer join! This lesson covers each type: left join, right join, and full join.

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