Final Exam: Working with Microsoft Azure SQL

WHAT YOU WILL LEARN

• 

  Recognize the properties of cloud databases and what makes them different from on-premises systems
  

  recall the benefits of cloud-hosted databases and the features which make them powerful storage solutions
  

  delineate the factors to consider when picking the best database for a particular use case
  

  differentiate the characteristics of sql and nosql systems
  

  identify some of the key benefits for adopting azure sql and azure sql databases
  

  create a new azure sql database instance on the azure cloud
  

  view and configure resources consumed by a database and configure access to a database
  

  connect to and run a simple query against azure sql database
  

  execute various transact-sql (t-sql) commands to create a schema and table in a database and run queries against it
  

  download and install the azure data studio desktop client and configure it to connect to azure sql database
  

  set up a notebook to run queries against azure sql database
  

  perform an update and query operation and save it
  

  create a database table and populate it with the contents of a csv file
• 

  execute aggregation queries in transact-sql (t-sql) and view estimated counts
  

  implement and validate table partitioning
  

  execute a query with and without a transaction
  

  manually roll back transactions and view the results
  

  roll back parts of a transaction using savepoints
  

  create nested transactions and use try/catch blocks
  

  enable change data capture (cdc) for a database and table using built-in procedures
  

  view change data capture and disable the feature
  

  set up the visual studio code ide to enable the development and deployment of an azure functions app
  

  create a table that can store json data as a field
  

  run simple and complex queries on json data
  

  use the json_modify function to alter a json structure to write to an azure sql database table