Showing posts with label practical training on SQL DBA. Show all posts
Showing posts with label practical training on SQL DBA. Show all posts

Tuesday, March 27, 2018

SQL DBA Training In Hyderabad

SQL DBA Training In Hyderabad


SQL Database Administration (SQL DBA) Course
This course is carefully designed for starters as well as for working professionals. Course includes SQL Server Architecture, Understanding Query Design, Query Performance Tuning, Upgrades, Migrations, Troubleshooting, Disaster Recovery (DR) and High Availability (HA) Solutions including SQL Clustering with Always-On (AAG). This SQL DBA course also include Azure SQL Database Dev and Azure SQL DBA. One Real-time Project is included in this SQL DBA course along with Study Material, Resume, Interview FAQs and Placement Support.

** Attend Demo Class on April 2nd at 10:30 AM IST.

Address:#101, 1st Floor, UMA Residency, Opposite Sindhu Travels, Backside to Abhiruchi Tiffins.Beside Metro Station SR Nagar, Hyd - 38 Mobile: (0) 9666440801

Map: https://goo.gl/maps/KRdit9MBM4M2

Contact:: +91 9666 44 0801


Thursday, November 3, 2016

PROJECT ORIENTED REALTIME CLASSROOM TRAINING ON SQL Server DBA 2016/2014

PROJECT ORIENTED REAL-TIME CLASSROOM TRAINING ON SQL Server DBA 2016/2014



SQL School Training Institute is one of the training organizations providing specialized in SQL Server 2012 DBA Training. We have been providing PROJECT ORIENTED REAL-TIME CLASSROOM TRAINING ON SQL Server DBA 2014/2016 Classroom Training and Online Training and Corporate Training for the last Nine years .

All our sessions are completely Practical and Real-time.

PROJECT ORIENTED REAL-TIME CLASSROOM TRAINING ON SQL Server DBA 2016/2014 Course Details :

SQL Server Basics & T-SQL Queries

• SQL Server Design Architecture – 2016/2014/2012

• SQL Server Database Design & Planning

• SQL Server Table Design & Pages

• Table Compression Techniques

• Data Integrity & Consistency

• SQL Server Views and Schemes

• JOINS and Sub Queries

• Uses of Indexes and Performance

• Stored Procedures and User Defined Functions

• Dynamic SQL and TEMP Tables

• DDL Triggers and DML Triggers

• Memory Usage with Triggers

• Cursors Usage and Limitations

• T-SQL Transactions Concepts & Types

• Locks and Memory Concepts & Locking Hints

• New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

• 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

• Security Issues and Audits

• Data Level Encryption and Data Security

• Performance Tuning & Tips

• Import -Export Techniques

• Tuning & Troubleshooting

• Security Audits in DENALI

• DBCC Commands and Management

• Server Level Audits

Advanced SQL Administration(Adv DBA)

• Log Space Issues and Temp-db Issues

• Pro-filer & Activity Monitor and Network Issues

• Partitioning Techniques, DB Snapshots and Usage

• Certificates, Signatures, Cryptography, Keys and TDE
Implementation

• DB Engine Tuning Adviser and Client Statistics

• Optimizing SSIS Packages

• Database Maintenance Plans

• DB Mail & Alert System with Notifications

• Upgrades, Migrations and Service Pack Installations

• SQL Server Fail over Cluster Configuration

• Active Directory Configurations and Storage (SAN) Management

• Active/Active and Active/Passive Cluster Configuration Issues

• SQL Server Cluster Management Operations

• MSDTC and Resource Governor Importance and Usage

• Contained Databases and Always-On Availability Groups

All Sessions are Completely Practical and Real time


Complete Course Details Available @ http://www.sqlschool.com/SQLDBA-Classroom-Training.html

SQL School Training Institute

Schedules for SQL DBA ClassroomTraining


India:
Office : +91 (0) 40 64577244
Mobile : +91 (0) 9666440801

USA:
Office: +1 (510) 400-4845

