Introduction
This course provides an overview of relational database design principles it does not cover the teaching of formal database design processes and database/table creation.
The course assumes no previous knowledge of SQL and SELECT statements, and takes delegates from simple queries, through to complex queries involving multiple tables, introducing the vast collection of built-in functions along the way.
Target Audience:
- IT Administrators
- Database Administrators
- Application Developers
- Cloud Computing Professionals
- Configuration Specialists
- Migration & Deployment Specialists
- Data Migration Specialists
- Deployment Specialists
- Infrastructure Specialists
- IT Security Professionals
Course Outlines
Day 1
Relational Database Overview
- Basic Relational Database Terminology
- Relational Database
- Tables and Columns
- Rows and Records
- Connecting Tables
- Primary Keys
- Foreign Keys
- Relationship Types
Day 2
The SELECT Statement
- SELECT list
- Columns
- ALL or DISTINCT
- String Expressions
- Arithmetic Expressions
- Column Aliases
Relational Operators
- BETWEEN AND
- IS NULL Example
- IN Example
- LIKE Examples
- Working With Dates
- NOT
Day 3
Aggregate Functions
- COUNT
- SUM
- MAX
- MIN
- AVG
- NULL Values and Aggregates
- Aggregate Expressions
- Mathematical Functions
- SQUARE
- POWER
- SQRT
- RADIANS, SIN, COS, TAN
- ABS
- ROUND
- CEILING & FLOOR
Day 4
Conversion Functions
- CAST and CONVERT
- Converting Dates To Strings
- Converting Money Values To Strings
- ISNULL Function
String Functions
- UPPER & LOWER
- STR
- LEFT & RIGHT
- CHARINDEX
- SUBSTRING
- REVERSE, REPLACE and SPACE
- RTRIM & LTRIM
- REPLICATE
- Using REPLICATE To Pad Strings
- ASCII & CHAR
Day 5
Date Functions
- GETDATE
- YEAR, MONTH & DAY
- DATEPART & DATENAME
- Date Arithmetic
- DATEADD & DATEDIFF
INNER Join
- Legacy Style Joins
- ANSI Style Joins
- Simple Joins
- Two Tables
- Three Tables
- Four Tables
- INNER JOIN Theory
Credits: 5 credit per day
Course Mode: full-time
Provider: Blackbird Training Centre
