You've got the power

Introduzione a 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

Introduzione a 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
)
Introduzione a 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
Introduzione a 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
Introduzione a SQL Server

Let's create some tables!

Introduzione a SQL Server

Preparing Video For Download...