10000.00 Dollar US$ Sql DBA Classroom Training In India Hyderabad

Mark as spam misclassified duplicated expired offensive

Other Classes Published date: March 8, 2018
  • Address: #307, 5th Floor, Liberty Plaza, Opp: Stanza, Himayat Nagar, Hyderabad - 500029.
  • City: Hyderabad
  • State: Telangana

SQL DBA TRAINING


 

 

INTRODUCTION TO THE SQL SERVER:

Microsoft SQL Server is a relational database server, developed by Microsoft. it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network.



  • DBMS

  • RDBMS

  • Data Models

  • Introduction to SQL SERVER

  • History of SQL SERVER

  • Software And Hardware Requirements

  • IP Configuration, Domain Creation

  • Client-Server Architecture

  • IIS Configuration

  • Installation Process

  • Services, Checks after installation

  • Architecture of SQL SERVER 2005

  • Server startup process


TOOLS IN SQL SERVER 2005


  • Management Studio(SSMS)

  • BI Tools(BIDS)

  • Configuration Tools

  • Performance Tools(Profiler)


ENABLING REMOTE CONNECTIONS


  • TCP/IP

  • Named Pipes


CHANGING PORT NUMBERS

AUTHENTICATIONS


  • Windows Authentications

  • SQL Server Authentications


SECURITIES


  • Logins

  • Users

  • Roles

  • Password Management

  • Database Assignment

  • Privileges

  • Schema


DATABASES


  • System Databases

  • User Databases


DATABASE DESIGNING


  • Creating Database

  • Altering Database


FILES AND FILE GROUPS


  • Data Files

  • Log Files

  • Primary File Group


MEMORY ARCHITECTURE


  • Data Pages

  • Header and Description

  • Extents


TRANSACTIONS IN SQL SERVER


  • Commit

  • Rollback

  • Buffer

  • Checkpoint


RECOVERY MODELS


  • Full

  • Bulk Logged

  • Simple

  • Non Logged Operations


COMPATIBILITY


  • 2005

  • 2000

  • 7.0


BACKUPS AND PLANNING


  • Full

  • Differential

  • Transaction Log

  • Files and File Groups

  • Temporary

  • Jobs and Schedules

  • Back up Device

  • Append and Over write


RESTORATIONS


  1. Complete restoration

  2. Point in Time restoration

  3. Restoration Options


OLTP AND OLAP

IMPORT AND EXPORT

SSIS



  1. Migrations

  2. SSIS Vs DTS Packages

  3. Transformations


UP GRADATION

Replication



  • Publisher

  • Publication

  • Subscriber

  • Subscription

  • Distributor

  • Agents

  • Snap Shot Publication

  • Transactional Publication

  • Merge Publication

  • Replication monitor


LOG SHIPPING


  • Primary Servers

  • Secondary Servers

  • Monitoring Servers

  • Jobs and Schedules

  • Blocking of Jobs

  • High Availability


MIRRORING


  • Principle Server

  • Mirror Server

  • Witness Server

  • Mirror_Error

  • Stand by Server


SQL SERVER AGENT


  • Jobs

  • Schedules

  • Alerts

  • Operators

  • Error Logs


DATABASE MAIL

MAINTENANCE PLAN


  1. Through SSMS

  2. Through SSIS



  • Overview of ClusteringPerformance Tuning

  • PERFMON

  • SQL LITESPEED

  • SQL DIAGNOSTIC MANAGE

  • LOG READER

  • DBCC

  • SYSTEM STORED PROCEDURES

  • REGULAR, WEEKLY AND MONTHLY ACTIVITIES

  • TROUBLE SHOOTING

  • INTERVIEW STUFF


Vote
Result 0 votes

Digital Goods

List all items from this seller

Contact seller

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"