NOTICE: Many events listed here have been canceled or postponed due to the Covid-19 emergency. It is best to call ahead or check with organizer's websites to verify the status of any local event.

Change Location × India

    Recent Locations

      AZURE Cloud SQl DBA Training in Hyderābād

      • AZURE Cloud SQl DBA Training Photo #1
      1 of 1
      November 29, 2020

      Sunday   7:30 AM - 8:30 AM

      Plot No:60, 2nd Floor ,Western Hills,, Opp: Sri Chaitanya Junior Kalasala, Behind Arjuna Theatre, Hyd
      Hyderābād, Andhra Pradesh 500072

      • No Performers Listed
      AZURE Cloud SQl DBA Training

      Azure Cloud SQl Server DBA Course Content
      PreRequiste : Candidates should have basic knowledge of SQL DBA technologies and activities to learn this course.

      Course Modules:
      Module 1: Introduction to Azure
      Module 2: Creation of Azure free account and how to use the Azure portal
      Module 3: Implementing virtual machines
      Module 4: Managing virtual machines
      Module 5: Implementing and managing Azure networking
      Module 6: Implementing Azure App services
      Module 7: Planning and implementing storage, backup, and recovery services
      Module 8: Planning and implementing Azure SQL Database
      Module 9: Implementing Azure Active Directory
      Module 10: Administration of cloud resources Using powershell and CLI

      Module 1: Introduction to Azure
      This module introduces cloud solutions in general and then focuses on the services that Azure offers.
       Cloud technology overview.
       Historical details of Cloud technology
       Discussion about virtualization
       Explanation about managed cloud providers before the cloud technologies evolved.
       Discussion about why cloud technologies became popular during late 90’s
       Benefits of cloud technologies
       Discussion about cloud deployment model (public, private and hybrid cloud discussion )
       Discussion about categories of cloud technologies (IaaS, PaaS, SaaS)
       Discussion about Different cloud providers in the market.
       Why Azure cloud is popular in the market
       Azure cloud certifications

      Module 2: Creation of Azure free account and how to use the Azure portal
       Basic requirements to create the azure free account
       Procedure to create free account
       Basic navigation of Azure services within the portal

      Module 3: Implementing virtual machines
      This module introduces the fundamentals of Azure Virtual Machines, and discusses the different ways in which you can deploy and manage them.
       Creation of Windows virtual Machine using Portal and Powershell
       Overview of Azure Resource Manager and virtual machines
       Configuration and discussion about the availability sets, update domain and fault domain
       Configuration and discussion about Proximity placement group
       Configuration and discussion about host groups in azure cloud
       Discussion about different computing family that are exists in the cloud.
       Creation of Windows VM servers and connectivity procedure.
       Discussion about temporary drive on the VM servers.
       Creation of Linux VMs and authentication modes.

      Module 4: Managing virtual machines
      This module explains how to manage virtual machines including configuring virtual machines, configuring virtual machine disks, and managing and monitor virtual machines.
       Managing and monitoring Azure virtual machines
       Discussion about Virtual Machine Disk types
       Adding new drive to existing Virtual Machine
       Expanding the existing drive on the VM server
       Uploading on-premise VHD to storage account
       Converting VHD to Azure managed disk and attached to the Azure VM
       Capture VM images from existing VM
       Deploying a new VM from Captured VM images
       Difference between Stop and De-allocating the Virtual Machine
       Understand and capture VM images and building new server from the OS snapshot.
       Scaling up an Scaling down VM server
       How to assign the static public IP to virtual machine
       How to assign the static private IP to virtual machine
       How to configure Virtual Machine Auto Scaling based on the load on the servers.
       How to create disk snapshots on the VM server and how to create another VM server using the Snapshot disks.
       Creation of golden OS as per the requirement.
       How to add or expand existing drives on Linux servers
       Migration of VMs from one Vnet to another VNet
       Creation and basic administration of Linux machines in cloud.
       Discussion about ssh-key based authentication on Azure Linux servers

      Module 5: Implementing and managing Azure networking
       Overview of Azure networking components and functionality.
       Types of IP addresses.
       Role of Private IP addresses in Azure cloud.
       Virtual Network Benefits.
       Configuring Azure virtual networks.
       Configuring and understanding Network Security Groups.
       Configuring Azure virtual network connectivity.
       Discussion about to how to segment the network into multiple subnets within the Virtual private network
       Setup Network Security Group to control the access between subnets
       Configuring internal and external load balancers.
       Configuring Peering between the Vnets to allow connections between the VNets.
       Configuring the Azure traffic manager to route the connections based on the geo-graphic regions.
       Configuring point-site VPN to connect to Azure resources using private IP

      Module 6: Implementing Azure App services
       Introduction to App Service
       Configuring web apps
       Configuring the Traffic Manager to route the traffic based on the rule assigned.

      Module 7: Planning and implementing storage, backup, and recovery services
       Types of Azure Storages
       Storage access Tires.
       Creating and configuring Azure storage
       How to create the file share and mount the file share within the VMs for sharing the data between the VMs
       Files and file recovery methods using snapshots.
       Scheduling the job for file share using azure recovery vault.
       Migrating and protecting on-premise file system using Azure vault recovery method and scheduling it to take regular files snapshot.
       Usage of Blob, Tables Queue storage.
       Configuring the Azure backup recovery vault.
       How to take the VM server backups and recover the VM servers using the recovery Vault service in Azure
       How to take VM disks snapshots using the recovery vault.
       Scheduling the SQL server backups using recovery vault service.

      Module 8: Planning and implementing Azure SQL Database
       Creation of PASS SQL server
       Understanding Database as a Service
       Difference between On-Prem SQL server and Azure SQL
       Azure SQL pricing model
       Different authentication methods to connect to the Azure SQL server
       Creation of Azure SQL databases using on-premise SSMS
       Exploring the cloud database properties
       Managing Azure SQL Database security
       How to configure and manage DB pools and eDTUs
       Discussion about DTU and eDTU usage model.
       Discussion about difference between DTU, eDTU and vCore based model databases.
       Azure Active directory authentication to connect Cloud SQL server.
       Configuration of cloud firewalls for SQL server and Database for access.
       Monitoring Azure SQL Database
       Backup methods for cloud SQL servers.
       How to maintain and rebuild the indexes on cloud PASS Database.
       How to implement column Encryption on critical tables.
       Configuration Dynamic data masking on the database and its usage.
       Restore and recovery methods for cloud SQL server
       Discussion about Transparent Data Encryption on database.
       Configuring Server level and database auditing in cloud database.
       Configuring alerting and Monitoring for Azure SQL servers.
       Migration of On-premise database to cloud and from cloud to on-premise using multiple methods.
       Configuring Geo-Replication for cloud SQL database
       Data Recovery procedures of PAAS databases and SQL server within the VM as well.
       Configuring the transactional and Merge replication cloud to cloud and cloud to On-premise databases.
       Configuring regular backups on Azure cloud VM’s using cloud recovery vault.
       Configuration of Always on Groups using cloud VMs
       Linking on premise SQL server and Cloud PASS SQL server.
       Different methods to migrate a on-premise database to Cloud VM and Cloud SQL server
       Procedure to do the live migration of On-premise SQL servers to cloud SQL server and Cloud VM SQL server using Database migration Assistant tool, Database Migration Service and backup methods using the storage credential keys.
       Automating tasks using azure Runbooks and using linked servers from Onpremise to cloud.
       How to use AZCOPY tool and Azure storage explorer tool to migrate the data from Onpremise to cloud.

      Module 9: Implementing Azure Active Directory
      This module explains how to implement Azure AD.
       Creating and managing Azure AD tenants
       Configuring application and resource access with Azure AD
       Implementing directory synchronization by using Azure AD Connect
       Configuration of single sign on in azure cloud
       Creation of multiple Azure domain directories.

      Module 10: Administration of cloud resources Using powershell and CLI

      Courses Offerings

      • Amazon Web Services
      • Android
      • AIX Administration
      • Azure cloud
      • Business Analyst
      • BIRT Reporting
      • CA Siteminder
      • CCNA, CCNP Security,
      • Citrix XenApp
      • Cognos 10 BI & Tm1
      • Crystal Reports
      • Data Stage
      • DB2 DBA
      • Dell Bhoomi
      • Dev Ops
      • Dot Net
      • Full Stack Developer
      • Google Web Tool Kit
      • Golden Gate
      • Go Programming
      • Hadoop
      • Hyperion Essabase, Planning, HFR , HFM , DRM
      • IBM APP Connect Enterprise
      • IBM Lotus Notes (Development)
      • IBM Lotus Notes Domino Server Administration
      • IBM Message Broker
      • IBM MQ Series Administration
      • IBM Netezza DBA & Development
      • IBM Tivoli Access Manager
      • IBM Web Sphere Application Server Administration (WAS)
      • IBM Websphere Transformation extender (WTX 8.2)
      • IBM Integration BUS ( IIB )
      • Informatica
      • I Phone
      • Java/J2EE
      • JAVA UI
      • Java Apache Wicket
      • JIRA
      • Linux Administration training
      • Mango DB
      • MicroSoft .NET Technologies (VB.NET, C#, ASP.NET, Wcf ,Wpf ,Mvc)
      • Microstrategy
      • MicroSoft Business Intelligence MSBI
      • MS Power BI
      • MuleSoft
      • OKTA
      • OBIEE 11 g , 12c
      • ODI ( Oracle Data Integrator)
      • Openstack
      • Oracle FUSION APPS SCm / HCM / Financial
      • Oracle APPS – HRMS, SCM, Manufacturing , Technical , ASCP .Dmantra
      • Oracle APPS – Project Accounting
      • Oracle APPS - iProcurement , iSupplier, Sourcing
      • OAF
      • Oracle BI Apps
      • Oracle BI Publisher
      • Oracle DBA 11g
      • Oracle RAC , Data Guard , Performance Tuning,
      • Oracle Fusion SOA
      • Oracle SQL , PL SQL
      • People soft Functional and Technical
      • Qlikview
      • RUBY Cucumber
      • Robotics Automation Process , UI Path , AA
      • SAP Simple Finance
      • SAS Clinical , Finance , Banking
      • Sales Force CRM Development , Administration and Lightening
      • SQL Server DBA
      • Springs and Hibernate , Spring Boot , MicroServices
      • Storage Area Network ( SAN)
      • Tableau
      • Tera Data
      • Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB, Jmeter, Appium
      • TIBCO BW,
      • Tivoli Access Manager & Tivoli Storage Manager
      • Webservices , SOAP , REST ( JAVA)

      Drop a mail we will get in touch with u

      Categories: Education

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.

      Hotels and Airbnbs near AZURE Cloud SQl DBA Training. Book your stay now!