SQL Server DBA

SQL SERVER DBA

n DBMS

n RDBMS

n Data Models

n Introduction to SQL SERVER

n History of SQL SERVER

n Software And Hardware Requirements

n IP Configuration, Domain Creation

n Client-Server Architecture

n IIS Configuration

n Installation Process

n Services, Checks after installation

n Architecture of SQL SERVER 2005

n Server startup process

n Tools in SQL SERVER 2005

1. Management Studio(SSMS)

2. BI Tools(BIDS)

3. Configuration Tools

4. Performance Tools(Profiler)

n Enabling Remote Connections

1. TCP/IP

2. Named Pipes

n Changing Port numbers

n Authentications

1. Windows Authentications

2. SQL Server Authentications

n Securities

1. Logins

2. Users

3. Roles

4. Password Management

5. Database Assignment

6. Privileges

7. Schema

n Databases

1. System Databases

2. User Databases

n Database Designing

1. Creating Database

2. Altering Database

n Files And File Groups

1. Data Files

2. Log Files

3. Primary File Group

n Memory Architecture

1. Data Pages

2. Header and Description

3. Extents

n Transactions in SQL SERVER

1. Commit

2. Rollback

3. Buffer

4. Checkpoint

n Recovery Models

1. Full

2. Bulk Logged

3. Simple

4. Non Logged Operations

n Compatibility

1. 2005

2. 2000

3. 7.0

n Backups and Planning

1. Full

2. Differential

3. Transaction Log

4. Files and File Groups

5. Temporary

6. Jobs and Schedules

7. Back up Device

8. Append and Over write

n Restorations

1. Complete restoration

2. Point in Time restoration

3. Restoration Options

n OLTP and OLAP

n Import and Export

n SSIS

1. Migrations

2. SSIS Vs DTS Packages

3. Transformations

n Up gradation

n Replication

1. Publisher

2. Publication

3. Subscriber

4. Subscription

5. Distributor

6. Agents

7. Snap Shot Publication

8. Transactional Publication

9. Merge Publication

10. Replication monitor

n Log Shipping

1. Primary Servers

2. Secondary Servers

3. Monitoring Servers

4. Jobs and Schedules

5. Blocking of Jobs

6. High Availability

n Mirroring

1. Principle Server

2. Mirror Server

3. Witness Server

4. Mirror Error

5. Stand by Server

n SQL SERVER AGENT

1. Jobs

2. Schedules

3. Alerts

4. Operators

5. Error Logs

n Database Mail

n Maintenance Plan

1. Through SSMS

2. Through SSIS

n Overview of Clustering

n Performance Tuning

n PERFMON

n SQL LITESPEED

n SQL DIAGNOSTIC MANAGER

n LOG READER

n DBCC

n SYSTEM STORED PROCEDURES

n REGULAR, WEEKLY AND MONTHLY ACTIVITIES

n TROUBLE SHOOTING

n INTERVIEW STUFF

SQL Server

SQLSERVER

1. Basics of DBMS

2. Basics of RDBMS

3. Data Models

4. What is SQL server

5. Introduction to SQL Server 2005

6. Tools of SQL Server 2005

7. Security

8. Authentications

A. Windows

B. SQL Server

9. Data types

10. TSQL Introduction

11. Database designing

12. Files and File groups

13. Data Definition language

14. Data Manipulation Language

15. Data Retrieval Language

16. Transactions in SQL Sever 2005

A. Commit

B. Roll back

17. Operators

18. Functions

A. Number Functions

B. Character Functions

C. Date time Functions

D. Aggregate Functions

19. Clauses

A. Group By

B. Having

C. Order by

20. Set Operators

21. Joins

A. Inner Join

B. Outer Join(3)

C. Non Equi Join

D. Self Join

E. Cross Join

22. Sub Queries

23. Copying table concept

24. Constraints

A. Primary key

B. Unique

C. Foreign key

D. Check Constraint

E. Not Null

F. Default

25. Views

26. Indexes

27. Synonyms

28. Snapshots

29. Locks in SQL Server 2005

30. Introduction to Programming

31. Batches and Basic programs

32. If. Else, While

33. Cursors

34. User Defined Functions

35. Stored Procedures

36. Triggers

37. Architecture of SQLSERVER 2005

38. SQLSERVER 2008 Features

JAMPANI PROFILE

JAMPANI Technologies provides an extensive training in Software Testing offering comprehensive testing solutions ranging from manual, performance, functional and Database testing. We also offer training SOA Testing/Web Services testing/API Testing/ Database Testing and UNIX Testing