When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
This Course Includes
udemy
4.3 (21 reviews )
3h 31m 
english
Online - Self Paced
professional certificate
Udemy
About 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_
What You Will Learn?
- How to install SQL server 2017 .
- How to create,alter,drop database .
- How to create,alter,drop table .
- How to insert, update and delete records from tables. .
- How to select data from tables using basic SELECT statement in SQL Server. .
- How to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause. .
- UNION and UNION ALL operators .
- GROUP BY clause, HAVING clause and Aggregate functions..