#1
28th November 2015, 10:32 AM
| |||
| |||
SQL Online Classes
Hello sir would you please give me some information about SQL DBA Online training Course offered by Good Online Trainings Institute?
|
#2
28th November 2015, 10:47 AM
| |||
| |||
Re: SQL Online Classes
Good Online Training institute provide the best online trainings in Data Warehousing, SAP & SAS…technologies with the real time experts and certified professionals. SQL is an ANSI standard computer language for dealing with relational databases SQL DBA Online training Course: SQL DBA Online training Course Content: 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 1. TCP/IP 2. Named Pipes Changing Port numbers Authentications 1. Windows Authentications 2. SQL Server Authentications Securities 1. Logins 2. Users 3. Roles 4. Password Management 5. Database Assignment 6. Privileges 7. Schema Databases 1. System Databases 2. User Databases Database Designing 1. Creating Database 2. Altering Database Files And File Groups 1. Data Files 2. Log Files 3. Primary File Group Memory Architecture 1. Data Pages 2. Header and Description 3. Extents Transactions in SQL SERVER 1. Commit 2. Rollback 3. Buffer 4. Checkpoint Recovery Models 1. Full 2. Bulk Logged 3. Simple 4. Non Logged Operations Compatibility 1. 2005 2. 2000 3. 7.0 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 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 Mirroring 1. Principle Server 2. Mirror Server 3. Witness Server 4. Mirror_Error 5. Stand by Server Database Mail Maintenance Plan 1. Through SSMS 2. Through SSIS Overview of Clustering Performance Tuning PERFMON SQL LITESPEED SQL DIAGNOSTIC MANAGER LOG READER DBCC SYSTEM STORED PROCEDURES REGULAR, WEEKLY AND MONTHLY ACTIVITIES TROUBLE SHOOTING INTERVIEW STUFF Up gradation 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 Contact details: Good Online Trainings Institute: Email: goodonlinetrainings@gmail.com Skype ID : goodtrainings USA: +1 214 347 4655 INDIA: +91 996 395 7366 |