SQL Scripting Fundamental

SQL SCRIPTING FOR BUSINESS REPORTING

Through a blend of hands-on labs and interactive lectures, participants will learn about querying data in relational databases that are hosted in Microsoft SQL Server-based database systems.

Audience Profile:

This course is intended for Data Analyst, and those responding for generating reports in an organization through interaction with tables in an SQL Server Environment.

Prerequisites:

No Prior Knowledge Required.

Here are the learning paths in this series:

• RELATIONAL DATABASE CONCEPTS
What is a Relational Database?
Relational Database Structures
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
Data Types
The Data Dictionary

• RETRIEVING DATA WITH THE SELECT STATEMENT
The Select Statement
The Select and From Clauses
Conditions and the Where Clause
Other Conditional Operators
Logical Operators
The Order By Clause
Column Aliases
Arithmetic Operations
Precedence of Operators

• AGGREGATE FUNCTIONS
Overview of Built in Aggregate Functions
The Group By Clause
The Having Clause

• JOINING TABLES
Overview of Table Joins
Inner Joins
Table Aliases
Outer Joins

• BASIC SUBQUERIES AND SET OPERATORS
Overview of Subqueries
Basic Subqueries
Set Operators