Monthly Subscription Starting at AED 99 + VAT

Database Design and Operational Business Intelligence
  • Level Foundation
  • Course by Edureka
  • Offered by

About

The goal of this specialization is to provide a comprehensive and holistic view of business intelligence and its enabling technologies, including relational databases, data warehousing, descriptive statistics, data mining, and visual analytics. Through this series of courses, you will explore relational database design, data manipulation through Extract/Transform/Load (ETL), gaining actionable insight through data analytics, data-based decision support, data visualization, and practical, hands-on experience with real-world business intelligence tools.

Modules

Overview of MS SQL Server

    • 8 Videos
    • 2 Readings
    • 2 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • MS SQL Server
  • End Lesson Quiz: MS SQL Server

2 Discussions

  • Components of SQL
  • Introduce Yourself

8 Videos

  • Course Introduction
  • What is SQL
  • Introduction to MS SQL Server
  • Installation of MS SQL Server
  • MS SQL Server Interface - I
  • MS SQL Server Interface - II
  • Data Modeling: ER Diagram - I
  • Data Modeling: ER Diagram - II

2 Readings

  • Welcome to Database Design and Operational Business Intelligence
  • Introduction to Microsoft SQL Server

ER Modeling in MS SQL Server

    • 4 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • ER Modeling in MS SQL Server
  • End Lesson Quiz: ER Modeling in MS SQL Server

1 Discussions

  • ER modeling Approaches

4 Videos

  • Cardinality in ER Diagram
  • Degree of Relationships
  • Relationships in Database Modeling
  • Complexity of Entity Relationships

1 Readings

  • ER Modeling Sessions in Database Design

Data Normalization

    • 7 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Data Normalization
  • End Lesson Quiz: Data Normalization

1 Discussions

  • Normalize Database

7 Videos

  • Operation on Keys
  • Normalization
  • Types of Normalization 1 NF
  • Types of Normalization 2 NF
  • Types of Normalization 3 NF
  • Types of Normalization 4 NF
  • Types of Normalization 5 NF

1 Readings

  • Understanding Database Keys and Normalization

SQL Commands

    • 7 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • SQL Commands
  • End Lesson Quiz: SQL Commands

1 Discussions

  • Aggregate functions

7 Videos

  • DDL Commands
  • DQL Commands
  • DML Commands
  • DCL Commands
  • TCL Comands
  • Merge Statement
  • Alter Statement

1 Readings

  • SQL Commands and Statements

Practice Session-Joins in Database

    • 5 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Joins in Database
  • End Lesson Quiz: Joins in Database

1 Discussions

  • Join Performance

5 Videos

  • Join Part-I
  • Join Part-II
  • Join Part-III
  • Join Part-IV
  • Join Part-V

1 Readings

  • Understanding Joins in Databases

Module Wrap-up & Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • End Module Quiz: MS-SQL Server

1 Videos

  • Summary of MS SQL Server

Built-in Functions and T-SQL

    • 7 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Built-in Functions and T-SQL
  • End Lesson Quiz: Built-in Functions and T-SQL

1 Discussions

  • Creative Approaches

7 Videos

  • What is T-SQL?
  • Aggregate Functions
  • Convenient Aggregate Functions MAX() and AVG()
  • Convenient Aggregate Functions MIN() and SUM()
  • Statistical Aggregate Functions
  • User Defined Aggregate Functions
  • Convenient Aggregate Functions – COUNT() and COUNT_BIG()

1 Readings

  • Exploring Built-in Functions and T-SQL

Practice Session - Functions

    • 2 Videos
    • 1 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Composing T-SQL
  • End Lesson Quiz: Composing T-SQL

2 Videos

  • Querying using Built-in Functions
  • Composing T-SQL

1 Readings

  • Understanding SQL Commands

Queries and Views

    • 5 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Queries and Views
  • End Lesson Quiz: Queries and Views

1 Discussions

  • Conditional Logic

5 Videos

  • Introduction to Sub-Queries
  • SQL Server Views - I
  • SQL Server Views - II
  • Case Expressions
  • Stored Procedures

1 Readings

  • Understanding Queries and Views in Databases

Practice Session - Views and Subqueries

    • 3 Videos
    • 1 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Views and Subqueries
  • End Lesson Quiz: Views and Subqueries

3 Videos

  • Operating Views
  • Implementing Stored Procedures
  • Executing Stored Procedures

1 Readings

  • Exploring Views and Subqueries in Databases

Module Wrap-up & Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • End Module Quiz: Functions and Views

1 Videos

  • Summary of Working with Advanced SQL

Introduction to Power BI

    • 3 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Introduction to Power BI
  • End Lesson Quiz: Introduction to Power BI

1 Discussions

  • Connecting to Data Sources

3 Videos

  • Applications of Power BI
  • Working with Power BI
  • Installation of Power BI Desktop and Service

1 Readings

  • Features of Power BI

Integrating Power BI with MS SQL Server

    • 8 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Data Preprocessing
  • End Lesson Quiz: Data Preprocessing

1 Discussions

  • Categorical Variables

8 Videos

  • Creating Database
  • Building Tables
  • Inserting Data
  • Connecting to Power BI
  • Creating Reports
  • Publishing Reports
  • Managing Gateways
  • Refresh gateway

1 Readings

  • Understanding Data Preprocessing

Best Practices for Visualization

    • 4 Videos
    • 1 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Exploring the Data
  • End Lesson Quiz: Best Practices for Visualization

1 Discussions

  • Exploratory Data

4 Videos

  • Phases for Optimal Visuals
  • Chart Types and Elements
  • Common Refining Techniques
  • Visual Perception of Variation

1 Readings

  • Exploring the Data

Module Wrap up & Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • End Module Quiz: Data Connectivity-Power BI

1 Videos

  • Summary of Data Connectivity with Power BI

Untitled Lesson

    • 1 Videos
    • 1 Readings
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • End Course Knowledge Check: Database Design and Operational Business Intelligence

1 Discussions

  • Describe Your Learning Journey

1 Videos

  • Database Design and Operational Business Intelligence Course Summary

1 Readings

  • Incident Tracking Report

Auto Summary

Embark on a transformative learning journey with the "Database Design and Operational Business Intelligence" course, an essential offering in the IT & Computer Science domain. This foundational course, brought to you by Coursera, provides a comprehensive exploration of business intelligence and the technologies that empower it. Dive deep into relational database design, data warehousing, descriptive statistics, and data mining. Learn the intricacies of data manipulation through Extract/Transform/Load (ETL) processes and master the art of visual analytics. Gain practical, hands-on experience with real-world business intelligence tools, equipping you with the skills to derive actionable insights and make data-driven decisions. Perfect for beginners and those looking to solidify their foundational knowledge, this course offers a holistic view of business intelligence, making it an ideal choice for aspiring data professionals and IT enthusiasts. Enroll with a Starter subscription and take the first step towards becoming proficient in the dynamic field of business intelligence.

Edureka
Instructor

Edureka