Learn How To Become an Azure SQL Database Architect
What you'll learn
- 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.
Requirements
- 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.
Description
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!!!
Who this course is for:
- 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.
Course content
- Preview01:18
- Preview01:24
- Preview06:00
- Preview01:07
- Preview02:05
- 00:34Terminology
- 00:33Summary
- 5 questionsQuiz
Instructor
![Mike West](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.1 Instructor Rating
- 12,345 Reviews
- 213,303 Students
- 53 Courses
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.