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