Agile Data Warehouse Design
Lawrence Corr, Jim Stagnitto
Agile Data Warehouse Design - A book resource
This link may earn us a small commission at no extra cost to you. Affiliate disclosure
More resources on Data Modeling
Data Modeling Essentials
Data Modeling Essentials - A book resource
vertabelo.com
Vertabelo is an online data modeling and database design platform that provides a visual editor for creating ER diagrams and relational schemas. It offers tutorials, articles, and documentation on data modeling concepts, best practices, and SQL/DDL generation for various database systems.
datamodel.com
Datamodel.com is a resource hub for data modeling, offering tutorials, articles, and practical examples on database design, data architecture, and modeling techniques.
The Data Model Resource Book
The Data Model Resource Book - A book resource
Advanced Data Modeling
Develop a working knowledge and familiarity with advanced database concepts such as usage, modeling, automation, storage, optimization and administration. To take this course, you must have completed the previous Database courses. You must also be eager to continue your journey with coding. The Professional Certificates create opportunities so that anyone regardless of education, background or experience can learn high-quality skills to land a high-growth career—no degree or experience required to get started. By the end of this course, you’ll be able to: - Deploy basic data modeling skills and navigate modern storage options for a data warehouse - Apply planning and execution of ETL style database engineering by building upon existing MySQL skills - Develop a working knowledge of the different aspects of managing a database including administration of database operations and concerns, alongside processes and solutions for monitoring, reporting and debugging - Demonstrate data modeling skills within a real-world project environment You’ll gain experience with the following tools and software: - Workbench data modeling software - Syntaxes used to interact with a data warehouse - Extract, transform and loading (ETL) techniques and methods - MySQL data warehouse administration - Data warehouse monitoring and reporting tools - Database debugging and testing tools - Data modeling tools
sqlshack.com
SQLShack is a comprehensive resource for SQL Server professionals offering tutorials, tips, and best practices on SQL Server development, data modeling concepts, database design, and T-SQL querying.