Home
WSQ - Administering Microsoft Azure SQL Solutions (DP-300)

WSQ - Administering Microsoft Azure SQL Solutions (DP-300)

WSQ Administering Microsoft Azure SQL Solutions (DP-300) provides comprehensive training on maintaining, securing, and optimizing SQL databases on Azure. Participants will develop efficient data processes, design secure environments, and implement robust data integration procedures tailored to business requirements.

The course covers a wide range of topics, including deploying SQL Server in Azure, migrating SQL workloads, configuring database security, monitoring performance, and automating database tasks. Additionally, it emphasizes high availability and disaster recovery strategies, ensuring participants are well-equipped to handle various database scenarios in Azure environments.

Learning Outcomes

By end of the course, learners should be able to:

Develop efficient processes and data warehouse process models for Azure SQ in accordance to business requirements.
Design data validation and staging databases for Azure SQL.
Design and verify an extraction process for Azure SQL that consolidates in accordance to business rules.
Design a transformation and loading process for Azure SQL in accordance to business rules.
Develop data integration procedure and translate business requirements into Azure SQL data structure.

Course Brochure

Download WSQ - Administering Microsoft Azure SQL Solutions (DP-300) Brochure

Skills Framework

This course follows the guideline of Data Engineering ICT-DIT-4005-1.1 under ICT Skills Framework

Certification

Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.
OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.
External Certification - The participant will be able to attempt the Administering Microsoft Azure SQL Solutions (DP300) exam after attending this course. Upon passing the exam, you will receive the Administering Microsoft Azure SQL Solutions (DP300) accreditation.

Microsoft Learning Partner

We are Authorised Microsoft Learning Partner (Org ID: 5238476). To get the official Microsoft certification, please register your certification exam at Pearson Vue Test Center.

Certification Exam at Pearson Vue

We are Authorised Pearson Vue Testing Center. Once you have prepared for the exam, you can register for the certification here. The course fee does not include the certification exam fee.

You can purchase the exam voucher (one of the lowest prices in Singapore) at Microsoft Role-Based Certification Exam Voucher.

WSQ Funding

WSQ funding is only applicable to Singaporeans and PR. Subject to eligibility, the funding support is subjected to funding caps.

Effective for courses starting from 1 Jan 2024
Full Fee	GST	Nett Fee after Funding (Incl. GST)
		Baseline	MCES / SME
$2,000.00	$180.00	$1,180.00	$780.00

Baseline: Singaporean/PR age 21 and above
MCES(Mid-Career Enhanced Subsidy): S'porean age 40 & above

Upon registration, we will advise further on how to tap on the WSQ Training Subsidy.

You can pay the nett fee (after the WSQ training subsidy) by the following :

SkillsFuture Enterprise Credit (SFEC)

Eligible Singapore-registered companies can tap on $10000 SFEC to cover out-of-pocket expenses.Click here to submit SkillsFuture Enterprise Credit

SkillsFuture Credit (SFC)

Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used. Click here for SkillsFuture Credit submission

UTAP

Eligible NTUC members can apply for 50% of the unfunded fee from UTAP, capped up to $250/year and for members aged 40 and above, capped up to $500/year. Click here to submit UTAP

PSEA

Eligible Singapore Citizens can use their PSEA funds to offset course fee payable after funding.

To check for Post-Secondary Education Account (PSEA) eligibility for this course, Visit SkillsFuture (course code: TGS-2024048319)

Scroll down to “Keyword Tags” to verify for PSEA eligibility.
If there is “PSEA” under keyword tags, the course is eligible for PSEA.

Course Code: TGS-2024048319

Post-Course Support

We provide free consultation related to the subject matter after the course. Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.

Course Details

Topic 1: Prepare to maintain SQL databases on Azure

Describe Microsoft Intelligent Data Platform roles
Understand SQL Server in an Azure virtual machine
Design Azure SQL Database for cloud-native applications
Explore Azure SQL Database Managed Instance

Topic 2: Deploy IaaS solutions with Azure SQL

Explain IaaS options to deploy SQL Server in Azure
Understand hybrid scenarios
Explore performance and security
Explain high availability and disaster recovery options
Exercise: Provision a SQL Server on an Azure Virtual Machine

Topic 3: Deploy PaaS solutions with Azure SQL

Explain PaaS options for deploying SQL Server in Azure
Explore single SQL database
Deploy SQL database elastic pool
Understand SQL database hyperscale
Examine SQL managed instance
Describe SQL Edge
Exercise: Deploy an Azure SQL Database

Topic 4: Evaluate strategies for migrating to Azure SQL

Understand compatibility level
Understand Azure preview features
Describe Azure database migration options

Topic 5: Migrate SQL Server workloads to Azure SQL Database

Choose the right Azure SQL Database feature
Use Azure SQL migration extension to migrate to Azure SQL Database
Explore Data Migration Assistant to migrate to Azure SQL Database
Migrate to Azure SQL Database using BACPAC
Use an online method to migrate to Azure SQL Database
Move data to Azure SQL Database
Exercise: Migrate a SQL Server database to Azure SQL Database

