Database Management

MySQL

Training Overview:

Forscher Solutions provides the SQL administrator training program that focuses on the delivery of modules to perform day­to­day management operations on a Wintel SQL database environment, that are deployed on the landscapes within your own or your customer's organization. The training is delivered by Subject Matter Experts currently managing, SQL and Oracle Database landscapes in real time environments. The course and its contents are developed by subject matter experts and solution Architects, who deliver the solutions to Fortune 500 and Top­Notch MNCs around the globe.

Target Audience and Prerequisites:

This training program is designed for candidates with no prior database knowledge or experience, however, Oracle Database and/or windows management experience is highly recommended.This training has been designed and developed from the ground up by training experts, specifically to cater, candidates from background with no prior DB management experience as well.

Course Duration:

Fast Track ­ 5 Days

Normal Track ­ 10 to 12 weekends

Corporates ­ Custom configured per Client requirements and modules required

Module 1: Servers, Network, Storage and Databases:

  • Overview of Servers, their processors and memory

  • Overview of Networking concepts

  • Storage Architecture from the window of a Database administrator

  • What are databases

  • Understanding the need for a database and its applications in enterprise environments

  • Hard Disks and their architecture

Module 2: Windows Server 2012 a DBA perspective

  • Overview of Windows server 2012 OS, its servers, processors and architecture

  • Managing a Windows server from a DBA perspective

  • Basic management and navigation of a Windows Server

  • Overview of Hyper­V and Virtualization

  • SQL and Windows: partners in database simplification

Module 3: Networking and Storage

  • Understanding the Networks: Ethernet and Fiber channel

  • Networking protocols in an Enterprise environment: NFS, CIFS, iSCSI, FC and FCoE

  • Understanding SAN and NAS.

  • Advantages of SAN over NAS and vice versa.

  • Basics of Netapp management

Module 4: Database from an SQL perspective

  • What is a DB?

  • Types of Databases and their specific applications in the enterprise environment

  • Why SQL ?

  • Understanding the SQL Database, its Architecture and components.

  • SQL DB management tools and techniques

  • Disks and Storage management from a SQL DB

  • Managing the system and user DBs on a SQL

  • Understanding a buffer pool extension

  • Indexing and DB integrity in SQL

  • Security features of the SQL DB application: Server, DB level security and encryption

  • SQL Tracing; Auditing and Maintenance functionalities

Module 5: Design, Plan, Implement and test an SQL Enterprise Environment:

  • Designing and planning a SQL Database solution for an Enterprise environment

  • Installation and configuration of a SQL Application on a Live Windows Enterprise environment

  • Configuring system and Db parameters after the implementation( This is preset from the Design stage)

Module 6: Management of an SQL Enterprise environment:<

  • Moving Data files

  • Import and export of SQL Database

  • Managing the jobs on a single server to multiple server enterprise environment

  • Security management in an SQL implementation

Module 7: Backup and restoration in SQL on an Enterprise Environment:

  • Recovery Models in SQL

  • Design, Plan and implement a backup strategy

  • Perform backup operations on the developed solution, by backing up DBs and logs

  • Performing an intentional destruction/corruption of a DB

  • Understanding the restoration techniques and processes used in an Enterprise

  • Environment on SQL architecture

  • What is point­in­time recovery

  • Restoring the corrupt file systems

  • Using storage backup solutions to integrate the SQL backup process

Module 8: Monitoring, Troubleshooting and Performance Tuning an SQL environment

  • SQL Dynamic management views and functions

  • Mail management for DM monitoring

  • System performance and relational DB performance

  • Automating Maintenance in an SQL Enterprise environment

  • Alerting mechanisms to a Monitoring tool from SQL perspective