Database Design with SQL

Title	Database Design with SQL
Course code	CM459-12-2021-C
Objective	The main purpose of this course is to teach students to design and implement a database for some specific business requirements, store the data in resonable structure for further query and analysis. This course will also teach students the correct way to design a database with usual design patterns.
Content	Identifying the design purpose Applying the normalization process Designing the table structures Setting up the table constraints Setting up the table indexes Setting up the access rights for tables Implement by SQL
Assessment	At least 80% attendance and complete all in-class exercises and assessments.
Target audience	Software developers or people who have to operate with a relational database
Prerequisite	Familar with SQL or finished the course CM429 - Introduction to SQL Please check the self-assessment
Class size	18 Full
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	English
Duration	18 hours in 6 sessions
Schedule	18:45-21:45, from Dec 1, 2021 to Dec 17, 2021 every Wednesday, Friday, plus Dec 22, 2021(Wednesday), excluding Dec 8, 2021(Wednesday).
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: 2104140025-0