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
    
• Free plan (12 months)
  
• Create an Azure SQL for mySQL Instance
  
• Instance Sizes are similar to VM Sizes
  
  
  
• Once the Database is created, Lets access.
• Install Azure Data Studio and install necessary extensions
  
• 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;

* Read Replicas can be created from Replicas section

* Multi AZ => High Availability

* 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