Course Outline
Lesson 1 - SQL Fundamentals:
- Select statements
- Join types
- Indexes
- Views
- Subqueries
- Union operations
- Table creation
- Data loading techniques
- Data export (dumping)
- NoSQL overview
Lesson 2 - Data Modeling:
- Transaction-based ER systems
- Data warehousing concepts
- Data warehouse models
- Star schema
- Snowflake schemas
- Slowly changing dimensions (SCD)
- Structured vs. unstructured data
- Different table type storage engines:
- Column-based
- Document-based
- In-memory storage
Lesson 3 - Indexing in NoSQL and Data Science:
- Constraints (Primary keys)
- Index-based scanning methods
- Performance tuning strategies
Lesson 4 - NoSQL and Unstructured Data:
- Use cases for NoSQL databases
- Eventually consistent data models
- Scheme on read versus scheme on write approaches
Lesson 5 - SQL for Data Analytics:
- Windowing functions
- Lateral joins
- Lead and Lag functions
Lesson 6 - HiveQL:
- SQL support features
- External and internal tables
- Joins in Hive
- Partition management
- Correlated subqueries
- Nested queries
- When to utilize Hive
Lesson 7 - Redshift:
- Design principles and structure
- Locks and resource sharing
- Differences from Postgres
- When to choose Redshift
Requirements
- A foundational understanding of databases.
- Previous experience with SQL is advantageous.
Target Audience
- Business analysts
- Software developers
- Database developers
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
