Course Information

  • Sessions 4 days
  • Duration 32 hrs
  • Level Beginner
  • Assessment 2 hrs

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Skills Framework

TSC Title
Data Engineering
TSC Code
ICT-DIT-4005-1.1

Funding Validity

Funding for this course is valid from 16 Aug 2024 to 15 Aug 2026. Register and complete the course within this period to qualify for funding support.

Learning Outcomes

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

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

Course Brochure

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.
  • 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.

Microsoft Learning Partner

We are an Authorised Microsoft Learning Partner (Org ID: 5238476). To get the official Microsoft certification, please register your certification exam at a Pearson VUE test center.

Certification Exam

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 - Administering Microsoft Azure SQL Solutions (DP-300)

Course Code: TGS-2024048319
  • WSQ
  • SFC
  • PSEA
  • UTAP
  • SFEC
  • Absentee Payroll
  • MCES
Share

What's This Course About

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.

Bonus: Free Practice Exams

Get exam-ready on our Practice Exam Portal — train in realistic Practice Mode and timed Exam Mode, then retake them as many times as you like before the real exam.

Start Practising →

WSQ Funding

Full Fee $2,000.00 Before GST
GST $180.00 9% of fee
Baseline Nett $1,180.00 SG/PR age 21+ · 50% funded
MCES / SME Nett $780.00 SG age 40+ · 70% funded
SkillsFuture Enterprise Credit (SFEC)

Eligible companies can use their $10,000 SFEC to cover up to 90% of out-of-pocket course fees for classes ending on or before 30 Nov 2026. A redesigned SFEC starts on 1 Dec 2026.

View on SkillsFuture for Business

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.

Direct Application on SkillsFuture Portal

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.

Submit UTAP Claim

PSEA

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

Check PSEA Eligibility

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

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form, then submit the completed form to us:

PSEA Withdrawal FormSubmit PSEA Form

Course FeeBefore Funding

$2,000.00 (GST-exclusive)
$2,180.00 (GST-inclusive)

Course Date

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

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.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Course Details

What You'll Learn

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

Assessment

  • Written Exam
  • Practical Exam

Course Info

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 will need the following for this course:

Hardware: Windows PC or Mac laptop

Funding Eligibility Criteria

Self-sponsored learners (individuals)

  • Singapore Citizens and Singapore Permanent Residents aged 21 and above.
  • Up to 50% course fee funding. Singapore Citizens aged 40 and above receive up to 70% under the Mid-career Enhanced Subsidy (MCES).
  • Singapore Citizens aged 25 and above can pay the remaining fee with SkillsFuture Credit.

Company-sponsored learners

  • Singapore Citizens and Singapore Permanent Residents who are direct employees of the sponsoring company.
  • Up to 50% course fee funding, or up to 70% for employees of SMEs (Enhanced Training Support for SMEs) and for Singapore Citizens aged 40 and above. An SME has no more than 200 employees or an annual turnover of no more than $100 million.
  • Employers can also claim Absentee Payroll funding for employees who attend during working hours.
  • Eligible companies can offset their out-of-pocket fees with SkillsFuture Enterprise Credit (SFEC).

Conditions for all funded learners

  • Attendance is taken digitally with Singpass for every session, including the assessment.
  • You must complete the course and pass all assessments (assessed as Competent).
  • If these conditions are not met, the funding is clawed back and the learner or employer pays the full course fee.
  • 9% GST is charged on the full course fee before funding.
  • Promo and discount codes cannot be used on funded courses.
  • Any balance after funding can be paid in cash, with SkillsFuture Credit, with PSEA (Singapore Citizens with a PSEA), or partly reimbursed by UTAP for NTUC members.

How to Apply SkillsFuture Credit Claim for Individuals

