SQL For Data Science and Data Analysis Training Course

This instructor-led, live training (online or onsite) is aimed at software developers, managers, and business analyst who wish to use big data systems to store and retrieve large amounts of data.

By the end of this training, participants will be able to:

Query large amounts of data efficiently.
Understand how Big Data system store and retrieve data
Use the latest big data systems available
Wrangle data from data systems into reporting systems
Learn to write SQL queries in:
- MySQL
- Postgres
- Hive Query Language (HiveQL/HQL)
- Redshift

Format of the Course

Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.

Course Customization Options

To request a customized training for this course, please contact us to arrange.

Thank you for sending your enquiry! One of our team members will contact you shortly.

Thank you for sending your booking! One of our team members will contact you shortly.

Course Outline

Lesson 1 - SQL basics:

Select statements
Join types
Indexes
Views
Subqueries
Union
Creating tables
Loading data
Dumping data
NoSQL

Lesson 2 - Data Modeling:

Transaction based ER systems
Data warehousing
Data warehouse models
- Star schema
- Snowflake schemas
Slowly changing dimensions (SCD)
Structured and non-structured data
Different table type storage engines:
- Column based
- Document-based
- In Memory

Lesson 3 - Index in the NoSQL/Data science world

Constraints (Primary)
Index-based scanning
performance tuning

Lesson 4 - NoSQL and non-structured data

When to use NoSQL
Eventually consistent data
Schema on read vs. Schema on write

Lesson 5 - SQL for data analytics

Windowing function
Lateral Joins
Lead & Lag

Lesson 6 - HiveQL

SQL Support
External and Internal Tables
Joins
Partitions
Correlated subqueries
Nested queries
When to use Hive

Lesson 7 - Redshift

Design and structured
Locks and shared resources
Postgres differences
When to use redshift

Requirements

An understanding of databases
Experience with SQL an asset.

Audience

Business analysts
Software developers
Database developers

14 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

Pre-course call with your trainer
Customisation of the learning experience to achieve your goals -

Bespoke outlines
Practical hands-on exercises containing data / scenarios recognisable to the learners

Training scheduled on a date of your choice
Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Public Training

Please see our public courses

Need help picking the right course?
opleidingen@nobleprog.com or +31 208 080 666

Testimonials (3)

Gunnar adjusted the content for the second day based on our feedback from day one. He checked in with us to find out what we liked, disliked, found hard and how we wanted to approach day 2. I liked Gunnar's style of teaching: Lecture, share examples, allowed us time to practice and answer questions before moving to the next subject. It meant we could fully understand a topic before moving onto the next subject. This reduced overload of information and gave us a chance to spend more time on the topics we struggled with and less time on the stuff we found easy.

Ffion - Complete Coherence

Course - SQL For Data Science and Data Analysis

Gunnar’s training technique is dynamic, thorough, and perfectly tailored to individual needs. In our group of five, he ensured everyone stayed on track and fully understood the material throughout the course. The knowledge and resources we gained will undoubtedly be valuable for years to come. Thank you, Gunnar!

Marcia - Complete Coherence

Course - SQL For Data Science and Data Analysis

Gunnar created a great rapport with the audience and was quick to identify our needs. He was engaging and highly knowledgeable throughout and we enjoyed his humour.