Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Name: SQL Server 101 : Microsoft SQL Server for Absolute Beginners
Rating: 3.9 (149 reviews)

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

Created byRashid Khan

Last updated 10/2018

English

What you'll 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.

Course content

10 sections • 45 lectures • 3h 51m total length

Course and Instructor Introduction5:03
Meet the instructor and learn how to install SQL Server 2012 Express, use SQL Server Management Studio, and explore the Adventure Works sample database across eight modules for absolute beginners.

Pre-requisites & Different Editions of SQL Server6:20
Learn SQL Server : New location for Adventure Works Database download0:11
Downloading Express Edition & sample database2:49
Installing the downloads & Configuration18:42
Install and configure SQL Server 2012 Express, set up a named instance SS2K12EXPRESS, enable mixed authentication, and attach the AdventureWorks sample database via SSMS.
The sa Login4:02
Wrap up - what we went over !1:12
Explore the prerequisites and hardware and software requirements for installing SQL Server 2012 Express Edition, compare editions, install Adventure Works, and apply best practices for the sa account.
Quiz - Section 2

What is RDBMS ?12:13
Explore why a relational database management system outperforms spreadsheets for large, collaborative data. Learn core concepts, including fields, rows, columns, tables, keys and relationships, plus schema, normalization, and data types.
Where does SQL Server fit in ?2:16
Explore how Microsoft SQL Server stacks up against Oracle and IBM in Gartner Magic Quadrant, and learn why its SSAS, SSIS, SQL Agent, and SSRS offer a cost advantage.
Basic database objects16:08
Different Files that got installed - MDF & LDF3:08
Identify the two physical files that power a SQL Server database: the primary data file (MDF) and the log file (LDF), plus secondary data files (NDF).
Wrap up - what we went over !1:22

Getting started with SSMS6:31
Get started with SQL Server Management Studio to connect to a database engine, start the SQL Server service, navigate objects with Object Explorer, and use the query editor for T-SQL.
Getting around Object Explorer5:12
Query Window5:59
Course : SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Lecture : Query Window

Exercise SQL file to be opened with SQL Server Management Studio.
Pre built DB - system database4:20
Explore the system databases—master, msdb, model, tempdb, and resource—and their roles in SQL Server. Understand startup dependencies, template behavior, and how catalog views replace queries to system tables.
Wrap up - what we went over !0:58

Bare Minimum : SELECTING a literal4:46
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.
Retrieving / Querying data from a table - using FROM clause6:27
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.
Playing with Column Names3:06
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.
Rearranging columns to your liking0:32
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.
Wrap up - what we went over !0:53
Construct a bare minimum select statement using literals, retrieve data with the from clause, and rearrange column order using aliases and literal values.

Narrowing down and ordering result set - WHERE and ORDER clause16:45
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 result set - BETWEEN / NOT BETWEEN9:05
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 - IN and NOT IN operator4:53
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 - Pattern Matching : LIKE and Wildcards10:48
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.
Wrap up - what we went over !0:51

Dealing with nothing : NULL5:56
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.
Working with strings : Concatenation and other string functions14:49
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 dates : Date Functions7:26
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.
Some System Functions5:01
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.
Wrap up - what we went over !1:42
Wrap up by reviewing null handling with isnull and string operations, including concatenation, ltrim, rtrim, left, right, and substring, plus date functions and simple or searched case.

Joining multiple tables - INNER JOIN8:49
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.
Join types - OUTER JOIN - LEFT / RIGHT / FULL8:09
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 - CROSS JOIN1:57
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.
Holy UNION !3:03
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.
A bite of Sub…….queries4:12
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.
Wrap up - what we went over !1:31
Explore SQL Server data retrieval using inner joins, left outer joins, right outer joins, full outer joins, and no-match results, then combine data with union and master a nested subquery.

DISTINCT and ALL Predicates2:22
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.
Aggregate Functions3:14
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.
GROUP BY clause / HAVING clause3:48
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.
WHERE and ORDER BY in aggregate queries3:30
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.
Wrap up - what we went over !1:00
Wrap up the course by showing how to group and summarize data, use distinct to remove duplicates, and apply aggregate functions like count, min, max, and avg.

Requirements

NO PRIOR DATABASE OR SQL experience is required.
You need High speed Internet connection with a PC.

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

What you'll 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.

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

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

What you'll learn

Explore related topics

Course content

Course and Instructor Introduction1 lecture • 5min

Laying out the foundation - Overview & Installation6 lectures • 33min

Core concepts - Taming the RDBMS beast !5 lectures • 35min

Tool of the trade - SQL Server Management Studio5 lectures • 23min

Simple SELECT5 lectures • 16min

Filtering out unwanted data5 lectures • 42min

Expressions and Functions5 lectures • 35min

Getting data out of multiple tables6 lectures • 28min

Summarizing and Grouping data5 lectures • 14min

Bonus2 lectures • 1min

Requirements

Description

Who this course is for: