Microsoft SQL Server 2017 Database Training For Beginners
Learn Microsoft SQL server step by step.An absolute beginners online course to learn SQL Server Database from scratch.
4.37 (390 reviews)
1,536
students
11.5 hours
content
Jan 2020
last update
$64.99
regular price
What you will learn
Start from scratch by installing Microsoft SQL Server 2017 and create a practice environment for yourself.
You will be familiarized with some of the core concepts of RDBMS / SQL Server.
You will learn the ins and outs of SQL Server Management studio.
You will learn how to create and connect SQL server colud database using Amazon AWS and Microsoft Azure.
You will learn how to create, alter and drop database.
You will learn how to create, alter and drop tables.
You will learn how to insert, update and delete records from tables.
You will start constructing your SELECT statement to retrieve data from SQL Server.
You will know 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.
You will also see how to use UNION / UNION ALL operators
You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.
You will learn Joins in SQL Server. Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join and Self Join.
You will also know about some of the string functions, date functions, and system functions.
You will learn how to create your own function.
You will learn how to create, alter and drop Stored Procedure and advantages of stored procedure.
You will learn how to create, alter and drop Trigger and its advantage.
You will learn how to create, alter and drop View and its advantage.
You will learn about temp tables and its advantage.
You will learn how to handel exceptions in SQL Server.
You will learn how to import data from excel file, flat file, another SQL server database and MySQL.
You will learn how to export data to excel file, flat file and another SQL server database
You will learn about Bulk Insert.
You will learn about Cursors.
Screenshots
Related Topics
1390412
udemy ID
10/11/2017
course created date
1/7/2021
course indexed date
Bot
course submited by