1. Ms SQL Syllabus
    • SQL Server 2008

        Overview of SQL Server 2005

      1. Introduction to SQL Server 2005
        1. Role of a Database Server
        2. SQL Server 2008Components
        3. The .NET Framework
        4. Features of SQL Server 2005
        5. SQL
      2. Identifying SQL Server 2008Tools
        1. SQL Server Management Studio
        2. SQL Server Business Intelligence Development Studio
        3. Database Engine Tuning Advisor
        4. SQL Server Configuration Manager
        5. SQL

      3. Querying Data

      4. Retrieving Data
        1. Identifying Data types
        2. Retrieving Specific Attributes
        3. Retrieving Selected Rows
      5. Using Functions to Customize the Result Set
        1. Using String Functions
        2. Using Date Functions
        3. Using Mathematical
        4. Using System Functions
      6. Summarizing and Grouping Data
        1. Summarizing Data by Using Aggregate Functions
        2. Grouping Data

      7. Querying Data Using Joins and Sub Queries

      8. Querying Data By Using Joins
        1. Using an Inner Join
        2. Using an Outer Join
        3. Using a Cross Join
        4. Using a Self Join
        5. SQL

      9. Managing Databases and Tables

      10. Managing Databases
        1. Identifying the System Databases in SQL Server 2005
        2. Identifying the Database Files
        3. Creating a User-Defined Databases
        4. Renaming a User-Defined Databases
        5. Dropping a User-Defined Databases
      11. Managing Tables
        1. Creating a Table
        2. Implementing Data Integrity
        3. Creating a Partitioned Table
        4. Modifying a Table
        5. Renaming a Table
        6. Dropping a Table

      12. Manipulating Data in Tables

      13. Manipulating Data by Using DML Statements
        1. Storing Data in a Table
        2. Updating Data in a Table
        3. Deleting Data from a Table
      14. Manipulating the XML Data
        1. oStoring XML Data in a Table
        2. Retrieving the XML Data from the Table
        3. Modifying the XML Data

      15. Implementing Indexes, Views and Full Text Search

      16. Creating and Managing Indexes
        1. Identifying the Types of Indexes
        2. Creating Indexes
        3. Creating XML Indexes
        4. Managing Indexes
      17. Creating and Managing Views
        1. Creating Views
        2. Indexing Views
        3. Managing Views
      18. Implementing Full-Text Search
        1. Configuring Full-Text Search
        2. Searching Data by Using a Full-Text Search

      19. Implementing Stored Procedures and Functions

      20. Implementing Batches
        1. Creating Batches
        2. Using Constructs
        3. Handling Errors and Exceptions
      21. Implementing Stored Procedures
        1. Creating Stored Procedures
        2. Creating Parameterized Stored Procedures
        3. Returning Values from Stored Procedures
        4. Calling a Procedure from Another Procedure
      22. Implementing Functions
        1. o Creating UDFs

      23. Working with Triggers and Transactions

      24. Implementing Triggers
        1. o Identifying Types of Triggers
        2. Creating Triggers
        3. Managing Triggers

      25. Implementing Managed Code

      26. Understanding Managed Code
        1. Understanding Managed Code
        2. Identifying the need for managed code
      27. Creating Managed Database Objects
        1. Importing and Configuring Assemblies
        2. Creating Managed Database Objects

      28. Implementing HTTP Endpoints

      29. Introduction to HTTP Endpoints
        1. Introduction to SOA
        2. Introduction to Web Services
        3. Identifying the role of HTTP Endpoints in a Native Web Service Architecture
      30. Implementing the HTTP Endpoints
        1. Creating HTTP Endpoints
        2. Securing HTTP Endpoints

      31. Implementing Services for Message-Based Communications

      32. Message Based Communication
        1. Introduction to Service Broker
        2. Introduction to Service Broker
      33. Implementing Service Broker
        1. Creating Messages
        2. Creating Queues
        3. Creating Contracts
        4. Creating Services

Benefits Of SQL Course

      1. Sharp Mind Info Train provides excellent coaching for the students who are looking to build high career goals.

      2. Sharp Mind not only provides professional teachers but also the necessary material required for the students and takes them to the next level of knowledge.

      3. The institute helps to gain fresh perspectives on your personal challenges and opportunities.

      4. In the era of cut-throat competition, there is huge competition in all the fields. Our institute makes the way for you easy by teaching all the new technologies to be a good competitor and ease your way to reach your goals.

      5. We provide competitive environment to you to make you more and more stable technically with all the best skills.

      6. We have company environment.

      7. All the courses available here are cost effective. The institute also provides 100% career assistance.

  • <