DATA AND BACK-END DEVELOPMENT
About This Course
At the end of the course, learners will be able to:
- Identify the data types in Postgresql and their storage requirements
- Draft an entity-relationship (schema) diagrams
- Create primary keys, foreign keys and not-null constraints to maintain, store and retrieve data from databases
- Apply the 6-step data modelling process to identify entities and relationships to create database models
- Describe the data warehouse process and its schemas - star and snowflake.)
- Create a data warehouse from at least 3 data sources and perform aggregation queries against it
What You'll Learn
Entry Requirements
Academic Requirement
- 3 GCE O level subjects (including English) with a pass (i.e. C6
and above) or equivalent
- Completion of General Assembly's Course - FULL-STACK DEVELOPMENT
Language Proficiency
- GCE O Level English with a pass (i.e. C6 of above) or
- Workplace Literacy & Numeracy (WPLN) Level 5