Learn How To Become an Azure SQL Database Architect
- 1.5 hours on-demand video
- 1 min on-demand audio
- 6 articles
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- This Course was Designed for SQL Server DBAs moving their Databases to Azure.
- You will be Architecting SQL Server Instances using Windows Azure.
- You'll be learning Azure SQL Database nomenclature and gaining real world insight into how Azure works.
- You'll need a FREE tier account on Windows Azure but don't create one now. We cover this in great detail before we start the course.
- Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
Some Course Reviews from Similar Courses:
"I've also looked at the database with multiple system monitoring products. But really where do I go from here? and when I find the problem what do I really need to do? Mike really shows you the nitty gritty."
"This was just the course I have been waiting for. Mike's demos and scripts have helped me become a confident tuner. The best thing about this course was that I was able to improve our server performance straightaway."
"I already have a great deal of DBA related experienced in the real world. What this course did for me was help me establish a model, and strategy for database tuning and performance monitoring."
Thank you reviewers for your kind feedback.
IMPORTANT: In Microsoft nomenclature there are two portals: Classic Portal and Azure Portal. The Classic one is being phased out. This Course is entirely based on Azure Portal, which is the newest version.
Additionally, this course is NOT for any of the current Microsoft Certifications.
In this course we are going to cover Azure SQL Database. Azure SQL Database is Microsoft’s cloud database service.
Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. Data is hosted, managed and provisioned in Microsoft data centers.
This course takes a hands on, real world approach to working with Azure SQL Databases. While there is some theory most the course will be focused on working with the latest version of Windows Azure.
This course will give YOU the foundation to become more comfortable working inside Windows Azure.
As a SQL Server Consultant I can tell you that many of my customers are MOVING to Windows Azure’s various cloud offerings.
As a matter of fact, 30% of Fortune 500 companies use Azure at some level.
There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.
The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Azure SQL Database. Windows Azure patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.
Enroll Now. Let’s Get Started!!!
- You will need to have a solid understanding of SQL Server fundamentals
- This is not a course for beginners.
- This course was created for SQL Server DBAs preparing to move SQL Server Databases to Azure SQL Database.
In this lecture let's introduce the course.
This course is very specific.
We are going to cover Microsoft's cloud platform SQL Server database called Azure SQL Database.
Is this course right for you?
I want to make sure you know exactly what's in this course.
Let's learn what we are going to cover in this brief lecture.
Before we can migrate our on premise databases to the cloud we will need to create an on premise environment.
You may already have a recent version of SQL Server installed. (SQL Server 2012 on up will do)
If you have an instance already feel free to move to the next lecture.
Before we get our hands dirty we are going to need a Microsoft account.
Let's learn how to create one in this lecture.
You'll need to have an account before you can move forward.