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.
In this course you will learn:
Start from scratch by installing Microsoft SQL Server Express edition
Requirements for installing Microsoft SQL Server
Core concepts of RDBMS
Comparison of MS SQL Server with Oracle, IBM etc.
Getting around SQL Server Management Studio
Details of System databases
Constructing SELECT statement starting with literals
Using FROM clause
Working with columns specified in the SELECT LIST
Using WHERE clause
Using ORDER BY clause
Using BETWEEN / NOT BETWEEN operator
Using IN / NOT IN operator
Pattern matching using LIKE operator and wild card characters
Working with NULL
Using string functions including concatenation
Using Date functions
SQL Server System functions
Working with JOINS – INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOIN
Working with UNION / UNION ALL
A look at sub queries
Duplicate rows – DISTINCT / ALL predicates
Aggregate functions
Using GROUP BY clause
Using HAVING clause
3.6
74 Ratings
$ 49.99
per course
Also check at
FAQs About "SQL Server 101 : Microsoft SQL Server for Absolute Beginners"
Is the online course "SQL Server 101 : Microsoft SQL Server for Absolute Beginners" free?
The online course "SQL Server 101 : Microsoft SQL Server for Absolute Beginners" costs $49.99 on the online classes platform Udemy
Is "SQL Server 101 : Microsoft SQL Server for Absolute Beginners" an online course worth taking?
138 students from the online classes platform Udemy have given an average rating of 3.6 to the online "SQL Server 101 : Microsoft SQL Server for Absolute Beginners" and at least 571 have completed this online training.
About
Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers. DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.