SQL SERVER Tutorial for the Beginners

Chapter 1:  Introduction

                        Introduction to RDBMS
                        Introduction to SQL Server
                        SQL Server Installation
                        Getting Started with SQL Server
                        System Databases in SQL Server

Chapter 2:  SQL Server Concepts
                       
                        Database Creation
                        Data types in SQL Server
                        Table Creation using SQL Commands
                        Table Creation using UI
                        Important points about Tables in SQL Server
                        Storing and Retrieving data in SQL Server 

Chapter 3: Introduction to SQL Server Commands

                        Introduction to SQL Server Commands
                        DDL Commands in SQL Server
                                        1.   CREATE
                                        2.   ALTER
                                        3.   DROP
                                        4.   TRUNCATE
                        DML Commands in SQL Server
                                        1.    INSERT  ( Part 1  , Part 2)
                                        2.    UPDATE
                                        3.    SELECT
                                        4.    DELETE
                        DCL Commands in SQL Server
                        TCL Commands in SQL Server
                        Difference Between DELETE and TRUNCATE

 Chapter 4: Simple Commands in SQL SERVER
                       
                        SELECT
                        DISTINCT
                        TOP
                        WHERE
                        GROUP BY
                        HAVING
                        ORDER BY
                        IN
                        BETWEEN
                        Difference Between Having and Where
                        Group By Errors

 Chapter 5: Aggregate Functions in SQL SERVER

                        COUNT
                        SUM
                        MAX
                        MIN
                        AVG

Chapter 6: Joins in SQL SERVER

                        INNER JOIN
                        LEFT OUTER JOIN
                        RIGHT OUTER JOIN
                        FULL OUTER JOIN
                        CROSS JOIN (or) CARTESIAN PRODUCT
                        SELF JOIN

Chapter 7: Stored Procedures in SQL SERVER


                        Introduction to stored procedures
                        Advantages and Disadvantages of Stored Procedures
                        Why stored procedures are faster than independent queries?
                        SP uses in Cross applications
                        SP without input and output parameters
                        SP with input parameters and without output parameters
                        Stored procedures with input and output parameters
                        Checks performed while compiling stored procedures
                        System Stored Procedures

Miscellaneous :

                        Templates for Creating Objects
                        Temporary Tables
                        @@FUNCTIONS
                        System Stored Procedures
                        Examples
                        White Papers on SQL SERVER




Posted in | Comments Off