• India, EUR | EN
  • + Add an Event
  • Login
    Mumbai, + 50 km
    Home / Events / Azure SQL Server Dba Training and Josupport
    Azure SQL Server Dba Training and Josupport

    Tickets to Azure SQL Server Dba Training and Josupport

    Online
    Hyderabad
    Find in other city
    Date and time
    Description
    Photo and video
    Location

    Schedule «Azure SQL Server Dba Training and Josupport»

    29
    Sep
    Tuesday Tu-6:00am
    Sep, 2020
    Sep 29 Tu-6:00am
    6:00 AM
    Online  ?
    Siddhi Vinayak Nagar Road, 500081, Hyderabad, Telangana, India

    Description

    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 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 • Swift Language training • 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 • 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 • PHP • Perl Scripting • Qlikview • RUBY Cucumber • Robotics Automation Process , UI Path , AA • SAP SD , BO , FICO , BI / BW , APO, BPC, BASIS , SRM , MM, BODS, HANA • SAP Simple Finance • SAS Clinical , Finance • Sales Force CRM • Shell Scripting • 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 • Unix & Linux Administration • VMWare • WCF, WPF, LINQ, AJAX, SILVER LIGHT • Webservices , SOAP , REST ( JAVA) • Windows 2012 server http://futurepointtech.com/azure-cloud-sql-server-dba-online-training.html Drop a mail info@futurepointtech.com we will get in touch with u