OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.

SQL Server Certification

Provisioning SQL Databases

Jeremy Chew

Embark on a journey to mastery with our comprehensive course tailored for the Microsoft Certified Solutions Associate (MCSA): 2016 Database Administration certification. This course is meticulously designed to prepare you for the Microsoft exam, "Provisioning SQL Databases," one of the pivotal steps toward achieving your MCSA certification.

Read more

Embark on a journey to mastery with our comprehensive course tailored for the Microsoft Certified Solutions Associate (MCSA): 2016 Database Administration certification. This course is meticulously designed to prepare you for the Microsoft exam, "Provisioning SQL Databases," one of the pivotal steps toward achieving your MCSA certification.

Gain invaluable insights into Microsoft's Azure cloud platform as we provide you with a robust foundation in both theoretical concepts and practical applications. Discover the seamless integration of SQL Server within the expansive Azure ecosystem, exploring both Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) models.

From the initial steps of creating a complimentary Microsoft Azure subscription to hands-on configurations and deployments, this course offers a rich, practical learning experience. Delve into varied cloud-based SQL Server configurations and understand their implications and strategic benefits to businesses transitioning to the cloud.

What You Will Learn:

  • Microsoft Exam Preparation: Thoroughly explore the objectives published by Microsoft necessary to ace the Provisioning SQL Databases exam.

  • Azure Platform Mastery: Develop a deep understanding of Microsoft Azure, learning to navigate its administrative interfaces like a seasoned professional.

  • Cloud Migration Strategies: Understand the pivotal considerations and impacts of migrating existing technologies to a cloud environment.

  • Database Solutions in Azure: Differentiate between Azure SQL Database and SQL Server on Azure VM, grasping the subtleties that define their deployment and management.

  • Tools and Security: Get acquainted with Azure’s monitoring tools and dashboard, and explore robust security implementations to safeguard your data in the cloud.

  • Operational Efficiencies: Realize the cost, performance, and scalability benefits of managing SQL Server in a cloud environment.

Designed for IT professionals, database administrators, and technology enthusiasts seeking to leverage cloud technologies for database management, this course not only prepares you for certification but also equips you with the knowledge to transform your organization’s database solutions with confidence and expertise.

Jumpstart your career with our

Enroll now

What's inside

Learning objectives

  • Understand mcsa certification requirements: master the objectives required to pass the provisioning sql databases exam.
  • Learn sql server fundamentals: acquire essential knowledge of sql server 2016, including its editions, database structures, and transact-sql.
  • Install and verify sql server 2016: perform installation and verification of sql server 2016 and sql server management studio.
  • Grasp cloud computing basics: understand cloud computing principles, service models like iaas, paas, and saas, and cloud virtualization.
  • Navigate microsoft azure: manage azure subscriptions, explore the azure portal, and utilize its features.
  • Deploy sql server in azure: utilize sql server in azure environments, differentiate between sql database and sql server on azure vm.
  • Administer azure sql database: create and manage azure sql databases and elastic pools, and optimize database performance.
  • Virtualize and manage sql server on azure vms: set up azure vms for sql server, including networking and manual installations.
  • Implement advanced security features: secure sql databases with features like tde, ddm, and always encrypted.
  • Execute database migrations to azure: use tools like data migration assistant for migrating databases and enhancing their performance in azure.

Syllabus

