Course Outline
Lesson 1 - SQL Basics for Government:
- Select Statements
- Join Types
- Indexes
- Views
- Subqueries
- Union
- Creating Tables
- Loading Data
- Dumping Data
- NoSQL for Government
Lesson 2 - Data Modeling for Government:
- Transaction-Based ER Systems
- Data Warehousing for Government
- Data Warehouse Models
- Star Schema
- Snowflake Schemas
- Slowly Changing Dimensions (SCD)
- Structured and Non-Structured Data for Government
- Different Table Type Storage Engines:
- Column-Based
- Document-Based
- In-Memory
Lesson 3 - Indexing in the NoSQL/Data Science World for Government:
- Constraints (Primary)
- Index-Based Scanning
- Performance Tuning for Government
Lesson 4 - NoSQL and Non-Structured Data for Government:
- When to Use NoSQL for Government
- Eventually Consistent Data for Government
- Schema on Read vs. Schema on Write for Government
Lesson 5 - SQL for Data Analytics in Government:
- Windowing Function
- Lateral Joins
- Lead & Lag
Lesson 6 - HiveQL for Government:
- SQL Support for Government
- External and Internal Tables for Government
- Joins for Government
- Partitions for Government
- Correlated Subqueries for Government
- Nested Queries for Government
- When to Use Hive for Government
Lesson 7 - Redshift for Government:
- Design and Structure for Government
- Locks and Shared Resources for Government
- Differences from Postgres for Government
- When to Use Redshift for Government
Requirements
- An understanding of databases for government operations
- Experience with SQL is beneficial
Audience
- Business Analysts
- Software Developers
- Database Developers
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.
