Fall Bootcamp Final Application Deadline is Monday! Apply Now

Accredited Professional Development Course

SQL Fundamentals

Offered Live Online Only

Are you interested in sharpening your SQL and data engineering skills, but don't know where to start? This SQL Fundamentals course is designed to take a beginner practitioner and up-skill them to confidently manage, query, and analyze data within a relational database using the SQL language. We will cover:

  • Creating and managing tables
  • Queries
  • Joins
  • Subqueries
  • Sets
  • Functions
  • Advanced data management

Course placeholder

Who the course is designed for:

This course focuses on true beginners who want to learn SQL and data management. Prior experience with SQL or another functional language is not required. Whether you’re considering a new career in data engineering or data science, you want to master SQL in order to advance your current career, or you want to communicate more effectively with data-oriented colleagues, you’ll finish this program with a solid understanding of SQL and foundational platforms.

Outcomes

  • Communicate effectively with data teams
  • Use SQL to build tables, capture data, and query results
  • Apply data management best practices to your firm's datasets
  • Create advanced SQL functions and reports
  • Analyze and mine complex datasets
Have questions? Get answers to frequently asked questions. FAQs

What you'll receive upon completion:

  • Certificate of completion
  • Certificate link and instructions on how to add to your LinkedIn profile
  • 1 Continuing Education Unit

Dates & Instructors

Live Online
$499

SQL Fundamentals

August 14 to August 23

Tuesdays and Thursdays

6:30 - 9:30pm Pacific Time

Jonathan balaban
Jonathan Balaban
Instructor

Jonathan Balaban, Senior Data Scientist at Metis, is a consultant, data scientist, and entrepreneur with ten years of private, public, and philanthropic experience. Jonathan has also worked at McKinsey and Booz Allen Hamilton, and he has taught data science at General Assembly. He has led teams to design bespoke data science solutions that have driven revolutionary changes in client operations. Jonathan - sometimes successfully - leverages data science solutions in his personal life: on friends, racing, and training.

Enroll
Live Online
$499

SQL Fundamentals

September 4 to September 13

Tuesdays and Thursdays

6:30 - 9:30PM Eastern Time

Instructor Coming Soon
Enroll
Live Online
$499

SQL Fundamentals

September 22 to September 23

Saturdays and Sundays

11:00 - 5:00PM Central Time

Instructor Coming Soon
Enroll
Live Online
$499

SQL Fundamentals

October 9 to October 18

Tuesdays and Thursdays

6:30 - 9:30PM Pacific Time

Instructor Coming Soon
Enroll
Live Online
$499

SQL Fundamentals

October 20 to October 21

Saturdays and Sundays

9:00 - 3:00PM Pacific Time

Instructor Coming Soon
Enroll

Prerequisites

There are no requirements other than a working laptop and internet connection. Having an understanding of your firm's data, technologies, and goals will motivate and direct your focus in this program. You do not need prior experience with SQL or another programming language, but it helps!

Considering our immersive data science bootcamp?

Professional development alumni can apply the amount of tuition paid for one part-time course towards enrollment in an upcoming bootcamp upon admittance.

Course Structure & Syllabus

Class 1
Introduction to SQL and Table Management
  1. Understanding relational databases
  2. Overview of technologies and platforms used in the course
  3. Creating and populating tables
Class 2
Joins and Queries
  1. SQL join types
  2. Querying and selecting relevant database information
  3. Intelligent filtering
Class 3
Subqueries, Sets, and Functions
  1. String logic
  2. Math functions
  3. Embedded queries
  4. Inserting data dynamically
  5. Set types and uses
Class 4
Advanced SQL Management
  1. Constraints
  2. Table indexing
  3. Creating custom views
  4. Summary and review

Live Online Interactive Learning

Learn from world-class data science practitioners.

Our Live Online instructors bring deep industry experience from a broad range of industries and companies including Viacom, Spotify, and Capital One Labs. You’ll have an Instructor and Assistant Instructor to support you throughout your learning process.

Interact with instructors and classmates in real-time.

This course is truly live, which means you can interact with the instructors and your fellow students in real-time. Stay engaged by asking questions and participating in polls and conversations, and join your course Slack channel for additional support, communication, and collaboration.

Learn online without sacrificing the value of live instruction.

The world is your classroom. Log in from wherever you are and gain access to live, interactive data science instruction that will push your career further in the right direction. In case you have to miss a class, you can access all recordings 24/7 to stay caught up and refer back.

Earn CEUs for accredited courses.

Not only will you walk away with new data science skills and knowledge, you’ll also earn up to 3.3 Continuing Education Units (CEUs). Our courses are accredited by ACCET, who requires we maintain high standards in areas such as quality of instruction and positive student feedback.

FAQs

Have more questions? No problem. Schedule a chat with admissions