Microsoft SQL Server For Beginners

In this course you will learn SQL server basic concepts.

         – How to create database

         – How to modify database

         – How to delete database

         – Database delete issues

          – How to create table

          – How to modify table

          – How to delete table

         – How to insert data in tables

        – How to update data in tables

        – How to delete data in tables

       – Truncating data vs deleting

       – Select statement

       – Filtering Data with the WHERE clause

       – Filtering Data with the WHERE clause using various Operators

       – UNION Operator and UNION ALL Operator

       – EXISTS Operator

       – Sorting Data with the ORDER BY Clause

       – SELECT TOP Clause

       – DISTINCT Statement

       – GROUP BY Statement

       – HAVING Clause