MCSA: Developing SQL Databases

Sorry, JavaScript required!
Title MCSA: Developing SQL Databases
Course code CM547.2-04-2019-C
Objective Teaching the basic knowledge of Microsoft SQL Database development, introduce the new feature and tools of SQL Server for database developing. This course match the MCSA Exam 70-762: Developing SQL Databases.
  • Introduction to Database Development
  • Designing and Implementing Tables
  • Advanced Table Designs
  • Ensuring Data Integrity through Constraints
  • Introduction to Indexes
  • Designing Optimized Index Strategies
  • Columnstore Indexes
  • Designing and Implementing Views
  • Designing and Implementing Stored Procedures
  • Designing and Implementing User-Defined Functions
  • Responding to Data Manipulation via Triggers
  • Using In-Memory Tables
  • Implementing Managed Code in SQL Server
  • Storing and Querying XML Data in SQL Server
  • Storing and Querying Spatial Data in SQL Server
  • Storing and Querying BLOBs and Text Documents in SQL Server
  • SQL Server Concurrency
  • Performance and Monitoring
Assessment In-class performance and exercises
Target audience IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database.Individuals who are looking to become skilled in the implementation of a SQL Server database.
Prerequisite Before attending this course, students must have experience on:
  • Familiar with Windows Operation System.
  • Completed course CM464.1 MCSA: Querying Microsoft SQL Server or have same level of knowledge.
  • 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.
Handout Original courseware from Microsoft
Instruction language Cantonese
Handout language Handouts in English
Duration 30 hours in 10 sessions
Schedule 10:00-13:00, 14:00-17:00, from Apr 14, 2019 to May 19, 2019 every Sunday, excluding May 12, 2019(Sunday).
Fee MOP2,400
Other fees Textbook (Compulsory): MOP1,100.
Venue Cyber-Lab (Rua Comandante Mata Oliveira, Ed. Associacao Industrial, 3-andar Macau)
Certificate Course Completion Certificate issued by Microsoft if 80% attendance is attained and pass the assessment.
PDAC code Approved Course under the SAR Government "Continuing Education Development Program", Code: 1810321208-0
  • Courseware Purchase Order one week before period. Student enrolls after the deadline may receive thier training materials Microsoft Offical Curriculum(MOC) after the course started.
  • Further MCSA certification info please check Microsoft website MCSA: SQL 2016 Database Development
Sorry, JavaScript required!