What you'll 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
Requirements
- It is highly recommended that the student takes the following prerequisites courses: Learn T-SQL, SQL administration part 1, SQL administration part 2, and SQL administration part 3, as the course assumes the student I well aware of SQL Server administration.
Description
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;
Who this course is 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.
Instructor
![Raphael Asghar](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 22,293 Reviews
- 122,409 Students
- 25 Courses
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.