Design & Optimize SQL Database Schemas
Most database schemas start simple, but as data grows and queries become complex, performance bottlenecks emerge. What separates skilled data engineers from the rest is the ability to architect schemas that scale. This Short Course was created to help data engineers and database professionals accomplish advanced schema design and optimization that directly impacts query performance and system scalability. By completing this course, you'll be able to implement DDL partitioning and clustering strategies, make informed decisions about when to denormalize for performance gains, and create profes
Skills you'll learn
We may earn a commission if you enroll through our links — it never affects the price you pay.
Similar courses
Stop Procrastination - Avoid Self Sabotage With Good Habits
Identify the root cause of your procrastination, fix it, overcome procrastination with healthier habits, and make yourself more productive for the rest of your career! In this course, you will examine procrastination from a number of different perspectives, and explain how to reverse it. You will be introduced to a number of different reasons why you may be procrastinating so that you can identify why you are doing, and what psychological barriers you may be facing. Once you get help identifying the psychological causes for your procrastinating, you will be shown how to reverse your procrast
All levels
Data Cleaning, Transformation, and Manipulation
In Data Cleaning, Transformation, and Manipulation, you’ll learn to turn messy data into analysis- and modeling-ready datasets using Python (pandas) and SQL. This is a skill-based path organized around real workplace tasks. Each module mirrors responsibilities you see in job descriptions and focuses on the exact steps you’ll perform on the job. You’ll begin with a quick skills check, then personalize your journey: double down on new topics, or skip what you already know. For each skill, you’ll review concise lessons curated from expert instructors with explanations and demos for filtering and
All levels
Data Engineering with Delta Lake on Databricks
Build production-ready data pipelines using Delta Live Tables and the Medallion Architecture on Databricks. This hands-on course teaches you to design, implement, and monitor ETL workflows that transform raw data into reliable, business-ready datasets through a structured bronze-silver-gold layering pattern. This course is primarily aimed at first- and second-year undergraduates interested in engineering or science, along with professionals with an interest in programming. You will start by mastering DLT fundamentals — declarative pipeline syntax in both SQL and Python, streaming ingestion w
All levels
AWS: Database
AWS: Databases Course is the fourth course of Exam Prep DVA-C02: AWS Certified Developer Associate Specialization. This course assists learners in learning the core concepts of NoSQL, contrasting it with traditional SQL databases. It covers key aspects of DynamoDB, including compute capacity, read consistency, transactions, and streams. The course also explores other NoSQL options like Amazon MemoryDB for Redis, covering cluster setup, data loading, and its comparison with ElastiCache for Redis. Finally, it provides an overview of Amazon RDS, a managed relational database service. This cours
All levels