We may earn an affiliate commission when you visit our partners.
A Cloud Guru
and
Landon Fowler
This course prepares students who are already familiar with core Azure services and Azure and SQL database skills used by Azure Database Administrators. An Azure Database Administrator is responsible for the management, availability, security, performance monitoring, and optimization of modern relational database solutions. They also assist Azure Data Engineers in managing operational aspects of a data platform solution. Azure Database Administrators are familiar with: - Deploying SQL database solutions within Azure - Azure SQL Server, database, and query architecture - Basic usage of Transact-SQL for administrative tasks - Securing Azure SQL resources and data - Interconnecting Azure SQL resources with other Azure services - Monitoring and optimizing Azure SQL Database performance - Maintaining business continuity for Azure SQL resources - Processes for migrating on-premises SQL Server databases to Azure - Other options for managing relational data in Azure This course also prepares exam candidates to pass the DP-300: Administering Relational Databases on Microsoft Azure exam to attain the Azure Database Administrator Associate certification. Candidates for the exam are presumed to be database administrators and data management specialists that manage on-premises and cloud relational databases built on top of Microsoft SQL Server and Microsoft Azure data services.
Register for this course and see more details by visiting:
OpenCourser.com/course/epfy8r/azure
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Develops in-demand skills for working with and managing database systems
Prepares students for industry-standard DP-300 certification
Geared toward experienced Azure users with familiarity in Azure services
Delivers a comprehensive overview of Azure Database Administrator role
Taught by recognized experts in cloud database management
Save this course
Save Azure Database Administrator Associate to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Azure Database Administrator Associate with these
activities:
Refresh Azure Database Skills
Show steps
Build a stronger foundation for the skills and knowledge you will cover in this course.
Show steps
-
Review the basics of SQL database solutions, including deployment and architecture.
-
Review the fundamentals of Azure SQL Server, including database and query architecture.
-
Refresh your knowledge of Transact-SQL for administrative tasks.
-
Practice securing Azure SQL resources and data.
Review intermediate SQL
Show steps
Refresh your intermediate SQL skills to strengthen your foundation for advanced Azure Database Administration concepts and techniques.
Browse courses on
Data Manipulation
Show steps
-
Review SQL syntax and data types
-
Practice writing queries for data manipulation
-
Review concepts such as joins, subqueries, and stored procedures
Review Microsoft SQL Server basics
Show steps
Refreshes knowledge on the fundamentals of Microsoft SQL Server, making sure you have a strong foundation before diving into the course.
Browse courses on
Microsoft SQL Server
Show steps
-
Review the concepts of relational databases and their components such as tables, columns, and rows.
-
Revisit the syntax and structure of Transact-SQL (T-SQL), including data definition language (DDL) and data manipulation language (DML) statements.
16 other activities
Expand to see all activities and additional details
Show all 19 activities
Complete the Microsoft Learn module on Azure Database Administration
Show steps
Follow guided tutorials provided by Microsoft Learn to enhance your Azure Database Administration skills and gain practical experience in managing and optimizing Azure SQL databases.
Show steps
-
Sign up for a Microsoft Learn account
-
Enroll in the Azure Database Administration learning path
-
Complete the interactive modules and exercises
-
Review the provided documentation and resources
Host a study session with classmates
Show steps
Encourages collaborative learning and allows you to share knowledge and insights with peers.
Browse courses on
Collaboration
Show steps
-
Organize a study session with a group of classmates.
-
Review course materials and discuss concepts together.
-
Solve problems and answer questions as a team.
Practice SQL Queries
Show steps
Reinforce your understanding of SQL queries and prepare for the DP-300 exam.
Show steps
-
Find a set of SQL query practice problems online.
-
Attempt to solve the problems on your own.
-
Check your answers against the provided solutions.
-
Review the concepts behind the queries you struggled with.
Practice SQL queries
Show steps
Solidify your understanding of SQL queries by completing practice exercises.
Browse courses on
SQL
Show steps
-
Find a resource for SQL practice exercises.
-
Complete a set of practice exercises.
-
Review your results and identify areas for improvement.
Follow tutorials on Azure Database Administration
Show steps
Expand your knowledge of Azure Database Administration by following guided tutorials.
Show steps
-
Find a reputable source for Azure Database Administration tutorials.
-
Follow a tutorial on a topic you want to learn more about.
-
Complete the tutorial and apply what you learned.
Participate in a study group or discussion forum
Show steps
Engage with peers in a study group or discussion forum to exchange knowledge, clarify concepts, and reinforce your understanding of Azure Database Administration topics.
Show steps
-
Join an online study group or discussion forum
-
Participate in discussions and ask questions
-
Share your knowledge and insights
-
Collaborate on projects or assignments
Create a sample Azure SQL database
Show steps
Provides hands-on experience in creating and managing Azure SQL databases, reinforcing the concepts learned in the course.
Browse courses on
Azure SQL Database
Show steps
-
Log in to the Azure portal and create a new resource group.
-
Create a new Azure SQL database using the Azure portal or Azure CLI.
-
Connect to the database using a tool like SQL Server Management Studio (SSMS) or Azure Data Studio.
Create a SQL Server database and tables
Show steps
Practice creating and managing SQL Server databases and tables to solidify your understanding of Azure Database Administration concepts.
Browse courses on
SQL Server
Show steps
-
Launch SQL Server Management Studio (SSMS)
-
Connect to an Azure SQL Server instance
-
Create a new database
-
Create tables within the database
-
Insert data into the tables
Write and execute Transact-SQL queries
Show steps
Practice writing and executing Transact-SQL queries to retrieve, manipulate, and update data in Azure SQL Server databases, reinforcing your understanding of query syntax and data management techniques.
Browse courses on
Transact-SQL
Show steps
-
Review basic Transact-SQL syntax
-
Write queries to select, insert, update, and delete data
-
Use joins and subqueries to retrieve complex data
-
Optimize queries for performance
-
Troubleshoot common query errors
Configure Azure SQL Database performance monitoring
Show steps
Provides opportunities to practice configuring performance monitoring tools, strengthening your understanding of Azure SQL Database performance optimization.
Browse courses on
Performance Monitoring
Show steps
-
Create performance metrics and alerts using Azure Monitor.
-
Configure diagnostic logs and queries to collect performance data.
-
Analyze performance data and identify areas for improvement.
Follow Tutorials on Azure Database Administration
Show steps
Enhance your practical skills by following guided tutorials on Azure Database Administration.
Show steps
-
Search for Azure Database Administration tutorials on platforms like Microsoft Learn or Pluralsight.
-
Choose a tutorial that covers a topic you want to learn more about.
-
Follow the steps in the tutorial carefully.
-
Try to apply what you learn in the tutorial to your own projects.
Optimize Azure SQL Database Performance
Show steps
Gain hands-on experience in optimizing Azure SQL databases
Browse courses on
Azure SQL Database
Show steps
-
Follow tutorials on using Azure SQL Database Performance Advisor
-
Learn and implement best practices for indexing, query tuning, and data partitioning
Create a data model for a relational database
Show steps
Deepen your understanding of data modeling by creating your own data model for a relational database.
Browse courses on
Data Modeling
Show steps
-
Choose a business scenario or problem to model.
-
Identify the entities and relationships involved.
-
Create an ER diagram or other data model representation.
-
Validate your data model using normalization techniques.
Deploy Different Azure Database Services
Show steps
Improve practical skills in deploying Azure database services
Browse courses on
Azure Database
Show steps
-
Identify use cases for different Azure database services
-
Practice deploying Azure SQL Database, Azure Cosmos DB, and Azure Database for MySQL
-
Configure and manage database resources
Develop a data model for a real-world scenario
Show steps
Create a data model that addresses a specific business problem, demonstrating your ability to design and implement effective database solutions for Azure SQL databases.
Browse courses on
Data Modeling
Show steps
-
Identify a real-world scenario and define the business requirements
-
Conceptualize and design the data model using appropriate data structures
-
Implement the data model in Azure SQL Server
-
Test and validate the data model
-
Document the data model and its implementation
Develop a data migration plan
Show steps
Challenges you to apply your understanding of Azure SQL Database features and migration strategies to a practical scenario.
Browse courses on
Data Migration
Show steps
-
Identify the source and target databases involved in the migration.
-
Assess the compatibility between the source and target databases.
-
Develop a detailed migration plan outlining the steps, timelines, and potential risks.
Refresh Azure Database Skills
Show steps
Build a stronger foundation for the skills and knowledge you will cover in this course.
Show steps
Show steps
Show steps
- Review the basics of SQL database solutions, including deployment and architecture.
- Review the fundamentals of Azure SQL Server, including database and query architecture.
- Refresh your knowledge of Transact-SQL for administrative tasks.
- Practice securing Azure SQL resources and data.
Review intermediate SQL
Show steps
Refresh your intermediate SQL skills to strengthen your foundation for advanced Azure Database Administration concepts and techniques.
Browse courses on
Data Manipulation
Show steps
Show steps
Show steps
- Review SQL syntax and data types
- Practice writing queries for data manipulation
- Review concepts such as joins, subqueries, and stored procedures
Review Microsoft SQL Server basics
Show steps
Refreshes knowledge on the fundamentals of Microsoft SQL Server, making sure you have a strong foundation before diving into the course.
Browse courses on
Microsoft SQL Server
Show steps
Show steps
Show steps
- Review the concepts of relational databases and their components such as tables, columns, and rows.
- Revisit the syntax and structure of Transact-SQL (T-SQL), including data definition language (DDL) and data manipulation language (DML) statements.
16 other activities
Expand to see all activities and additional details
Show all 19 activities
Complete the Microsoft Learn module on Azure Database Administration
Show steps
Follow guided tutorials provided by Microsoft Learn to enhance your Azure Database Administration skills and gain practical experience in managing and optimizing Azure SQL databases.
Show steps
Show steps
Show steps
- Sign up for a Microsoft Learn account
- Enroll in the Azure Database Administration learning path
- Complete the interactive modules and exercises
- Review the provided documentation and resources
Host a study session with classmates
Show steps
Encourages collaborative learning and allows you to share knowledge and insights with peers.
Browse courses on
Collaboration
Show steps
Show steps
Show steps
- Organize a study session with a group of classmates.
- Review course materials and discuss concepts together.
- Solve problems and answer questions as a team.
Practice SQL Queries
Show steps
Reinforce your understanding of SQL queries and prepare for the DP-300 exam.
Show steps
Show steps
Show steps
- Find a set of SQL query practice problems online.
- Attempt to solve the problems on your own.
- Check your answers against the provided solutions.
- Review the concepts behind the queries you struggled with.
Practice SQL queries
Show steps
Solidify your understanding of SQL queries by completing practice exercises.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Find a resource for SQL practice exercises.
- Complete a set of practice exercises.
- Review your results and identify areas for improvement.
Follow tutorials on Azure Database Administration
Show steps
Expand your knowledge of Azure Database Administration by following guided tutorials.
Show steps
Show steps
Show steps
- Find a reputable source for Azure Database Administration tutorials.
- Follow a tutorial on a topic you want to learn more about.
- Complete the tutorial and apply what you learned.
Participate in a study group or discussion forum
Show steps
Engage with peers in a study group or discussion forum to exchange knowledge, clarify concepts, and reinforce your understanding of Azure Database Administration topics.
Show steps
Show steps
Show steps
- Join an online study group or discussion forum
- Participate in discussions and ask questions
- Share your knowledge and insights
- Collaborate on projects or assignments
Create a sample Azure SQL database
Show steps
Provides hands-on experience in creating and managing Azure SQL databases, reinforcing the concepts learned in the course.
Browse courses on
Azure SQL Database
Show steps
Show steps
Show steps
- Log in to the Azure portal and create a new resource group.
- Create a new Azure SQL database using the Azure portal or Azure CLI.
- Connect to the database using a tool like SQL Server Management Studio (SSMS) or Azure Data Studio.
Create a SQL Server database and tables
Show steps
Practice creating and managing SQL Server databases and tables to solidify your understanding of Azure Database Administration concepts.
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Launch SQL Server Management Studio (SSMS)
- Connect to an Azure SQL Server instance
- Create a new database
- Create tables within the database
- Insert data into the tables
Write and execute Transact-SQL queries
Show steps
Practice writing and executing Transact-SQL queries to retrieve, manipulate, and update data in Azure SQL Server databases, reinforcing your understanding of query syntax and data management techniques.
Browse courses on
Transact-SQL
Show steps
Show steps
Show steps
- Review basic Transact-SQL syntax
- Write queries to select, insert, update, and delete data
- Use joins and subqueries to retrieve complex data
- Optimize queries for performance
- Troubleshoot common query errors
Configure Azure SQL Database performance monitoring
Show steps
Provides opportunities to practice configuring performance monitoring tools, strengthening your understanding of Azure SQL Database performance optimization.
Browse courses on
Performance Monitoring
Show steps
Show steps
Show steps
- Create performance metrics and alerts using Azure Monitor.
- Configure diagnostic logs and queries to collect performance data.
- Analyze performance data and identify areas for improvement.
Follow Tutorials on Azure Database Administration
Show steps
Enhance your practical skills by following guided tutorials on Azure Database Administration.
Show steps
Show steps
Show steps
- Search for Azure Database Administration tutorials on platforms like Microsoft Learn or Pluralsight.
- Choose a tutorial that covers a topic you want to learn more about.
- Follow the steps in the tutorial carefully.
- Try to apply what you learn in the tutorial to your own projects.
Optimize Azure SQL Database Performance
Show steps
Gain hands-on experience in optimizing Azure SQL databases
Browse courses on
Azure SQL Database
Show steps
Show steps
Show steps
- Follow tutorials on using Azure SQL Database Performance Advisor
- Learn and implement best practices for indexing, query tuning, and data partitioning
Create a data model for a relational database
Show steps
Deepen your understanding of data modeling by creating your own data model for a relational database.
Browse courses on
Data Modeling
Show steps
Show steps
Show steps
- Choose a business scenario or problem to model.
- Identify the entities and relationships involved.
- Create an ER diagram or other data model representation.
- Validate your data model using normalization techniques.
Deploy Different Azure Database Services
Show steps
Improve practical skills in deploying Azure database services
Browse courses on
Azure Database
Show steps
Show steps
Show steps
- Identify use cases for different Azure database services
- Practice deploying Azure SQL Database, Azure Cosmos DB, and Azure Database for MySQL
- Configure and manage database resources
Develop a data model for a real-world scenario
Show steps
Create a data model that addresses a specific business problem, demonstrating your ability to design and implement effective database solutions for Azure SQL databases.
Browse courses on
Data Modeling
Show steps
Show steps
Show steps
- Identify a real-world scenario and define the business requirements
- Conceptualize and design the data model using appropriate data structures
- Implement the data model in Azure SQL Server
- Test and validate the data model
- Document the data model and its implementation
Develop a data migration plan
Show steps
Challenges you to apply your understanding of Azure SQL Database features and migration strategies to a practical scenario.
Browse courses on
Data Migration
Show steps
Show steps
Show steps
- Identify the source and target databases involved in the migration.
- Assess the compatibility between the source and target databases.
- Develop a detailed migration plan outlining the steps, timelines, and potential risks.
Career center
Learners who complete Azure Database Administrator Associate will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
A Database Administrator is responsible for managing the day-to-day operations of an organization's database systems. This includes tasks such as installing and maintaining software, backing up and restoring data, and monitoring performance. The Azure Database Administrator Associate certification validates your skills in managing and administering Azure SQL Databases and will help you stand out in the job market.
Data Architect
Data Architect
A Data Architect designs and builds the architecture for an organization's data systems. This includes tasks such as determining which data to collect, how to store it, and how to make it accessible to users. The Azure Database Administrator Associate certification will help you build a solid foundation in Azure SQL Database and prepare you for a career in data architecture.
Data Engineer
Data Engineer
A Data Engineer builds and maintains the infrastructure that supports an organization's data systems. This includes tasks such as designing and implementing data pipelines, developing data models, and optimizing data storage. The Azure Database Administrator Associate certification will provide you with the skills you need to be successful in a data engineering role.
Data Scientist
Data Scientist
A Data Scientist uses data to solve business problems. This includes tasks such as collecting data, analyzing data, and building models to predict future outcomes. The Azure Database Administrator Associate certification will help you build a strong foundation in data management and prepare you for a career in data science.
Cloud Architect
Cloud Architect
A Cloud Architect designs and implements cloud-based solutions for organizations. This includes tasks such as selecting cloud services, designing cloud architectures, and migrating applications to the cloud. The Azure Database Administrator Associate certification will help you build a solid foundation in Azure and prepare you for a career in cloud architecture.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications. This includes tasks such as writing code, testing code, and debugging code. The Azure Database Administrator Associate certification will help you build a strong foundation in Azure SQL Database and prepare you for a career in software engineering.
Systems Engineer
Systems Engineer
A Systems Engineer designs, implements, and maintains computer systems. This includes tasks such as installing hardware, configuring software, and troubleshooting problems. The Azure Database Administrator Associate certification will help you build a solid foundation in Azure and prepare you for a career in systems engineering.
Network Engineer
Network Engineer
A Network Engineer designs, implements, and maintains computer networks. This includes tasks such as installing hardware, configuring software, and troubleshooting problems. The Azure Database Administrator Associate certification will help you build a solid foundation in Azure and prepare you for a career in network engineering.
Security Engineer
Security Engineer
A Security Engineer designs, implements, and maintains security systems. This includes tasks such as installing hardware, configuring software, and troubleshooting problems. The Azure Database Administrator Associate certification will help you build a solid foundation in Azure and prepare you for a career in security engineering.
Business Analyst
Business Analyst
A Business Analyst analyzes business processes and develops solutions to improve efficiency. This includes tasks such as gathering requirements, designing solutions, and implementing solutions. The Azure Database Administrator Associate certification will help you build a solid foundation in data management and prepare you for a career in business analysis.
Project Manager
Project Manager
A Project Manager plans, executes, and closes projects. This includes tasks such as defining project scope, developing project plans, and managing project resources. The Azure Database Administrator Associate certification will help you build a solid foundation in project management and prepare you for a career in project management.
Technical Writer
Technical Writer
A Technical Writer creates documentation for technical products. This includes tasks such as writing user manuals, white papers, and training materials. The Azure Database Administrator Associate certification will help you build a solid foundation in Azure SQL Database and prepare you for a career in technical writing.
Sales Engineer
Sales Engineer
A Sales Engineer sells technical products and services. This includes tasks such as identifying customer needs, developing sales proposals, and closing deals. The Azure Database Administrator Associate certification will help you build a solid foundation in Azure and prepare you for a career in sales engineering.
Marketing Manager
Marketing Manager
A Marketing Manager plans and executes marketing campaigns. This includes tasks such as developing marketing strategies, creating marketing materials, and managing marketing budgets. The Azure Database Administrator Associate certification may be useful for a Marketing Manager who wants to gain a better understanding of how Azure SQL Database can be used to support marketing campaigns.
Customer Success Manager
Customer Success Manager
A Customer Success Manager helps customers achieve success with a product or service. This includes tasks such as providing training, answering questions, and resolving problems. The Azure Database Administrator Associate certification may be useful for a Customer Success Manager who wants to gain a better understanding of how Azure SQL Database can be used to support customers.
For more career information including salaries, visit:
OpenCourser.com/course/epfy8r/azure
Reading list
We've selected four books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Azure Database Administrator Associate.
A highly relevant, supplemental reference for this course. It covers all the main skills needed by Azure Database Administrators.
Save
Provides a collection of recipes for solving common Transact-SQL problems. It valuable reference for anyone who needs to write or troubleshoot Transact-SQL queries.
Save
This comprehensive book explores the challenges of designing and building scalable, reliable data-intensive applications, which is highly relevant to Azure Database Administration.
Provides a comprehensive and authoritative overview of database systems concepts and principles, including some that are relevant to Azure SQL databases.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/epfy8r/azure
Share
Similar courses
Here are nine courses similar to
Azure Database Administrator Associate.
Exam Prep DP-300: Azure Database Administrator Associate
OpenCourser.com/course/71h351/exam
Exam Prep DP-300: Azure Database Administrator Associate
Most relevant
Microsoft Azure Relational Databases
OpenCourser.com/course/58ezyw/microsoft
Microsoft Azure Relational Databases
Most relevant
Microsoft Azure SQL
OpenCourser.com/course/m2egxg/microsoft
Microsoft Azure SQL
Most relevant
Microsoft Azure Solutions Architect: Implement an Azure SQL Databases Strategy
OpenCourser.com/course/ecpcqj/microsoft
Microsoft Azure Solutions Architect: Implement an Azure...
Most relevant
Microsoft Azure Cosmos DB
OpenCourser.com/course/ve457i/microsoft
Microsoft Azure Cosmos DB
Most relevant
Optimizing a Data Warehouse on the Microsoft SQL Server Platform
OpenCourser.com/course/ur4qhy/optimizing
Optimizing a Data Warehouse on the Microsoft SQL Server...
Most relevant
Microsoft Certified: Azure Solutions Architect Expert (AZ-305): Database, Integration, and Analysis Storage Solutions
OpenCourser.com/course/xjloaf/microsoft
Microsoft Certified: Azure Solutions Architect Expert (AZ...
Most relevant
Processing Serverless Data Using AWS Lambda
OpenCourser.com/course/h7xov1/processing
Processing Serverless Data Using AWS Lambda
Most relevant
DP-900 Azure Data Fundamentals
OpenCourser.com/course/yig0xw/dp
DP-900 Azure Data Fundamentals
Most relevant
Time
795 hours
Level
Advanced
Via
Pluralsight
Instructors
A Cloud Guru
Landon Fowler
Language
English
Good to know
Develops in-demand skills for working with and managing database systems
Prepares students for industry-standard DP-300 certification
Geared toward experienced Azure users with familiarity in Azure services
Delivers a comprehensive overview of Azure Database Administrator role
Taught by recognized experts in cloud database management
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser