*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3498-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, KSA 0502283468

Or log in to access your purchased courses
by admin2
Price:  90,000  80,000
2 Month
0 Lessons

Database Admin in Microsoft SQL ServerMicrosoft SQL Server Course (70-765)

This Microsoft SQL Server course is intended for architects, developers, infrastructure specialists, and development leads. Candidates have a working knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. Candidates also have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.

Course Key Learning 

  • Implement SQL in Azure
  • Deploy a Microsoft Azure SQL Database
  • Plan for SQL Server installation
  • Deploy SQL Server instances
  • Deploy SQL Server databases to Azure virtual machines
  • Manage databases and instances
  • Configure secure access to Microsoft Azure SQL Databases
  • Configure SQL Server performance settings
  • Manage SQL Server instances
  • Manage SQL Storage
  • Perform database maintenance

This course covers the skills and knowledge measured by Exam 70-765, at the end of this course, you will have developed the knowledge and skills necessary to pass the Provisioning SQL Databases Exam.


Course Topics

Module 1: SQL Server Components
This module describes the various SQL Server components and versions.

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

Module 2: Installing SQL Server
This modules describes the process to install SQL Server 2016.

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

Module 3: Upgrading SQL Server to SQL Server 2017
This module describes the process for upgrading to SQL Server 2017.

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

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.

  • 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

Module 5: Performing Database Maintenance
This module covers database maintenance plans.

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Module 6: Database Storage Options
Describe SQL Server storage options.

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

Module 7: Planning to Deploy SQL Server on Microsoft Azure
This module describes how to plan to deploy SQL Server on Azure.

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

This course requires that you meet the following prerequisites:

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

🎥 Your FREE eLEARNING Courses (Click Here)


Who Should Attend 

  • Database professionals who administer and maintain SQL Server databases including database maintenance
  • Database professionals who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from SQL Server databases
  • IT Students willing to make career as Database Admin

International Student FEE : USD 500 | 665 CAD | 1,875 AED | 192 OMR


Related Courses

Oracle DBA 11g /12c
Microsoft SharePoint Developer
ASP .Net Core MVC Developer
PHP with MYSQL Web Development Course
Python Programming Course
Big Data Analytics Course

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now

Print Friendly, PDF & Email

Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0312-2169325, 0331-3929217
  • Gulshan Iqbal: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, (Near Rab Medial) Karachi. 021-3498-6664, WhatsApp 0331-3929217
  • INQUIRY: Karachi 02134986664, 03122169325, Lahore 0331-3929217, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • info@omni-academy.com
WORKING HOURS

  • Monday10.00am - 8.00pm
  • Tuesday10.00am - 8.00pm
  • Wednesday10.00am - 8.00pm
  • Thursday10.00am - 8.00pm
  • FridayClosed
  • Saturday10.00am - 8.00pm
  • Sunday10.00am - 8.00pm
WhatsApp Us