Database Design and Operational Business Intelligence

Instructor: Edureka

Access provided by FutureX

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

8 hours to complete

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

8 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Understand the fundamentals of MS SQL Server and relational database design.
Create and manage functions, views, and database objects for real-world use cases.
Integrate and connect SQL Server with Power BI for reporting and analytics.
Apply learned skills to solve business intelligence challenges with hands-on scenarios.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

28 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 4 modules in this course

Learn how to design scalable databases and integrate them with Power BI for impactful business intelligence. This course on Database Design and Operational Business Intelligence is designed to help you master the principles of relational database design, normalization, and schema optimization. You'll gain hands-on experience managing complex datasets and structuring databases that align with real-world business needs.

Throughout this course, you'll delve into how Power BI and MS SQL Server are applied within specific industries. By the end of this course, you will be able to: 1. Compose different data models by re-structuring the data 2. Interpreting Data models 3. Create dashboards and Publish them on Service 4. Demonstrate machine learning and advanced features in Power BI Service 5. Analyze the scorecard and results from the binary prediction model 6. Implement best practices for visualization This long course is designed for Data Analyst, Data Engineer, Data Administrator, and Business Analyst seeking to enhance their analytical and design skills. Prior experience with MS Excel and RDBMS is beneficial but not mandatory for this course. Join us on this journey to enhance your Power BI and MS SQL Server skills and elevate your analytical and design capabilities.

Welcome to Database Design and Operational Business Intelligence. In this module, we will understand the capabilities of MS SQL Server. Learn to model data with the help of ER diagrams to get a holistic view of the database that is to be designed in MS SQL Server. Improve data integrity by reducing redundancy while ensuring efficient database management by handling data with the help of SQL commands.

What's included

32 videos6 readings11 assignments6 discussion prompts

32 videos Total 112 minutes

Course Introduction 3 minutes
What is SQL 3 minutes
Introduction to MS SQL Server 6 minutes
Installation of MS SQL Server 3 minutes
MS SQL Server Interface - I 7 minutes
MS SQL Server Interface - II 5 minutes
Data Modeling: ER Diagram - I 3 minutes
Data Modeling: ER Diagram - II 3 minutes
Cardinality in ER Diagram 3 minutes
Degree of Relationships 3 minutes
Relationships in Database Modeling 5 minutes
Complexity of Entity Relationships 3 minutes
Operation on Keys 4 minutes
Normalization 3 minutes
Types of Normalization 1 NF 2 minutes
Types of Normalization 2 NF 1 minute
Types of Normalization 3 NF 2 minutes
Types of Normalization 4 NF 1 minute
Types of Normalization 5 NF 4 minutes
DDL Commands 4 minutes
DQL Commands 4 minutes
DML Commands 2 minutes
DCL Commands 5 minutes
TCL Comands 4 minutes
Merge Statement 4 minutes
Alter Statement 3 minutes
Join Part-I 5 minutes
Join Part-II 2 minutes
Join Part-III 4 minutes
Join Part-IV 5 minutes
Join Part-V 3 minutes
Summary of MS SQL Server 2 minutes

6 readings Total 12 minutes

Welcome to Database Design and Operational Business Intelligence 2 minutes
Introduction to Microsoft SQL Server 2 minutes
ER Modeling Sessions in Database Design 2 minutes
Understanding Database Keys and Normalization 2 minutes
SQL Commands and Statements 2 minutes
Understanding Joins in Databases 2 minutes

11 assignments Total 55 minutes

MS SQL Server 2 minutes
ER Modeling in MS SQL Server 2 minutes
Data Normalization 2 minutes
SQL Commands 2 minutes
Joins in Database 2 minutes
End Lesson Quiz: MS SQL Server 5 minutes
End Lesson Quiz: ER Modeling in MS SQL Server 5 minutes
End Lesson Quiz: Data Normalization 5 minutes
End Lesson Quiz: SQL Commands 5 minutes
End Lesson Quiz: Joins in Database 5 minutes
End Module Quiz: MS-SQL Server 20 minutes

