Management of Relational and Non-Relational Databases

Duration 1 Month

Certificate TP Certificate

Course Overview

Databases need to be structured properly to enable efficient and effective querying and analysis of data. Build normalised, consistent, and performant relational data models. Use SQL Database Definition Language (DDL) to create the data schemas designed in Postgres and apply SQL Database Manipulation Language (DML) to migrate data from a denormalized schema to a normalised one. Understand the tradeoffs between relational databases and their non-relational counterparts, and justify which one is best for different scenarios. With a radical shift in paradigms, learn about MongoDB and Redis to get an understanding of the differences in behaviours and requirements for non-relational databases.

Entry Requirements

To be successful in this programme, learners should have knowledge of basic SQL.

Important: Self-assessment test for this Advanced Online Course

Click here: Management of Relational and Non-relational Databases

If you fail this self-assessment test and still apply for the course, your learning will likely be difficult, and you may not complete or pass the project & course. Re-taking of the test is allowed.

Who Should Attend

This 100% e-learning course is relevant to professionals looking to advance their skills in the roles of Database administrator, Database Engineer, etc..

What You'll Learn

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.

For more information on course fee / schedule, or to apply,

CLICK HERE

Course Contact

knowitgetit@tp.edu.sg
67881212
Monday - Thursday: 8:30am - 6:00pm
Friday: 8:30am - 5:30pm

Closed during lunchtime, 12:00pm - 1:00pm
and on weekends and public holidays.
https://www.tp.edu.sg/knowitgetit
Temasek SkillsFuture Academy (TSA)

Temasek Polytechnic

East Wing Block 1A, Level 3, Unit 109

21 Tampines Avenue 1,

Singapore 529757

Temasek Polytechnic reserves the right to alter the course, modify the scale of fee, amend any other information or cancel course with low enrolment.

CHECK OUT OTHER COURSES

VIEW THE FULL COURSE LISTING