The Nature of Data and Relational Database Design
Learn about data types, database design, and SQL manipulation in this comprehensive course. Gain skills in business intelligence, descriptive statistics, and database creation. Understand normalization, ERD design, and SQL scripting for database creation.
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.
