Microsoft SQL Server 2008 Online Training

Microsoft SQL Server 2008 Online Training

  • ABOUT THE COURSE
    • Course Duration

      This course requires 35 hours of training with two convenient options (weekday or weekend sessions)

      Training Materials

      1. Elaborate and precise training material designed by expert database professionals for each sub module
      2. 24×7 technical support team is available through phone, email or live chat sessions
      3. Provides plenty of work opportunities on real time database projects
      4. Offers the most recognized and worldwide Microsoft SQL 2008 certification that acts as a valuable addition to a candidate’s skill set

      What’s Needed To Join This Course?

      A basic knowledge of SQL Server and its functionalities will help you learn this course efficiently. Candidates who have knowledge of functionalities and working of SQL Server 2005 will prove to be an added advantage.

      Who Are Ideal Candidates?

      It is the best course for candidate aspiring for SQL Server 2008 administration, business intelligence and reporting or programming.

      Course Info

      Microsoft SQL Server training covers various aspects of Microsoft's premier database system SQL Server 2008 to suit the needs of all sizes of business. The learning process begins with the understanding of the core concepts such as installation, planning and building a first database. The accurate and authentic course content taught under this training comprises of the various aspects of Microsoft SQL Server 2008 that includes exploring the way Transact-SQL is used to retrieve, insert and update information and obtain an insight into the effective administration of databases. This online course also covers features such as SQL Server Reporting and Integration Services.

      Why NORTH TECH SYSTEMS?

      This training center takes pride to be one of the best leading Microsoft SQL Server 2008 training institutes that provides best in class conceptual training to its students. Some of the most appealing features of our institute are:

      1. Perfect combination of 80% practical learning and 20% theoretical learning that equips learners with the adequate hands-on experience
      2. Affordable fee structure for the complete training course
      3. Regular mock interviews, quizzes, group discussion and assessments throughout the training session helps to measure the progress of each student
      4. 100 % job placement assistance after successful completion of the course
  • CURRICULUM
    • Module: 1

      SQL Server Architecture

      Introduction to SQL Server 2008 Overview on RDBMS and Beyond Relational

      1. System Databases
      2. What’s New in SQL Server 2008

      SQL Server Component Overview

      1. The Relational Engine
      2. The Command Parser
      3. The Query Optimizer
      4. The SQL Manager
      5. The Database Manager
      6. The Query Executor
      7. The Storage Engine

      Pages & Extents

      1. Pages
      2. Extents [Uniform & Mixed]
      3. Managing Extent Allocations
      4. Tracking Free Space

      Files and File groups

      1. Database FilesDatabase File groups [Primary & User-defined]
      2. Primary data files
      3. Secondary data files
      4. Log file

      Memory Architecture

      1. 32-bit Vs 64-bit Architecture
      2. Dynamic Memory Management
      3. Effects of min and max server memory
      4. Buffer Management
      5. Using AWE
      6. The Buffer Pool and the Data Cache
      7. Checkpoints

      Thread and Task Architecture

      1. Allocating Threads to a CPU
      2. Using the lightweight pooling Option
      3. Thread and Fiber Execution
      4. Hot Add CPU

      Module: 2

      Installing, Upgrading, Configuration, Managing services & Migration

      SQL server 2005/2008 Installation

      1. Planning the System/Pre-Requisites
      2. Installing SQL server 2005
      3. Installing SQL server 2008
      4. Installing Analysis Services
      5. Installing & Configuring Reporting Services
      6. Best Practices on Installation
      7. Uninstalling SQL server
      8. Common Installation Issues
      9. Practical Troubleshooting on a Failed Installation

      Upgrading to SQL server 2005/2008

      1. Upgrading the server by applying service packs
      2. Upgrading the server by applying Hot fixes
      3. In-Place Up gradation from SQL server 2005 to 2008
      4. Pre-Upgrade Checks
      5. Upgrade advisor
      6. Best Practices to follow while upgrading

      Configuring SQL Server

      1. Configuring Network Protocols from SQL Server configuration manager
      2. Configuring features by using SQL Sever surface area configuration manager
      3. Configuring other settings through SP_Configure
      4. Dedicated Administrator Connection
      5. Connecting to DAC
      6. Configuring Database Settings
      7. Configuring Memory Settings
      8. Configuring Database Mail
      9. Configuring Tempdb
      10. Best Practices on configuration/Database settings

      Managing services

      1. Starting and Stopping Services throughStart Up parameters
      2. Configuration manager
      3. Net Command
      4. Command Prompt [sqlsrvr.exe
      5. Starting SQL server in single user mode
      6. Starting SQL server with minimal configuration

      Migrating SQL server

      1. Side-By- Side Migration Techniques
      2. Difference between in-place & Side by Side Migration/Upgradation
      3. Advantages/Disadvantages of In-Place to Side-by-Side
      4. Migrating DatabasesMigrating Logins [Fixing Orphaned Users]
      5. Migration by using Attach and Detach Method
      6. Migration by using Back and restore method
      7. Migration by using Copy Database Wizar
      8. Migrating Jobs
      9. Migrating DTS Packages to SSIS
      10. Import & Export
  • ROADMAP
  • REVIEWS
    • “Excellent tempo and a wealth of knowledge, with a little touch of humor made the course all the more interesting and beneficial. Course flow was well designed by the trainer. I would definitely recommend the trainer to my friends, i am amazed with his skills” – Amey Shah
      “The course provided an incredible amount of understanding in an amazingly short time. Transitions from topic to topic were seamless, as each topic builds upon the previous one. The instructor has an infectious enthusiasm and passion for the subject and peppers his lectures with hilarious and interesting anecdotes”- Apurva Kothari
  • FAQ's
    • Content will be coming soon

Copyrights @2018-All rights reserved