Perform analysis on data stored in relational and non-relational database systems to power strategic decision-making;
Build the supporting data structures for a social media news aggregator site;
Investigate the provided data model for potential errors such as lack of normalisation, consistency rules, and proper indexing.
Create a new, normalised database using DDL based on the denormalized one that is provided;
Write DML queries to migrate the data from the denormalized schema to their normalised schema.
You need to be familiar with the following for the course:
Familiarity with operating systems
Experience using spreadsheet programmes (Excel, Google spreadsheets, etc)
Understanding data types (string, integer, char), etc.
Certification
Learners will be awarded the Advanced Course certification upon passing a project within the 1-month course duration.