Sign In
Manage PermissionsManage Permissions
|
Export Event

Title

Introduction to Structured Query Language (SQL) for Business & Finance

Event Description

​​Course Goals and Overview:

Databases are ubiquitous and used in almost every organization. Understanding the basics of databases and how to access and manipulate data efficiently allows business professionals to significantly boost their productivity and decision making skills.

This course provides a hands-on introduction to databases and SQL. At the end of the course, participants will be confident in working with database systems to effectively analyze relevant data and draw meaningful business conclusions.

Learning Objectives:

  • Overview of different database technologies
  • Experience working with relational databases
  • Introduction to SQL and how to access and manage complex data

Who Should Attend:

Junior and senior professionals who work with databases and want to understand how to access and manipulate data efficiently

Course Sections:

Introduction

  • What are relational databases, why are databases so important, overview of different database technologies, Excel vs. databases, query & syntax tips

From Data to Tables

  • Introduction to fundamental database concepts, how to structure data in tables, relationship between tables, keys and indices, normalization

Most Important SQL Commands

  • Overview of the most important  SQL statements including SELECT, BETWEEN, IN, WHERE, GROUP BY, HAVING, etc., including writing complex queries with these commands
  • How to gather basic descriptive statistics on large datasets
  • Aggregating data
Advanced SQL Functionality

  • INNER JOIN
  • Subqueries

In-Class Project

  • Hands-on experience importing, preparing, analyzing, and drawing meaningful business insights from a real-world database

Final Exam

Wrap-up & Summary

  • Where to go from here, recommendation of additional resources

What is needed from you:

Participants will need to bring a laptop with them to the course.

Event Type

Educational

Education Topic

 

Start Time

5/22/2018 9:00 AM

End Time

5/23/2018 5:00 PM

City

TBD

State/Province

 

Event Country

 

Event Region

Americas

Location Info

​TBD

Speaker

 

CE Credits

 

SER Credit

0.00

Currency

USD

Member Price

899.00

Non-Member Price

999.00

Candidate Price

899.00

Registration

​Click here​ to register.

If you are having trouble with the online registration, please register here with a manual form.

All Day Event

 

Recurrence

 

Location

 

Cost

 

Description

 

Begin

5/22/2018 9:00 AM

Attachments

Content Type: MyCFA Calendar
Created at 11/13/2017 10:12 AM by serena.roche@gmail.com[CASMSTS:username]
Last modified at 11/14/2017 11:31 AM by serena.roche@gmail.com[CASMSTS:username]