Edureka
Database Design and Operational Business Intelligence
Edureka

Database Design and Operational Business Intelligence

Taught in English

Course

Gain insight into a topic and learn the fundamentals

Edureka

Instructor: Edureka

Intermediate level

Recommended experience

7 hours to complete
3 weeks at 2 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Working with MS SQL Server and data connectivity with Power BI to visualize datasets.

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

March 2024

Assessments

28 assignments

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

Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 4 modules in this course

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

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

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

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.

What's included

1 video1 reading1 assignment1 discussion prompt

Instructor

Edureka
Edureka
36 Courses11,336 learners

Offered by

Edureka

Recommended if you're interested in Data Analysis

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

New to Data Analysis? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions