| Course Teaching | You are Offering Professional Course | Locality Kukatpalli |
About Kosmiktechnologies:
KOSMIK is a Global leader in training,development,and consulting services that helps students bring the future of work to life today in a corporate environment.We have a team of certified professionals and experienced faculty working with latest technologies in CMM level top MNC S.
We build students capabilities and leadership skills at every level and every opportunity.We do this to help build internal support, get to real issues, and reach practical recommendations. We bring out the capabilities of students to fully participate in the training and lead any project work. We are passionate about taking on immense challenges that matter to our students and,often,to the world.
About course:
Kosmik technologies is the best institute for SQL DBA training in Hyderabad. we offer class room and online SQL DBA training in Hyderabad by certified faculty. we provide online SQL DBA training institutes in Hyderabad on SQL Server, Managing services, Configuring SQL Server, SQL server Installation, Security, Migrating SQL server.
Course curriculum:
Introduction to SQL Server 2012
Overview on RDBMS and Beyond Relational
System databases
What is new features in SQL Server 2012
SQL Server Component Overview
Components of SQL Server
Protocols
The Relational Engine
The Query Optimizer
Pages & Extents
Pages
Extents [Uniform & Mixed] Managing Extent Allocations
Tracking Free Space
Files and File groups
Primary data files
Secondary data files
Log files
Database File groups [Primary & User-defined]
SQL server 2008R2/2012/2014 Installation
Installing SQL server 2008R2
Planning the System/ Pre-Requisites
Best Practices on Installation
Case Study on Moving System Databases
Upgrading to SQL server
Upgrading the server by applying service packs
SQL Server Upgrade Advisor
In-Place Upgrade to SQL Server 2012
Best Practices to follow while upgrading
Configuring SQL Server
Central Management Services
Best Practices on configuration/Database settings
Network Protocols from SQL Server configuration manager
Temp-db Configuration
Possible failures while shrinking temp-db in SQL Server
Managing services
Starting & Stopping Services through
1. Configuration manager in SQL Server
2. Net Command
Start Up parameters
Starting SQL server in single-user mode command line
starting sql server in minimal configuration mode temp-db
we have 3 case studies such as
1: Resolving temp-db error [Error: 5123] 2: Rebuilding System databases
3: Changing SQL Server Collation in 2008
Migrating SQL server
Difference between in-place & Side by Side Migration/Up-gradation
Migrating database by using Backup and restore method
Using Attach and Detach Method for Migrating database
Migrating Logins [Fixing Orphaned Users] Import & Export
Security
Fixed Server Roles
Availability Groups
User Defined Server Roles
Instance-Wide Settings
Creating Logins
Fixed Database Roles
Database users
Permissions
Indexing
Performance Tuning
Automating Administrative Tasks
Shrinking the log file
Recovery Models
Types of backups
Third party Backup Tools
Recovery states
Log Shipping
Database Mirroring
Clustering
About offered courses:
kosmik Provides online Hadoop, MSBI, Core Java, Data Science, Digital Marketing, Tableau, Android & selenium, hadoop, Testing tools, Python,sales force,manual testing,ect....
For More information vist our website:http://kosmiktechnologies.com/sql-dba-training-in-hy
derabad/
Contact:
KOSMIK TECHNOLOGIES PVT.LTD
3rd Floor, Above Airtel Showroom,
Opp KPHB Police Station,
Near JNTU, Kukatpally,
Hyderabad 500 072. INDIA.
PH.No : (+91) 87 121 86 898
+9140-64648401/02, +91- 8712186898, +91-9032337979
[email protected];
careers@kosmiktech
nologies.com;
[email protected];
info@kosmikt
echnologies.com,
[email protected]
For More information vist our website: http:kosmiktechnologies.com/