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.
通过 Coursera Plus 提高技能,仅需 239 美元/年(原价 399 美元)。立即节省
推荐体验
推荐体验
中级
Prior working experience with MS Excel and RDBMS is beneficial but not mandatory for this course.
推荐体验
推荐体验
中级
Prior working experience with MS Excel and RDBMS is beneficial but not mandatory for this course.
您将学到什么
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.
要了解的详细信息

添加到您的领英档案
28 项作业
了解顶级公司的员工如何掌握热门技能

该课程共有4个模块
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.
涵盖的内容
32个视频6篇阅读材料11个作业6个讨论话题
32个视频•总计112分钟
- Course Introduction•3分钟
- What is SQL•3分钟
- Introduction to MS SQL Server•6分钟
- Installation of MS SQL Server•3分钟
- MS SQL Server Interface - I•7分钟
- MS SQL Server Interface - II•5分钟
- Data Modeling: ER Diagram - I•3分钟
- Data Modeling: ER Diagram - II•3分钟
- Cardinality in ER Diagram•3分钟
- Degree of Relationships•3分钟
- Relationships in Database Modeling•5分钟
- Complexity of Entity Relationships•3分钟
- Operation on Keys•4分钟
- Normalization•3分钟
- Types of Normalization 1 NF•2分钟
- Types of Normalization 2 NF•1分钟
- Types of Normalization 3 NF•2分钟
- Types of Normalization 4 NF•1分钟
- Types of Normalization 5 NF•4分钟
- DDL Commands•4分钟
- DQL Commands•4分钟
- DML Commands•2分钟
- DCL Commands•5分钟
- TCL Comands•4分钟
- Merge Statement•4分钟
- Alter Statement•3分钟
- Join Part-I•5分钟
- Join Part-II•2分钟
- Join Part-III•4分钟
- Join Part-IV•5分钟
- Join Part-V•3分钟
- Summary of MS SQL Server•2分钟
6篇阅读材料•总计12分钟
- Welcome to Database Design and Operational Business Intelligence•2分钟
- Introduction to Microsoft SQL Server•2分钟
- ER Modeling Sessions in Database Design•2分钟
- Understanding Database Keys and Normalization•2分钟
- SQL Commands and Statements•2分钟
- Understanding Joins in Databases•2分钟
11个作业•总计55分钟
- End Lesson Quiz: MS SQL Server•5分钟
- End Lesson Quiz: ER Modeling in MS SQL Server•5分钟
- End Lesson Quiz: Data Normalization•5分钟
- End Lesson Quiz: SQL Commands•5分钟
- End Lesson Quiz: Joins in Database•5分钟
- End Module Quiz: MS-SQL Server•20分钟
- MS SQL Server•2分钟
- ER Modeling in MS SQL Server•2分钟
- Data Normalization•2分钟
- SQL Commands•2分钟
- Joins in Database•2分钟
6个讨论话题•总计12分钟
- Components of SQL•2分钟
- Introduce Yourself•2分钟
- ER modeling Approaches•2分钟
- Normalize Database•2分钟
- Aggregate functions•2分钟
- Join Performance•2分钟
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.
涵盖的内容
18个视频4篇阅读材料9个作业2个讨论话题
18个视频•总计56分钟
- What is T-SQL?•3分钟
- Aggregate Functions•2分钟
- Convenient Aggregate Functions MAX() and AVG()•3分钟
- Convenient Aggregate Functions MIN() and SUM()•2分钟
- Statistical Aggregate Functions•3分钟
- User Defined Aggregate Functions•2分钟
- Convenient Aggregate Functions – COUNT() and COUNT_BIG()•2分钟
- Querying using Built-in Functions•5分钟
- Composing T-SQL•4分钟
- Introduction to Sub-Queries•4分钟
- SQL Server Views - I•2分钟
- SQL Server Views - II•3分钟
- Case Expressions•2分钟
- Stored Procedures•2分钟
- Operating Views•8分钟
- Implementing Stored Procedures•3分钟
- Executing Stored Procedures•4分钟
- Summary of Working with Advanced SQL•1分钟
4篇阅读材料•总计8分钟
- Exploring Built-in Functions and T-SQL•2分钟
- Understanding SQL Commands•2分钟
- Understanding Queries and Views in Databases•2分钟
- Exploring Views and Subqueries in Databases•2分钟
9个作业•总计48分钟
- End Lesson Quiz: Built-in Functions and T-SQL•5分钟
- End Lesson Quiz: Composing T-SQL•5分钟
- End Lesson Quiz: Queries and Views•5分钟
- End Lesson Quiz: Views and Subqueries•5分钟
- End Module Quiz: Functions and Views•20分钟
- Built-in Functions and T-SQL•2分钟
- Composing T-SQL•2分钟
- Queries and Views•2分钟
- Views and Subqueries•2分钟
2个讨论话题•总计4分钟
- Creative Approaches•2分钟
- Conditional Logic•2分钟
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.
涵盖的内容
16个视频3篇阅读材料7个作业3个讨论话题
16个视频•总计52分钟
- Applications of Power BI•3分钟
- Working with Power BI•5分钟
- Installation of Power BI Desktop and Service•6分钟
- Creating Database•4分钟
- Building Tables•1分钟
- Inserting Data•1分钟
- Connecting to Power BI•5分钟
- Creating Reports•2分钟
- Publishing Reports•2分钟
- Managing Gateways•2分钟
- Refresh gateway•4分钟
- Phases for Optimal Visuals•6分钟
- Chart Types and Elements•3分钟
- Common Refining Techniques•4分钟
- Visual Perception of Variation•3分钟
- Summary of Data Connectivity with Power BI•1分钟
3篇阅读材料•总计6分钟
- Features of Power BI•2分钟
- Understanding Data Preprocessing•2分钟
- Exploring the Data•2分钟
7个作业•总计41分钟
- End Lesson Quiz: Introduction to Power BI•5分钟
- End Lesson Quiz: Data Preprocessing•5分钟
- End Lesson Quiz: Best Practices for Visualization•5分钟
- End Module Quiz: Data Connectivity-Power BI•20分钟
- Introduction to Power BI•2分钟
- Data Preprocessing•2分钟
- Exploring the Data•2分钟
3个讨论话题•总计6分钟
- Connecting to Data Sources•2分钟
- Categorical Variables•2分钟
- Exploratory Data•2分钟
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.
涵盖的内容
1个视频1篇阅读材料1个作业1个讨论话题
1个视频•总计2分钟
- Database Design and Operational Business Intelligence Course Summary•2分钟
1篇阅读材料•总计20分钟
- Incident Tracking Report•20分钟
1个作业•总计20分钟
- End Course Knowledge Check: Database Design and Operational Business Intelligence•20分钟
1个讨论话题•总计10分钟
- Describe Your Learning Journey•10分钟
位教师