Address: 108/2RT, Road No 1, SR Nagar, Land Mark : Beside Bus Stop, Hyderabad, India.



Tuesday, November 1, 2016

Microsoft BI SSIS Training From SQL School Training Institute

Microsoft BI SSIS Training From SQL School Training Institute


SQL Server Integration Services (SSIS) From SQL School Training Institute provides offers business data mashup and data modeling capabilities with code-free, interesting user-driven data consolidation (Extract-Transform-Load) operations. This powerful Data Warehouse component offers rich and robust way to search, capture, reuse and publish OLTP Data, Warehouse Design and Loading and data layout objects.
Our SSIS course is designed for starters and professionals who wanted to start/enhance their skillset in Datawarehouse (DWH) Design with ETL, Incremental Loads and Optimal Fact Loads. Study & Practice material, Interview & certifications guidance are included in this course.

All Training Sessions are completely real-time. Study & Practice Material, Certification Guidance, Interview FAQs included in this training.

Benefits of SSIS (ETL / DWH) course:

  • Completely Practical and Realtime
  • Highly Interactive and Interesting
  • Certification Guidance and FAQs
  • One Real-time CaseStudy for SSIS Course
  • 24x7 Server Access with Realtime DBs
  • Benefical for MCSA Exams (MSBI)

After this SSIS course participants shall be able to:

 

  • Design Data Warehouses & Optimal ETL Packages with SCD, CDC
  • Work with Legacy, Fuzzy Data, Iterations, FTP & Script Options
  • Plan for Dimension Loads, Fast Loads, Tuning Options, Debugging
  • Perform Incremental Loads and Fact Table Design, Event Bubbling
  • Exhibit Package Designing & Project Deployment, SSIS Catalogs
  • Schedule SSIS Packages, Command Line Deployments & Migrations



ETL AND MICROSOFT BI (DW) ONLINE TRAINING AT SQL SCHOOL

Course Highlights for SQL Server Integration Services (SSIS) Online Training:

• Database Engine Limitations and Need for MSBI Process

• Configuring SSIS Catalog Database

• Introduction to SSIS Work flow Environment

• Control Flow and Data Flow Operations

• Custom Scripting and Data Import Techniques

• Need for Data warehouses and Design

• ETL with non-SQL Server sources

• SSIS Expressions and Advanced Control Flow

• Variable Usage & Configurations

• Transactions and Isolation Levels in SSIS

• Advanced SSIS Controls

• Variables and Configurations

• Custom Components and Profiling

• Package Configurations & Deployment

• SSIS Utilities and WMI Controls

• Scheduling SSIS Packages

• SSIS Security and Management

• Fast Load and Performance Tuning Options

• Buffer Sizing, Dump Files and TDS Sizing

• SSIS Isolation Levels and Transaction Options

• SSIS Checkpoint Files & SSIS Logging

• Type I, Type II and Type III SCD implementation in SSIS

• SSIS CHECKSUM Transformation

• Error Handling and Event Handling

• SSIS Package Parameters and Configurations

• WMI Events and Use in SSIS

• Migrating SSIS 2005 Packages to 2008 R2 and SSIS 2012

• Package Backups and Version Coding

• Managing MSDB Packages and Monitoring

• ISPAC Files and Package Conversions

• Package Deployment & Management

• SSIS Catalog DB and Management

• SSIS Package Reports and ISPAC Files Security

• MSDB and SSIS Catalog Security Enforcement

• SSIS Server Health and Auditing

• A Real world Scenario

 For Course Schedules and Free Demo Registration @ http://www.sqlschool.com/register.html 


SQL School (SequelGate (I) Technologies Pvt. Ltd.)

OFFICE 1:
#108/2RT, Road No: 1, Beside Bus Stop, 
SR Nagar, Ameerpet, Hyderabad - 38 (India). Map

OFFICE 2:
Sai Anu Avenue, Street Number 3, Patrika Nagar, 
Patrika Nagar, HITEC City, Hyderabad - 81 (India). Map

 India: 0091 (0)9666440801  USA: 001 (510) 400-4845