Persistence and Analytics Fundamentals

Overview

Storing and retrieving data is part and parcel of any applications. There are, however, a bewildering number of persistence mechanism with different properties and storage models.

The objective of this course is to demystify these persistence options and help make you make informed choices when selecting a persistence mechanism for your application.

In this course, we will learn how to select relational, document and key-value database, as well as discover their persistence properties.


Upcoming Classes

Class 1 25 Mar 2019 to 05 Apr 2019 (Full Time)

Duration: 10 days

When:
Mar:
25, 26, 27, 28, 29
Apr:
01, 02, 03, 04, 05
Time:
9:00am - 5:00pm

Class 2 24 Jun 2019 to 05 Jul 2019 (Full Time)

Duration: 10 days

Time:
09:00am to 05:00pm

Class 3 04 Nov 2019 to 15 Nov 2019 (Full Time)

Duration: 10 days

Time:
09:00am to 05:00pm

Class 4 16 Mar 2020 to 27 Mar 2020 (Full Time)

Duration: 10 days

Time:
09:00am to 05:00pm



Key Takeaways

  • Learn about SQL and NoSQL database and how it relates to the CAP theorem
  • Select relational, document and key-value database for your storage requirements
  • Define data models and relationship to which the models represent your data
  • Apply data normalisation to your data model, specifically, relational data model
  • Learn about queries and updates with respect to online transaction processing (OLTP) database and NoSQL databases



Who Should Attend

Application developers who need to select and use persistence for their applications

Requirements
  • Must have working knowledge of at least one server side web frameworks, like Express, Flask, Java EE, etc
  • Familiarity with HTML, CSS and JavaScript
  • Participants will be required to take an online assessment upon course enrolment

What to Bring
Please bring along your laptop during the training.
Specs: 8 GB RAM minimum
16 GB RAM recommended
64 GB storage 1280x1024 minimum screen resolution
Windows 10 or Later/Mac OSX 10.10 or Later (64-Bit OS Required)



What Will Be Covered

  • Relational and non-relational databases
  • Data Modelling
  • Key Relational Concepts
  • Transactions
  • Append-only Datastore
  • Storing Blob Data
  • Signed URLs



Fees & Funding

Self-sponsored

International Participants

S'poreans and PRs 
(aged 21 and above)

SkillsFuture Mid-Career Enhanced Subsidy1 
(S’poreans aged 40 and above)

Workfare Training Support2
(S’poreans aged 35 and above, and earn ≤ $2,000 per month)

Full course fee

S$2500

S$2500

S$2500

S$2500

SSG grant

-

(S$1750)

(S$1750)

(S$1750)

Nett course fee

S$2500

S$750

S$750

S$750

7% GST on nett course fee

S$175

S$52.50

S$52.50

S$52.50

Total nett course fee payable, including GST

S$2675

S$802.50

S$802.50

S$802.50

Less additional funding if eligible under various schemes

-

-

(S$500)

(S$625)

Total nett course fee payable, including GST, after additional funding from the various funding schemes

S$2675

S$802.50

S$302.50

S$177.50


Singaporeans aged 25 and above can use their SkillsFuture Credit to pay for course fees, apart from government subsidies. For more information, click here.

Company-sponsored

International Participants

S'poreans and PRs 
(aged 21 and above)

SkillsFuture Mid-Career Enhanced Subsidy1 
(S’poreans aged 40 and above)

Workfare Training Support2
(S’poreans aged 35 and above, and earn ≤ $2,000 per month)

Enhanced Training Support for SMEs3

Notes

Full course fee

S$2500

S$2500

S$2500

S$2500

S$2500

SSG grant

-

(S$1750)

(S$1750)

(S$1750)

(S$1750)

Nett course fee

S$2500

S$750

S$750

S$750

S$750

7% GST on nett course fee

S$175

S$52.50

S$52.50

S$52.50

S$52.50

Total nett course fee payable, including GST

S$2675

S$802.50

S$802.50

S$802.50

S$802.50

Fee payable to NUS-ISS

Less additional funding if eligible under various schemes#
(company needs to submit training grant and claim via Skillsconnect)

