Sign In

A Member of the CFA Institute Global Network of Societies

​​​

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

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.

 Registration Fees

​CFAW Members: $899.00

Non-Members: $999.00

 Dates and Location

​May 22-23, 2018

9:00 am  - 5:00 pm

George Mason University - Arlington ​​Campus
Founders Hall
Room 118
3351 North Fairfax Drive
Arlington, VA 22201

Click here​ to register.