Introduction to Azure SQL Database for Beginners
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 Databases
Willingness and Excitement to learn something new!
THIS COURSE CONTAINS/OFFERS:
8+ hours of high-quality video lectures and guides
Step by step live demonstrations and guides that can help you get started with Azure SQL Database
Downloadable resources with useful information and links
Useful quizzes for testing your knowledge on each section
A major practice test in the end of the course
Ability to ask the instructor questions via the Q&A section
Certificate on course completion
Also: This course is being updated with new educational material on a regular basis.
Who this course is for:
- IT Professionals
- Database Administrators
- Database Developers
- SQL Server Engineers
- Technology Managers
Instructor
Hi, I’m Artemakis, and I’ve spent over 20 years immersed in the world of technology, specializing in AI, automation, databases, data management, cloud computing, and programming. My journey has allowed me to explore and master these fields, and now I’m excited to share my knowledge with you.
As a Certified Cloud, Database, and AI professional and a former Microsoft Data Platform MVP (nine years in a row), I’ve had the privilege of helping thousands of people sharpen their skills in SQL Server, Data Access/Entity Framework, Azure, .NET/C#, AI, Data Management and much more. Whether it’s through video tutorials, articles, public speaking, eBooks, or online courses, my goal is simple: to break down complex topics and make them accessible to everyone.
I’m also the founder of SQLNetHub and GnoelixiAI Hub, where I continue my mission of making advanced technology concepts easier to understand. Throughout my career, I’ve contributed to many renowned technology journals, and I truly enjoy the process of teaching and inspiring others to harness the power of cutting-edge technologies.
So, if you're ready to dive deeper into these fascinating fields and elevate your skills, I invite you to join me in one of my Udemy courses. Let’s embark on this learning journey together!