Oracle Database: Introduction to SQL
{{col1}}
{{col0}}
Sorry, JavaScript required!
Title Oracle Database: Introduction to SQL
Course code CM556.1-03-2021-C
Objective Teach Students to write Oracle Database customized SQL to query and manipulate data, and find-tuning SQL statements.
Content
  • Introduction to Oracle Database
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Definition Language
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Controlling User Access
  • Managing Data in Different Time Zones
Assessment
  • The average mark for all the written tests is at least 60.
  • The average mark for all the lab assignments (or lab tests) is at least 60.
Target audience
  • Database Adminstrators
  • Programmers
Prerequisite Familiar with standard SQL.
Could 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 English
Duration 45 hours in 15 sessions
Schedule 19:00-22:00, from Mar 10, 2021 to Apr 24, 2021 every Wednesday, Saturday, plus Apr 28, 2021(Wednesday), May 5, 2021(Wednesday), excluding Apr 3, 2021(Saturday).
Fee MOP2,500
Other fees Electronic Training Materials: MOP1,300.
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 ---
Remark
{{col0}}
{{col1}}
Sorry, JavaScript required!