Description

Duration

2 Days

12 CPD hours

This course is intended for

This SQL training course is designed for students new to writing SQL queries.

Overview

Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables.

Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases.

Relational Database Basics

Brief History of SQL

Relational Databases

Popular Databases

SQL Statements

Simple SELECTs

Introduction to the Northwind Database

Some Basics

SELECTing All Columns in All Rows

Exploring the Tables

SELECTing Specific Columns

Sorting Records

The WHERE Clause and Operator Symbols

Using the WHERE clause to check for equality or inequality

Using the WHERE clause to check for greater or less than

Checking for NULL

Using WHERE and ORDER BY Together

The WHERE Clause and Operator Words

More SELECTs with WHERE

Checking Multiple Conditions

Writing SELECTs with Multiple Conditions

Advanced SELECTs

Calculated Fields

Calculating Fields

Aggregate Functions and Grouping

Working with Aggregate Functions

Built-in Data Manipulation Functions

Data Manipulation Functions

Subqueries, Joins and Unions

Subqueries

Joins

Using Joins

Outer Joins

Unions

Working with Unions

If time allows, one or more of the following may be covered:

Conditional Processing with CASE

INSERT, UPDATE, DELETE

Student Challenges - Design your own reports

Course Images

Introduction to SQL

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews