Date: 22 Mar, 23 Mar 2023 | 9am-5.30pm | Classroom Learning
Duration: 2 Days
This course teaches how to create a database, manipulate it with data, and make queries on the data using SQL, a structured, relational query language commonly used to retrieve data from databases. Learners will be taught how to create a MySql Database, single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation.
This module is part of Professional Certificate in Database Management.
This course will equip learners with the following competencies:
- Learn what is SQL
- Learn SQL commands and code to create databases and tables
- Learn SQL commands and code to manipulate databases such as insert, delete and update records
- Learn the JOIN operation to query databases with multiple tables
Who Should Attend
Data Analysts, Business Analysts
At least a polytechnic diploma.
(Click their photos to view their short biographies)
Assoc Prof Danny Poo
Assoc Prof Danny Poo brings with him 35 years of Software Engineering and Information Technology and Management experience. A graduate from the University of Manchester Institute of Science and Technology (UMIST), England, Dr Poo is currently an Associate Professor at the Department of Information Systems and Analytics, National University of Singapore. Prior to joining the University, Dr Poo was with the System Operations at DBSBank, Singapore.
A Steering Committee member of the Asia-Pacific Software Engineering Conference, Dr Poo is actively involved in Information Management and Healthcare Analytics research. A well-known speaker in seminars, Dr Poo has conducted numerous in-house training and consultancy for organizations, both locally and regionally. Dr Poo is the author of 5 books on Object-Oriented Software Engineering, Java Programming language and Enterprise JavaBeans.
Dr Poo notable teaching credentials include:
- Data Strategy
- Data StoryTelling
- Data Visualisation
- Data Analytics
- Machine Learning
- Data Management
- Data Governance
- Data Architecture
- Capstone Projects for Business Analytics
- Software Engineering
- Server-side Systems Design and Development
- Information Technology Project Management
- Health Informatics
- Healthcare Analytics
- Health Informatics Leadership.
- Deutsche Bank
- Standard Chartered Bank
- ST Electronic
- Monetary Authority of Singapore
- Infocomm Development Authority
- National Library Board
- Ministry of Manpower
- Nanyang Technological University
- Nanyang Polytechnic
- National University Hospital.
Total Nett Programme Fee Payable, Including GST, after additional funding from the various funding schemes
Participants must fulfill at least 75% attendance and pass all assessment components to be eligible for SSG funding.
To enquire, email email@example.com
To register, click Register
TGS-2022012358 (Classroom Learning)
TGS-2022012350 (Synchronous e-learning)
For members of public and NUS Alumnus (without R&G Voucher), please follow the steps below:
Select Short Course / Modular Course -> Apply for Myself -> Browse Academic Modules / Short Courses-> Module/Course Category -> Short Courses -> Browse Courses-> Advanced Computing for Exe (Faculty/Department / Unit)
Please download the user guide for NUS Online Application Portal after you click ‘Apply for Myself’ if you need assistance.
Course Fee Breakdown
Singapore Citizens39 years old or younger
Singapore Citizen40 years old or older