Azure SQL For beginners: SQL,T-SQL, SSMS, Azure Data Studio

Provision and interact with SQL Server Database in the Cloud.

4.00 (9 reviews)
Udemy
platform
English
language
Databases
category
Azure SQL For beginners:  SQL,T-SQL, SSMS, Azure Data Studio
1,205
students
1 hour
content
Jul 2021
last update
$39.99
regular price

What you will learn

Setup Free Azure Account

How to access Azure Services

How to provision an azure SQL Database Server

How to create an azure database

How to query azure SQL Database using azure portal

Connect to Azure SQL using SSMS

Connect to Azure SQL using Azure Data Studio

Create tables

Insert data into database

Update data inside database

Description

Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.

  • Azure SQL Database: Support modern cloud applications on an intelligent, managed database service, that includes serverless compute.

  • Azure SQL Managed Instance: Modernize your existing SQL Server applications at scale with an intelligent fully managed instance as a service, with almost 100% feature parity with the SQL Server database engine. Best for most migrations to the cloud.

  • SQL Server on Azure VMs: Lift-and-shift your SQL Server workloads with ease and maintain 100% SQL Server compatibility and operating system-level access.

Azure SQL is built upon the familiar SQL Server engine, so you can migrate applications with ease and continue to use the tools, languages, and resources you're familiar with. Your skills and experience transfer to the cloud, so you can do even more with what you already have.


Many organizations have an aging or under-engineered data platform strategy.

There's been a significant trend of moving existing systems to the cloud, building new

applications quickly by using the cloud, and offloading some on-premises costs.

You need a plan for how to move some workloads to the cloud. And you need to understand how to set up your organization for success. You also need to understand how the role of a database administrator (DBA)

or data professional stays the same, and what changes you'll have to make. In this module, you'll

start with a brief history of why and how Microsoft built Azure SQL. You'll then learn about

the various deployment options and service tiers, including what to use for your organization, and when..  These options include Azure SQL Database, Azure SQL Managed Instance, and SQL Server in an Azure virtual machine.

Understanding what platform as a service (PaaS) encompasses and how it compares to a traditional SQL Server environment will help you understand what you do and don't get when you move to the cloud.


Content

Azure SQL Database Server Setup

Introduction
What is Azure
What is Azure SQL
Creating Azure Acount
How to access azure services
Create a database using azure portal
Query SQL Database with Portal

Connecting to Azure SQL Database with SSMS

Installing SSMS
Connecting to Azure SQL Database with SSMS
insert data into azure SQL database
Update Data in an azure SQL Database
Delete Data from an azure SQL database

Connecting to Azure SQL Database with Azure Data Studio

Install Azure Data Studio
Connect to Azure SQL Database
Create a new database
Create a table
Insert data and query data

Coupons

DateDiscountStatus
1/8/2022100% OFF
expired

Charts

Price

Azure SQL For beginners:  SQL,T-SQL, SSMS, Azure Data Studio - Price chart

Rating

Azure SQL For beginners:  SQL,T-SQL, SSMS, Azure Data Studio - Ratings chart

Enrollment distribution

Azure SQL For beginners:  SQL,T-SQL, SSMS, Azure Data Studio - Distribution chart

Related Topics

4131524
udemy ID
6/18/2021
course created date
6/20/2021
course indexed date
Bot
course submited by