This program guides participant about:
a.) Introduction to Microsoft SQL Server
b.) Introduction to T-SQL Querying
c.) Writing SELECT Queries
d.) Querying Multiple Tables
e.) Sorting and Filtering Data
f.) Working with SQL Server Data Types
g.) Using DML to Modify Data
h.) Using Built-In Functions
i.) Grouping and Aggregating Data
j.) Using Subqueries
k.) Using Table Expressions
l.) Using Set Operators
m.) Using Windows Ranking, Offset, and Aggregate Functions
n.) Pivoting and Grouping Sets
o.) Executing Stored Procedures
p.) Programming with T-SQL
q.) Implementing Error Handling
r.) Implementing Transactions

Important Note:
a.) Prior approval from your superior is required, please register this program after approval obtained.
b.) A confirmation email will be send out to participant via email at least one week before the program begins.
c.) Please apply as Training Leave Application (for half day/full day training session during working day only) in Payroll2U system before attend this program.

8 hours | PUB | Module Owner: LND (learning@sam-malaysia.com)