提供方

提供方

Edureka is an online education platform focused on delivering high-quality learning to working professionals. We have the highest course completion rate in the industry and we strive to create an online ecosystem for our global learners to equip themselves with industry-relevant skills in today’s cutting edge technologies.
从 Data Analysis 浏览更多内容
状态:免费试用免费试用UUniversity of California, Irvine
专项课程
状态:免费试用免费试用
状态:预览预览SSimplilearn
课程
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
常见问题
The Database Design and Operational Business Intelligence course offers comprehensive insights into the full potential of your data analytics with Power BI connection with MS SQL Server. This course is designed to empower learners with the knowledge and skills needed to seamlessly integrate Power BI with Microsoft SQL Server, enabling efficient data visualization and analysis.
This course caters to a diverse audience, embracing those new to the field as Freshers. Database Administrators will enhance their skills in database management, while BI Developers will gain insights into seamless database integration and visualization. Business Analysts will learn to design and maintain databases for creating paginated reports and dashboards.
Prior working experience with MS Excel and RDBMS (Relational Database Management Systems) is advantageous, offering a valuable foundation for this course. However, it is important to note that possessing proficiency in these tools is not obligatory.
This course emphasizes the seamless integration with Microsoft SQL Server, encompassing skills for proficient data analytics. Commencing with foundational SQL Server principles, the course rapidly advances into advanced topics such as data visualization, analysis, and modeling. Learners will acquire the expertise required to navigate the integrated relationship between Power BI and SQL Server, thereby enhancing their data analytics and reporting capabilities.
This course is designed to span approximately four weeks each week comprising of roughly 4 hours each, encompassing a diverse range of learning materials and activities. Throughout this course, learners will engage with various educational resources, including video content on the Power BI with Microsoft SQL Server, reading materials to deepen understanding, graded quizzes to assess comprehension, and thought-provoking discussion prompts to encourage collaborative learning and critical thinking.
Yes, you will need a Power BI Pro subscription for this course. You can obtain a 60-day trial of Power BI Pro using an onmicrosoft account. This subscription is essential for accessing advanced features, collaborative tools, and sharing reports.
The SQL Server Developer edition from Microsoft is freely available for development and testing purposes. While offering the same features and capabilities as the Enterprise edition, it is licensed exclusively for use in development and testing environments.
Microsoft SQL Server excels in Power BI applications by providing robust data management capabilities that ensure efficient storage and retrieval. It supports complex queries, enhances processing speed, and optimizes Power BI dashboards and reports, delivering a seamless and high-performance data analytics experience.
Yes, you’ll practice connecting MS SQL Server to Power BI and building reports step by step.
Yes, the course introduces SQL Server from the ground up, making it suitable for beginners.
Yes, learners will receive a certificate upon successfully completing the course.
You’ll gain practical skills to design databases, integrate data with BI tools, and support data-driven decision-making in business roles.
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
更多问题
提供助学金,



