{{col1}}
{{col0}}
Sorry, JavaScript required!

Introduction to SQL

Title Introduction to SQL
Course code CM429-11-2024-C
Objective

Today, database is widely used for the storage of information, and so programmers must have the basic ability in handling database data as well as developing applications using the database.

Relational database is the most widely used Database at the moment, SQL is a common relational database query language, upon completion make students will acquire the essential knowledge of SQL database language.

Content
  • Create tables
  • Basic data query, update and delete
  • Joint multi-table queries, form complex queries by using subquery
  • Joint conditions and filter
  • Sorting and grouping query results
  • Using the built-in functions such as date, statistical and other functions
Assessment In-class performance, assignments and test
Target audience Software Developer, or anyone who will need to operate the relational database
Prerequisite Familiar with PC or Mac and common software operation.
Can read English materials
Please check the self-assessment.
Class size 18
Instructor Microsoft certified Trainer(MCT), Oracle Certifited Professional (OCP), a result-driven IT professional experienced in hardware & network troubleshooting. Certified in MCITP,CCNA, Oracle OCP and ITIL v3 qualification. Has been teaching for CPTTM since 2004.
Instruction language Cantonese (supplemented with English)
Handout language Handouts in English
Duration 18 hours in 6 sessions
Schedule 18:45-21:45, Nov 6, 2024 (Wednesday), and from Nov 11, 2024 to Nov 20, 2024 every Monday, Wednesday, plus Nov 25, 2024(Monday).
Fee MOP1,000
Venue Cyber-Lab (Rua Comandante Mata Oliveira, Ed. Associacao Industrial, 3-andar Macau)
Certificate Certificate of Completion/Merit issued by CPTTM (with at least 80% attendance and passed the assessment).
PDAC code Approved Course under the SAR Government "Continuing Education Development Program", Code: 2404120054-0
{{col0}}
{{col1}}
Sorry, JavaScript required!