• $499.00 $399.00
  • 30 Days
0 STUDENTS ENROLLED

    Contact Information

    Email : training@learnfromguru.com
    Phone : 408 - 657 – 4159

    LearnFromGuru’s SQL DBA Training, will introduce to the participants to explore the master  programmers who wants to learn how to  develop the software application.

    Participants will be offered guidance and will share lot of demo’s on each topic with real time examples

    Participants will also get to implement one project towards the end of the course.

    After the completion of the SQL DBA at LearnFromGuru, you will be able to:

    • Install and configure SQL Server 2014
    • Upgrading from older versions like 2005/2008/R2 to 2014
    • Backup and restore databases.
    • Manage security.
    • Managing indexes and finding performance bottlenecks
    • Automate administrative tasks.
    • Replicate data between SQL Server instances.
    • Maintain high availability.[log-shipping, Mirroring]
    • SQL Server 2014 Clustering implentation/administration
    • Impletementing AlwaysOn and administering AlwaysOn groups
    • Data Compression, Resource Governor, Central Management Servers
    • User defined Server roles, Contained Databases, Column store indexes
    • Performance tuning using Profiler, DTA & System monitor

    – This course is intended for IT Professionals who administer and maintain SQL Server databases.

    No prior experience is presumed.

    An Overview of SQL Server 2005/2008/2008 R2 /2012

    • Available Features and Tools
    • New Capabilities
    • SQL Services
    • Product Licensing
    • Product Editions
    • Hardware and software requirements
    • Storage specifications

    Configuring and Installing SQL Server 2008 R2 / 2012

    • Preparing for Installation
    • Creating Users for Service Accounts
    • Choosing Appropriate File Locations
    • Choosing Instance Names
    • Installing SQL Server 2008 R2 / 2012
    • Choosing Appropriate Features
    • Specifying Service User Accounts
    • Choosing Licensing Mode
    • Choosing Appropriate Collation
    • Installing Multiple Instances
    • Upgrading to SQL Server 2008 R2 / 2012
    • Service Packs and hot fix
    • Configuring SQL Server
    • Lab Exercise : Will teach in class room

    Using SQL Server 2005/2008/2008 R2 Management Tools

    • SQL Server Management Studio
    • SQL Server Configuration Manager
    • SQL Server Books Online
    • SQLCMD
    • SQL SERVER Power Shell
    • Lab Exercise : Will teach in class room

    Databases/File Groups

    • System Databases
    • Creating and Populating Databases
    • Describing Data File Structure
    • Describing Log File Structure and Function
    • CAPACITY PLANNING
    • Creating File groups
    • Single instance architecture Multi-instance architecture
    • Working with database schemas
    • Configuring File stream Storage
    • Creating and Using Database Snapshots
    • Moving a Database from one Server Instance to another SQL Server
    • Lab Exercise : Will teach in class room

    Backups and Restore

    • Choosing Appropriate Database
    • Recovery Model Option
    • Describing Automatic Recovery
    • Choosing an Appropriate Backup Strategy
    • Determining Backup File Contents
    • Designing a Database Recovery Plan
    • Using Backup Compression
    • Use of File groups in a Backup Strategy
    • Restoring the Master Database
    • Rebuilding System Databases
    • Configure Data Compression
    • Lab Exercise : Will teach in class room

    Automating Tasks

    • Creating Maintenance Plans
    • Job Creation and Execution
    • Creating Schedules for Jobs
    • Configuring and Using Database Mail
    • Lab Exercise: Will teach in class room

    Importing and Exporting Data

    • Using the Import/Export Wizard
    • Using Integration Services to Import Data
    • Lab Exercise : Will teach in class room

    Security

    • SQL Server Security Architecture
    • Defining Principals and Securables
    • Using the Security Hierarchy
    • Creating Logins and Users
    • Applying Password Policies to SQL Logins
    • Creating Roles
    • Granting Permissions
    • Using SQLCMD to Test Permissions
    • Creating and Using Certificates
    • Encrypting Data
    • Encrypting Databases
    • Lab Exercise : Will teach in class room

    SQL SERVER Architecture

    • SQL Server Database Engine Architecture

    High Availability

    • Four Nines
    • SLA
    • High Availability Factors

    Mirroring

    • Endpoints creation
    • Configuring Mirroring
    • Mirroring Modes
    • Lab Exercise : Will teach in class room

    Log Shipping

    • Setup the Log Shipping
    • Disaster Recovery Examples
    • Troubleshooting
    • Out of Sync
    • Lab Exercise : Will teach in class room

    Replication

    • What is SQL Replication?
    • SQL Server Replication Concepts
    • Types of Replication
    • SQL Server Roles
    • Pieces of SQL Replication Model
    • Players of SQL Replication Model
    • Creating Replication Admin Account
    • Creating Agent Accounts
    • Adding Replication Accounts to Database
    • Creating Publication
    • Creating Push Subscription
    • Lab Exercise : Will teach in class room

    SQL Server Failover Clustering

    • Windows Clustering
    • Clustering Types
    • MSCS
    • Shared storage
    • Resource Group
    • Heartbeat
    • Quorum Installing SQL SERVER Clustering
    • Troubleshooting
    • Adding a new node ? Failing over to a passive node ? Lab Exercise : Will teach in class room

    Performance and Tuning

    • Using the Windows Performance Tool to Detect the Cause of a Bottleneck
    • Using SQL Server Profiler
    • Using Dynamic Management Functions
    • Interpreting Management Studio
    • Using Activity Monitor
    • Rebuilding and Reorganizing Indexes
    • Using the Database Engine Tuning Advisor
    • Generating and Interpreting Query Plans
    • Configuring the Resource Governor
    • Master Data Services
    • Choosing optimal file size and growth parameters
    • Dedicated Administrator Connection
    • Lab Exercise : Will teach in class room

    SQL Server 2012 AlwaysOn

    • Enhancing the capabilities of database mirroring
    • Database mirroring with multiple databases and multiple mirrors
    • Manually failing over a group of databases
    • Clustering and deployment
    • Multi-site clustering across subnets
    • Automating deployment using AlwaysOn PowerShell cmdlets
    • Monitoring the high-availability configuration using the AlwaysOn dashboard


    Course Reviews

    N.A

    ratings
    • 1 stars0
    • 2 stars0
    • 3 stars0
    • 4 stars0
    • 5 stars0

    No Reviews found for this course.

    Login

    Register

    Create an Account
    Create an Account Back to login/register
    X