SQL Tutorial - Introduction to Creating and Modifying Tables

Jon Avis, IT Systems Engineer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Lessons (47m)
    • 1. WHAT IS A DATABASE

      1:38
    • 2. WHAT IS SQL

      1:01
    • 3. How to Install PostgreSQL

      2:24
    • 4. What Is Data Definition Language

      0:58
    • 5. Data Types

      10:07
    • 6. Primary Key

      1:30
    • 7. Foreign Key

      1:32
    • 8. Creating Tables

      10:07
    • 9. Adding and Removing Columns

      5:16
    • 10. Modifying Data Types and Constraints

      7:16
    • 11. Removing Tables

      2:23
    • 12. Removing Rows from Tables

      2:26

About This Class

In this class you will learn how to create a database using SQL. You will learn what data definition language is and some of the concepts within it. You will learn how to create tables within a database. You will learn how you can modify and remove tables with a database. You will also learn about primary and foreign keys and how these can be used to link tables within a database together.