IT Training and Job Marketing placement

[roiarjun5]

SQL Server DBA Topic Wise Course Details:
SQL Server 2008 Overview and Installation
• Overview of SQL Server
• Installation Requirements (Hardware and Software)
• Installation Walkthrough (Step-by-Step)
• Overview of SQL Server Management Studio (SSMS)
Creating and Managing Databases
• Creating Databases
• Database
• File Groups
• Database Options
• Managing database
Creating and Managing Tables and implementing Data Integrity
• Creating Tables
• Defining Table Location
• Modifying Tables
• Dropping Tables
• Data Types
• Defining Constraints
• Partitioned Table
• Data Compression (New Feature in SQL Server 2008
Data Manipulation and Data Correlation
• Select/Update/Delete
• Sub Queries
• Joins
• Union/UnionAll/Intersect
SQL Server Built in Functions
• Mathematical Functions
• String Functions
• Date Functions
• Convert Functions
• Aggregate Functions
Creating and Managing Views
• Create View
• Alter View
• Drop View
• Check and Encryption Options
Introduction to T-SQL Programming
• Variable Declaration
• Temp Table Concepts
• Variable Table Concepts
• Loops
Creating and Modifying Procedures and Cursors
• Creating Procedures
• Parameter Types
• Modifying Procedures
• Using Temp Tables, Variable Tables and cursors in Procedures
• How to use Dynamic SQL Statements in Procedures.
• Error Handling
Creating and Modifying user defined Functions
• Creating/Modifying Scalar functions
• Creating/Modifying table functions
Creating and Modifying Triggers
• Table Triggers
• DDL Triggers
Working with distributed Data
• Creating Linked Servers
• How to use DML Statements against to the remote servers
• How to use remote Procedure execution in SQL Servers
SQL Server Security
• Authentication Methods
• Server level Security
• Database Level Security
• Object Permissions
Creating and Managing Indexes
• Clustered Index
• Non Clustered Index
• Unique index
• Composite Indexes
• Fill Factor /Pad Index
Backup/Recovery
• Recovery Models
• Backup Types
• Full Database backup
• Differential Backup
• Transactional Log Backup
• Restore Databases
• Restore transaction Logs
• Point of Recovery
• Backup Compression (New Feature in SQL Server 2008)
Database Mail
SQL Server Scheduling and Notification
• Managing jobs
• Managing Alerts
Monitoring and Troubleshooting SQL Server Performance
• Identify and Resolve Blocking issues
• SQL Server trace
• QUERY Execution Plan Analysis
• DB Tuning Adviser
• Performance Monitor
• Setting Maintenance plans
SQL Server Clustering (High availability Solutions) Concept
Database Mirroring
Replication
Migrate or Upgrade to SQL Server 2008
Log Shipping
Resource Governor (new Feature in SQL Server 2008)
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
Database Design Concepts and Design Tool (ERWin Tool)
• Normalization
• De-Normalization
To enroll this course you would have to take action and join it and move forward with your next career level. Email: [email protected]
Phone: 214-736-3535

[Author]

Posts