1 / 4

SQL DBA training

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…

kosmik5
Download Presentation

SQL DBA training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. SQL DBA Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery. 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… SQL DBA COURSE CONTENT 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

  2. SQL DBA 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

  3. SQL DBA 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

  4. SQL DBA 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: http://kosmiktechnologies.com/tableau-training-in-hyderabad/ 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 For More information vist our website: http://kosmiktechnologies.com/

More Related