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.
The techniques and tools covered in The Nature of Data and Relational Database Design are most similar to the requirements found in Analista de datos data science job advertisements.
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