Topic 6: Migrate SQL workloads to Azure Managed Instances

Evaluate migration scenarios to SQL Database Managed Instance
Migrate to SQL Database Managed Instance
Load and Move data to SQL Database Managed Instance

Topic 7: Configure database authentication and authorization

Describe Active Directory and Microsoft Entra ID
Describe authentication and identities
Describe Security Principals
Describe database and object permissions
Identify authentication and authorization failures
Exercise: Authorize Access to Azure SQL Database with Microsoft Entra ID

Topic 8: Protect data in-transit and at rest

Explore Transparent Data Encryption
Configure server and database firewall rules
Explain object encryption and secure enclaves
Enable encrypted connections
Describe SQL injection
Understand Azure Key Vault
Exercise: Configure a server-based firewall rule using the Azure portal

Topic 9: Implement compliance controls for sensitive data

Explore data classification
Explore server and database audit
Implement Dynamic Data Masking
Implement Row Level security
Understand Microsoft Defender for SQL
Explore Azure SQL Database Ledger
Implement Azure Purview
Exercise: Enable Microsoft Defender for SQL and Data Classification

Topic 10: Describe performance monitoring

Describe performance monitoring tools
Describe critical performance metrics
Establish baseline metrics
Explore extended events
Describe Azure SQL Insights
Explore Query Performance Insight
Exercise: Isolate problems with monitoring

Topic 11: Configure SQL Server resources for optimal performance

Explain how to optimize Azure storage for SQL Server virtual machines
Describe virtual machine resizing
Optimize database storage
Control SQL Server resources

Topic 12: Configure databases for optimal performance

Explore database maintenance checks
Describe database scoped configuration options
Describe automatic tuning
Describe intelligent query processing
Exercise: Detect and correct fragmentation issues

Topic 13: Explore query performance optimization

Understand query plans
Explain estimated and actual query plans
Describe dynamic management views and functions
Explore Query Store
Identify problematic query plans
Describe blocking and locking
Exercise: Identify and resolve blocking issues

Topic 14: Explore performance-based design

Describe normalization
Choose appropriate data types
Design indexes
Exercise: Identify database design issues

Topic 15: Evaluate performance improvements

Describe wait statistics
Tune and maintain indexes
Understand query hints
Exercise: Isolate problem areas in poorly performing queries

Topic 16: Automate deployment of database resources

Describe deployment models in Azure
Automate deployment by using Azure Resource Manager templates and Bicep
Automate deployment by using PowerShell
Automate deployment by using Azure CLI
Exercise: Deploy an Azure SQL Database using an Azure Resource Manager template

Topic 17: Create and manage SQL Agent jobs

Create a SQL Server maintenance plan
Describe task status notifications
Knowledge check
Exercise: Create a CPU status alert for a SQL Server

Topic 18: Manage Azure PaaS tasks using automation

Explore Elastic jobs
Understand Azure Automation
Build an automation runbook
Automate database workflows by using Logic Apps
Monitor automated tasks
Exercise: Deploy an automation runbook to automatically rebuild indexes

Topic 19: Describe high availability and disaster recovery strategies

Describe recovery time objective and recovery point objective
Explore high availability and disaster recovery options
Describe Azure high availability and disaster recovery features for Azure Virtual Machines
Describe high availability and disaster recovery options for PaaS deployments
Explore an IaaS high availability and disaster recovery solution
Describe hybrid solutions

Topic 20: Explore IaaS and PaaS solutions for high availability and disaster recovery

Describe failover clusters in Windows Server
Configure Always-on availability groups
Describe temporal tables in Azure SQL Database
Describe active geo-replication for Azure SQL Database
Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance
Exercise: Configure geo replication for Azure SQL Database

Topic 21: Back up and restore databases

Back up and restore SQL Server running on Azure virtual machines
Back up a SQL Server virtual machine
Back up and restore a database using Azure SQL Database
Exercise: Backup to URL

Final Assessment

Written Assessment - Short Answer Questions (WA-SAQ)
Practical Performance (PP)

Course Info

Promotion Code

Promo or discount cannot be applied to WSQ courses

Minimum Entry Requirement

Knowledge and Skills

Able to operate using computer functions
Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

Positive Learning Attitude
Enthusiastic Learner

Experience

Minimum of 1 year of working experience.

Target age group: 21-65 years old

Minimum Software/Hardware Requirement

Software:

You can download and install the following software:

Microsoft 365 Defender

Hardware: Windows and Mac Laptops

About Progressive Wage Model (PWM)

The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity.

Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

For more information on PWM, please visit MOM site.

Funding Eligility Criteria

Individual Sponsored Trainee

Employer Sponsored Trainee

Singapore Citizens or Singapore Permanent Residents of age 21 and above
From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
Trainee must pass all prescribed tests / assessments and attain 100% competency.
We reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria.

Singapore Citizens or Singapore Permanent Residents who are DIRECT EMPLOYEE of the sponsoring company.
From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
Trainee must pass all prescribed tests / assessments and attain 100% competency.
We reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria.

SkillsFuture Credit:

Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

PSEA:

