Project Description

SQL SERVER DBA TRAINING

About SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network

As of December 2016 the following versions are supported by Microsoft:

SQL Server 2008

SQL Server 2008 R2

SQL Server 2012

SQL Server 2014

SQL Server 2016

Microsoft makes SQL Server available in multiple editions

Enterprise Edition

Standard Edition

Express Edition

Developer Edition

Who Should Learn SQL Server DBA?

Freshers who want build their career in DBA

IT professionals

SQL Developers

Database server professionals

DBA Salaries across Globe

DBAs play an important and responsible role in every company’s Information Technology (IT) department. DBAs are also very well paid and the average annual salary is more than $100,000 in the USA

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers

MS SQL Alternatives and Competitors

  • Oracle Database
  • MySQL
  • PostgreSQL
  • SQLite
  • Amazon RDS
  • IBM DB2
  • SAP HANA
  • Teradata Database
  • MariaDB
  • Vertica
  • SQL Buddy
  • Ingres
  • Lovefield
  • SQLyog
  • Firebird
  • VoltDB

Numaware Trainings provide completely practical and real time SQL Server DBA Training starts from basics to advanced modules. Get an introduction to the fundamentals of SQL Server and gain proficiency in identifying terminologies and concepts in the SQL Server DBA environment

 Give Miss Call to +91-9916-566-300 for further more details on SQL Server DBA Training

Detailed Course Content

Module1:  Starting with SQL Server

  • Responsibilities of Database Administrator
  • Types of DBAs
  • History of SQL Server
  • Editions of SQL Server
  • Tools of SQL Server
  • Differences between Standard and Enterprise editions Instances types in SQL Server
    • Default Instance
    • Named Instance
  • SQL Server Services
    • Instance aware services
    • Instance unaware services

Module2:  Installing SQL Server

  • Pre-requisites
  • Installation
  • Post Installation verification Session

Module3:  Functioning of Databases

  •  Database
  • Types of Database and Brief explanation
    • System Databases
    • User Database
  • Database Architecture
    • Pages
    • Extents
    • File groups
    • Database
  • Transaction Architecture
  • Creating Database
  • Modifying Database
    • Adding Files
    • Moving and renaming  of Database files
  • Database modes
  • Real time Scenario

Module4:  Security

  • Authentication Types in SQL Server
  • Types of Login
    • Windows Login
    • SQL Login
  • Creating Users and Logins
    • Server roles
    • Password policy
    • Understanding Database and Server Roles
    • Permissions
    • Working on access level issues
    • Orphan users Finding and Fixing
    • Important Queries

Module5:  Database Backups and Restoration

  • Database Backups
    • Why we need backups
  • Types of Backup
    • Full Backup
    • Differential Backup
    • Transaction Log Backup
  • Copy-only, Mirrored, Split and Tail log Backups
  • Differences between backups
  • Backup Strategy
  • Understanding how the data moving from Log to Data File, CHECKPOINT
  • Monitoring the space usage of Log File and fixing
  • Checking the backup files VALID or CORRUPTED
  • Backup storage tables
  • Important Queries
  • Performing Restorations
    • Types of Restoration
    • Attach and Detach
    • Shrinking files

Module6:  Recovery Models of Database

  • Types of Recovery Models
    • Full
    • Bulk Logged
    • Simple
  • Differences between Recovery Models
  • Setting Recovery Models according to the Scenarios with examples

Module7:  Automation of SQL SERVER

  • Working with SQL SERVER Agent
    • Creating Jobs
    • Managing Jobs and Resolving issues
    • Monitoring Jobs
    • Monitoring Tables
  • Log Shipping
  • Mirroring
  • Replication
  • Clustering

HIGH AVAILABILTY CONCEPTS

Module8:  Log Shipping

  • Log Shipping
  • Working with Log Shipping
  • Terminology
  • Pre-requisites to implement Log Shipping
  • Different modes of Log Shipping
  • Configuring Log Shipping
  • Monitoring
  • Manually Performing Failover
  • Log Shipping Tables

Discussing Real Time Scenarios

Module9:  Database Mirroring

  • Working with Database Mirroring
  • Terminology
  • Pre-requisites to implement Mirroring
  • Pre check mirroring ports ENABLED or DISABLED
  • Architecture
  • Operating Modes
  • Differences between Modes
  • Port numbers involved in Mirroring
  • Requirements for Mirroring
  • Configuring Mirroring
  • Mirroring failover
  • Issues on Mirroring

Module10:  Replication

  • Working with Replication
  • Terminology
  • Pre-requisites to implement to Replication
  • Types of Replications
  • DISTRIBUTOR Database
  • Agents involved in Replication
  • Configuring Replication
  • Resolving Issues

