SQL FOR DATA ANALYTICS

In this 30 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.

Location

The participants have voted! We are meeting in Room E430, George Brown College Casa Loma Campus, 146 Kendal Avenue, Toronto, ON.

Software To Be Used

You will be using your own computer. We are using Microsoft Access.  You can also use MSSQL Products if you have that installed.

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 | 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

Room E430

146 Kendal Avenue

Toronto, ON

FACILITATOR

Jing Yan

Jing has 10 years of experience in the IT industry. She graduated with a Bachelor of Commerce at McGill University majoring in Management Information Systems. She has spent the last 6 years doing data analytics with large amounts of financial, HR and customer data at TD Bank within TD Wealth and TD Merchant Services. She has exceptional SQL query manipulation skills and is always thriving for the simplest, most efficient business solutions to serve her clients’ needs.

 

Throughout the course of her career, Jing has built and designed several database tools from scratch to support reporting needs of businesses using MS Access, MS Excel and Tableau. She has worked with up to 3,000,000 lines of large data sets and dissected them into useful information for stakeholders. She has strong expertise in database Best Practices and querying strategies to ensure simplicity and accuracy of data results.

 

Jing has experience delivering training to educate new hires in the corporate environment. Her teaching style is engaging, fun, and offers a very positive environment that is conducive to effective learning.

 

You can check out her LinkedIn Profile and add her in your network! https://www.linkedin.com/in/jingjing-yan-2b8ba11b/

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

Everything you learn will be used in a project you will execute in-class.