Course Details

Course module is as follows:

• SQL Server 2012 Developer
  • Module 1: Introduction to SQL Server 2012 and its Toolset
  • Module 2: Working with Data Types
  • Module 3: Designing and Implementing Tables
  • Module 4: Ensuring Data Integrity through Constraints
  • Module 5: Planning for SQL Server 2012 Indexing
  • Module 6: Implementing Table Structures in SQL Server 2012
  • Module 7: Reading SQL Server 2012 Execution Plans
  • Module 8: Improving Performance through Nonclustered Indexes
  • Module 9: Designing and Implementing Views
  • Module 10: Designing and Implementing Stored Procedures
  • Module 11: Merging Data and Passing Tables
  • Module 12: Designing and Implementing User-Defined Functions
  • Module 13: Creating Highly Concurrent SQL Server 2012 Applications
  • Module 14: Handling Errors in T-SQL Code
  • Module 15: Responding to Data Manipulation via Triggers
  • Module 16: Implementing Managed Code in SQL Server 2012
  • Module 17: Storing XML Data in SQL Server 2012
  • Module 18: Querying XML Data in SQL Server
  • Module 19: Working with SQL Server 2012 Spatial Data
  • Module 20: Working with Full-Text Indexes and Queries
• SQL Server 2012 Administrator
  • Module 1: Introduction to SQL Server 2012 and its Toolset
  • Module 2: Preparing Systems for SQL Server 2012
  • Module 3: Installing and Configuring SQL Server 2012
  • Module 4: Working with Databases
  • Module 5: Understanding SQL Server 2012 Recovery Models
  • Module 6: Backup of SQL Server 2012 Databases
  • Module 7: Restoring SQL Server 2012 Databases
  • Module 8: Importing and Exporting Data
  • Module 9: Authenticating and Authorizing Users
  • Module 10: Assigning Server and Database Roles
  • Module 11: Authorizing Users to Access Resources
  • Module 12: Auditing SQL Server Environments
  • Module 13: Automating SQL Server 2012 Management
  • Module 14: Configuring Security for SQL Server Agent
  • Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
  • Module 16: Performing Ongoing Database Maintenance
  • Module 17: Tracing Access to SQL Server 2012
  • Module 18: Monitoring SQL Server 2012
  • Module 19: Managing Multiple Servers
  • Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
• SQL Server 2008 R2 Developer
  • Module 1: Introduction to SQL Server 2008 R2 and its Toolset
  • Module 2: Working with Data Types
  • Module 3: Designing and Implementing Tables
  • Module 4: Ensuring Data Integrity through Constraints
  • Module 5: Planning for SQL Server 2008 R2 Indexing
  • Module 6: Implementing Table Structures in SQL Server 2008 R2
  • Module 7: Reading SQL Server 2008 R2 Execution Plans
  • Module 8: Improving Performance through Nonclustered Indexes
  • Module 9: Designing and Implementing Views
  • Module 10: Designing and Implementing Stored Procedures
  • Module 11: Merging Data and Passing Tables
  • Module 12: Designing and Implementing User-Defined Functions
  • Module 13: Creating Highly Concurrent SQL Server 2008 R2 Applications
  • Module 14: Handling Errors in T-SQL Code
  • Module 15: Responding to Data Manipulation via Triggers
  • Module 16: Implementing Managed Code in SQL Server 2008 R2
  • Module 17: Storing XML Data in SQL Server 2008 R2
  • Module 18: Querying XML Data in SQL Server
  • Module 19: Working with SQL Server 2008 R2 Spatial Data
  • Module 20: Working with Full-Text Indexes and Queries
• SQL Server 2008 R2 Administrator
  • Module 1: Introduction to SQL Server 2008 R2 and its Toolset
  • Module 2: Preparing Systems for SQL Server 2008 R2
  • Module 3: Installing and Configuring SQL Server 2008 R2
  • Module 4: Working with Databases
  • Module 5: Understanding SQL Server 2008 R2 Recovery Models
  • Module 6: Backup of SQL Server 2008 R2 Databases
  • Module 7: Restoring SQL Server 2008 R2 Databases
  • Module 8: Importing and Exporting Data
  • Module 9: Authenticating and Authorizing Users
  • Module 10: Assigning Server and Database Roles
  • Module 11: Authorizing Users to Access Resources
  • Module 12: Auditing SQL Server Environments
  • Module 13: Automating SQL Server 2008 R2 Management
  • Module 14: Configuring Security for SQL Server Agent
  • Module 15: Monitoring SQL Server 2008 R2 with Alerts and Notifications
  • Module 16: Performing Ongoing Database Maintenance
  • Module 17: Tracing Access to SQL Server 2008 R2
  • Module 18: Monitoring SQL Server 2008 R2
  • Module 19: Managing Multiple Servers
  • Module 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues