Become a Data Engineering Star
📖 Background
If you are working towards a career as a Data Engineer a DataCamp certification is a great way to show you are developing the data management skills you will need. You will be able to demonstrate to employers that you have built the SQL skills that will be the foundation to your future career.
🎓 Step 1: Get Certified!
you can view my certificate from here
📝 Step 2: Explain your choice of metrics
Data Modeling
Data modeling is organizing and structuring data in a form that will be easily accessible to systems. There are three data models:
- The Conceptual Data Model is an overview of what the system will contain, along with an organization of essential entities and their relationships.
- Logical Data Models add more detail by specifying data types and relationships without considering technical requirements.
- Physical Data Models outline how data is stored in the database, including accurate details, like keys and properties of the database management system.
Star Schema
A star schema is a type of physical data model commonly used to store data in a database. Here is a brief overview:
Structure:
A star schema has a fact table in the center, surrounded by dimension tables. The fact table contains quantitative data, like sales amounts, while dimension tables have descriptive attributes such as dates, product details, and locations.
Example:
In a sales database, the "Sales" fact table might include (SalesID, DateID, ProductID, StoreID, and Amount). Dimension tables could be "Date" (DateID, Year, Month, Day), "Product" (ProductID, ProductName, Category), and "Store" (StoreID, Name, StoreLocation).
Use Case:
It simplifies complex queries and boosts performance in data analysis, making it easy to generate reports and insights quickly. Its simplicity and efficiency in querying large datasets make it popular for analytical purposes.