Welcome
Introduction
Course Overview
Course Materials & Source Code
Read more
SQL Server Fundamentals
Overview of the SQL Server Platform
SQL Server Editions and Features
Understanding Databases and Data Structures
Database Architecture and Structures
Introduction to Transact-SQL
Installing and Configuring SQL Server
Downloading SQL Server Developer Edition
Downloading SQL Server
Installation Guide: SQL Server 2016 (Part 1)
Installation Guide: SQL Server 2016 (Part 2)
Installing SQL Server Management Studio
Verifying SQL Server Installation
SQL Server Deployment Options
Overview of Cloud Computing
Defining Cloud Computing: An Overview
Virtualization Techniques in Cloud Environments
Designing and Deploying Cloud-Based Applications
Reliability, Maintenance, and Availability (RMA) in Cloud
Key Benefits of Utilizing Cloud Technologies
Differentiating Cloud Deployment Models
Exploring Cloud Service Models
Infrastructure as a Service (IaaS): A Detailed Guide
Platform as a Service (PaaS): Opportunities and Use Cases
Software as a Service (SaaS): Features and Benefits
Emerging Technologies in the Cloud Ecosystem
Assessing the Impact of Cloud Computing on Business and IT
Mastering Microsoft Azure
Comprehensive Guide to Microsoft Azure
Key Azure Terminologies
Setting Up Azure Subscriptions
How to Sign-Up and Navigate Azure
Exploring the Azure Portal Interface
Working with Azure SQL Database
Introduction to Azure SQL Database
Understanding Database Transaction Units (DTUs)
Configuring Logical SQL Servers
Creating an Azure SQL Database
Connecting to SQL Database via SQL Server Management Studio (SSMS)
Understanding and Configuring Elastic Pools
Creating and Managing Elastic Pools
Virtualizing SQL Server in Microsoft Azure
Introduction to Azure Virtual Machines
Understanding Azure Resource Groups
Creating and Configuring an Azure Virtual Machine (Part 1)
Creating and Configuring an Azure Virtual Machine (Part 2)
Accessing and Managing Virtual Machines
Storage Planning for Virtual Machines
Virtual Networking in Azure
Comparing On-Premises vs. SQL Server Virtual Machines
Provisioning a SQL Server Virtual Machine
Manual SQL Server Installation on Virtual Machines
Configuring SQL Server Memory Allocation
Manual Memory Configuration
Utilizing SQL Server Agent for Task Automation
Setting Up Operators and Alerts in SQL Server
Configuring Azure Alerts for SQL Server
Monitoring SQL Server Virtual Machines
Securing SQL Server in Microsoft Azure
Security Best Practices for Azure SQL Database
Managing Access Control and Authorization
Implementing Transparent Data Encryption (TDE)
Enabling Transparent Data Encryption (TDE)
Understanding Dynamic Data Masking (DDM)
Implementing Dynamic Data Masking (DDM)
Utilizing Always Encrypted for Data Protection
Migration and Performance Optimization
Strategies for Migrating to the Cloud
Using Data Migration Assistant for Cloud Migration
Migrating On-Premises Data to Azure SQL Database
Migrating On-Premises Data to SQL Server Virtual Machines
Performance Tuning and Optimization in Azure SQL Database
Monitoring SQL Server Performance with Azure Monitor
High Availability with Azure Availability Sets
Conclusion
Course Summary and Wrap-Up
Thank You

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Prepares learners for the Microsoft exam, "Provisioning SQL Databases," which is a step toward achieving MCSA certification, demonstrating expertise in SQL Server database administration
Explores the integration of SQL Server within the Azure ecosystem, covering both Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) models, which are essential for cloud-based database solutions
Covers security implementations like Transparent Data Encryption (TDE), Dynamic Data Masking (DDM), and Always Encrypted, which are crucial for safeguarding data in cloud environments
Requires learners to create a Microsoft Azure subscription, which may involve costs depending on usage beyond the complimentary services
Focuses on SQL Server 2016, which, while still relevant, may not cover the latest features and updates available in newer versions of SQL Server
Teaches about database migration assistant, which may not be relevant for organizations that have already migrated to the cloud or are using other migration tools

Save this course

Save SQL Server Certification: Provisioning SQL Databases to your list so you can find it easily later:
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 SQL Server Certification: Provisioning SQL Databases with these activities:
Review SQL Server Fundamentals
Reinforce your understanding of SQL Server basics, including database structures and Transact-SQL, to prepare for the course's more advanced topics.
Browse courses on Transact-SQL
Show steps
  • Review the different SQL Server editions and their features.
  • Study database architecture and structures.
  • Practice writing basic Transact-SQL queries.
