MCSA: Querying Data with Transact-SQL

Sorry, JavaScript required!
Title MCSA: Querying Data with Transact-SQL
Course code CM547.1-03-2019-C
Objective This course is the essential course of other advance SQL Server course(database admin, database development and Business Intelligence), will teach students to write basic TRANSACT-SQL query on Microsoft SQL Server 2012. This course helps people prepare for exam 70-761.
  • Introduction to Microsoft SQL Server
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Windows Ranking, Offset, and Aggregate Functions
  • Pivoting and Grouping Sets
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions
Assessment In-class performance and exercises
Target audience Database Adminstrators, Database Developer or Anyone planing to attempt the SQL Server Certificate Exam.
Prerequisite Before attending this course, students must have experience on:
  • Familiar with Windows Operation System.
  • Familiar with SQL or completed course CM429: Introduction to SQL
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 Mar 3, 2019 to Mar 31, 2019 every 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: 1807320950-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.
Sorry, JavaScript required!