text.skipToContent text.skipToNavigation

SQL for BI developers


SQL - Writing SQL for Business Intelligence Training

Introduction

This 1-day instructor led training course provides delegates with the technical skills required to write basic SQL queries using Microsoft SQL Server or Oracle.

This 1-day instructor led training course provides delegates with the technical skills required to write basic SQL queries using Microsoft SQL Server or Oracle.
This 1-day instructor led training course provides delegates with the technical skills required to write basic SQL queries using Microsoft SQL Server or Oracle.
Price:
On Request
Duration: 1 day

Getting Started with Databases and SQL

  • Overview of SQL server databases
  • Overview and syntax elements SQL
  • Working with SQL scripts
  • Using SQL querying tools
  • Using SQL server management studio

Querying and Filtering Data

  • Using the SELECT statement
  • Filtering data
  • Working with NULL values
  • Formatting result Sets
  • Performance considerations for writing queries
  • Querying and filtering data

Joining Data from Multiple Tables

  • Querying multiple tables by using joins
  • Applying joins for typical reporting needs
  • Combining and limiting result set

Grouping & Summarising Data

  • Summarising data by using aggregate functions
  • Summarising grouped data
  • Ranking grouped data
  • Creating crosstab queries
  • Grouping and summarising data

Working with Sub-queries

  • Writing basic sub queries
  • Writing correlated sub queries
  • Comparing sub queries with joins and temporary tables
  • Using common table expressions (CTE)
  • Working with sub-queries

Modifying Data in Tables

  • Inserting data into tables
  • Deleting data from tables
  • Updating data in tables
  • Overview of transactions
  • Modifying data in tables

Using programming objects for Data Retrieval

  • Creation of views
  • Creation of user-defined functions
  • Creation of stored procedures
  • Overview of triggers
  • Writing distributed queries
  • Use querying tools.
  • Write SELECT queries to retrieve data.
  • Group and summarize data by using SQL.
  • Join data from multiple tables.

Experience with these subject areas is strongly recommended:

  • Basic Relational database knowledge

If you want to further increase your skill and knowledge, the following additional courses are recommended

  • Data Warehousing ETL Process