Review 'SQL Server 2019 Administration Inside Out'
Supplement your learning with a detailed guide on SQL Server administration, focusing on practical aspects relevant to the course.
View SQL Server 2022 Administration Inside Out on Amazon
Show steps
  • Read the chapters on installation and configuration.
  • Study the sections on security and performance tuning.
  • Take notes on key concepts and best practices.
Practice Azure Portal Navigation
Familiarize yourself with the Azure portal interface through hands-on practice to improve your efficiency in managing cloud resources.
Browse courses on Azure Portal
Show steps
  • Create a free Azure account.
  • Explore different services and features in the portal.
  • Practice creating and managing a virtual machine.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Document a SQL Server Installation
Solidify your understanding of SQL Server installation by creating a detailed, step-by-step guide that you can reference later.
Show steps
  • Install SQL Server on a virtual machine or local environment.
  • Document each step of the installation process with screenshots.
  • Explain the purpose of each configuration option.
  • Share your guide with other students for feedback.
Migrate a Database to Azure
Apply your knowledge by migrating an on-premises database to Azure, gaining practical experience with cloud migration strategies.
Browse courses on Azure SQL Database
Show steps
  • Choose a database to migrate.
  • Use Data Migration Assistant to assess compatibility.
  • Migrate the database to Azure SQL Database or SQL Server on Azure VM.
  • Test the migrated database for functionality and performance.
Review 'Pro SQL Server on Microsoft Azure'
Expand your understanding of SQL Server on Azure with a book dedicated to cloud deployment and management.
View Microsoft SQL Server 2017 on Linux on Amazon
Show steps
  • Read the chapters on Azure SQL Database and SQL Server on Azure VMs.
  • Study the sections on hybrid cloud scenarios.
  • Take notes on key considerations for cloud deployment.
Create a Security Implementation Plan
Develop a comprehensive security plan for an Azure SQL Database, incorporating features like TDE, DDM, and Always Encrypted.
Show steps
  • Identify sensitive data in a sample database.
  • Implement TDE to encrypt data at rest.
  • Apply DDM to mask sensitive data for non-privileged users.
  • Configure Always Encrypted for data in use.
  • Document your security implementation plan.

Career center

