This course provides a comprehensive overview of data, various data types, design of databases for storage of data, and creation and manipulation of data in databases using SQL. By the end of this course, students will be able to describe what business intelligence is and how it’s different from business analytics and data science, conduct a basic descriptive statistical analysis and articulate the findings, and differentiate between types of statistics. They will also be able to define normalization and ETL, create an ERD that shows progression from conceptual to logical to physical design, define DDL, DML, DCL, and TCL, and write SQL scripts to create a database and associated tables.
Этот курс входит в специализацию ''Специализация Database Design and Operational Business Intelligence'
1 914 уже зарегистрированы
от партнера
Специализация Database Design and Operational Business IntelligenceКалифорнийский университет в ИрвайнеОб этом курсе
Недавно просмотрено: 5 248
Гибкие сроки
Назначьте сроки сдачи в соответствии со своим графиком.
Сертификат, ссылками на который можно делиться с другими людьми
Получите сертификат по завершении
100% онлайн
Начните сейчас и учитесь по собственному графику.
Курс 1 из 3 в программе
Начальный уровень
No experience in BI or database needed. Experience with at least one programming language is recommended.
Прибл. 7 часов на выполнение
Английский
Субтитры: Английский
Чему вы научитесь
Create an ERD that shows progression from conceptual to logical to physical design
Conduct a basic descriptive statistical analysis and articulate the findings
Write SQL scripts to create a database and associated tables
Приобретаемые навыки
- SQL Overview
- Statistical Analysis
- Relational Database
- Business Intelligence
- Basic Descriptive Statistics
Гибкие сроки
Назначьте сроки сдачи в соответствии со своим графиком.
Сертификат, ссылками на который можно делиться с другими людьми
Получите сертификат по завершении
100% онлайн
Начните сейчас и учитесь по собственному графику.
Курс 1 из 3 в программе
Начальный уровень
No experience in BI or database needed. Experience with at least one programming language is recommended.
Прибл. 7 часов на выполнение
Английский
Субтитры: Английский
от партнера
Калифорнийский университет в Ирвайне
Since 1965, the University of California, Irvine has combined the strengths of a major research university with the bounty of an incomparable Southern California location. UCI’s unyielding commitment to rigorous academics, cutting-edge research, and leadership and character development makes the campus a driving force for innovation and discovery that serves our local, national and global communities in many ways.
Программа курса: что вы изучите
2 ч. на завершение
Overview of Business Intelligence
Welcome to Module 1: Overview of Business Intelligence! In our first module, we will define business intelligence and differentiate it from business analytics and data science. We will also overview decision support systems and practice working with them through our activity. Finally, we will differentiate between OTLP and OLAP as well as identify the goals of business intelligence through a short quiz.
2 ч. на завершение
7 материалов для самостоятельного изучения
2 ч. на завершение
Nature of Data & Descriptive Statistics
Welcome to Module 2: Nature of Data & Descriptive Statistics. In this module, we will dive into the types of data, the process of data preparation and descriptive and inferential statistics. We will differentiate between descriptive and inferential statistics as well as structured and unstructured data with a short quiz. Finally, we will use Microsoft Excel Data Analysis Toolpak to conduct a basic descriptive statistical analysis and share our findings.
2 ч. на завершение
1 видео ((всего 7 мин.)), 4 материалов для самостоятельного изучения, 1 тест
2 ч. на завершение
Module 3: Relational Database Design (ERD and Normalization)
Welcome to Module 3: Relational Database Design (ERD and Normalization). In this module, we will define relational databases and overview the process of designing databases. We will differentiate between conceptual, logical and physical design with a short quiz. In addition, we will create an ERD that shows progression from conceptual to logical to physical design through our activity.
2 ч. на завершение
4 материалов для самостоятельного изучения
2 ч. на завершение
Module 4: Structured Query Language (SQL) Overview
Welcome Module 4: Structured Query Language (SQL) Overview. In our final module, we will overview SQL as well as define Data Definition Language (DDL) and Data Manipulation Language (DML). Through a short quiz, we will define DDL, DML, DCL, and TCL, as well as differentiate between varying MySQL keywords and data types. In our final activity, we will write SQL scripts to create a database and some associated tables. We will then extract and articulate useful information from the data that we can share with fellow students.
2 ч. на завершение
1 видео ((всего 20 мин.)), 1 материал для самостоятельного изучения, 1 тест
Рецензии
- 5 stars70,49 %
- 4 stars11,47 %
- 3 stars8,19 %
- 2 stars4,91 %
- 1 star4,91 %
Лучшие отзывы о курсе THE NATURE OF DATA AND RELATIONAL DATABASE DESIGN
от партнера DB11 февр. 2022 г.
The topics are very interesting and I really want to use the things that I have learned from here.
Специализация Database Design and Operational Business Intelligence: общие сведения
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.
Часто задаваемые вопросы
Когда я получу доступ к лекциям и заданиям?
Что я получу, оформив подписку на специализацию?
Можно ли получить финансовую помощь?
Остались вопросы? Посетите Центр поддержки учащихся.
