
Create a Microsoft and Azure account to access the Azure portal and start with $200 credit for 12 months of free services; explore sql databases, storage, and the dashboard.
Connect to on-premises sql server via ssms. Compare it with azure sql databases and learn that azure databases are self-contained, isolated containers; practice creating, using, and querying a prod database.
Learn to deploy and manage an Azure SQL managed instance via PowerShell or GUI, access via a jump box and SSMS, and assess on-premises migrations.
Use the Azure SQL Database calculator to determine the best DTU or vcore model by collecting on-premises performance data and testing with a SQL stress utility to guide migration decisions.
Learn how to restore a deleted Azure SQL database, navigate deleted databases, review and restore, and avoid ongoing costs by deleting resources after restoration.
The following course ‘Azure SQL Server for Beginners part 1 of 2’ will guide you step by step in learning about cloud technology called Azure SQL databases. The course will cover subject matter such what is azure SQL databases, option for selecting the best model to fit your company needs, pricing tiers, resource consumption models, securing your azure database, migrating your database and virtual machines from on premises to azure cloud, migration options, firewall rules, setting up disaster recovery modes, geo replicating your servers and databases across the globe.
The student will get first hand exposure to a technology that is revolutionizing the way the SQL dba performs his job. With this knowledge, the SQL dba is positioning himself/herself at the front line with market being so competitive. Getting hands on knowledge on how to manage and migrate database from your on-premises to the azure cloud is a demanding field that every SQL dba needs to know. Having this experience in azure cloud technology will enable the student to not only work on azure platform, but will give him the opportunity to see the working of other cloud technologies such as AWS; as the principles of cloud technology will be somewhat similar. So, join this great course and begin a chapter that will make you more desirable by recruiter and companies and give you the edge over your peers in your own company