6 discussion prompts Total 12 minutes

Components of SQL 2 minutes
Introduce Yourself 2 minutes
ER modeling Approaches 2 minutes
Normalize Database 2 minutes
Aggregate functions 2 minutes
Join Performance 2 minutes

In the second week of this course, Learn to use built-in functions in SQL Server to simplify functions that can be used for faster data processing. Harnessing the abilities of T-SQL to interact with and manage relational databases in various ways.

What's included

18 videos4 readings9 assignments2 discussion prompts

18 videos Total 56 minutes

What is T-SQL? 3 minutes
Aggregate Functions 2 minutes
Convenient Aggregate Functions MAX() and AVG() 3 minutes
Convenient Aggregate Functions MIN() and SUM() 2 minutes
Statistical Aggregate Functions 3 minutes
User Defined Aggregate Functions 2 minutes
Convenient Aggregate Functions – COUNT() and COUNT_BIG() 2 minutes
Querying using Built-in Functions 5 minutes
Composing T-SQL 4 minutes
Introduction to Sub-Queries 4 minutes
SQL Server Views - I 2 minutes
SQL Server Views - II 3 minutes
Case Expressions 2 minutes
Stored Procedures 2 minutes
Operating Views 8 minutes
Implementing Stored Procedures 3 minutes
Executing Stored Procedures 4 minutes
Summary of Working with Advanced SQL 1 minute

4 readings Total 8 minutes

Exploring Built-in Functions and T-SQL 2 minutes
Understanding SQL Commands 2 minutes
Understanding Queries and Views in Databases 2 minutes
Exploring Views and Subqueries in Databases 2 minutes

9 assignments Total 48 minutes

Built-in Functions and T-SQL 2 minutes
Composing T-SQL 2 minutes
Queries and Views 2 minutes
Views and Subqueries 2 minutes
End Lesson Quiz: Built-in Functions and T-SQL 5 minutes
End Lesson Quiz: Composing T-SQL 5 minutes
End Lesson Quiz: Queries and Views 5 minutes
End Lesson Quiz: Views and Subqueries 5 minutes
End Module Quiz: Functions and Views 20 minutes

2 discussion prompts Total 4 minutes

Creative Approaches 2 minutes
Conditional Logic 2 minutes

In the third week of this course, Apply concepts of data management to prepare a dataset which is suitable for data visualization. Establish a stable connection with Power BI to transfer data from MS SQL Server to Power BI and visualize the data to display hidden insights.

What's included

16 videos3 readings7 assignments3 discussion prompts

16 videos Total 52 minutes

Applications of Power BI 3 minutes
Working with Power BI 5 minutes
Installation of Power BI Desktop and Service 6 minutes
Creating Database 4 minutes
Building Tables 1 minute
Inserting Data 1 minute
Connecting to Power BI 5 minutes
Creating Reports 2 minutes
Publishing Reports 2 minutes
Managing Gateways 2 minutes
Refresh gateway 4 minutes
Phases for Optimal Visuals 6 minutes
Chart Types and Elements 3 minutes
Common Refining Techniques 4 minutes
Visual Perception of Variation 3 minutes
Summary of Data Connectivity with Power BI 1 minute

3 readings Total 6 minutes

Features of Power BI 2 minutes
Understanding Data Preprocessing 2 minutes
Exploring the Data 2 minutes

7 assignments Total 41 minutes

Introduction to Power BI 2 minutes
Data Preprocessing 2 minutes
Exploring the Data 2 minutes
End Lesson Quiz: Introduction to Power BI 5 minutes
End Lesson Quiz: Data Preprocessing 5 minutes
End Lesson Quiz: Best Practices for Visualization 5 minutes
End Module Quiz: Data Connectivity-Power BI 20 minutes

3 discussion prompts Total 6 minutes

Connecting to Data Sources 2 minutes
Categorical Variables 2 minutes
Exploratory Data 2 minutes

This module is designed to assess an individual on the various concepts and teachings covered in this course. Answer a comprehensive quiz which marks you as a learner who is confident in working with Power BI.