SQL Server 101 : Microsoft SQL Server for Absolute Beginners (Udemy.com)

An absolute beginner's tutorial to quickly learn Microsoft SQL Server from scratch using Management Studio and T SQL.

( 39 Reviews )

Created by: Rashid Khan

Produced in 2018

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 function

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 84 / 100

Course Description

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

Who this course is for:

Anyone who is just starting out on their database career.
Information workers who work with database.
Healthcare professionals who need to understand the working of database in order to make sure that their PHI data remains HIPAA compliant.
Finance professionals who need to understand how their data is stored in database and as to how SQL Server provides a better data storing mechanism in strict regulatory environments, such as Sarbanes-Oxley (SOX), Dodd-Frank, Basel II etc.
Anyone looking for their first stepping stone to start working on their Microsoft Certification 70-461
Quality Analyst people who need to understand the workings of a database while they do their software testing.
Managers who need to understand as to how their data is handled by the database while they try to adopt agile development methodology.
Business Professional
Accountants
Software Developers
Programming Students
Financial Analysts

Time: 4h

Instructor Details

Rashid Khan

4.2 Rating
39 Reviews

Rashid Khan has a degree in Computer Science from New Jersey Institute of Technology, New Jersey, USA ( Magna Cum Laude ).
He has extensive professional experience with different technologies, including but not limited to, Microsoft stack of technology that includes SQL Server, SSRS, SSIS, SSAS , ASP.NET and .NET development.
He has worked with different types of companies belonging to different verticals that include finance, manufacturing, consulting and most recently in delivering a cutting edge healthcare analytics solution for a Fortune 500 Healthcare organization utilizing HL7, MS SQL Server, SSRS, SSIS, SSAS and ASP.NET.
He also has a passion for teaching, and is currently teaching various important technology courses that have thousands of students, coming from over 151 countries all across the world.