Design and query a relational database in Azure SQL Database

Design and query a relational database in Azure SQL Database, available at $19.99, has an average rating of 4, with 22 lectures, based on 1 reviews, and has 1212 subscribers.

You will learn about Provision an Azure SQL Server Create a database using the Azure portal Set up a server-level IP firewall rule using the Azure portal Connect to the database with SSMS Create tables with SSMS Bulk load data with BCP Query data with SSMS Create database diagram with table relationships This course is ideal for individuals who are Beginners to SQL or Beginners to Microsoft SQL (T-SQL) or Beginners to Azure or Beginners to Databases It is particularly useful for Beginners to SQL or Beginners to Microsoft SQL (T-SQL) or Beginners to Azure or Beginners to Databases.

Enroll now: Design and query a relational database in Azure SQL Database

Summary

Title: Design and query a relational database in Azure SQL Database

Price: $19.99

Average Rating: 4

Number of Lectures: 22

Number of Published Lectures: 22

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Provision an Azure SQL Server
Create a database using the Azure portal
Set up a server-level IP firewall rule using the Azure portal
Connect to the database with SSMS
Create tables with SSMS
Bulk load data with BCP
Query data with SSMS
Create database diagram with table relationships

Who Should Attend

Beginners to SQL
Beginners to Microsoft SQL (T-SQL)
Beginners to Azure
Beginners to Databases

Target Audiences

Beginners to SQL
Beginners to Microsoft SQL (T-SQL)
Beginners to Azure
Beginners to Databases

The Azure cloud platform is more than 200 products and cloud services designed to help you bring new solutions to life – to solve today’s challenges and create the future. Build, run and manage applications across multiple clouds, on-premises and at the edge, with the tools and frameworks of your choice.

Cloud is everywhere. It has completely changed the way businesses think about IT resources and software solutions. Organizations of every type, size, and industry are using the cloud for a wide variety of use cases. Even individuals like you and me are using cloud and cloud services on a daily basis.

Azure is a cloud computing platform from Microsoft. Initially it was called Windows Azure. Later renamed to Microsoft Azure. It is an ever expanding set of services to help you build solutions to meet your business goals. It offers a wide variety of services. For example, we have

Virtual machines running in the cloud for you to host and run your software.
Storage services to store all sorts of data – relational, non-relational etc.
Software development and deployment services.
Networking and Data analysis services.
Artificial Intelligence, Machine learning, Internet of Things etc. The list goes on.

Azure SQL Database is a relational database-as-a-service (DBaaS) in the Microsoft Cloud (Azure).

In this course, you learn how to use the Azure portal,T-SQL and SQL Server Management Studio (SSMS) to:

Create a database using the Azure portal*
Set up a server-level IP firewall rule using the Azure portal
Connect to the database with SSMS
Create tables with SSMS
Create database diagram with table relationships
Bulk load data with BCP
Query data with SSMS

A database in Azure SQL Database is created with a defined set of compute and storage resources.

The database is created within an Azure resource group and is managed using an logical SQL server.

Azure SQL Database creates an IP firewall at the server-level. This firewall prevents external applications and tools from connecting to the server and any databases on the server unless a firewall rule allows their IP through the firewall. Azure SQL Database communicates over port 1433. If you are trying to connect to this service from within a corporate network, outbound traffic over port 1433 may not be allowed by your network’s firewall. If so, you cannot connect to your database unless your administrator opens port 1433.

Course Curriculum

Chapter 1: Microsoft Azure Setup

Lecture 1: Introduction

Lecture 2: What is Azure

Lecture 3: What is Cloud computing

Lecture 4: Benefits of Cloud computing

Lecture 5: Why move to the cloud might be good

Lecture 6: Why cloud computing could be cheaper

Lecture 7: create a free azure account

Lecture 8: How to access Azure Services

Lecture 9: What is SQL Server

Lecture 10: SQL Server Editions

Lecture 11: SQL Server Installation Requirements

Lecture 12: What is T-SQL

Lecture 13: Overview of Azure SQL Database design and query

Chapter 2: Azure SQL Database Server Setup

Lecture 1: Create a database using Azure portal

Lecture 2: Query Azure Database using Query Editor

Lecture 3: Installing SSMS

Lecture 4: Connect to Azure SQL Database with SSMS

Lecture 5: Create tables with SSMS

Lecture 6: Creating database diagrams with relationships using SSMS

Lecture 7: Download and install Microsoft Command Line Utilities 11 for SQL Server

Lecture 8: Bulk load data with BCP

Lecture 9: Query data with SSMS

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 1 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu