Introduction To Azure Sql Database For Beginners

Get started with Azure SQL Database and SQL Server on Azure Virtual Machines fast and easy! Many live demos included!
What you'll learn
What is Azure Portal and how to use it
How to create and configure your first database on Azure SQL Database
How to configure and manage firewall rules
How to access your Azure SQL Database from on-premises client tools such as SSMS and Azure Data Studio
How to manage your Azure SQL Database Server
How to create and configure an Azure SQL Server Virtual Machine
How to access your Azure SQL Server Virtual Machine using RDP, SSMS and Azure Data Studio
Requirements
Basic knowledge of SQL Server and Databases
Willingness and excitement to learn something new!
Description
Cloud Computing is the future and Azure SQL Database is a major part of it. That's why possessing this skill, is essential in the modern computing Era that we live in.This course does exactly that: it helps you get started with Azure SQL Database (PaaS) and Azure SQL Server VMs (IaaS) in no time!With my course, among other, you will learn how to create and manage Azure SQL Databases and VMs, and access them from your on-premises tools, such as SQL Server Management Studio and Azure Data Studio.WHAT OTHER STUDENTS SAY ABOUT THE COURSE:"It was very straight forward and easy to understand.""The updated course is great! The live demos explain things in simple words, in a step by step manner, making it easier for me to learn Azure SQL.""I really enjoyed the course. The instructor clearly explains all the concepts and the live demonstrations are very useful.""A quick and very good start with Azure SQL Server and Database.""This is a good course i found. Whoever wants to professionally learn and apply on job all the skills here, can easily do that after this course. SQL to Azure migration is ongoing market skill and major requirement. This course shows all steps how to make it possible"WHAT IS THIS COURSE ALL ABOUT?Cloud Computing is the future and databases are the backbone of just about everything in Computing, because data is everywhere. Imagine knowing how to fully manage data in a powerful Cloud Computing platform such as Microsoft Azure. Such knowledge is a must, not only for your personal development as an IT Engineer, Database Administrator or Developer, but also for staying up to date with the latest trends and technologies when it comes to database systems.This course has been carefully designed, in order to help you getting started with Azure SQL Database fast and easy. Via a well-structured curriculum, it starts with the very basics of Azure SQL Database, and then it moves to a more intermediate-level of knowledge on how you can manage your Azure SQL Database Servers both as a platform (PaaS) and Virtual Machines (IaaS).So join me into a journey of more than 7 hours and learn all about Azure SQL Database!AFTER THE COURSE:You will be able to navigate in Azure Portal and create, manage and use resources and services.You will be able to create and configure your first Azure SQL Database Server and database (platform as a service – PaaS).You will be able to configure and manage firewall settings.You will be able to access your Azure SQL Database using your on-premises tools such as SQL Server Management Studio (SSMS) and Azure Data Studio.You will be able to manage your Azure SQL Database Server.You will be able to create and configure Azure SQL Server Virtual Machines (infrastructure as a service - IaaS)You will be able to connect to your Azure SQL Server virtual machine via:RDP (Windows access)SQL Server Management Studio (SQL access)Azure Data Studio (SQL access)PREREQUISITES:Basic knowledge of SQL Server and DatabasesWillingness and Excitement to learn something new!THIS COURSE CONTAINS/OFFERS:8 hours of high-quality video lectures and guidesStep by step live demonstrations and guides that can help you get started with Azure SQL DatabaseDownloadable resources with useful information and linksUseful quizzes for testing your knowledge on each sectionA major practice test in the end of the courseAbility to ask the instructor questions via the Q&A sectionCertificate on course completionAlso: This course is being updated with new educational material on a regular basis.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Azure Terminology - The Main Terms
Section 2: Introducing the Azure Portal
Lecture 3 Section Overview
Lecture 4 Meet Azure Portal
Lecture 5 Section Recap
Section 3: Creating your First Azure SQL Database
Lecture 6 Section Overview
Lecture 7 What are the Available SQL Deployment Options in Azure?
Lecture 8 Creating the SQL Database and Server
Lecture 9 Firewall Settings
Lecture 10 Section Recap
Section 4: Accessing Azure SQL Database
Lecture 11 Section Overview
Lecture 12 Accessing SQL Database from within Azure Portal
Lecture 13 Accessing SQL Database from SQL Server Management Studio
Lecture 14 Accessing SQL Database from Azure Data Studio
Lecture 15 Section Recap
Section 5: Managing your Azure SQL Database Server
Lecture 16 Section Overview
Lecture 17 Azure SQL Server Management Components
Lecture 18 Azure SQL Server Dashboard, Activity Logs and Access Control
Lecture 19 Azure SQL Server Settings
Lecture 20 Azure SQL Server Data Management
Lecture 21 Azure SQL Server Security
Lecture 22 Azure SQL Server Intelligent Performance
Lecture 23 Azure SQL Server Monitoring
Lecture 24 Azure SQL Server Automation
Lecture 25 Azure SQL Server Support & Troubleshooting
Lecture 26 Creating SQL Users for an Azure SQL Database
Lecture 27 Section Recap
Section 6: Managing your Azure SQL Database
Lecture 28 Section Overview
Lecture 29 Azure SQL Database Dashboard and Management Components
Lecture 30 Overview, Activity Log, Tags and Query Editor
Lecture 31 Power Platform
Lecture 32 Azure SQL Database Settings
Lecture 33 Azure SQL Database Data Management
Lecture 34 Azure SQL Database Integrations
Lecture 35 Azure SQL Database Security
Lecture 36 Azure SQL Database Intelligent Performance
Lecture 37 Azure SQL Database Monitoring
Lecture 38 Azure SQL Database Automation
Lecture 39 Support + Troubleshooting
Lecture 40 Section Recap
Section 7: Creating and Accessing an Azure SQL Server Virtual Machine
Lecture 41 Section Overview
Lecture 42 Let's Create an Azure SQL Server Virtual Machine
Lecture 43 Set the Firewall Rules for Virtual Machine and SQL Server
Lecture 44 Accessing the Virtual Machine via RDP
Lecture 45 Accessing the Virtual Machine SQL Instance via SQL Server Management Studio
Lecture 46 Accessing the Virtual Machine SQL Instance via Azure Data Studio
Lecture 47 Section Recap
Section 8: Special Topics (New)
Lecture 48 Tips on SQL Server Agent Functionality in Azure SQL Database
Lecture 49 How to Enable Stretch Database in SQL Server
Lecture 50 Installing Multiple SQL Server Instances on a Single Azure VM
Lecture 51 Migrating a SQL Server Database from On-Premises to the Azure Cloud (New)
Section 9: Putting it All Together
Lecture 52 What Have you Learned in this Course?
Section 10: Learning More
Lecture 53 Bonus Lecture
IT Professionals,Database Administrators,Database Developers,SQL Server Engineers,Technology Managers
Screenshots

#