Oracle / SQL Server

Oracle / SQL Server
Posted inTraining

MODULE 1: SQL & SQL

  • Configuring of SQL SERVER 2008 
  •   Hardware requirement for SERVER 2008 
  •   Software requirement for SERVER 2008 
  •   Introduction to RDBMS System Database 
  •   E-R Diagrams 
  •   Normalization 
  •   Introduction to TSQL 
  •   Select Command 
  •   DDIs 
  •   DMIs 
  •   Sub-Queries 
  •   Working with Tables 
  •   Correlated Sub queries 
  •   Transactions 
  •   Constraints 
  •   Views 
  •   Stored Procedures 
  •   Functions 
  •   Triggers 
  •   Cursors 
  •   Indexes 

MODULE 2: ADMIN & ARCHITECTURE

  • Introduction to Admin & Architecture 
  •   Memory Architecture 
  •   Storage Architecture 
  •   Database Creation 
  •   Database Creation with wizard and & with T-SQL 
  •   Up grading Database 
  •   Migration of Database 
  •   Introduction to Managing Filegroups 
  •   Datafiles 
  •   Logfiles 
  •   Managing Logins & Users 
  •   System Tables and Views & Linked Servers 
  •   Using System Stored Procedure and DBCC Commands 
  •   Import & Export 
  •   Attach and Detach Databases 
  •   BCP Command

MODULE 3: BACKUP AND RECOVERY, HIGH AVAILABILITY CONFIGURATION, DISASTER RECOVERY OPTIONS

  • Introduction to Database Backup 
  •   Partial Backup 
  •   Full Backup 
  •   Differential Backup 
  •   Data Encryption 
  •   Managing Database Snapshots 
  •   Jobs and Alerts 
  •   Restoration and Recovery ( with all Options) 
  •   Managing Log Shipping (Wizard and scripting) 
  •   Managing Database Mirroring (Wizard and scripting) 
  •   Managing Replication

MODULE 4: OPTIMIZATION

  • Introduction to Locking 
  •   Dead Locks 
  •   Transaction Isolation Levels 
  •   Introduction to Tuning 
  •   SQL Tuning 
  •   Index tuning 
  •   Performance Tuning Goals 
  •   Tuning Methodology 
  •   SQL Profiler 
  •   Resourse Governer. Policy Management 
  •   Introduction to Views 
  •   Dynamic Management Views 
  •   Instance Tuning 
  •   I/O tuning 
  •   OS Tuning