SQL Database Design for Beginners

185 CQ
41 Lessons
Course Info
Previous...
  • Playing
    3 CQ
    31. Creating Derived Tables in SQL
    A lesson with LearnToProgram
    View lesson

    In this lesson, learn how to create a derived table in SQL using a subquery, and about potential issues with derived tables in large databases.

    Creating Derived Tables in SQL
    with LearnToProgram

    In this lesson, learn how to create a derived table in SQL using a subquery, and about potential issues with derived tables in large databases.

  • Playing
    10 CQ
    32. Using Insert Statements in SQL
    A lesson with LearnToProgram
    View lesson

    Learn how to code implicit, explicit, and multiple INSERT statements in SQL, as well as how to use INSERT to copy data within or between tables.

    Using Insert Statements in SQL
    with LearnToProgram

    Learn how to code implicit, explicit, and multiple INSERT statements in SQL, as well as how to use INSERT to copy data within or between tables.

  • Playing
    7 CQ
    33. Using Update Statements in SQL
    A lesson with LearnToProgram
    View lesson

    In this lesson, learn how to use UPDATE statements to change records in a SQL table, and how to avoid the pitfalls of this record modification method.

    Using Update Statements in SQL
    with LearnToProgram

    In this lesson, learn how to use UPDATE statements to change records in a SQL table, and how to avoid the pitfalls of this record modification method.

  • Playing
    4 CQ
    34. Using Delete Statements in SQL
    A lesson with LearnToProgram
    View lesson

    In this lesson, learn how to write code to permanently erase both single and multiple records in SQL tables, using DELETE, WHERE and LIKE statements.

    Using Delete Statements in SQL
    with LearnToProgram

    In this lesson, learn how to write code to permanently erase both single and multiple records in SQL tables, using DELETE, WHERE and LIKE statements.

  • Playing
    3 CQ
    35. Introduction to SQL Transactions
    A lesson with LearnToProgram
    View lesson

    In this lesson ,learn how to use a SQL transaction for committing a series of operations as a single unit, and rolling back failed modifications.

    Introduction to SQL Transactions
    with LearnToProgram

    In this lesson ,learn how to use a SQL transaction for committing a series of operations as a single unit, and rolling back failed modifications.

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