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
- 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
Digital Goods
List all items from this 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"