Provisioning SQL Databases, Germany

We can host this training at your preferred location. Contact us!

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

This course requires that you meet the following prerequisites:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

After completing this course, students will be able to:

Provision a Database Server
Upgrade SQL Server
Configure SQL Server
Manage Databases and Files (shared)

Module 1: SQL Server 2016 Components

This module describes the various SQL Server 2016 components and versions.

Lessons

Introduction to the SQL Server Platform
Overview of SQL Server Architecture
SQL Server Services and Configuration Options

Lab : Discussion: SQL Server versions

When we do use a separate installation of SQL Server and when would use a separate instance?
Which version of SQL Server is most suitable in your organization?

Module 2: Installing SQL Server 2016

This modules describes the process to install SQL Server 2016.

Lessons

Considerations for SQL Installing Server
TempDB Files
Installing SQL Server 2016
Automating Installation

Lab : Installing SQL Server

Assess the available resources
Install an instance of SQL Server
Perform post installation checks
Automating Installation

Module 3: Upgrading SQL Server to SQL Server 2016

This module describes the process for upgrading to SQL Server 2016.

Lessons

Upgrade Requirements
Upgrade SQL Server Services
Migrating SQL Server Data and Applications

Lab : Upgrading SQL Server

Create the Application Logins
Restore Database Backups
Orphaned Users and Database Compatibility Level

Module 4: Working with Databases

This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

Lessons

Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving and Copying Database Files
Side-by-Side Upgrade: Migrating SQL Server Data and Applications
Buffer Pool Extension

Lab : Managing Database Storage

Configuring tempdb Storage
Creating Databases
Attaching a Database
Enable Buffer Pool Extension

Module 5: Performing Database Maintenance

This module covers database maintenance plans.

Lessons

Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

Lab : Performing Database Maintenance

Use DBCC CHECKDB to Verify Database Integrity
Rebuild Indexes
Create a Database Maintenance Plan

Module 6: Database Storage Options

Describe SQL Server storage options.

Lessons

SQL Server storage Performance
SMB Fileshare
SQL Server Storage in Microsoft Azure
Stretch Databases

Lab : Implementing Stretch Database

Run Stretch Database Advisor
Implement Stretch Database

Module 7: Planning to Deploy SQL Server on Microsoft Azure

This module describes how to plan to deploy SQL Server on Azure.

Lessons

SQL Server Virtual Machines in Azure
Azure Storage
Azure SQL Authentication
Deploying an Azure SQL Database

Lab : Plan and Deploy an Azure SQL Database

Plan an Azure SQL Database, Networking, performance tiers, security
Provision an Azure SQL Database
Connect to an Azure SQL Database

Module 8: Migrating Databases to Azure SQL Database

This module describes how to migrate databases to Azure SQL Database.

Lessons
Database Migration Testing Tools
Database Migration Compatibility Issues
Migrating a SQL Server Database to Azure SQL Database

Lab : Migrating SQL Server Databases to Azure

Perform Migration Testing
Migrate a SQL Server Database to Azure SQL Database
Test a Migrated Database

Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine

This module describes how to deploy SQL Server on Microsoft Azure VMs.

Lessons

Deploying SQL Server on an Azure VM
The Deploy Database to a Microsoft Azure VM Wizard

Lab : Deploying SQL Server on an Azure Virtual Machine

Provision an Azure VM
Use the Deploy Database to Azure VM Wizard

Module 10: Managing databases in the Cloud

This module describes how to manage SQL Server on Azure.

Lessons

Managing Azure SQL Database Security
Configure Azure storage
Azure Automation

Lab : Managing Databases in the Cloud

Configure Azure Security
Automate Azure Deployment

Provisioning SQL Databases Training Course in Germany

The Federal Republic of Germany is the second most populous country in Europe and is located in Central Europe. The official language of the country is German. Germany is one of the richest countries in the world. The main exports of the country include motor vehicles and iron and steel products.

Here are some fun facts about Germany:
The fairy tale writer, the Brothers Grimm, came from Germany and wrote many famous stories such as Cinderella, Snow White, and Sleeping Beauty.
Germany is home to the largest theme park in Europe, the Europa-Park.
The famous composer Ludwig van Beethoven was born in Germany.
The Autobahn, the German highway system, is known for having no general speed limit.

Berlin was divided by the Berlin Wall from 1961 to 1989. Known for its street art, Berlin has many colorful murals and graffiti throughout the city. Also, Berlin is home to many famous museums, such as the Pergamon Museum and the Museum Island. Many clubs and bars stay open until the early hours of the morning in this big city.

Another popular city is Munich, which is famous for its Oktoberfest beer festival that attracts millions of visitors every year. Munich is also home to many historic buildings, including Nymphenburg Palace and the Marienplatz town square.

The country's capital and largest city is Berlin, however Frankfurt is considered to be the business and financial center of Germany. It is home to the Frankfurt Stock Exchange, the European Central Bank, and many other financial institutions. Because of its central location within Europe and its status as a major financial hub, Frankfurt is often referred to as the "Mainhattan," a play on the city's name and its association with the Manhattan financial district in New York City.

Frankfurt is also a major transportation hub, with the largest airport in Germany and one of the largest in Europe, Frankfurt Airport. Additionally, it is a popular destination for tourists, with its historic city center, beautiful parks, and vibrant cultural scene.

Some of the top German technology companies like Siemens AG, Bosch, SAP SE, Deutsche Telekom, Daimler AG and Volkswagen has business centers in Frankfurt. The country has a strong tradition of engineering and innovation, and is home to many other world-class technology companies and research institutions.

Tailored to meet the specific needs of Germany, Bilginç IT Academy combines cutting-edge training methodologies with our comprehensive range of Certification Exam preparation courses and accredited corporate training programs. Experience a transformative approach to IT training that will redefine your expectations.

Provisioning SQL Databases Training in Germany

Upcoming Trainings

Provisioning SQL Databases Training in Germany

Prerequisites

Who Should Attend

What You Will Learn

Outline

SQL VS NOSQL

Upcoming Trainings