The Basics of Creating Tables in SQL

Table of contents

1. 1. Create Your First Table

   0/12

   Remember what tables are? You will learn how to create simple tables.

   List of exercises Start now
   1. Your First Table
      1. Welcome
      2. Insert some data
      3. Query the table
      4. Play time!
   2. CREATE TABLE basics
      1. How tables work
      2. How tables work – continued
      3. CREATE TABLE with one column
      4. CREATE TABLE with multiple columns
      5. The VARCHAR column type
   3. Entity Relationship Diagrams (ERD)
      1. Example of ERD
      2. ERD to SQL code
   4. Summary
      1. Summary

2. 2. Primary keys and NOT NULL columns

   0/27

   How to tell the database that an id column is really an identifier and that a column value is obligatory.

   List of exercises Buy course
   1. Primary keys – the basics
      1. Primary keys – Introduction
      2. Primary keys – Syntax
      3. Primary keys – Missing values
      4. Primary keys – adding new values
      5. Primary keys – duplicated values
      6. Primary keys – NULL values
      7. Primary keys – summary
   2. Single-column primary keys
      1. Syntax revisited
      2. Primary key data type
      3. Primary keys in ERD
      4. There can only be one...
      5. ...but one there should be!
   3. Multi-column primary keys
      1. Multi-column primary keys – introduction
      2. Uniqueness with multi-column primary keys
      3. Uniqueness with multi-column primary keys – continued
      4. Uniqueness with multi-column primary keys – summary
      5. Multi-column primary keys in ERD
   4. NOT NULL
      1. NOT NULL – Adding NULL values
      2. NOT NULL – Creating tables
      3. NULLable columns – default behavior
      4. NULLable columns – default behavior continued
      5. NULL columns
      6. NULL or NOT NULL?
      7. NULL in ERD diagrams
   5. Review
      1. Question 1
      2. Question 2
      3. Summary

3. 3. Foreign Keys

   0/20

   How to properly reference one table in another table.

   List of exercises Buy course
   1. Introduction
      1. Foreign Keys – Introduction
      2. Referring to one table from another
      3. Adding new data
      4. Adding incorrect data
      5. Adding incorrect data – explained
   2. Foreign keys
      1. Creating tables with foreign keys
      2. Inserting incorrect data with foreign keys
      3. Updating incorrect data with foreign keys
      4. Updating data in the table the foreign key points to
      5. Creating tables with foreign keys – exercise
      6. Foreign keys in ERD diagrams
   3. Multi-column Foreign Keys
      1. Creating multi-column foreign keys
      2. Playing around with multi-column foreign keys
      3. Creating multi-column foreign keys on your own
      4. Creating multiple foreign keys in one table
      5. Foreign key columns as primary key columns
      6. Foreign key columns as primary key columns – practice
   4. Summary
      1. Question 1
      2. Question 2
      3. Review – Summary

4. 4. Modifying table structure

   0/14

   How to add, remove a table or change the structure of an existing table in a database.

   List of exercises Buy course
   1. Introduction
      1. Modifying table structure – Welcome
   2. Modifying table structure
      1. Removing entire tables
      2. Changing table name
      3. Changing column name
      4. Removing columns
      5. Different ways to remove a column
      6. Adding a column
      7. Adding data to a column
   3. Adding NOT NULL constraints
      1. Adding NOT NULL columns – part 1
      2. Adding NOT NULL columns – part 2
      3. Adding NOT NULL columns – exercise
   4. Summary
      1. Question 1
      2. Question 2
      3. Summary

5. 5. Final quiz

   0/7

   Time to test your knowledge!

   List of exercises Buy course
   1. Introduction
      1. Welcome
      2. Question 1
      3. Question 2
      4. Question 3
      5. Question 4
      6. Question 5
   2. Summary
      1. Congratulations

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more