Azure Classroomnotes 15/Dec/2022

Azure SQL for mysql

  • This is Database as a Service from Azure
  • Azure SQL is offered as two services
    • Azure SQL for mysql
    • Azure SQL for mysql with flexible servers
      Preview
  • Free plan (12 months)
    Preview
  • Create an Azure SQL for mySQL Instance
    Preview
  • Instance Sizes are similar to VM Sizes
    Preview
    Preview
    Preview
  • Once the Database is created, Lets access.
  • Install Azure Data Studio and install necessary extensions
    Preview
  • Try to create the following
CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

INSERT INTO `employees`.`Persons` VALUES (1, 'one','one','one','one');
INSERT INTO `employees`.`Persons` VALUES (2, 'two','two','two','two');

INSERT INTO `employees`.`Persons` VALUES (3, 'three','three','three','three');

INSERT INTO `employees`.`Persons` VALUES (4, 'four','four','four','four');

select * from employees.Persons;

Preview
* Read Replicas can be created from Replicas section
Preview
* Multi AZ => High Availability
Preview
* We Can Perform
* Backup and Restore
* Server Paramters
* High Availability
* Maintenance Schedule

Pre-req’s for tomorrow’s workshop

  • Azure Account (Free tier)
  • Ensure the following softwares are installed Refer Here
    • Azure CLI
    • Visual Studio Code
    • Git Bash
  • Json and YAML Refer Here

Azure Sql for Postgres

  • Create an Azure SQL for postgres (Free tier)
    • Standard_B1ms
    • storage size upto 32 GB

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner