Microsoft SQL Server For Beginners

About this course

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