Azure Data Fundamentals: Relational Data Management

Azure 2020    |    Intermediate
  • 14 Videos | 1h 43m 43s
  • Includes Assessment
  • Earns a Badge
Relational data management ensures cloud database systems are versatile and functionable. In this course, you'll explore how to work with relational data on Azure, including basic management tasks for relational data such as SQL database and the security features within. You'll then learn about Azure Data Studio, Azure SQL Server Management Studio, SQL Server, and the sqlcmd utility. Finally, you'll learn about SQL Managed Instance, Azure Synapse Analytics, as well as different connectivity issues such as authentication or firewall. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    use different methods for deploying relational data
    describe Azure SQL Database uses and features
    recognize Azure SQL Database security features
    use Azure AD authentication for security
    use Azure Data Studio as a query tool
    use SQL Server Management Studio as a query tool
  • use the sqlcmd utility as a query tool
    describe SQL Server on Azure Virtual Machine
    describe Azure Managed Instance features
    describe Azure Synapse Analytics components and features
    identify different Azure SQL connectivity errors
    identify different Azure SQL connectivity issues
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 59s
    UP NEXT
  • Playable
    2. 
    Deploying Relational Data
    12m 25s
  • Locked
    3. 
    Azure SQL Database
    7m 24s
    FREE ACCESS
  • Locked
    4. 
    Azure SQL Database Security Features
    7m 27s
    FREE ACCESS
  • Locked
    5. 
    Using Azure AD Authentication
    12m 30s
    FREE ACCESS
  • Locked
    6. 
    Using Azure Data Studio
    8m 23s
    FREE ACCESS
  • Locked
    7. 
    Using Azure SQL Server Management Studio
    6m 6s
    FREE ACCESS
  • Locked
    8. 
    Using the sqlcmd Utility
    8m 58s
    FREE ACCESS
  • Locked
    9. 
    Azure SQL Server
    7m 41s
    FREE ACCESS
  • Locked
    10. 
    Azure SQL Managed Instance
    6m 56s
    FREE ACCESS
  • Locked
    11. 
    Azure Synapse Analytics
    5m 59s
    FREE ACCESS
  • Locked
    12. 
    Azure SQL Connectivity Errors
    8m 36s
    FREE ACCESS
  • Locked
    13. 
    Azure SQL Connectivity Issues
    8m 31s
    FREE ACCESS
  • Locked
    14. 
    Course Summary
    51s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Azure Data Scientist Associate: High Availability & Disaster Recovery
COURSE Azure Data Scientist Associate: Non-relational Data Stores
COURSE Data Engineering on Microsoft Azure: Securing Data Access