SQL DBA Online Training and Classroom Training: Completely Practical - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

SQL DBA Online Training and Classroom Training: Completely Practical

Description:

SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 2012 DBA Training. We have been providing Online Training, Classroom Training and Corporate Training for the last SIX years. All our sessions are completely Practical and Real-time. – PowerPoint PPT presentation

Number of Views:240

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: SQL DBA Online Training and Classroom Training: Completely Practical


1
  • SQL School is strongly committed to provide
    COMPLETE PRACTICAL REALTIME Trainings on SQL
    Server Technologies Dev, SQL DBA, MSBI (SSIS,
    SSAS, SSRS) and SQL Azure (Windows Cloud). We
    have been providing Trainings for the last SIX
    years successfully and our trainings are
    guaranteed to ASSURE you the quality you
    expect over LIVE production environment.
  • http//sqlschool.com

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
2
Courses Offered
  • Course 1 T-SQL with SQL Server Basics
  • Course 2 T-SQL with Basic SQL DBA and Advanced
    SQL DBA
  • Course 3 Microsoft Business Intelligence (MSBI
    SSIS, SSAS, SSRS)
  • Course 4 SQL Server Integration Services (SSIS)
  • Course 5 SQL Server Analysis Services (SSAS)
  • Course 6 SQL Server Reporting Services (SSRS)
  • Course 7 Windows SQL Azure
  • ALL SESSIONS ARE COMPLETELY REALTIME PRACTICAL

3
Course2 T-SQL, Basic DBA, Advance DBA Project
  • Real-time ONLINE training on SQL Server 2012
    (DENALI) Design Principles and T-SQL Programming.
    A step by step training course exclusively
    designed with Basic through Intermediate Transact
    SQL (T-SQL) Concepts. The course is carefully
    designed addressing all practical aspects of SQL
    Server fundamentals required for Database
    Administration and Business Intelligence (MSBI)
    areas. Study Material and Practice Material are
    provided during the course. All Sessions are
    Completely Practical.

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
4
T-SQL Basic SQL Server
  • SQL Server Introduction 2008 Installation
  • Services and Service Accounts
  • SQL Server Database Design Planning
  • SQL Server Table Design , Pages compression
    techniques
  • Data Integrity Consistency
  • SQL Server Views and Schemas
  • JOINS and Sub Queries
  • Uses of Indexes and Performance
  • continue..gtgt

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
5
  • Stored Procedures and User Defined Functions
  • DDL Triggers and DML Triggers
  • Cursors Usage and Limitations
  • T-SQL Transactions Concepts Types
  • Locks and Memory Concepts Locking Hints
  • New Features in DENALI (SQL Server 2012)

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
6
Basic SQL Server Administration
  • Blocking Deadlocks Issues
  • Backup Strategies Backup Options
  • Point-In-Time, Partial and Piecemeal Restores
  • Replication Techniques and Monitoring
  • Peer Peer Replication Topology and Limitations
  • Log Shipping Modes and Issues
  • DB Mirroring and Encryption
  • SQL Server Security Client Security
  • Database Object Security
  • continue..gtgt

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
7
  • Security Issues and Audits
  • Data Level Encryptions and Data Security
  • Performance Tuning Tips
  • Import -Export Techniques 
  • Tuning Troubleshooting
  • Security Audits in DENALI
  • DBCC Commands and Management
  • Server Level Audits

8
Advanced SQL Administration
  • Certificates and Signatures
  • Cryptography Security Keys
  • Service Broker Implementation
  • Query Troubleshooting Tuning
  • SQL Server Profiler Filters
  • DB Engine Tuning Advisor
  • Data Movement Procedures
  • SMO and BCP Tools
  • Maintenance Plans SSIS continue..gtgt

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
9
  • SQL CMD Utility Remote Access
  • Database Mail and Alerts
  • Clustering Configuration Issues
  • Cluster Quorum Storage Issues
  • Server and DB Upgrades
  • Policy Based Management
  • MSDTC and Server Linking
  • Client Level Statistics Tuning
  • IO and Memory Issues
  • Optimizing SSIS Packages

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
10
Training Highlights
  • REALTIME PROJECTS
  • Completely Practical
  • Highly Interactive
  • Study Material
  • Interview Guidance
  • Resume Preparation
  • Job Support
  • Certification Material

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL
11
  • For further training details and
  • Free Demo, please visit
  • http//sqlschool.com
  • SQL School
  • 302, Sai Manohar Towers
  • SR Nagar X Roads
  • Hyderabad 500038 (India)
About PowerShow.com