Module11:

Clustering

  • Introduction about clustering
  • Clustering Architecture
  • Importance of IP’s involved in Clustering
  • SAN importance
  • Drive dependency
  • Nodes in Clustering
  • Important commands

Module12: SQL Server 2012 Always On

Windows Server Failover Clustering (WSFC)

  • Database Mirroring
  • AlwaysOn Nodes
  • AlwaysOn Storage
  • Synchronous & Asynchronous Mirroring
  • Availability Groups
  • Maintenance Tasks/ Reporting
  • Licensing
  • Security & Performance

Implementing AlwaysOn

  • Building your AlwaysOn Cluster
  • Building your Windows Server Failover Cluster
  • SQL Server 2012 Setup

Configuring SQL Server 2012

  • Configuring SQL Server 2012 AlwaysOn Availability Groups
  • Availability Replicas
  • Availability Modes
  • Failing Over
  • Availability Group Listener

PERFORMANCE TUNING

 Module13:  Monitoring Tools

  • System Monitor
  • SQL Server Profiler
  • SQL Server and Windows Error Logs

Module14:  Database Performance Tanning

  • Indexes
  • Types of indexes
  • Fragmentation in Indexes
  • Types of Fragmentations
  • Database Tuning Advisor
  • Dead Locks
  • Blockings
  • Terminating Processes

Module15:  Managing the SQL Server and Databases

  • Starting SQL Server in Single user mode
  • Changing the Default path of Database files
  • Modifying the Logical and Physical names of database files

Module 16: Process:

  • ITIL Process
  • Ticket, Monitoring Tool
  • Escalation Matrix
  • Maintenance Activities[Daily\Weekly\Monthly]
  • DR Plan
  • BCP Plan
  • RACI Matrix
  • RCA Plan

Module17: New and Upcoming features in SQL Server

  • SQL Server 2014 Features
  • SQL Server 2016 Features

Module18: Interview Preparation

  • Resume Preparation
  • Discussions on Real time scenarios
  • Replying to Questioner mails on subject doubts
  • Resume Preparations

SQL SERVER DBA TRAINER DETAILS

Role : SQL SME (Subject Matter Expert)
Experience : 10+ Yrs of IT Experience across MNC Companies
Technologies : SQL Server, Oracle and PeopleSoft
About Trainer :

Database architect having 10+ Years working experience on SQL Server 2005, 2008, 2008 R2, 2012, SQL Server 2014,2016  Database Administration (DBA). A certified SQL Server database developer and administrator expertise in database design, data modeling, system analysis, installation and troubleshooting of Microsoft SQL Server 2014/2012/ 2008 R2 /2008 in development, test and production environments MNC Certified Corporate Trainer. Trainings are completely practical and Real-Time on live server.

Certifications : Microsoft Certified Solution Associate SQL Server 2012
Microsoft Certified Technology Specialist on SQL Server 2005
Microsoft Certified DBAm
             

Role : Senior Database Engineer
Experience : 6+ Yrs of IT Experience across MNC Companies
Technologies : SQL Server, T-SQL, SSIS, SSRS, Power shell Scripting
About Trainer :

Microsoft Certified DBA with 6+ years good hands-on experience on SQL Server Database Administration and Development. He loves sharing knowledge as trainer to SQL DBA Community and very patience to answering doubts from the candidate and get involved in brainstorming sessions servers.

Certifications : SQL Server 2005 Technology Specialist
Microsoft Certified IT Professional Database Administrator SQL Server 2008
            

SQL SERVER DBA CERTIFICATIONS

We support! You Certify

Numaware Technologies provides certification trainings and also support you with getting certified in desired skill sets.

Microsoft announced significant changes to its certification program, adding five new certifications to the MCSE and Microsoft Certified Solutions Developer (MCSD) programs alone. These certifications are designed to support Windows Server 2016 and Microsoft SQL Server 2016, among other technologies. For database administrators, the new MCSE: Data Management and Analytics may be of most interest, which you’ll learn about later in this section.

SQL SERVER 2014 CERTIFICATIONS

MTA (Microsoft Technology Associate)

The MTA program includes a single database-related exam: Database Fundamentals (98-364). This credential is ideal for students or as an entry-level cert for professionals looking to segue into database support.

MCSA (Microsoft Certified Solution Architect)

Microsoft offers one credential for the Microsoft Certified Solutions Associate (MCSA):

Microsoft SQL Server 2012/2014, which requires candidates to pass three exams:

  • Querying Microsoft SQL Server 2012/2014 (70-461)
  • Administering Microsoft SQL Server 2012/2014 Databases (70-462)
  • Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 (70-463)

