MCSA: Querying Microsoft SQL Server

Title	MCSA: Querying Microsoft SQL Server
Course code	CM464.1-02-2018-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. This course helps people prepare for exam 70-761.
Content	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 Window Ranking, Offset and Aggregate Functions Pivoting and Grouping Sets Querying SQL Server Metadata Executing Stored Procedures Programming with T-SQL Implementing Error Handling Implementing Transactions Improving Query Performance
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	19:00-22:00, Feb 24, 2018 (Saturday), and Mar 28, 2018 (Wednesday), and from Feb 28, 2018 to Mar 24, 2018 every Wednesday, Saturday.
Fee	MOP2,200
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: 1707320119-0
Remark	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. Microsoft is a registered trademark of Microsoft Corporation in the United States and/or other countries. Students might prictice at Microsoft SQL Server 2016 due to Microsoft original courseware upgrade.