Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Microsoft Azure

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!
Rating: 4.4 out of 54.4 (139 ratings)
743 students
Created by Artemakis Artemiou
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

Course content

10 sections • 23 lectures • 2h 6m total length

  • Preview02:29

  • Preview04:26
  • Meet Azure Portal
    2 questions

  • Create the SQL Database and Server
    09:49
  • Preview03:38
  • Creating your First Azure SQL Database
    2 questions

  • Accessing SQL Database from within Azure Portal
    04:26
  • Accessing SQL Database from SQL Server Management Studio
    07:19
  • Accessing SQL Database from Azure Data Studio
    05:04
  • Accessing Azure SQL Database
    2 questions

  • Preview01:40
  • Preview06:26
  • Azure SQL Server Settings
    09:52
  • Azure SQL Server Security
    08:35
  • Azure SQL Server Performance
    03:07
  • Azure SQL Server Support & Troubleshooting
    00:38
  • Managing your Azure SQL Database Server
    2 questions

  • Let’s Create an Azure SQL Server Virtual Machine
    14:20
  • Creating an Azure SQL Server Virtual Machine
    2 questions

  • Set the Firewall Rules
    06:56
  • Accessing the Virtual Machine via RDP
    03:39
  • Accessing the Virtual Machine SQL Instance via SQL Server Management Studio
    05:43
  • Accessing the Virtual Machine SQL Instance via Azure Data Studio
    02:49
  • Accessing your SQL Server Instance on Azure Virtual Machine
    2 questions

  • Tips on SQL Server Agent Functionality in Azure SQL Database
    00:30
  • How to Enable Stretch Database in SQL Server
    15:35
  • How to create a new SQL Login/User with db_owner Permissions on a Database
    01:13

  • What we’ve Learned in this Course
    01:21
  • Practice Test of Introduction to Azure SQL Database
    15 questions

  • Bonus Lecture
    06:59

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 2-hour journey 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:

  • 2 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

Instructor

Artemakis Artemiou
Award-Winning Database Expert, Trainer, Author, Speaker.
Artemakis Artemiou
  • 4.3 Instructor Rating
  • 455 Reviews
  • 4,366 Students
  • 13 Courses

Artemakis is a Senior SQL Server and Software Architect and a former Microsoft Data Platform MVP (awarded for 9 consecutive years). He has over 20 years of experience and he has taught thousands of people to efficiently work with SQL Server, Data Access/Entity Framework, Azure, .NET/C#, Programming and more, via his video tutorials, blog and guest articles, public speaking, eBooks and online courses.

Artemakis published hundreds of articles and videos that explain in simple words, how to perform complex technical tasks and he really enjoys the interaction with the technical communities.

Besides his regular blogging activities, Artemakis is also a guest author on many prestigious online technology journals.

Moreover, he currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).

Artemakis, really enjoys sharing hands-on knowledge on a large set of technology topics, and thus helping his fellow tech community members, to easily start using these great technologies. To this end, he is really looking forward to seeing you in his online courses on Udemy!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.