datamodel.com
Unknown
Datamodel.com is a resource hub for data modeling, offering tutorials, articles, and practical examples on database design, data architecture, and modeling techniques.
More resources on Data Modeling
vertabelo.com
Vertabelo is an online data modeling and database design platform that lets you create and visualize ER diagrams, design schemas, and generate SQL code. It also offers tutorials, articles, and resources on database design best practices for learners and professionals.
Understand Star Schema and the Importance for Power BI
Microsoft guidance on shaping Power BI semantic models as star schemas with fact and dimension tables. Covers surrogate keys, snowflaking, role-playing, slowly changing, junk and degenerate dimensions, and factless fact tables for many-to-many relationships, so models perform well and totals stay correct.
Data Modeling Essentials
Graeme Simsion and Graham Witt's widely used text on conceptual, logical and physical data modeling. Covers normalization, entity-relationship notation, business rules and quality criteria, so readers can design and critique relational models that reflect real business requirements.
The Data Model Resource Book
A library of reusable logical data models for functions common to most businesses, including parties, products, orders, shipments, invoicing, work efforts and accounting, plus matching data warehouse designs, so modelers can adapt proven patterns instead of starting from scratch.
SQLShack
Free article library started by ApexSQL, written by SQL Server professionals, covering T-SQL, indexing, query tuning, backup and recovery, high availability, auditing and SSIS. Readers can follow step-by-step examples to administer, secure and tune SQL Server instances.
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