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,
CLICK HERE

You May Also Be Interested In

Building a Reproducible Model Workflow
Building a Reproducible Model Workflow
View More
Cloud Computing for Business Leaders
Cloud Computing for Business Leaders
View More
Business Analytics
Business Analytics
View More

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.

CHECK OUT OTHER COURSES

GO
VIEW THE FULL COURSE LISTING
CET Course Search

We use cookies to offer you a better browsing experience. By continuing, you are agreeing to the use of cookies on your device as described in our privacy statement.

Accept