Radical Technologies
Call :+91 8055223360 | 8103400400

MS SQL SERVER DBA

A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. DBA is also responsible for DBA Activities.

Satisfied Learners
One time class room registraion to click here Fee 1000/-

Clasroom training batch schedules:

Location Day/Duration Date Time Type
Pimple Saudagar Weekend 29/02/2020 04:00 PM New Batch Enquiry

Best MS SQL Server Training in Pune 

 SQL Server Training by  Certified Instructors

Trainers : 12 years Exp in  Database Administration

Duration of Training: 8 weekends

MS SQL SERVER DBA SYLLABUS

SQL Server DBA  :  42 Hours ,21 Classes :  Students can feel 5 Year’s experience in DBA experience post completion of course.

 

·        System & User database, SQL Server Architecture (4 hours-  2 Classes)

·        Security (4 Hours –  2 Classes)

·        Backup & Restore, Database Refresh ( 4 Hours – 2 Classes)

·        Installation, Service Patches & DB Upgrades (6 Hours – 3 Classes )

·        DBCC, DMVs and Health Checkup (4 Hours -2 Classes)

·        Database Mirroring (2 Hours -1 Class )

·        Log Shipping (2 Hours -1 Class)

·        Clustering & Always on Availability (6 Hours – 3 Class )

·        Database Maintenance (4 Hours – 2 Class )

·        Database Monitoring (2 Hours -1 Class)

·        SQL Server Replications ( 4 Hours – 2 Classes)

·        Cracking SQL Server DBA Interviews (4 Hours – 2 Classes ) 

 

SQL Server Advanced DBA  :  50 Hours , 25 Classes : Students can feel 6-10 years of DBA Experience post completion of course ( SQL Server Basic + Advanced Course can land you a best opportunity in market)

 

·        DBCC, DMV, Linked Servers, Profiler (4 Hours -2 Classes )

·        Index Management & Fixing Database Corruptions Issue  (4 Hours – 2 Classes)

·        Proactive Health Checkup & Email Alerts ( 4 Hours  – 2 Classes)

·        Index Tuning ( 6 Hours – 3 Classes)

·        Query Tuning (6 Hours – 3 Classes)

·        Server Tuning (6 Hours -3 Classes)

·        Blocking, Deadlocks ( 2 Hours – 1 Class)

·        PerfMon, Extended Events , Recompilations (4 Hours -2 Classes)

·        TempDB Performance, Query Store, Force Plans (4 Hours – 2 Classes)

·        Hints , Filters, Trace Flags, Database Encryptions ( 4 Hours – 2 Classes)

·        DAC Connections, PowerShell for SQL Server (4 Hours -2 Classes)

·        SQL Server for Linux (2 Hours – 1 Class)

 

SQL Server Upgrades & Migrations :  20 Classes  : Course is designed who are interested to upgrades and migrate databases

 

·        Data Migrations Advisor ( 2 Hours – 1 Classes)

·        SQL Server Upgrade :SQL Server 2005 to SQL Server 2016 ( 2 Hours – 1 Class)

·        SQL Server Upgrade :SQL Server 2008 to SQL Server 2016 ( 4 Hours – 2 Classes)

·        SQL Server Upgrade :SQL Server 2012 to SQL Server 2016 ( 4 Hours – 2 Classes)

·        SQL Server Upgrade :SQL Server 2014 to SQL Server 2016 ( 4 Hours – 2 Classes)

·        SQL Server Upgrade :SQL Server 2016 to SQL Server 2019 ( 4 Hours – 2 Classes)

·        In-place Upgrades  (4 Hours – 2 Classes)

·        Side by Side Upgrades (4 Hours – 2 Classes)

·        Migrations from MySQL to SQL Server (4 Hours -2 Classes )

·        Migrations from Oracle to SQL Server ( 4 Hours -2 Classes)

·        Migration from DB2 LUW to SQL Server (4 Hours – 2 Classes)

SQL Server Azure (Cloud )  ( 30 Hours ) : Course is designed for students who want to become SQL Server Cloud Database Experts .

 

·        Azure SQL Server Database Architecture ( 2 Hours -1 Class)

·        Migrating SQL Server On Premise Database to an Azure Database ( 4 Hours – 2 Classes)

·        Backing up Azure SQL Server Database  ( 4 Hours – 2 Classes)

·        Restoring Azure SQL Server Database ( 4 Hours – 2 Classes)

·        Scaling Azure Database ( 2 Hours -1 Class)

·        Elastic Pools in Azure SQL Server Database ( 4 Hours -2 Classes)

·        High Availability and Disaster Solutions in Azure Database ( 4 Hours -2 Classes)

·        Monitoring & Tuning Azure Database ( 4 Hours – 2 Classes

 

Summary
Review Date
Reviewed Item
After taking the guidance from Deepak, I can feel that there is a huge change in the confidence while working on Database. It is my privilege to get an opportunity to learn from his industry experience. Very well organized teaching structure and intellectually motivating.He encourages independent thinking and creates a learning atmosphere. The way he communicates the teaching information is very clear and organized..
Author Rating
51star1star1star1star1star
  • Having over 12.5 Years of Experience in SQL Server Administrative and SQL Development Activities.
  • Good experience with implementing DR solutions, High Availability of databases using Database mirroring, replications, Clustering and Log Shipping.
  • Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types, link servers and Functions.
  • Experience in query optimization and performance tuning Using SQL Profiler, Execution Plan, Performance Monitor etc.
  • Users and databases security management i.e. creating users, roles, granting permissions, policies etc.
  • Good Experience in Database Designing using normalization model.
  • Experience in SQL Server upgrades from SQL Server 2000 to 2005 and 2005 to 2008.
  • Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling SSIS Packages.
  • Configured Active/Active and Active/Passive Cluster with SQL Server 2012 on Windows 2012.
  • Extensive experienceCapacity Planning and sizing for SQL Database Server.
  • Having good Exposure on Team Foundation Server with visual studio 2010.

Our Courses

Drop A Query