Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Understanding Microsoft Azure SQL - PAAS
Rating: 4.1 out of 5(50 ratings)
2,008 students

Understanding Microsoft Azure SQL - PAAS

Learn Azure SQL at your own Pace - Clear and Concise
Created byAnand Rao Nednur
Last updated 8/2018
English

What you'll learn

  • Students will have proficiency in features offered by Microsoft Azure SQL.
  • Get a deeper insight to availabilty and security aspects of Azure SQL
  • Understand backups, restoration procedures and best practices

Course content

1 section • 32 lectures • 1h 35m total length

  • Introduction to SQL Databases in Azure4:50

    Explore Azure SQL databases as a platform as a service, a fully managed relational database. Connect apps to data with monitoring and geo replication for security and availability.

  • Azure SQL Security and Compliance3:57

    Learn how to secure Azure SQL databases with encryption in transit and at rest, data discovery and classification, firewall access control, authentication options, auditing, and threat detection.

  • Database Platform Continuum3:45

    Explore the database platform continuum from on-premise servers to cloud, comparing IaaS and PaaS in Azure SQL, cost, administration, and time-to-market impacts.

  • Azure PAAS Vs IAAS3:43
  • Azure SQL PAAS4:01
  • Database Availability and Backups2:08
  • Build the First Azure SQL DB - PAAS6:03
  • Allowing Inbound connectivity to SQL DB2:19
  • Connect to Azure SQL with SQL Management Studio ( LAB )3:40
  • Connect to Azure SQL with Microsoft Excel ( LAB )2:54
  • Export Database to Blob Storage ( LAB )2:16

    Learn how to export a database to blob storage using the export button, selecting the storage account and container, and verify the backup file in the blob container.

  • Import Database from BACPAC Files in BLOB storage ( LAB )1:16
  • Learn to Verify the state of Export and Import of Azure SQL DB( LAB )1:24
  • Copying the Azure SQL DB / Snapshots2:16
  • Verify Azure SQL DB Copy Operation (LAB)2:08

    Verify Azure SQL DB copy operation by checking for the original and copied databases on the same server, and confirm identical table structures and content via the query editor.

  • Azure SQL - Metrics and Monitoring (LAB)5:51
  • Scaling Azure SQL1:53

    Learn how to scale Azure SQL by configuring vertical scaling, selecting elastic, basic, standard, or premium options, and exploring geographic replication for workloads.

  • GeoReplication - Maintaining redundancy for Azure SQL4:33
  • Geo-Replication - Initiate Failover1:58
  • Did Failover Work? Lets Verify1:44
  • Connection Strings to SQL1:04

    Learn to connect applications to a SQL database using connection strings, including copy-paste code for ODBC or PAGG and modifying password and attributes, with a view of database connections.

  • Sync Azure SQL DB to other Databases - Part I1:30
  • Sync Azure SQL DB to other Databases - Part II3:09
  • Sync Azure SQL DB to other Databases - Part III2:29
  • Sync Azure SQL DB to other Databases - Part IV3:42

    Configure granular data synchronization by selecting specific tables and columns from the hub to member databases, monitor progress, and adjust sync frequency for Azure SQL PaaS.

  • Dynamic Data Masking4:08

    Enable dynamic data masking to limit exposure of sensitive data by masking fields such as phone numbers and credit card digits for non-privileged users, with rules for verification and compliance.

  • Azure SQL Security : Advanced Threat Protection0:56
  • Data Discovery and Classification4:20
  • Vulnerability assesment for Azure SQL3:04
  • Threat Detection1:44
  • Auditing MS Azure SQL4:50
  • Transparent Data Encryption - TDE2:02

Requirements

  • Basic Understanding of Microsoft Azure
  • Passionate to learn cutting edge technologies
  • Zest to do the labs and research as we progress through the course.
  • Microsoft Azure account to do the labs

Description

In this course, students will get an understanding of various features available in Azure SQL . There are theory sessions followed by practical ones. There will be live demonstrations as we progress through the class. There are numerous new features that Azure SQL as on today. You will learn various aspects like database redundancy , security in Azure SQL, geographic replication, metrics and monitoring options , taking snapshots and backups. You will also learn to audit the SQL DB and store the data in storage account for future investigations.

Azure offers a choice of fully managed relational, NoSQL, and in-memory databases, spanning proprietary and open-source engines, to fit the needs of modern app developers. Infrastructure management—including scalability, availability, and security—is automated, saving you time and money. Focus on building applications while Azure managed databases make your job simpler by surfacing performance insights through embedded intelligence, scaling without limits, and managing security threats.

You will see more content in near future . This will include managing SQL with Powershell and Azure CLI

As cloud is a moving target , I am sure there will be new features offered by Microsoft . I will keep this course updated to ensure that you get the latest and greatest stuff in this course at all times.

Happy Learning

Who this course is for:

  • Anyone willing to build career in cloud platforms specifically Azure SQL.

Report abuse