online & regional CourseSQL For Data Analysis

Strengthen skills foundations by using SQL to access a broader range of data sources.

Schedule This Course
Course Details
Course Level
full
Course Length
16 Hrs
Minimum Class Size
5 Students
Course Platform
online & regional
Need a print version of this course?
Download PDF

Course Overview

Structured Query Language or SQL is one of the most useful means of data analysis that is no longer confined to relational databases. Many tools, including Spark, Flink, Drill, Cassandra and even ElasticSearch now support SQL queries. A solid understanding of SQL will expand the number of different data sources that an analyst can access.

Man Looking at course on screen

Once You’ve Completed This Course You Have The Skills To:

Effectively use a foundation in SQL to expand access to data sources.


Course Objectives

Execute simple queries in SQL
Understand the relational database model
Use SQL to query non-relational datasets and flat files
Create complex datasets by joining datasets together
Create data summaries with complex aggregate queries

The Fine Print

Course Size Requirements

GTK has a 5 student minimum for courses and no maximum head count. Head count must be locked in at the time of contract.

US Travel / Incidental Cost

  • U.S. Travel/Incidental cost is $500 per day.
  • Virtual courses do not incur travel/incidental costs.
  • No Travel/Incidental costs are charged for local courses (MD/DC/VA corridor).

Course Format

  • Instructors typically teach 50% of the day, and run training simulations for the other 50%.
  • GTK typically uses Google Meets for virtual courses, but can use any service with advanced notice.

[The GTK Cyber course] was well organized and flowed nicely, all of the topics were relevant.

Former Student

I found it informative and interesting.

Former Student

The Jupyter notebooks and answers were a big help.

Former Student

Other Courses You Might Like

Let GTK Cyber build a program that fits your network security requirements. Explore the suggested courses below to expands your team’s knowledge and skills.
online & regional

full coursePython Coding for Security Analysts

Learn More
online & regional

full courseData Science for Managers

Learn More
online & regional

full courseApplied Data Science and Machine Learning

Learn More
online & regional

full courseSQL For Data Analysis

Learn More
online & regional

micro courseSecurity Data Visualization

Learn More
online & regional

micro courseRapid Data Exploration with Pandas

Learn More
online & regional

full courseThreat Hunting With Data Science

Learn More
online & regional

micro courseConceptual Overview of Machine Learning

Learn More
online & regional

full courseRapid Data Exploration With Open Source Tools

Learn More