Course Objectives
- Describe the bases of data modeling
- Describe the use of relational databases with SQL applications
- To understand the need and existing technology of NoSQL database models
- Provide information on how to create value from data existing in an enterprise
Topics
- Introduction to data, data base and other basic concepts
- History of database systems and introduction to relational databases
- Relational data models and data modelling
- Basic SQL (Structured Query Language)
- Advanced SQL: view, trigger, stored procedure
- Introduction to data warehouse and ETL (Extract, Transform, Load)
- Introduction to NoSQL and positioning NoSQL databases in organization
- NoSQL data base models
- Use cases of NoSQL with applications
- Reporting and data visualization
- Analysis of real-world applications
