SQL Server 101 : Microsoft SQL Server for Absolute Beginners
An absolute beginner’s tutorial to quickly learn Microsoft SQL Server from scratch using Management Studio and T SQL.
3.89 (148 reviews)
597
students
4 hours
content
Oct 2018
last update
$54.99
regular price
What you will learn
At the completion of the course, you will know how to install SQL Server 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 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 know about some of the string functions, date functions, and system functions.
You will see how to get data out of multiple tables using JOIN ( INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOINS).
You will also see how to use UNION / UNION ALL operators and as to how they differ from JOINS.
You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.
Screenshots
Related Topics
1136680
udemy ID
3/6/2017
course created date
11/23/2019
course indexed date
Bot
course submited by