·
RDBMS
·
DBMS
·
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
- Complete
restoration
- Point in Time
restoration
- Restoration
Options
OLTP AND OLAP
IMPORT AND EXPORT
SSIS
- Migrations
- SSIS Vs DTS
Packages
- 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
- Through SSMS
- 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
Arjun Rai
Phone : 318 500 3479
Skype:
Arjun.rai3 | G-Talk: roiarjun5
| BA | QA | JAVA | HADOOP | SQL | ORACLE | SELENIUM |
| Java/J2EE| .NET/BA/Project Manager
(PMP)/QA/ Lead/ SCCM/Citrix Administrator/Oracle Lead/Middleware
Admin/Regression/Test Lead/Sr. Informatica/Data Analyst/Modeler/Project Manager
/ C++ Developer/Oracle Pl/SQL developer/Power Builder/Mainframe/Web Sphere Admin/VMWare
Admin/ Network Engineer/Linux Engineer/Windows Admin/Active Directory/Build
Engineer/ System Admin |
"Training
& Job Placement + Profile Marketing Help |
"Much more to do in life"