SQL Server 101 : Microsoft SQL Server for Absolute Beginners
5.0 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
25 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server 101 : Microsoft SQL Server for Absolute Beginners to your Wishlist.

Add to Wishlist

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.
5.0 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
25 students enrolled
Created by Rashid Khan
Last updated 7/2017
English
English
Curiosity Sale
Current price: $10 Original price: $45 Discount: 78% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 22 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
  • Last Update Date : The course was last updated on 26 July 2017
View Curriculum
Requirements
  • NO PRIOR DATABASE OR SQL experience is required.
  • You need High speed Internet connection with a PC.
Description
  • 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 JOINS
  • 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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
43 Lectures
03:50:54
+
Course and Instructor Introduction
1 Lecture 05:03
+
Laying out the foundation - Overview & Installation
5 Lectures 33:05

Downloading Express Edition & sample database
02:49

Installing the downloads & Configuration
18:42

The sa Login
04:02

Wrap up - what we went over !
01:12
+
Core concepts - Taming the RDBMS beast !
5 Lectures 35:07
What is RDBMS ?
12:13

Where does SQL Server fit in ?
02:16

Basic database objects
16:08

Different Files that got installed - MDF & LDF
03:08

Wrap up - what we went over !
01:22
+
Tool of the trade - SQL Server Management Studio
5 Lectures 23:00
Getting started with SSMS
06:31

Getting around Object Explorer
05:12

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : Query Window

Exercise SQL file to be opened with SQL Server Management Studio.

Query Window
05:59

Pre built DB - system database
04:20

Wrap up - what we went over !
00:58
+
Simple SELECT
5 Lectures 15:44

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - bare minimum.

Exercise SQL file to be opened with SQL Server Management Studio.

Preview 04:46

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - FROM clause

Exercise SQL file to be opened with SQL Server Management Studio.

Retrieving / Querying data from a table - using FROM clause
06:27

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - FROM clause - playing with column names - Alias

Exercise SQL file to be opened with SQL Server Management Studio.

Playing with Column Names
03:06

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - FROM clause - playing with column names - SELECT LIST

Exercise SQL file to be opened with SQL Server Management Studio.

Rearranging columns to your liking
00:32

Wrap up - what we went over !
00:53
+
Filtering out unwanted data
5 Lectures 42:22

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - WHERE clause

SELECT statement - ORDER BY clause

Exercise SQL file to be opened with SQL Server Management Studio.

Narrowing down and ordering result set - WHERE and ORDER clause
16:45

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - BETWEEN OPERATOR

SELECT statement - NOT BETWEEN OPERATOR

Exercise SQL file to be opened with SQL Server Management Studio.

Narrowing down result set - BETWEEN / NOT BETWEEN
09:05

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - IN OPERATOR

SELECT statement - NOT IN OPERATOR

Exercise SQL file to be opened with SQL Server Management Studio.

Narrowing down result set - IN and NOT IN operator
04:53

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - LIKE Predicate

SELECT statement - Wildcard character matching

Exercise SQL file to be opened with SQL Server Management Studio.

Narrowing down result set - Pattern Matching : LIKE and Wildcards
10:48

Wrap up - what we went over !
00:51
+
Expressions and Functions
5 Lectures 34:54

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - NULL values

SELECT statement - NULL functions - ISNULL , COALESCE, NULLIF

Exercise SQL file to be opened with SQL Server Management Studio.

Dealing with nothing : NULL
05:56

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - working with string values

Functions - CAST (), CONVERT (), CONCAT (), LTRIM (), RTRIM () , LEFT () , RIGHT () , LEN () , CHARINDEX () , SUBSTRING () , UPPER () , LOWER () , REPLACE ()

Exercise SQL file to be opened with SQL Server Management Studio.

Working with strings : Concatenation and other string functions
14:49

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - working with date values

Functions - GETDATE () , SYSDATETIME () , DATEADD () , DATEDIFF () , DATENAME () , DATEPART () , CONVERT ()

Exercise SQL file to be opened with SQL Server Management Studio.

Working with dates : Date Functions
07:26

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - system functions 

Functions - CASE

Exercise SQL file to be opened with SQL Server Management Studio.

Some System Functions
05:01

Wrap up - what we went over !
01:42
+
Getting data out of multiple tables
6 Lectures 27:41

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - joining multiple tables using JOIN operator

JOIN TYPE : INNER JOIN

Exercise SQL file to be opened with SQL Server Management Studio.

Joining multiple tables - INNER JOIN
08:49

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - joining multiple tables using JOIN operator

JOIN TYPE : OUTER JOIN - LEFT OUTER JOIN , RIGHT OUTER JOIN  , FULL OUTER JOIN

Exercise SQL file to be opened with SQL Server Management Studio.

Join types - OUTER JOIN - LEFT / RIGHT / FULL
08:09

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - joining multiple tables using JOIN operator

JOIN TYPE : CROSS JOIN ( Cartesian product )

Exercise SQL file to be opened with SQL Server Management Studio.

Join types - CROSS JOIN
01:57

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement -UNION operator / UNION ALL operator

Exercise SQL file to be opened with SQL Server Management Studio.

Holy UNION !
03:03

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - sub query - nested sub query , IN operator, NOT IN operator

Exercise SQL file to be opened with SQL Server Management Studio.

A bite of Sub…….queries
04:12

Wrap up - what we went over !
01:31
+
Summarizing and Grouping data
5 Lectures 13:54

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - DISTINCT predicate , ALL predicate, eliminating duplicate records

Exercise SQL file to be opened with SQL Server Management Studio.

DISTINCT and ALL Predicates
02:22

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - aggregate functions - COUNT () , MAX (), MIN (), SUM (), AVG ()

Exercise SQL file to be opened with SQL Server Management Studio.

Aggregate Functions
03:14

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - grouping and summarizing data

GROUP BY clause

HAVING clause

Exercise SQL file to be opened with SQL Server Management Studio.

GROUP BY clause / HAVING clause
03:48

Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : SELECT statement - aggregate queries

Exercise SQL file to be opened with SQL Server Management Studio.

WHERE and ORDER BY in aggregate queries
03:30

Wrap up - what we went over !
01:00
+
Bonus
1 Lecture 00:04
About the Instructor
Rashid Khan
4.4 Average rating
45 Reviews
3,647 Students
2 Courses
Microsoft Certified-Business Intelligence Consultant

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 Microsoft stack of technology that include 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.