Learn SQL: Course OverviewCourse Overview

Manipulation

Learn how to use SQL to access, create, and update data stored in a database.

Start

Key Concepts

Review core concepts you need to learn to master this subject

CREATE TABLE Statement

INSERT Statement

UPDATE Statement

ALTER TABLE Statement

DELETE Statement

Column Constraints

`CREATE TABLE` Statement

CREATE TABLE table_name (
  column1 datatype,
  column2 datatype,
  column3 datatype
);

The CREATE TABLE statement creates a new table in a database. It allows one to specify the name of the table and the name of each column in the table.

Manipulation

Lesson 1 of 1

1
Introduction to SQL
SQL, Structured Query Language, is a programming language designed to manage data stored in relational databases. SQL operates through simple, declarative statements. This keeps data ac…
Start
2
Relational Databases
Nice work! In one line of code, you returned information from a relational database. SELECT * FROM celebs; We’ll take a look at what this code means soon, for now, let’s focus on what relationa…
Start
3
Statements
The code below is a SQL statement. A statement is text that the database recognizes as a valid command. Statements always end in a semicolon ;. CREATE TABLE table_name ( column_1 data_type, …
Start
4
Create
CREATE statements allow us to create a new table in the database. You can use the CREATE statement anytime you want to create a new table from scratch. The statement below creates a new table named…
Start
5
Insert
The INSERT statement inserts a new row into a table. We can use the INSERT statement when you want to add new records. The statement below enters a record for Justin Bieber into the celebs table….
Start
6
Select
SELECT statements are used to fetch data from a database. In the statement below, SELECT returns all data in the name column of the celebs table. SELECT name FROM celebs; 1. SELECT is a clause …
Start
7
Alter
The ALTER TABLE statement adds a new column to a table. You can use this command when you want to add columns to a table. The statement below adds a new column twitter_handle to the celebs table. …
Start
8
Update
The UPDATE statement edits a row in a table. You can use the UPDATE statement when you want to change existing records. The statement below updates the record with an id value of 4 to have the twit…
Start
9
Delete
The DELETE FROM statement deletes one or more rows from a table. You can use the statement when you want to delete existing records. The statement below deletes all records in the celeb table with …
Start
10
Constraints
Constraints that add information about how a column can be used are invoked after specifying the data type for a column. They can be used to tell the database to reject inserted data that does no…
Start
11
Review
Congratulations! We’ve learned six commands commonly used to manage data stored in a relational database and how to set constraints on such data. What can we generalize so far? SQL is a programmin…
Start