Singapore Citizens aged 25 and above can use their SkillsFuture Credit (base tier) to pay the course fee after funding. The $4,000 mid-career top-up cannot be used for this course.

  1. Register for this course as self-sponsored and tell us you will use SkillsFuture Credit. Do not pay the amount you plan to claim.
  2. We email you an invoice showing the course fee after funding.
  3. From 60 days before the course starts, and no later than the course start date, log in to MySkillsFuture with Singpass and click Claim credits.
  4. Click Submit a Claim and search for this course by its course code, TGS-2024048319.
  5. Select your class start date, enter the course fee payable after funding and the amount of credit to claim, then upload the invoice (PDF, JPG or PNG, under 4MB).
  6. Review, accept the terms and click Agree and Submit. The credit is paid directly to us; processing can take up to 14 working days.

Changing or withdrawing: cancel the claim on MySkillsFuture at least one day before the course starts. If your class date changes, cancel the claim and submit a new one with the new date.

How to Apply SkillsFuture Enterprise Credit (SFEC)

SFEC helps companies pay for employee training. The current SFEC ends on 30 November 2026, and a redesigned SFEC starts on 1 December 2026.

Current SFEC: classes ending on or before 30 November 2026

  • Eligible companies received a one-off $10,000 credit, notified by letter to their Corppass administrator. Eligibility generally required at least 3 Singapore Citizen or PR employees and Skills Development Levy contributions.
  • SFEC covers up to 90% of the company's out-of-pocket course fee after other subsidies.
  1. Check your company's SFEC eligibility and balance on EnterpriseSG.
  2. Register your Singapore Citizen or PR employee for a class that ends by 30 November 2026, as company-sponsored, and pay the course fee after funding.
  3. Your employee attends and completes the course. We submit the attendance and assessment results to SWDA.
  4. No separate claim is needed. SFEC is calculated automatically once the course fee grant is approved and is paid quarterly to your company's IRAS GIRO or PayNow Corporate account.

Any unused balance of the current SFEC expires on 30 November 2026.

Redesigned SFEC from 1 December 2026

Companies with at least 3 resident employees receive a fresh $10,000 in an online SFEC wallet that offsets out-of-pocket fees upfront at enrolment, instead of reimbursing them afterwards. SWDA has not yet published the support rates and claim steps; see OurWorkforce or our SFEC guide.

How to Apply UTAP (NTUC Members)

NTUC members can claim 50% of the unfunded course fee under the Union Training Assistance Programme (UTAP), capped at $250 a year (aged below 40) or $500 a year (aged 40 and above). The cap is shared with UTAP claims for AI tool subscriptions.

Eligibility: you must be an NTUC member paying full membership fees, with your membership paid up before and during the course and when you claim. The course must not be fully paid for by your employer or another source.

  1. Make sure your NTUC membership is paid up before the course starts.
  2. Register for this course with us and pay the course fee after funding and SkillsFuture Credit.
  3. Attend at least 75% of the course and sit all assessments.
  4. Within 6 months after the course ends, go to the NTUC U Portal, open UTAP under E-services, log in with Singpass and choose Course Fee Claim.
  5. Enter the nett course fee you paid (after all subsidies and SkillsFuture Credit, including GST), and upload your invoice or receipt and your certificate or result slip (PDF, JPG or PNG, up to 5MB each).
  6. NTUC usually pays the claim within 4 weeks of submission.

Read more in our UTAP guide.

How to Apply PSEA

Singapore Citizens with a Post-Secondary Education Account (PSEA), which stays open until around the year you turn 31, can use it to pay the course fee after funding for PSEA-approved courses. You can also use a sibling's PSEA after your own has been used up.

  1. Check that this course shows the PSEA tag on its MySkillsFuture page.
  2. Check your PSEA balance on MOE's Student Finance System with Singpass.
  3. Download and complete the PSEA withdrawal form, then submit it to us.
  4. We submit the withdrawal request to MOE. You (and your sibling, if you are using their account) authorise it in the Student Finance System. Nothing is withdrawn without this authorisation.
  5. MOE pays us directly. If you have already paid, we refund the amount covered by PSEA.

More details: MOE PSEA overview.

