SQL - Introduction to Creating and Modifying Tables

Jon Avis, Application Support Analyst

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

      1:38
    • WHAT IS SQL

      1:01
    • How to Install PostgreSQL

      2:24
    • What Is Data Definition Language

      0:58
    • Data Types

      10:07
    • Primary Key

      1:30
    • Foreign Key

      1:32
    • Creating Tables

      10:07
    • Adding and Removing Columns

      5:16
    • Modifying Data Types and Constraints

      7:16
    • Removing Tables

      2:23
    • 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.

3 of 3 students recommendSee All

Fantastic class on sql
Great introduction to sql!
Good class as introduction. Thanks, Jon!

14

Students

1

Project

Jon Avis

Application Support Analyst

My name is Jon. I am from the UK and currently work in Hong Kong as an application support analyst for an investment bank. I have over three years experience as a support analyst. This has allowed me to become an expert on SQL and Unix systems.

In my spare time I enjoy hiking, cycling, photography and traveling.