-

-

(S$500)

(S$625)

(S$500)

Total nett course fee payable, including GST, after additional funding from the various funding schemes

-

-

S$302.50

S$177.50

S$302.50

Actual financial outlay by company

Various Funding Schemes

1Mid-Career Enhanced Subsidy

  • Singaporeans aged 40 and above may enjoy subsidies up to 90% of the course fees.


2
Workfare Training Support (WTS)

  • Singaporeans aged 35 and above (13 years and above for Persons With Disabilities) and earn not more than $2,000 per month, may enjoy subsidies up to 95% of the course fees.


3
Enhanced Training Support for SMEs (ETSS)

  • SME-sponsored employees (Singaporean Citizens and PRs) may enjoy subsidies up to 90% of the course fees. For more details, click on Enhanced Training Support for SMEs.


Course attendee is eligible for only one funding scheme.

#For company-sponsored participants, companies would need to pay upfront 30% of the course fee to NUS-ISS and submit a training grant application for the remaining eligible subsidies, and subsequently a claim in Skillsconnect. For details, please refer to Skillsconnect guide 4.1 & 5.1.

This course is aligned to the National Infocomm Competency Framework (NICF) and accredited by SSG. Absentee payroll and up to 70% SSG funding of the course fee is available for eligible participants (Singapore Citizens and Permanent Residents). Absentee payroll subsidy is available for eligible companies and companies on a short work week system will receive the absentee payroll subsidy based on their employees' current income. Please visit www.ssg.gov.sg for full details.




Certificate

Certificate of Completion

The ISS Certificate of Completion will be issued to participants who have attended at least 75% of the course.

Assessment

Participants will be assessed based on their aptitude, attitude and the quality of deliverables produced.

Participants may need to attend additional coaching sessions and re-assessments if they do not pass. ISS reserves the right not to disclose any information on the course assessment process.

 




Preparing for Your Course

NUS-ISS Course Registration Terms and Conditions

Find out more.

NUS-ISS and Learner’s Commitment and Responsibilities

Find out more.

WIFI Access

WIFI access will be made available. User ID and password will be provided in the participant’s kit.

Venue

NUS-ISS Stackup Studio
JTC LaunchPad @ One North
Block 79 Ayer Rajah Crescent #02-09
Singapore 139957

In the event of a change of venue, participants are advised to refer to the acceptance email sent one week prior to the commencement date.

Course Confirmation

All classes are subject to confirmation and ISS will send an acceptance email to participants one week prior to the commencement date. Confirmed registrants are to attend and complete all lectures, class exercises, workshops and assessments (where applicable). Additionally, all responses to feedbacks and surveys conducted by ISS and its partners must be submitted. All training and assessments will be delivered as described in the course webpage.

General Enquiry

Please feel free to write to isstraining@nus.edu.sg or call 6516 2093 if you have any enquiry or feedback.




Instructors

Mr. Kenneth PHANG

Senior Lecturer & Consultant, Software Engineering & Design Practice View Profile >

Mr. LEE Chuk Munn

Chief, StackUp Programme View Profile >

Mr. Vincent LAU

Chief Technology Officer View Profile >

Course Resources

Develop your Career in the Following
Training Roadmap(s)

Please click on the discipline(s) to view the training roadmap of related courses to assess your training needs and goals.

StackUp - Startup Tech Talent Development

Empower Your Imagination

Read More

You Might be Interested in...

Related Courses

StackUp - Startup Tech Talent Development

Security, Notification and Messaging Fundamentals

As we deliver more applications and services through the Internet, so do security threats. In the Security, Notification and Messaging Fundamentals course, we will learn about security concepts, like authentication and authorisation, as well as how to send and receive push notifications.

StackUp - Startup Tech Talent Development

Client Side Foundation

The Client Side Foundation course covers the full development lifecycle starting with setting up your development machine through to deploying, versioning and working with others through Git and publishing your application on the web!

StackUp - Startup Tech Talent Development

Machine Learning driven Data Science

Be equipped with Machine Learning techniques to deal with data in the most intelligent way so as to derive actionable insights.

A+
A-
Scrolltop