Welcome to Bussma
All you need is an idea. We handle the rest.
All you need is an idea. We handle the rest.
The course provides a comprehensive and advanced overview of database systems, blending both theoretical foundations and practical applications. It begins by introducing the importance of databases as a solution to traditional file-based systems, highlighting the role of DBMS in organizing, storing, and retrieving data consistently. The course then delves into data modeling, covering Entity-Relationship Diagrams (ERDs) and Enhanced ERDs (EERDs), explaining key concepts like entities, attributes, relationships, supertypes and subtypes, generalization, specialization, disjoint and overlapping constraints, with real-world examples such as university systems and sports leagues. It guides students through converting ERDs into relational databases using keys (primary, foreign, composite) and different relationship types (1:1, 1:M, M:N). It then teaches normalization up to the Boyce-Codd Normal Form (BCNF), addressing data redundancy and anomalies (insertion, deletion, update). The course expands into enterprise-level data modeling, introducing enterprise data models, functional decomposition, and two main system development approaches: SDLC and prototyping. It also highlights roles of key personnel like analysts, data modelers, and DB engineers. Advanced topics include Data Warehousing: understanding OLAP vs. OLTP, ETL processes, fact and dimension tables, star/snowflake/galaxy schemas, and data marts. Finally, the course addresses ethical data practices such as privacy, transparency, consent, non-discrimination, and secure data handling through data governance, quality management, and data catalogs. In short, the course equips learners with the skills to design, implement, and ethically manage powerful, scalable, and trustworthy data systems.
Tasneem Alboqary
Data Management consultant and Teaching Assistant
The course provides a comprehensive and advanced overview of database systems, blending both theoretical foundations and practical applications. It begins by introducing the importance of databases as a solution to traditional file-based systems, highlighting the role of DBMS in organizing, storing, and retrieving data consistently. The course then delves into data modeling, covering Entity-Relationship Diagrams (ERDs) and Enhanced ERDs (EERDs), explaining key concepts like entities, attributes, relationships, supertypes and subtypes, generalization, specialization, disjoint and overlapping constraints, with real-world examples such as university systems and sports leagues. It guides students through converting ERDs into relational databases using keys (primary, foreign, composite) and different relationship types (1:1, 1:M, M:N). It then teaches normalization up to the Boyce-Codd Normal Form (BCNF), addressing data redundancy and anomalies (insertion, deletion, update). The course expands into enterprise-level data modeling, introducing enterprise data models, functional decomposition, and two main system development approaches: SDLC and prototyping. It also highlights roles of key personnel like analysts, data modelers, and DB engineers. Advanced topics include Data Warehousing: understanding OLAP vs. OLTP, ETL processes, fact and dimension tables, star/snowflake/galaxy schemas, and data marts. Finally, the course addresses ethical data practices such as privacy, transparency, consent, non-discrimination, and secure data handling through data governance, quality management, and data catalogs. In short, the course equips learners with the skills to design, implement, and ethically manage powerful, scalable, and trustworthy data systems.
Lessons
9
Duration
4 Hours
Skill Level
Entry level
Views
10k
Data Management consultant and Teaching Assistant
I am a 2024 graduate from the Faculty of Computing and Data Science at Alexandria University, holding a GPA of 3.9 and ranking third in my class. I currently serve as a teaching assistant at my university. In addition, I have over two and a half years of industry experience at Bussma , specializing in data management and business intelligence. My technical expertise includes working with SSIS, SSAS, SSMS, Power BI, and SQL, with a strong focus on BI analysis and data-driven decision-making.
Students
Courses