Microsoft SQL Server For Beginners

In this course you will learn SQL server basic concepts.

• Microsoft SQL Server 2017 Installation
• Introduction to databases and its structure

• Database

         - How to create database

         - How to modify database

         - How to delete database

         - Database delete issues

• Tables

          - How to create table

          - How to modify table

          - How to delete table

• Data manipulation

         - How to insert data in tables

        - How to update data in tables

        - How to delete data in tables

       - Truncating data vs deleting

• Retrieving data

       - Select statement

• Filtering data retrieval

       - 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