Professional Development · IT & Digital
Advanced SQL — Performance and Design
A professional-level course covering relational database design, query optimisation, advanced SQL features, database objects, and analytical querying. Designed for practitioners who already know basic SQL and want to master performance tuning, schema design, and enterprise-grade patterns.
15 Lektionen
15 Karteikarten-Decks
15 Quizze
Lehrplan
Database Design and Performance
Advanced Querying Techniques
Window Functions: RANK, ROW_NUMBER, DENSE_RANK1 Decks1 QuizLAG, LEAD, and Running Totals with Window Functions1 Decks1 QuizCommon Table Expressions (CTEs)1 Decks1 QuizRecursive CTEs: Hierarchical Data1 Decks1 QuizTransactions: ACID Properties and Isolation Levels1 Decks1 QuizStored Procedures and Functions1 Decks1 Quiz
Database Objects, Architecture, and Analytics
Triggers: Automating Database Actions1 Decks1 QuizViews: Simplifying Complex Queries1 Decks1 QuizMaterialised Views and Caching Strategies1 Decks1 QuizDatabase Design Patterns: Star Schema, Snowflake1 Decks1 QuizIntroduction to NoSQL: Document, Key-Value, Graph1 Decks1 QuizSQL for Analytics: Building Reporting Queries1 Decks1 Quiz
Jetzt Advanced SQL — Performance and Design lernen
Alle 15 Lektionen mit Karteikarten, Quizzen und KI-Lernhilfen. 7 Tage kostenlos.
Kostenlos testen