Learners who complete SQL Server Certification: Provisioning SQL Databases will develop knowledge and skills that may be useful to these careers:
Cloud Database Engineer
A Cloud Database Engineer specializes in designing, implementing, and managing databases on cloud platforms. This course directly aligns with this career path, as it extensively covers SQL Server database provisioning on Microsoft Azure. The course provides knowledge about Azure services, the difference between Azure SQL Database and SQL Server on Azure VMs, and cloud migration strategies. A Cloud Database Engineer benefits from this course because it provides foundational skill sets in cloud-based database management. The detailed syllabus on virtualizing, securing, and optimizing SQL servers in Azure make this course particularly useful for someone developing a cloud based database career.
See salaries and explore the career path for Cloud Database Engineer
Database Administrator
A Database Administrator is responsible for the performance, integrity, and security of a database. This course is directly applicable, since it focuses on provisioning databases, particularly within the Microsoft Azure environment. Skills gained in this course, such as database deployment, security implementations like Transparent Data Encryption, and performance monitoring, directly contribute to the core functions of a Database Administrator. A learner will gain practical skills and knowledge about administering SQL Server databases, both on premises and in the cloud. This course provides a robust foundation in Azure, which is increasingly important for anyone pursuing a career as a Database Administrator.
See salaries and explore the career path for Database Administrator
Data Migration Specialist
A Data Migration Specialist focuses on planning and executing the transfer of data between different systems. This course, with its emphasis on migrating databases to Azure, directly helps build a foundation for this role. The course provides hands-on experience with tools like Data Migration Assistant and teaches best practices for optimizing database performance after migration. A Data Migration Specialist benefits from the course by gaining practical skills in cloud migration strategies, and also understanding the nuances of moving database systems to Azure. This course covers the topics a data migration specialist will require.
See salaries and explore the career path for Data Migration Specialist
Azure Administrator
An Azure Administrator is responsible for implementing, managing, and monitoring a company's Microsoft Azure environment. This course directly addresses this role by teaching learners how to create and manage Azure SQL Databases and SQL Servers on Azure VMs. The detailed exploration of the Azure portal, subscription management, and database deployment techniques provides an excellent foundation for an Azure Administrator. Mastering Azure security features and tools, as taught in this course, is also essential for protecting data in the cloud. This course provides practical, hands-on knowledge that is critical for succeeding as an Azure Administrator.
See salaries and explore the career path for Azure Administrator
Cloud Solutions Architect
A Cloud Solutions Architect designs and implements cloud-based solutions. This course aligns with their needs because it provides in-depth knowledge of Microsoft Azure, focusing on database services. A Cloud Solutions Architect needs to understand how to deploy and manage SQL Server in the cloud, including both PaaS and IaaS models. This course provides a practical learning experience, from initial Azure subscription setup to advanced security implementations, that helps build a foundation for anyone interested in becoming a Cloud Solution Architect. The coverage of the Azure portal and its features is helpful as well.
See salaries and explore the career path for Cloud Solutions Architect
Database Consultant
A Database Consultant advises organizations on how to optimize their database systems. Because this course provides a strong foundation in SQL Server provisioning and deployment, particularly within the Azure cloud, it is relevant to the role of Database Consultant. The curriculum includes topics like database migration, performance tuning, and security, all of which address the kinds of issues that a Database Consultant typically works on. A learner wishing to become a Database consultant should consider this course as it provides the necessary information to understand Azure cloud solutions and allows the learner to offer more informed advice. The material is practical and hands on.
See salaries and explore the career path for Database Consultant
Cloud Security Engineer
A Cloud Security Engineer focuses on protecting cloud-based infrastructure and data. This course helps a Cloud Security Engineer by teaching them about security implementation in Azure's SQL Server environments. The course provides practical knowledge of security features such as Transparent Data Encryption and Dynamic Data Masking. The detailed security implementations covered in the syllabus, including access control and authorization tools, will help an aspiring Cloud Security Engineer. The course is an excellent starting point for someone interested in the security aspects of cloud based database deployments.
See salaries and explore the career path for Cloud Security Engineer
Cloud Support Engineer
A Cloud Support Engineer provides technical support for cloud-based services and infrastructure. This course may be useful because it covers the practical aspects of deploying and managing SQL Server databases in the Azure cloud. A Cloud Support Engineer needs familiarity with Azure services, SQL Server configurations, and troubleshooting techniques. This course helps build a foundation in these areas. Its focus on Azure, in particular, sets a learner up with the tools and information they will need to handle cloud based database issues. A Cloud Support Engineer should consider enrolling in this course.
See salaries and explore the career path for Cloud Support Engineer
Systems Engineer
A Systems Engineer maintains and improves an organization's computer systems. This course may be useful to a Systems Engineer by providing an understanding of database systems within the Microsoft ecosystem. The course covers SQL Server provisioning, cloud deployments, and security measures, which are all aspects of maintaining a robust IT infrastructure. The knowledge of Azure services, cloud migration strategies, and virtualization techniques in this course helps build a strong foundation for a Systems Engineer. The material covered in the course introduces the learner to the tools they will use in their career.
See salaries and explore the career path for Systems Engineer
Solutions Architect
A Solutions Architect designs and oversees the implementation of IT solutions that address specific business problems. This course may be useful to a Solutions Architect as it provides in-depth knowledge of Azure database services and how to deploy and manage SQL Server in the cloud. A Solutions Architect would use this knowledge to design and integrate database solutions into larger systems. The course's practical approach, from Azure subscription setup to database security, provides a foundation that may be beneficial for a Solutions Architect. The coverage of virtualization techniques is also helpful.
See salaries and explore the career path for Solutions Architect
IT Project Manager
An IT Project Manager oversees technology projects, including database deployments. This course may be useful because it provides an understanding of the technical aspects of SQL Server provisioning in the cloud. While not directly a hands-on technology role, an IT Project Manager will be better positioned to manage a project by understanding the technical considerations involved in deploying SQL servers in Azure. The course provides a great technical overview of the Microsoft ecosystem and the many services offered by Azure making this a potentially useful course for an IT Project Manager.
See salaries and explore the career path for IT Project Manager
Technical Support Specialist
A Technical Support Specialist provides assistance to users experiencing issues with software and systems. While not a direct match, this course may help a Technical Support Specialist with information on SQL Server deployments, and understanding how databases are provisioned. The focus on Azure services and how to navigate the Azure portal also means that a Technical Support Specialist will be better equipped to help a user in a cloud based environment. The practical and hands-on nature of the course will give a technical support specialist exposure to systems they may encounter in their day to day work.
See salaries and explore the career path for Technical Support Specialist
IT Auditor
An IT Auditor evaluates the effectiveness of IT controls and processes. This course may be useful because it provides a detailed look into how SQL databases are deployed and managed in the Azure cloud environment. By understanding the practical aspects of setting up and securing SQL databases and database systems, an IT Auditor will be better positioned to identify potential vulnerabilities. The course's focus on security implementations, access control, and monitoring tools, all allow for a greater understanding of the database system and its associated risks. This knowledge will directly help an IT Auditor carry out their duties.
See salaries and explore the career path for IT Auditor
DevOps Engineer
A DevOps Engineer works to streamline the software development lifecycle and deployment process. This course may be useful to a DevOps Engineer because it covers the process of provisioning and managing SQL Server databases within Azure. An understanding of database deployment and management is important to a DevOps Engineer and this course provides a practical hands-on look into that process. The course’s hands-on approach will give a DevOps Engineer the information they need to streamline and automate SQL database deployments. This course may help them understand the intricacies of the process.
See salaries and explore the career path for DevOps Engineer
Data Analyst
A Data Analyst interprets data using various tools, including databases. This course may be useful to a Data Analyst by providing a better understanding of how databases are structured, provisioned, and managed, especially in Azure. While the focus of the course is not on data analysis, an understanding of the underlying database infrastructure will help a Data Analyst who will be accessing data from SQL Server. Learning how databases are set up will help the data analyst structure their queries and analysis more efficiently. This course may provide insight into the database architecture itself.
See salaries and explore the career path for Data Analyst

