You've got the power

Introduction to SQL Server

John MacKintosh

Instructor

CRUD operations

CREATE

  • Databases, Tables or views
  • Users, permissions, and security groups

READ

  • Example: SELECT statements

UPDATE

  • Amend existing database records

DELETE

Introduction to SQL Server

CREATE

  • CREATE TABLE unique table name
  • (column name, data type, size)
CREATE TABLE test_table(
  test_date date, 
  test_name varchar(20), 
  test_int int
)
Introduction to SQL Server

A few considerations when creating a table

  • Table and column names
  • Type of data each column will store
  • Size or amount of data stored in the column
Introduction to SQL Server

Data types

Dates:

  • date (YYYY-MM-DD), datetime (YYYY-MM-DD hh:mm:ss)
  • time

Numeric:

  • integer, decimal, float
  • bit (1 = TRUE, 0 = FALSE. Also accepts NULL values)

Strings:

  • char, varchar, nvarchar
Introduction to SQL Server

Let's create some tables!

Introduction to SQL Server

Preparing Video For Download...