Course: Provisioning SQL Databases (exam 70-765)
duration: 25 hours |
Language: English (US) |
access duration: 180 days |
Details
In this SQL Server 2016 course you will learn how to create SQL
Server databases ready to use, both on location and in SQL
Azure.
You learn to perform migrations from already installed versions,
upgrading to SQL Server 2016 and installing SQL Server on Azure
virtual machines.
Among topics this course covers are storage options in SQL Server
2016, database security, TDE implementation, performance settings,
implementation of applications to Microsoft Azure SQL databases and
far more.
Result
After this course you will be able to prepare SQL Server databases, both on location and in SQL Azure. You are also prepared for the Provisioning SQL Databases exam 70-765. This exam is part of MCSA: SQL 2016.
Prerequisites
- Basic knowledge of Windows operating systems
- Practical knowledge of Transact-SQL
- Practical knowledge of relational databases
Target audience
Database Administrators
Content
Provisioning SQL Databases (exam 70-765)
Components of a SQL Server 2016 Installation
- start the course
- recognize the SQL Server 2016 components
- describe SQL Server 2016 instances
- describe SQL Server 2016 editions
- describe SQL Server versions
- explain SQL Server 2016 32-bit systems
- explain SQL Server 2016 64-bit systems
- recognize the different SQL Server 2016 architecture layers
- explain SQL Server 2016 CPU usage
- explain SQL Server 2016 Server memory management
- describe parallelism in SQL Server 2016
- explain I/O operations in SQL Server 2016
- describe the various services used by SQL Server 2016
- describe the various account types available in SQL Server 2016
- explain the different network protocols supported by SQL Server 2016
- understand the various hardware requirements for SQL Server 2016
- understand the various software requirements for SQL Server 2016
- describe considerations when implementing I/O subsystems for SQL Server 2016
- demonstrate how to use the SQLIOSim tool in SQL Server 2016
- demonstrate how to use the Diskspd tool in SQL Server 2016
- determine the requirements for a successful SQL Server deployment
Installing and Upgrading SQL Server 2016
- start the course
- explain SQL Server 2016 tempdb files
- describe tempdb attributes
- understand tempdb sizing
- describe SQL installation options
- demonstrate how to install SQL Server 2016
- recognize post-installation best practices
- demonstrate SQL Server servicing installation
- recognize unattended installation options
- perform an unattended SQL Server 2016 installation
- create an upgrade strategy for SQL Server 2016
- recognize the supported upgrade paths for SQL Server 2016
- use the data migration assistance in SQL Server 2016
- explain how to upgrade from SQL Server 2005
- explain how and when to use the in-place upgrade option
- explain how and when to use the side-by-side upgrade option
- describe hybrid and rolling upgrade options in SQL Server 2016
- demonstrate how to use the upgrade advisor in SQL Server 2016
- describe the SQL Server distributed replay feature
- determine the appropriate installation options and features for a given scenario
SQL Server Virtual Machines on Azure
- start the course
- explain SQL Server on Azure virtual machines
- recognize SQL Server Azure VM usage scenarios
- explain per-minute licensing
- recognize the differences between IaaS and on-premises deployments
- demonstrate how to connect to a SQL Server Azure VM
- demonstrate how to migrate a database to a SQL Server Azure VM
- perform a backup of a database to an Azure storage account
- perform a restore from an Azure storage account to an Azure VM
- configure automatic patching and updating of an Azure VM running SQL Server
- describe the customer experience improvement program (CEIP)
- explain service tiers in SQL Server 2016
- describe common service tier use cases
- demonstrate how to create a sysadmin account
- explain elastic database pools
- describe when to use the appropriate service tier
- explain SQL Server 2016 database transaction units
- describe how to provision an Azure SQL Server 2016 database
- demonstrate how to create an Azure SQL Server 2016 database
- demonstrate how to connect to an Azure SQL Server 2016 database
- determine when to deploy SQL to Azure VMs and databases
SQL Server Instances and Storage Considerations
- start the course
- describe SQL Server instances
- explain how to host a SQL Server instance using Azure VMs
- recognize the benefits of using Azure automation
- explain how and when to use Azure Resource Manager
- demonstrate how to deploy SQL Server using templates
- provide an introduction to data storage with SQL Server
- discuss considerations when planning disk storage devices
- explain the different types of RAID configurations
- differentiate between the five SQL Server system databases
- demonstrate how to create user databases in SQL Server 2016
- explain the use of filegroups in SQL Server 2016
- describe how SQL Server uses the buffer pool extension
- demonstrate how to configure the storage buffer pool extension
- explain how storage spaces can be used in SQL Server 2016
- describe storage layout considerations when using virtual machines
- describe other possible storage solutions, including NAS, DAS, and SAN
- determine effective disk or storage configuration for a given scenario
Microsoft Azure SQL Database Security
Azure SQL Database Encryption
- start the course
- provide a general overview of transparent data encryption
- demonstrate how to use transparent data encryption
- demonstrate how to use transparent data encryption commands and functions
- describe the TDE catalog views in SQL Server 2016
- describe the TDE dynamic management views in SQL Server 2016
- describe considerations when implementing TDE
- demonstrate how to enable TDE using the Azure portal
- demonstrate how to enable and disable TDE using PowerShell
- demonstrate how to disable TDE using the Azure portal
- describe how to move a TDE protected database
- describe the Always Encrypted database engine feature
- recognize when to use the Always Encrypted feature in SQL Server 2016
- configure Always Encrypted in SQL Server 2016
- describe the available database permissions in SQL Server 2016
- understand the encryption key hierarchy in SQL Server 2016
- recognize when to use cell-level encryption
- describe the security permissions required for cell-level encryption
- demonstrate how to encrypt data using simple symmetric encryption
- configure encryption for Azure SQL Databases
SQL Server Performance Settings
- start the course
- describe how to evaluate and tune database performance
- demonstrate how to improve performance by changing service tiers
- configure elastic database pools to scale resources automatically
- configure the database scope in SQL Server 2016
- demonstrate how to configure memory options including min server memory and max server memory
- demonstrate how to configure and view memory options using T-SQL
- describe the three approaches you can use to manage memory when running multiple instances of the database engine
- describe the role of operators in SQL Server 2016
- demonstrate how to create an operator in SQL Server 2016
- perform the necessary steps to delete an operator in SQL Server 2016
- demonstrate how to configure operator availability in SQL Server 2016
- edit an existing operator in SQL Server 2016
- access and view operator information in SQL Server 2016
- demonstrate how to designate a fail-safe operator in SQL Server 2016
- configure alerts based on monitoring metrics in SQL Server 2016
- create an alert rule on a metric within the Azure portal
- assign alerts to an operator in SQL Server 2016
- manage alerts in SQL Server 2016
- optimize SQL Server 2016 database performance
Deploying Applications to Microsoft Azure SQL Databases
- start the course
- explain the difference between single-tenant and multi-tenant data architectures
- recognize the architectural considerations that influence choosing between a single vs multi tenant
- explain considerations, such as economic, security, tenant, relating to multiple tenants
- describe how to manage multi-tenant data in SQL Server 2016
- describe the benefits of partitioning and isolating tenant data
- demonstrate how to manage deployments that support multiple tenants
- recognize the various steps and considerations involved with migrating on-premise SQL Server databases to Azure
- recognize the tools available to test for SQL Database compatibility
- describe how to migrate a non-SQL Server database
- demonstrate how to migrate a SQL Server database using the Microsoft Azure database wizard
- compare the bacpac export and transactional replication migration methods
- demonstrate how to create a BACPAC file to use in a database migration
- explain the Azure data factory
- describe the data transformation activities supported by Azure data factory
- discuss how to install the data management gateway
- create linked services that connect to data sources in Azure data factory
- define and create tables to specify how to access datasets
- demonstrate how to define, create, and start the pipeline
- manage data using the Azure Data Factory
Azure Virtual Machines
- start the course
- describe the primary migration methods available when migrating to Azure VMs
- describe how to use the Azure VM deployment wizard
- describe alternative deployment options such as backing up to a file and URL
- demonstrate how to detach and copy to URL and attach from URL using the AzCopy command line utility
- explain the Microsoft Azure import/export service
- describe the benefits of generating benchmark data
- explain why it is important to perform cache warming prior to gathering benchmark data
- describe the Iometer tool and how it can be used to gather benchmark data
- demonstrate how to use the IOMeter tool to gather benchmark data
- explain how the FIO tool can be used to gather benchmark data on Azure VMs
- explain how to effectively tune data disks in Azure
- describe how VM disk caching works
- explain how using data compression reduces overall I/O
- describe the different types of platform events that can affect the availability of VMs
- demonstrate how to configure multiple VMs in an availability set for redundancy
- configure each application tier into separate availability sets for redundancy
- describe the benefits of combining Azure load balancer with availability sets
- configure multiple storage accounts for each availability set
- migrate data using the Microsoft Azure VM wizard
Migrating Client Applications
- start the course
- explain the role of connection strings
- describe the use of connection strings in Azure
- discuss how to create connection strings for Azure storage accounts
- create a connection string using a shared access signature
- create a connection string to an explicit storage endpoint
- parse a connection string from a configuration file
- develop application retry connection logic
- describe the different options for distributing network traffic using Azure
- describe the traffic manager feature found in Azure
- explain the priority traffic routing method
- explain the weighted traffic routing method
- explain the performance traffic routing method
- describe the 1-tier application pattern
- explain the 3-tier application pattern
- explain the presentation tier scale out application pattern
- describe the business tier scale out application pattern
- describe the 2-tier and 3-tier presentation and business tiers scale out and HADR application pattern
- describe the 2-tier and 3-tier using the Azure VMs and Cloud services application pattern
- explain the N-Tier hybrid application pattern
- demonstrate how to create a traffic manager profile
Course options
We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.
Optional practice exam (trial exam)
To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.
Optional practice lab
To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
WHY_ICTTRAININGEN
Betaal in termijnen
| Cursusnaam | |
| Looptijd | |
| Rentebedrag financiering | |
| Totaal bedrag | |
| Maandbedrag |
Gespreid betalen met Spraypay
Met de betaaloptie SprayPay kun je jouw bestelling van € 250,- tot € 3.500,- veilig en gespreid betalen in gelijke termijnen van 12, 18, 24 of 36 maanden. Je hebt op die manier een minimale financiële belasting en je kunt eenvoudig de termijnbetalingen opnemen in jouw vaste lasten.
Hoe werkt het kopen op afbetaling? De beoordeling van de kredietaanvraag vindt online plaats. Binnen enkele seconden weet je of je in aanmerking komt voor een krediet. Is de aanvraag akkoord dan kun je meteen genieten van je aankoop.
Let op: deze betaalmetode is aleen beschikbaar voor particulieren! Bekijk voor je aankoop ook de SprayPay voorwaarden.
Via ons opleidingsconcept bespaar je tot 80% op trainingen
Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo
Spar met medecursisten en profileer je als autoriteit in je vakgebied.
Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl
Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers
Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten
Orderproces
Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.
read more about the order process
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
What is included?
| Certificate of participation | Yes |
| Monitor Progress | Yes |
| Award Winning E-learning | Yes |
| Examination possible | Yes |
| Mobile ready | Yes |
| Sharing knowledge | Unlimited access to our IT professionals community |
| Study advice | Our consultants are here for you to advice about your study career and options |
| Study materials | Certified teachers with in depth knowledge about the subject. |
| Service | World's best service |
Platform
Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.
FAQ
Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.