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

Introduction to SQL

Title Introduction to SQL
Course code CM429-03-2018-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 Skilled computer operation, know the concept and process of database and programming, 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 10:00-13:00, 14:30-17:30, from Mar 17, 2018 to Apr 7, 2018 every Saturday, excluding Mar 31, 2018(Saturday).
Fee MOP900
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: 1707320108-0
Remark
{{col0}}
{{col1}}
Sorry, JavaScript required!