• Home
  • Workshop - SQL for Data Analytics - 11-Nov to 16-Dec

Workshop - SQL for Data Analytics - 11-Nov to 16-Dec

  • 11 Nov 2017
  • 9:00 AM
  • 16 Dec 2017
  • 5:00 PM

Registration


Register

SQL FOR DATA ANALYTICS

In this 36 hour SQL for Data Analytics workshop you will be able to confidently perform data data analysis. You will gain the knowledge and skills needed to understand what Structured Query Language (SQL) will deliver and how it deliver the information.  You will be have the capacity to answer business questions, using Microsoft SQL (MSSQL). And you will have the capacity to deliver a visualization of the data using Tableau.


KEY Reasons To Learn

This 36 hour SQL for Data Analytics workshop  will help you act on data for actual business gain, and not just about what a tool can do. You will leverage tools and techniques to foster better business decision making. Learn valuable ways to store, process and analyze data for business outcomes.


This workshop is hands-on. You will learn the concepts and you will learn how to build and deliver using tools as Microsoft SQL and Tableau.


Recommended Experience

Working knowledge of the Microsoft Windows platform or Mac Platform


Who Should Attend

Anyone wants to start new career in data analytics or needing to implement data, engage your data environment, and wanting to advance their career by ensuring a SQL and analytics foundational knowledge.


Typical job roles include

Anyone wanting to start new career in data analytics or SQL Developer, Report Developer, Tableau Developer, Data Analyst, Business Analysts, Analysis based roles, Project Managers, Software Designers, IT Managers, Business Intelligence. Roles also include those who engage data as part of their job function, such as marketing, branding, strategy, design, solution evaluation, business architecture, research, and more.


Meetups After the Workshop – Keeping it Real World

We stay with you following the course. IIBA Toronto has meetups to answer questions and keep you growing as you apply what you learned.


Dates

SQL for Data Analytics

November | 11, 18, 25

December | 02, 09, 16


Investment

Full Member / Associate Member – Early Bird $895

Full Member / Associate Member – Regular Rate $995

Basic Member / Nonmember – Early Bird $1045

Basic Member / Nonmember – Early Bird $1145


Location

George Brown College

Casa Loma Campus

146 Kendall Avenue, Toronto, ON


Nearest Subway Station: DuPont

Parking: Yes

Type: Street

Type: Parking Lot $6/day


Payment Policy

The IIBA Toronto Workshop fees must be paid upon registration in the Workshop prior to attending. Pricing, registration terms, and conditions are subject to change without notice.

 

IIBA Toronto Chapter reserves the right to make changes to the Workshop described or to cancel the Program at any time without notice or liability. The Chapter's sole liability will be limited to the refund of registration fees paid in respect of the Workshop and the Chapter shall not be responsible for any incidental or consequential loss arising whatsoever. The Chapter will endeavor to give enrollees as much advance notice as possible of any change to the Program or registrant’s enrollment.

 

Registration Fee

The registration fee covers participation only.

 

Refund Policy

Cancellations will be allowed prior to 5 day of the Workshop start date and a full refund will be issued. Cancellations will not be permitted within 5 days of the Workshop start date; however, substitutions will be permitted. It is up to the registrant to find and arrange a substitute. The Chapter will process the substitution by changing the registrant name but is not responsible for any financial transactions between the registrants.

 

No refunds will be issued within 5 days of the Workshop start date. If a registrant does not attend the Workshop and has not given adequate notification, it will result in full forfeiture of the registration fee.

 

If you are unable to attend the Workshop, or have comments or questions, please contact  president@iibatoronto.org.


COURSE OUTLINE

Defining Data Analytics

What is Data Analytics

Types of Data Analytics

Correlation

Delivering Data Analytics business benefits

  • Data Analytics Applications Across Industries

  • Data Analytics Lifecycle

  • Technology Trends


Defining SQL Language

Introducing Relational Database and SQL

Introducing SQL


SQL Language – Getting Started with the Basics

SQL Command Categories

  • Data Definition Language (DDL)

  • Data Manipulation Language (DML)

  • Data Query Language (DQL)

  • Data Control Language (DCL)

  • Data Transactional Commands

Data By Types

  • Data Type and its Importance

  • Basic Data Types

SQL Tables - Creating and Altering Tables

  • SQL Constraints

  • Not Null

  • Unique

  • Primary Key

  • Foreign Key

  • Default

  • Manipulating Data

  • Insert

  • Update

  • Delete


SQL Language – Building Your Competency

Retrieving Data

  • Retrieving Data with SQL

  • Select Query

  • Case Sensitivity

  • Counting the record

  • Column Aliases

Operators

  • Using Operators to Categories Data

  • What is an Operator in SQL

  • Comparison Operators

  • Logical Operators

  • Conjunctive Operators

  • Negative Operators

  • Arithmetic Operators

Data Results

  • Summarizing Data Results

  • Using WHERE to Filters Results

  • The Group by Clause

  • Having Clause

  • Restructuring the Appearance of Data

Functions

  • Character Functions

  • Mathematical Functions

  • Date Functions

Join

  • Joining : Getting Results from Multiple Tables • Inner Join or Equijoins

  • Outer Join (Left Join, Right Join)

  • Self-Join

Cartesian Product

Table Aliases

Sub Queries

Views


Data Visualization with Tableau

Tableau Basics

Tableau Visualization


Workshop Project – Keeping It Real!





© IIBA Toronto Chapter
Powered by Wild Apricot Membership Software