SQL and Database (SCTP)
Training Provider: NATIONAL UNIVERSITY OF SINGAPORE
Course Reference: TGS-2026065153
S$285
Original: S$950
Save S$665
About This Course
This course aims to equip learners with the foundational skills and practical experience required to use Structured Query Language (SQL) for querying and managing relational data. It provides a comprehensive introduction to database design and SQL fundamentals, emphasizing their applicability and versatility in any technical role.
The course will focus on hands-on exercises, helping learners effectively use SQL's capabilities for data retrieval, filtering, and aggregation. By the end of the course, learners will gain the essential skills to use SQL for key database tasks, such as data manipulation and analysis.
What You'll Learn
At the end of the course, learners will be able to:
• Understand the core principles of relational databases (RDBMS) and structured query language
• Perform Data Retrieval: Execute efficient queries to selectively retrieve, project, and structure data from database tables
• Refine and Organize Data: Use querying, including filtering and sorting, to extract, and present query results
• Manage Data Quality: Implement methods to standardize data formats, manage data types, and reliably handle missing or ambiguous values (NULLs) within queries
• Conduct Data Aggregation: Apply grouping and summarization functions to transform raw data into meaningful metrics and reports for analysis
• Understand the core principles of relational databases (RDBMS) and structured query language
• Perform Data Retrieval: Execute efficient queries to selectively retrieve, project, and structure data from database tables
• Refine and Organize Data: Use querying, including filtering and sorting, to extract, and present query results
• Manage Data Quality: Implement methods to standardize data formats, manage data types, and reliably handle missing or ambiguous values (NULLs) within queries
• Conduct Data Aggregation: Apply grouping and summarization functions to transform raw data into meaningful metrics and reports for analysis
Entry Requirements
General Diploma
Course Details
Back to All Courses
Note: To apply for this course, visit or contact the training provider directly.
More Courses from NATIONAL UNIVERSITY OF SINGAPORE
Objectives:
At the end of the programme, participants are expected to achieve the following objecti...
In Singapore’s dynamic business and governance spheres, senior executives & government leaders mus...
The programme is designed to transform educators into impactful leaders equipped to navigate the com...