Назад в каталог
Курс от University of California, Irvine
courseraIT и технологии
The Nature of Data and Relational Database Design
Курс от University of California, IrvineО курсе
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.
Навыки, которые вы освоите
Relational DatabasesSQLDatabase DesignData ManipulationDescriptive StatisticsBusiness IntelligenceBusiness AnalyticsDecision Support SystemsMicrosoft ExcelExtract, Transform, LoadDatabase TheoryDatabase Architecture and AdministrationDatabase ManagementDatabase DevelopmentStatisticsStatistical ReportingData ProcessingDatabase Management SystemsStatistical AnalysisDatabase Systems
Программа курса
4 модулей · 26 учебных материалов
01Overview of Business Intelligence9 материалов
Учитесь у экспертов
Tim Carrington
Преподаватель курса