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

DP-300 Azure Database Administrator Associate

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

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.
Download Course Brochure

Certification

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

Free Certificate Practice Exams

Take Free Certificate Practice Exams at exams.tertiaryinfotech.com.

You can also purchase Certificate exam vouchers at exams.tertiaryinfotech.com.

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

Course Code: TGS-2024048319
  • WSQ
  • SkillsFuture Credit
  • PSEA
  • UTAP
  • SFEC
  • Absentee Payroll
  • MCES

Be the first to review this product

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.

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

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 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.

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form and email to us. 

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

Final Assessment 

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

Assessment

  • Written Exam
  • Practical Exam

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:

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

  • Log in to your U Portal account to submit your UTAP application upon completion of the course.

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.

Appeal Process

  1. The candidate has the right to disagree with the assessment decision made by the assessor.
  2. When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
  3. If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
  4. If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
  5. If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
  6. If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
  7. The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
  8. The candidate must lodge the appeal within 7 days, giving reasons for appeal 
  9. The assessor can help the candidate with writing and lodging the appeal.
  10. he assessment manager will collect information from the candidate & assessor and give a final decision.
  11. A record of the appeal and any subsequent actions and findings will be made.
  12. An Assessment Appeal Panel will be formed to review and give a decision.
  13. The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
  14. The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
  15. Please click the link below to fill up the Candidates Appeal Form.

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

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