Email – Enquiry@GoalsInfoCloud.com | For Pune – 9923115877 | Mumbai/Thane – 9221048123

Email or Phone

SQL Server Training

Microsoft SQL server admins are most demanded in IT organization nowadays. Since most of the candidates think that cloud is the future and trying to get into cloud. There is a big shortage of SQL admins. Considering current requirement in INDIA 2000+ SQL engineers are required. So Learn this amazing technology and give boost to your career. Microsoft SQL training in Pune, Mumbai, Thane, Aundh, Wakad, Pimple Saudagra, Talawade is available now..

2567 Satisfied Learners

Topic 1:- Starting With SQL Server

            Responsibilities of Database Administrator
            Types of DBA’s
            History of SQL Server – Versions
            What’s new in SQL Server 2012 & 2014 for Administrators?
            SQL Server 2008 & 2012 Service Packs
            Editions of SQL Server
            Differences between Enterprise and Standard Editions
            Hardware and software Requirements
            Instances

Topic 2:- Installing and configuring

  • Configuration of Various Services
  • Startup Parameters
  • Configuring data files and log file paths
  • Memory Configuration
  • Remote Connections
  • Configuring network protocols, Ports
  • Configuring Services
  • Configuring default backup folder.

       

Topic 3:- Working With Databases

Working with Databases 

  • System Defined databases
  • Moving System Databases
  • Handling TempDB database 

Database Architecture 

  • Data Files
  • Log Files
  • Filegroups
  • Extents
  • Pages –Types
  • Page Architecture
  • Tracking Free Space
  • Log file full – How to troubleshoot. 

Creating Databases
Adding files, Filegroups

 

Topic 4:- Implementing Security.

Security in SQL Server 2016
Security Enhancements
Types of Authentications. 

  • Windows Authentication 
  1. Creating logins from windows users and groups
  2. Orphan logins

SQL Server Authentication 

  • Creating SQL logins and testing logins
  • Setting Authentication Mode
  • Security Auditing
  • Understanding Server roles
  • Working with users
  • Resolving Orphan users
  • Understanding database roles
  • Understanding permissions
  • Working with certificates and schemas
  • Security catalogue views and stored procedures
  • Major Issues

 

Topic 5:- Backup And Restoration.

Understanding Transaction Log Files
Understanding Checkpoints and Lazy writer
Truncation log file
Recovery ModelsSetting Recovery Model

  1. Full
  2. Bulk Logged
  3. Simple

Database Backups

  • Why we need backups

Backup TypesCopy-Only, Mirrored and Tail log backups

  1. Full
  2. Differential
  3. Transaction Log
  4. File or Filegroup

Backup Devices
Performing Restoration
Backup System Databases
CompressionsUsing LiteSpeed for Backups

  1. Row Compression
  2. Page Compression
  3. Compressing Backups

Point-in-time Recovery
Viewing complete details of backup process
Issues related to backups

 

Topic 6:- High Availability

  • Introduction to High Availability

Working with Log Shipping

  • Features
  • Jobs
  • Requirements to implement Log Shipping
  • Configuring Log Shipping
  • Monitoring Log Shipping
  • Manually performing Fail Over
  • Transferring Logins
  • Log Shipping tables and stored procedures
  • Handling Issues

Working with Database Mirroring

  • Advantages
  • Architecture
  • Operating Modes
  • Server involved in Mirroring
  • Requirements for Mirroring
  • Configuring
  • MonitoringMirroring Fail Over 
  1. Using Mirroring Monitor
  2. Using System Monitor
  3. Using Profiler
  4. Using System views and SPs
  • Mirroring System Tables and Stored Procedures
  • Major issues with Mirroring 

Replication

  • Replication and Advantages
  • New Features
  • Replication Entities
  • Replication Architecture
  • Replication Agents
  • Types of Replications
  • Configuring Replication 
  1. Snapshot Replication
  2. Transactional Replication
  3. Merge Replication
  4. Peer to Peer replication
  5. Managing Replication
  6. Monitoring and Tuning Replication

 

Topic 7:-Automating Administrative tasks

  • Working with Database MailConfiguring Linked Servers
  1. Mail Architecture
  2. Configuring Profiles and Accounts
  3. Sending Mails
  • Implementing Automation
  1. Configuring SQL Server Agent
  2. Creating Operators, Alerts, Jobs
  3. Managing jobs and resolving errors
  4. Monitoring Jobs
  5. Auto alert when jobs are enabled, disabled or failed

 

Topic 8:-Advance Administrative Concepts

  • Maintenance Plans
  • Monitoring and Tuning SQL Server 
  1. Performance counters Setup
  2. Measuring performance of server
  3. Tuning queries
  4. Tuning Databases
  5. Tuning physical architecture of databases
  6. Using DTA
  • Monitoring Tools 
  1. System Monitor
  2. SQL Server Profiler
  3. Database Engine Tuning Advisor
  4. Dynamic Management Views
  5. SQL Server and Windows Error Logs 
  • TroubleshootingLocks 
  1. Physical Server Performance
  2. Connectivity to SQL Server
  3. Database Performance
  • Managing ConcurrencyLocks
    • SQL Server Architecture 
      • Relational Engine
      • Storage Engine
      • Buffer Pool
      • Managing Execution Plans
  • Dead Locks
  • Transaction Isolation Levels
  • Understanding Blocking
  • Terminating Processes
  • Using the DAC
  • Managing Databases 
  1. Manage Index Fragmentation
  2. Manage Statistics
  3. Shrink Files
  4. Performing database integrity checks (DBCC CheckDB)
  5. Index Rebuilding and Reorganising
  6. Migrations
  7. Using DBCC Commands
  8. Resource Governor

 

Topic 9:-Clustering SQL Server

Clustering SQL Server
Overview of windows Clustering
Requirements
Installation and configuration of SQL Server Clustering
Applying Service packs and fixes
Moving groups
Adding node on a SQL Server Failover Cluster
Troubleshooting Cluster issues.

Topic 10:-Always On

HADR Internals & advantages
Setting up HADR
Adding a DB to the AG
Patching in Always on
Adding Replica in AG
Setting up Listener & read-only Replicas in AG
Troubleshooting & maintenance

Topic 11:-Performance Tuning

Blocking
Dead Locking
Index’s Rebuild & Reorganise
Locks Types
Trace Flags
DMV’s

 

Interview Preparation and Exam Preparation at ther end of the training.

 

       

 

Our Courses

Drop A Query

Quick Enquiry