To check for Post-Secondary Education Account (PSEA) eligibility, goto mySkillsFuture portal and search for this course code.
Scroll down to "Keyword Tags" to verify for PSEA eligibility.
If there is “PSEA” under keyword tags, the course is eligible for PSEA.
And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA.
Not all courses are eligible for PSEA funding.

Absentee Payroll (AP) Funding:

$4.50 per hour, capped at $100,000 per enterprise per calendar year.
AP funding will be computed based on the actual number of training hours attended by the trainee.

SFEC:

If the Training Provider has submitted an enrolment for course fee grant claim in Training Partners Gateway (TPGateway), SSG would be able to derive SFEC funding based on this record. There is no need for enterprise to submit any claim request and the SFEC claim will be automatically generated and disbursed.
Where there is no such record, eligible employers are required to submit an SFEC claim after course completion via the SFEC microsite.
SkillsFuture Enterprise Credit (SFEC) Microsite

Steps to Apply Skills Future Claim

The staff will send you an invoice with the fee breakdown.
Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
Upload your invoice and click ‘Submit’

SkillsFuture Level-Up Program

The SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

Get Additional Course Fee Support Up to $500 under UTAP

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

Steps to Apply UTAP

Note

SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
UTAP support amount will be paid to training provider first and claimed after end of class by learner.

Job Roles

Azure Database Administrator
SQL Database Developer
Cloud Solutions Architect
Data Warehouse Architect
Database Security Manager
Performance Tuning Specialist
Disaster Recovery Specialist
Data Migration Consultant
Azure Cloud Engineer
SQL Server DBA
Azure SQL Consultant
Data Integration Specialist
SQL Performance Analyst
Data Compliance Officer
Azure Systems Administrator
High Availability Systems Engineer
Database Backup and Recovery Specialist
SQL Server Migration Engineer
Database Architect
Cloud Database Support Specialist

Trainers

Sanjiv Venkatram: Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers

Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.

Alec Tan: Alec Tan is a ACTA certified trainer, He has a number of Comptia certifications. Since 2002, starting off from IT technical background to pre-sales, sales account manager, system integration, operate IT retail / repair shop business in Sim Lim Square 2008 ~ 2012, and back to IT industry employment, freelance IT Trainer till present.

Kishan Raaj: Kishan Raaj is a seasoned Data Science and SAP Program Manager with over 15 years of experience, currently leading all end-to-end training and projects for Data Science across Asia at LITHAN, Singapore. With expertise in machine learning, data analytics, and cloud technologies, he is well-versed in techniques such as regression, decision trees, clustering, and text mining. He has hands-on experience with tools like Python, R, Tableau, PowerBI, and Microsoft Azure Machine Learning Studio.
As an ACTA certified trainer, Kishan has designed and delivered comprehensive courses for SAP and Data Science programs, managing teams and training in multiple countries, including Singapore, Malaysia, China, India, and Vietnam. His background in SAP, particularly in S4/HANA and ABAP, combined with his expertise in machine learning libraries such as TensorFlow and Keras, positions him as a highly capable leader in technical education and project management across various industries.

Quah Chee Yong: Quah Chee Yong is a ACTA certified trainer. Quah Chee Yong Chee Yong is an experienced professional who has held various Technical, Operations and Commercial positions across several industriesA firm believer that AI can create a better world, he has equipped himself with the Knowledge and Skills in the fields of Data Science, Machine Learning, Deep Learning and Cloud Deployment

He has a deep passion for training & facilitating and is currently a Singapore WSQ certified Adult Educator. He particularly enjoys the interactive engagements with his fellow trainers and learners

Peter Cheong : I am a ACLP certied trainer. Specialise In IT related knowlege and conduct IT Training which Include Microsoft Window Server Technology (Wintel) and Linux - Centos/Red Hat. Comptia ,ITIL , Motorola Solution Trunking System and Cisco Networking. I was worked in Motorola Solutions Conduct Motorola Astro 25 Trunking System For Police Force Malaysia (RMPnet),Taiwan Navy, Indonesia METRO POLDA (Police Force). After that I Join As IT Group Manager For W-Group which include 17 subsidiaries Companies in Real Estate Developer,Plantation, Building Management Services ,Contruction and also Fiber Opti Service Provider in Sabah,Malaysia.

Dr Alvin Ang: Dr Alvin Ang is a ACTA certified trainer. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally

Truman Ng: I am a ACLP certified trainer. With In-depth and diversified experiences from Project Management DevOps, Blockchain, Project Management, Education, IT and even Numerology, I am passionate to meet good people and generate new ideas, in pursuit of realization of better world!

Agus Salim : I am a professional with more than 10 years of experience in Project Management, IT Solutions Management, and Systems Integration both in waterfall and agile methodology. He started out his career as a Web Developer before moving on to Business Analyst/Project Manager. He has strong leadership and the capability of leading a team with a proven ability to deliver projects with tight timelines. Besides his experiences in managing projects, he has good knowledge in Cybersecurity and hands-on experience in Next Generation Firewall such as Check Point. During his free time, he likes to explore Cloud Technology, especially on Microsoft Azure.