Appeal Process

If you disagree with an assessment decision, you have the right to appeal.

  1. When the assessor gives you feedback, say whether you agree with the outcome. If you agree, you and the assessor sign the Assessment Summary Record; if you disagree, do not sign it.
  2. Discuss the decision with the assessor or the assessment manager first.
  3. If you are still not satisfied, tell the assessor you intend to appeal. The assessor records this in the feedback section of the Assessment Summary Record and informs the assessment manager.
  4. Lodge your appeal within 7 days, giving your reasons, using the Candidate Appeal Form. The assessor can help you write and lodge it.
  5. An Assessment Appeal Panel reviews the information from you and the assessor and makes a decision. A record of the appeal and its outcome is kept.
  6. You will be told the outcome within 2 weeks of lodging the appeal. The panel's decision is final.

Job Roles

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

Trainers

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.
Agus Salim is an experienced IT solutions and cybersecurity professional with a strong foundation in cloud infrastructure and project management. With over a decade of experience in systems integration, software development, and IT security across both enterprise and consulting environments, he brings a practical understanding of secure system design and deployment. His credentials include PMP, CompTIA Security+, CEH, and AWS Certified Cloud Practitioner, reflecting his balanced expertise in governance, risk management, and cloud operations. Agus has worked with leading organizations such as Citi and Check Point Software Technologies, providing hands-on technical and security support across multi-cloud platforms.
Gollapalli Rajendra Kishnan is a Microsoft Certified Trainer and Azure Data Scientist with over 20 years of experience across cloud technologies, AI, and enterprise systems. With a Master’s degree in Computer Applications, he has delivered training and consultancy projects across Asia for clients including SAP, Accenture, Singapore Power, and Wipro. His technical expertise spans Azure Machine Learning, Azure Data Engineering, and Power Platform solutions, along with SAP HANA and BTP integration.
Alec Tan is an IT trainer and systems engineer with over 20 years of experience spanning IT technical support, system integration, and IT training. He holds multiple CompTIA certifications, including A+, Network+, and Server+, and is also WSQ ACLP-certified, equipping him with both the technical expertise and the pedagogical skills to deliver effective training. His professional career includes roles as a Network Systems Engineer at McKinn International and freelance IT trainer at Nexus Academy, where he taught Office 365, Big Data, Artificial Intelligence, and CompTIA certification programs. With strong technical competencies in Microsoft Windows Server, desktop and laptop support, and IT infrastructure management, Alec brings a wealth of hands-on experience to Security+ training. His teaching emphasizes practical learning, covering key Security+ domains such as threat management, identity access, cryptography, and risk mitigation. By combining deep technical knowledge with a learner-focused approach, Alec ensures participants are well-prepared to achieve Security+ certification and apply cybersecurity principles in real-world IT environments.
is a results-driven data scientist and financial services professional with over two decades of experience in data analytics, visualization, and business intelligence. As a Senior Partner and Lead Data Scientist at Big Data Venture Capital, he has led consulting projects, curriculum development, and training operations for blue-chip firms, equipping professionals with practical skills in Microsoft Power BI, Python, and advanced data analytics. His expertise in data acquisition, cleaning, feature engineering, ETL, and visualization ensures that organizations can harness Power BI to transform raw data into actionable insights for strategic decision-making. In addition to his industry leadership, Mr. Peh is a certified adult educator with the WSQ Advanced Certificate in Learning and Performance (ACLP) and has delivered numerous Power BI and data science courses through NTUC LearningHub and other training providers. His ability to merge technical expertise with pedagogy has made him a trusted trainer, empowering professionals to build interactive dashboards, automate reporting workflows, and adopt data-driven cultures. With a unique blend of hands-on technical mastery and proven teaching experience, Mr. Peh has established himself as a credible authority in Power BI and business intelligence solutions

Review

Write Your Own Review

You're reviewing: WSQ - Administering Microsoft Azure SQL Solutions (DP-300)

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment