English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 24m | 326 MB
Learn how to design, implement, and optimize databases using SQL and ETL processes. Review the nuances of database needs and planning, and then conceptualize a music database, identify requirements, and create initial conceptual models. Explore normalization techniques, designing data pipelines, and applying advanced error handling strategies. Practice writing a range of SQL queries from basic to complex, and optimizing these queries for performance and efficiency. Join Walter Shields in this advanced course that features hands-on projects so you can design your own database. This course is ideal for DBAs, data engineers, and any IT professional eager to master database management.
Table of Contents
Introduction
1 Advanced SQL project intro
2 What you should know
3 Using the course exercise files
Module 1 Understanding Database Needs and Planning
4 Conceptualizing the music database
5 Identifying requirements and purpose
6 Brainstorming entities and relationships
7 Creating an initial conceptual model
Module 2 Implementing Database Design
8 Introduction to database normalization
9 Normalization forms
10 Applying normalization
11 Refine normalized schema
Module 3 Extract, Transform, Load (ETL) Basics
12 Overview of ETL processes and tools
13 ETL in the music database
Module 4 Loading Data into the Database
14 Understanding data pipelines
15 Building the data pipeline
16 Validation techniques
17 Advanced error handling and logging
Module 5 Writing Basic to Complex SQL Queries
18 Introduction to SQL queries (basic, aggregate, joins)
19 Exploring and analyzing music data
Module 6 Query Optimization and Large Dataset Management
20 Techniques for optimizing SQL queries
21 Handling and querying large datasets efficiently
Module 7 Bringing It All Together
22 Final project
23 Final project solution
Conclusion
24 Reflect on the knowledge and skills acquired
25 Career opportunities
26 Further learning resources and pathways
Resolve the captcha to access the links!