SQL Online Crash Course – Introduction

What will you learn?

Understand the creation and modification of tables, how to handle data, do calculations and gain query speed.

Content

  1. Chapter 1 – Straight Into Action

    1. Create Table
    2. Insert Into
    3. Select *, Where, Group By, Age, AvgAge
    4. Alter Table (Gender, Size, Notes)
    5. Update, Delete
    6. Create Index
    7. Create Table Class, Join
  2. Chapter 2 – Hands On

    1. How To Test – SQL Fiddle
    2. How To Install – Microsoft SQL Server Express
    3. Usefull Tools – SSMS, Profile

Preamble – What you should know first!

Usually you will hear at this point a lot of theory. Terms like “Database normalization”, abstraction, tuples, redundancy and so on. My point of view – forget about it – first let’s see, what a database is and can do for you! Learning by doing.

Once you got the point, you can go further into details and optimizations.

Ok, here are a few terms you should have heard of you start.

Database

Database Management System

Table

Record

Field

Value

Datatype

SQL

DDL

DML

DCL

Query

Database Tool

>> Part 1