SQL Database Design for Beginners

185 CQ
41 Lessons
Course Info
Previous...
  • Playing
    2 CQ
    36. Initiating a Transaction in SQL
    A lesson with LearnToProgram
    View lesson

    Interested in using transactions in the SQL programming language? In this lesson, analyze example code to see how to start a SQL transaction.

    Initiating a Transaction in SQL
    with LearnToProgram

    Interested in using transactions in the SQL programming language? In this lesson, analyze example code to see how to start a SQL transaction.

  • Playing
    3 CQ
    37. Commit & Rollback Commands in SQL
    A lesson with LearnToProgram
    View lesson

    In this lesson, learn to use the COMMIT and ROLLBACK commands in SQL to discard or finalize transaction changes so they’re visible to database users!

    Commit & Rollback Commands in SQL
    with LearnToProgram

    In this lesson, learn to use the COMMIT and ROLLBACK commands in SQL to discard or finalize transaction changes so they’re visible to database users!

  • Playing
    8 CQ
    38. Creating & Dropping Tables in SQL
    A lesson with LearnToProgram
    View lesson

    In this lesson, learn to make a new SQL table with the correct column data types, and learn about the ALTER TABLE and DROP TABLE statements.

    Creating & Dropping Tables in SQL
    with LearnToProgram

    In this lesson, learn to make a new SQL table with the correct column data types, and learn about the ALTER TABLE and DROP TABLE statements.

  • Playing
    4 CQ
    39. Using SQL Views
    A lesson with LearnToProgram
    View lesson

    Wondering why your SQL database is running so slowly? In this lesson, learn how to create and use SQL views for performance optimization of SQL queries.

    Using SQL Views
    with LearnToProgram

    Wondering why your SQL database is running so slowly? In this lesson, learn how to create and use SQL views for performance optimization of SQL queries.

  • Playing
    5 CQ
    40. SQL Stored Procedure Basics
    A lesson with LearnToProgram
    View lesson

    Get a taste of advanced SQL features by learning how to develop, call, and drop a simple stored procedure for executing pre-optimized queries!

    SQL Stored Procedure Basics
    with LearnToProgram

    Get a taste of advanced SQL features by learning how to develop, call, and drop a simple stored procedure for executing pre-optimized queries!

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