Demo on 20th Oct
PIMPLE SAUDAGAR :    Tableau(11:00 AM)   |    Angular JS (11:00 AM)   |    AWS(11:00 AM)    |    SAP ABAP (11:00 AM)   |    Selenium (12:00 PM)   |    DevOps (12:30 PM)   |    Python - Data Science (12:00 PM)   |    API Testing (2:00 PM)   |    J2EE (2:00 PM)   |    Hadoop (2:30 PM)   |    DevOps(3:00 PM)   |    SAP FICO (5:00 PM)   | DECCAN :    Selenium (10:00 AM)   |    Python (10:00 AM)   |    MEAN Stack (11:00 AM)   |    Angular (11:00 AM)   |    DevOps (11:00 AM)   |    MVC .NET (2:00 PM)   |    SAP ABAP (2:00 PM)   |    SAP FICO (3:00 PM)   |
ISO 9001:2015 Certified Organization  |  Pearson Exam Center

MS SQL SERVER DBA

Book your Seat by a One-time Registration Fee of Rs.2000/-

Course Overview

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. The primary task of DBA in an organization is to manage the data e.g employee’s data, customer’s data etc.

3RI Technologies is one of the best SQL Server DBA training institute in Pune offering SQL DBA training to candidates. Our classroom training in Pune is conducted by experienced industry professionals at our 2 locations i.e Pimple Saudagar and Deccan. We offer the best in class infrastructure with well equipped labs to our students. Our course is a mix of theoretical and more of practical knowledge wherein live projects, and real time scenarios are discussed and implemented accordingly.Our MS SQL server DBA training in Pune imparts the best training to students with an updated course curriculum. Our trainers also help candidates to get prepared for job interviews by conducting mock sessions and interviews from time to time.

Course Features

  • 100 % Placement Assistance
  • Resume Preparation
  • Interview Preparation
  • Missed Sessions Covered
  • Multiple Batches
  • Flexible Timings
  • Practice Course Material

PREREQUISITES:

  • Knowledge of Basic DBMS

Duration:

  • 60 Hours
  • Who can join this course?

    • Software professionals
    • SQL Developers
    • Database server professionals

    Course Syllabus

    MS SQL SERVER DBA
    1. Introduction To Database Management Systems And Databases
      • What are a database and a database management system (DBMS?)
      • Introduction to Microsoft SQL Server and its overall SQL Server Data Platform
      • History and Current trends of DBMS and Database Administration
      • Tasks of a Database Administrator
    2. SQL Server 2012 Installation.
      • Editions of SQL Server 2012
      • Hardware and Software pre-requisite for a successful SQL Server installation
      • Understanding SQL Server components
      • Perform a successful SQL Server 2012 installation
    3. SQL Server 2012 Administration and Development Tools
      • Using SQL Server Management Studio (SSMS)
      • Using SQL Server Command Line interface
      • Using SQL Server Configuration Manager
    4. SQL Server 2012 Architecture
      • Understanding SQL Server system databases
      • Understanding the SQL Server database structure
      • SQL Server files and filegroups
      • SQL Server Transactional logs
      • What is the difference between SQL Server instance and database
      • Client-Server Communication
      • Attaching and detaching SQL Server databases
    5. SQL Server Database objects
      • Understanding Schemas
      • Understanding SQL Server data types
      • Understanding column properties
      • Creating tables, altering tables and adding constraints, relationships
      • Understanding the filetable
      • Creating database diagrams
    6. SQL Server Backup and Recovery
      • Introduction to Backup and Recovery strategy for databases
      • Full Database backups using SIMPLE Recovery Model
      • Full Database and Transactional log backups with FULL Recovery Model
      • Backup history and maintenance
      • Designing Maintenance plans for Backup Tasks
      • Server Agent for scheduling backups
      • Database Mail for email notifications to DBAs
    7. SQL Server Data Export and Import (Data Movement)
      • Partial Data export and import using the command line tools
      • Partial Data export and import using GUI tools – Export and Import Wizard
    8. SQL Server security
      • SQL Server authentication vs. Windows authentication
      • Auditing database logins using SQL Server Error Logging
      • SQL Server server-wide logins and database specific users
      • Creating user-defined server roles
    9. Performance Tuning
      • Understanding database indexes
      • Understanding SQL Server Profiler
      • Creating Traces
      • Database Mirroring (Advance)(Overview)

    FAQs

    1. Will I get any certificate after this course?

    After the course completion, an exam will be conducted to judge your knowledge along with the live project work completion check and you will be awarded a certificate from 3RI Technologies.

    2. Will I get any placement assistance after the course completion?

    Yes, we provide 100% placement assistance to our students. We have a dedicated team for Placement and tie ups with 300+ MNC’s and SME companies.

    3.Do you provide any demo classes for this course?

    Yes we conduct demo classes every weekend. Please contact us for more details.

    Inquire Now

    

    Student's Reviews about 3RI