SQL SERVER 2016 CERTIFICATIONS

MTA (Microsoft Technology Associate)

The MTA program includes a single database-related exam: Database Fundamentals (98-364). This credential is ideal for students or as an entry-level cert for professionals looking to segue into database support.

MCSA: SQL 2016 Database Development

Exam 70-761: Querying Data with Transact-SQL (development)

Exam 70-762: Developing SQL Databases (beta)

SQL 2016 Database Development, which requires candidates to pass above two exams:

MCSA: SQL 2016 Database Administration

Exam 70-764: Administering a SQL Database Infrastructure (development)

Exam 70-765: Provisioning SQL Databases (beta)

SQL 2016 Database Administration, which requires candidates to pass above two exams:

MCSA: SQL 2016 Business Intelligence Development

Exam 70-767: Implementing a SQL Data Warehouse (development)
Exam 70-768: Developing SQL Data Models (beta)

EARN YOUR CERTIFICATION. BOOST YOUR CAREER

Trainings and Batches

Mode of Training

Numaware provides the following list of trainings according to Trainee or Colleges or Organization preference

  • Classroom Training
  • Online Training
  • Corporate Training
  • Campus Training
  • University Training
  • Virtual Instructor-Led Training
  • Instructor-led Live Classroom Training

Batches Available

We are Flexible with following list of batches as per the student requirements and availability.

  • Regular Batch
  • Weekend Batch
  • Weekday Batch
  • Fast-Track Batch
  • One to One Batch
  • Customized Batch

Flexible Timings

Numaware providing Flexible timings to schedule the Batches according to student-preferred timings at either Morning or Evening

  • Morning : 6.00 AM to 12.00PM
  • Evening : 3.00 PM to 10.00PM

Affordable Fees

We Charge very nominal, least and best price for all trainings when compared to Market or any other institutes with good quality standards and no compromise on commitment of providing Quality of Training.

Digital and Flexible Payment Options are available with Numaware Technologies Pvt. Ltd

  • Cash with Invoice
  • Credit-Card Pay
  • Debit-Card Pay
  • Any Digital-Pay
  • Account Transfer
  • Pay-Tm Transfer

Note: Fee will be finalized after demo session as per the Trainer suggestions and Student requirement.

Numaware Benefits

Numaware Technologies Pvt. Ltd is one of the best training institutes in Bangalore, offering Job demanding IT courses, Niche skills for working professionals, fresher’s, and students to ensure a successful future. We offer 100% placement support, cost-effective courses, real-time project experience, resume support, interview support and more. Our courses will equip you to get jobs in top MNCs and launch a successful career.

TRAINING BENEFITS in Numaware Technologies :

  • Training with IT Industry experts and Certified professional s working in MNC Companies.
  • Importance given to both theory and practice
  • Hands-on experience in real-time projects
  • Assistance in all stages of getting a job
  • Proven track record
  • Limited students in a batch
  • Flexible timings
  • Certification support

STUDENT BENEFITS in Numaware Technologies:

  • Post-training and on-job support
  • Backup classes for missed sessions
  • Remote lab facility, Wi-Fi access and LED TV projection
  • Mock exams and interviews for real-life simulation experience
  • Affordable fees with 2 easy installments

PLACEMENT BENEFITS in Numaware Technologies:

  • Our recruitment team will send you for interviews till you get placed
  • Frequently asked interview Q & A will be shared
  • Resume build support from industry professionals
  • We train you with real cases studies for interviews
  • Emphasis on practical knowledge in everything

Job Demanding Courses

Numaware Trainings is a Platform for Learning Technologies

Learn what really matters

Just work hard and focus on your job… because luck truly favors the prepared!!
All the best for your career

SQL Server DBA Training |Best SQL Server DBA Training Institute in Bangalore |Best SQL Server DBA Training Institute in Marathahalli |Best SQL Server DBA Training Institute in India |SQL Server DBA Online Training |Best SQL Server DBA Online Training Institute in Bangalore |Best SQL Server DBA Online Training Institute in Marathahalli |Best SQL Server DBA Online Training Institute in India |SQL Server DBA Corporate Training |DBA Training | Best DBA Training Institute in Bangalore |Best DBA Training Institute in Marathahalli |Best DBA Training Institute in India |DBA Online Training |Best DBA Online Training Institute in Bangalore |Best DBA Online Training Institute in Marathahalli |Best DBA Online Training Institute in India |DBA Corporate Training |Best Database Administration Training Institute in Bangalore |Best Database Administration Training Institute in Marathahalli |Best Database Administration Training Institute in India