HOT
blank

Azure SQL Server for Beginners part 2 of 2

IT & Software

Azure SQL Server for Beginners part 2 of 2, available at $79.99, has an average rating of 4.65, with 46 lectures, based on 268 reviews, and has 2221 subscribers.

Rating4.7
Enroll Now

You will learn about This is Azure SQL Server for Beginners part 2 of 2. The students will learn how to manage Azure SQL database family technology on Azure cloud platform. The Azure SQL database consists of databases, virtual machines, managed instances, and elastic pool databases. They will learn how to design, configure, manage, navigate, and deploy SQL database in the cloud. This leading technology will make the student who is interested in the SQL dba career path far more attractive to companies and recruiters. This is a continuation from Azure SQL Server for Beginners part 1 of 2. In Azure part 2, we continue to learn about Azure SQL database and tackle issue such as security, auditing, geo replication, HA solutions such as always on, diagnostics, monitoring of Azure database, setting up linked servers, and creating elastic jobs and much more This course is ideal for individuals who are The course is targeted to those students that have taken the following prerequisites courses: Azure SQL Server for Beginners part 1 of 2, Learn T-SQL, SQL administration part 1, SQL administration part 2, and SQL administration part 3; and is ready to learn and manage SQL database on Azure cloud platform. It is particularly useful for The course is targeted to those students that have taken the following prerequisites courses: Azure SQL Server for Beginners part 1 of 2, Learn T-SQL, SQL administration part 1, SQL administration part 2, and SQL administration part 3; and is ready to learn and manage SQL database on Azure cloud platform.

Enroll now: Azure SQL Server for Beginners part 2 of 2

Summary

Title: Azure SQL Server for Beginners part 2 of 2

Price: $79.99

Average Rating: 4.65

Number of Lectures: 46

Number of Published Lectures: 46

Number of Curriculum Items: 46

Number of Published Curriculum Objects: 46

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

  • This is Azure SQL Server for Beginners part 2 of 2.
  • The students will learn how to manage Azure SQL database family technology on Azure cloud platform. The Azure SQL database consists of databases, virtual machines, managed instances, and elastic pool databases.
  • They will learn how to design, configure, manage, navigate, and deploy SQL database in the cloud. This leading technology will make the student who is interested in the SQL dba career path far more attractive to companies and recruiters.
  • This is a continuation from Azure SQL Server for Beginners part 1 of 2.
  • In Azure part 2, we continue to learn about Azure SQL database and tackle issue such as security, auditing, geo replication, HA solutions such as always on, diagnostics, monitoring of Azure database, setting up linked servers, and creating elastic jobs and much more

Who Should Attend

  • The course is targeted to those students that have taken the following prerequisites courses: Azure SQL Server for Beginners part 1 of 2, Learn T-SQL, SQL administration part 1, SQL administration part 2, and SQL administration part 3; and is ready to learn and manage SQL database on Azure cloud platform.

Target Audiences

  • The course is targeted to those students that have taken the following prerequisites courses: Azure SQL Server for Beginners part 1 of 2, Learn T-SQL, SQL administration part 1, SQL administration part 2, and SQL administration part 3; and is ready to learn and manage SQL database on Azure cloud platform.

When the student has completed the following course ‘Azure SQL Server for Beginners part 1 of 2’ and has completed the subject matter such what is azure SQL databases, option for selecting the best model to fit your company needs, pricing tiers, resource consumption models, securing your azure database, migrating your database and virtual machines from on premises to azure cloud, migration options, firewall rules, setting up disaster recovery modes, Geo replicating your servers and databases across the globe; we will continue to learn in Azure part 2, such subjects as security, firewall rules, auditing databases, monitoring databases, examining performance metrics of databases, creating HA solution such as always on, creating elastic jobs, and setting up linked servers and much more.  The student will get first hand exposure to a technology that is revolutionizing the way the SQL dba performs his job. With this knowledge, the SQL dba is positioning himself/herself at the front line with market being so competitive. Getting hands on knowledge on how to manage and migrate database from your on-premises to the azure cloud is a demanding field that every SQL dba needs to know.     Having this experience in azure cloud technology will enable the student to not only work on azure platform, but will give him the opportunity to see the working of other cloud technologies such as AWS;

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: SQL SERVER AND DATABASE LEVEL SECURITY PART 1

Lecture 3: SQL SERVER AND DATABASE LEVEL SECURITY PART 2

Lecture 4: VIRTUAL NETWORK SQL SECURITY

Lecture 5: AD AUTHENTICATION SECURITY

Lecture 6: AZURE LOGINS ROLES AND PERMISSIONS

Lecture 7: AZURE LOGINS ROLES AND USERS

Lecture 8: AZURE ACTIVE DIRECTORY LOGIN

Lecture 9: TRANSPARENT DATA ENCRYPTION

Lecture 10: TRANSPARENT DATA ENCRYPTION

Lecture 11: DATA MASKING

Lecture 12: AUDITING

Lecture 13: ALERTS

Lecture 14: AZURE SECURITY CENTER

Lecture 15: SQL LOCKS

Lecture 16: SQL DATABASE GEO REPLICATION

Lecture 17: SQL DATABASE GROUP GEO REPLICATION

Lecture 18: SQL ELASTIC DATABASE WITH GEO REPLICATION

Lecture 19: ACTIVE SITE RECOVERY

Lecture 20: ACTIVE SITE RECOVERY DEMO

Lecture 21: AZURE SQL SERVER ALWAYS ON PART 1

Lecture 22: AZURE SQL SERVER ALWAYS ON PART 2

Lecture 23: AZURE SQL SERVER ALWAYS ON PART 3

Lecture 24: AZURE SQL SERVER ALWAYS ON PART 4

Lecture 25: AZURE SQL SERVER ALWAYS ON PART 5

Lecture 26: AZURE SQL SERVER ALWAYS ON PART 6

Lecture 27: AZURE SQL SERVER ALWAYS ON PART 7

Lecture 28: AZURE MONITORING PART 1

Lecture 29: AZURE MONITORING PART 2

Lecture 30: AZURE MONITORING GRAPHS

Lecture 31: AZURE MONTORING DMVS

Lecture 32: AZURE DATABASE DIAGNOSTIC MONITORING

Lecture 33: SETTING UP MONITORING SQL DIAGNOSTIC PART 1

Lecture 34: SETTING UP MONITORING SQL DIAGNOSTIC PART 2

Lecture 35: SETTING UP MONITORING SQL DIAGNOSTIC PART 3

Lecture 36: CREATE ELASTIC JOBS

Lecture 37: CREATE ELASCTIC JOB PART 2

Lecture 38: LINKED SERVERS

Lecture 39: ELASTIC QUERIES

Lecture 40: AD AUTHENTICATION SECURITY SANDBOX

Lecture 41: SCENARIO 1

Lecture 42: SCENARIO 2

Lecture 43: SCENARIO 3 PART 1

Lecture 44: SCENARIO 3 PART 2

Lecture 45: SCENARIO 4

Lecture 46: END OF COURSE WHAT NEXT

Instructors

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 1 votes
  • 3 stars: 16 votes
  • 4 stars: 95 votes
  • 5 stars: 155 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!

You may also like

Top 10 Cloud Computing Courses to Learn in December 2024

Top 10 Devops Courses to Learn in December 2024

Top 10 Cyber Security Courses to Learn in December 2024