Jump to Section

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,

You May Also Be Interested In

Course Contact

  • 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.