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.Lee mas.
Este recurso es ofrecido por un socio afiliado. Si paga por la capacitación, podemos ganar una comisión para respaldar este sitio.
Las técnicas y herramientas cubiertas en The Nature of Data and Relational Database Design son muy similares a los requisitos que se encuentran en los anuncios de trabajo de Analista de datos.
The Nature of Data and Relational Database Design is a part of uno structured learning path.
3 Courses
3 Months
Database Design and Operational Business Intelligence