Reading list

We've selected two 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 SQL Server Certification: Provisioning SQL Databases.
Cover image
Microsoft SQL Server 2017 on Linux
Save
Provides a deep dive into deploying and managing SQL Server on Microsoft Azure. It covers various topics, including Azure SQL Database, SQL Server on Azure VMs, and hybrid cloud scenarios. This book is particularly useful for understanding the nuances of running SQL Server in the cloud. It is more valuable as additional reading than it is as a current reference, as it provides a broader perspective on the topic.
Microsoft SQL Server 2017 on Linux
Paperback
Check
Microsoft SQL Server 2017 on Linux
Kindle Edition
Check
Cover image
SQL Server 2022 Administration Inside Out
Save
Provides a comprehensive guide to SQL Server 2019 administration, covering topics such as installation, configuration, security, and performance tuning. It valuable resource for understanding the practical aspects of managing SQL Server in both on-premises and cloud environments. This book can be used as a reference tool throughout the course. It adds more depth to the course by providing real-world examples and best practices.
SQL Server 2022 Administration Inside Out
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Similar courses are unavailable at this time. Please try again later.
Effort
8 total hours
Via
Udemy
Instructor
Jeremy Chew
Language
English
Good to know
Prepares learners for the Microsoft exam, "Provisioning SQL Databases," which is a step toward achieving MCSA certification, demonstrating expertise in SQL Server database administration
Explores the integration of SQL Server within the Azure ecosystem, covering both Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) models, which are essential for cloud-based database solutions
Covers security implementations like Transparent Data Encryption (TDE), Dynamic Data Masking (DDM), and Always Encrypted, which are crucial for safeguarding data in cloud environments
Requires learners to create a Microsoft Azure subscription, which may involve costs depending on usage beyond the complimentary services
Focuses on SQL Server 2016, which, while still relevant, may not cover the latest features and updates available in newer versions of SQL Server
Teaches about database migration assistant, which may not be relevant for organizations that have already migrated to the cloud or are using other migration tools
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
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 - 2025 OpenCourser