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.

Instructed by Rashid Khan

  • Includes all Standard Features
  • Get Unlimited access to all the courses
  • No Contract. Cancel Anytime
Starting in just $19 / mo see all plans
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
  • 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.

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.

  • NO PRIOR DATABASE OR SQL experience is required.
  • You need High speed Internet connection with a PC.
  • 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
View More...

Section 1 : Course and Instructor Introduction

  • Lecture 1 :
  • Course and Instructor Introduction Preview

Section 2 : Laying out the foundation - Overview & Installation

  • Lecture 1 :
  • Pre-requisites & Different Editions of SQL Server
  • Lecture 2 :
  • Learn SQL Server : New location for Adventure Works Database download
  • ******** Learn SQL Server : New location for Adventure Works Database download ********** (1)Please go to the following Link: https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks2012 (2)Please download the file: “adventure-works-2012-oltp-data-file.mdf” (3)Then follow the instruction of “attaching a database MDF file” as outlined in video “Installing the Downloads & Configuration “under section 2. Thank you !
  • Lecture 3 :
  • Downloading Express Edition & sample database
  • Lecture 4 :
  • Installing the downloads & Configuration
  • Lecture 5 :
  • The sa Login
  • Lecture 6 :
  • Wrap up - what we went over !

Section 3 : Core concepts - Taming the RDBMS beast !

  • Lecture 1 :
  • What is RDBMS ?
  • Lecture 2 :
  • Where does SQL Server fit in ?
  • Lecture 3 :
  • Basic database objects
  • Lecture 4 :
  • Different Files that got installed - MDF & LDF
  • Lecture 5 :
  • Wrap up - what we went over !

Section 4 : Tool of the trade - SQL Server Management Studio

  • Lecture 1 :
  • Getting started with SSMS
  • Lecture 2 :
  • Getting around Object Explorer
  • Lecture 3 :
  • Query Window
  • Lecture 4 :
  • Pre built DB - system database
  • Lecture 5 :
  • Wrap up - what we went over !

Section 5 : Simple SELECT

  • Lecture 1 :
  • Bare Minimum : SELECTING a literal
  • Lecture 2 :
  • Retrieving / Querying data from a table - using FROM clause
  • Lecture 3 :
  • Playing with Column Names
  • Lecture 4 :
  • Rearranging columns to your liking
  • Lecture 5 :
  • Wrap up - what we went over !

Section 6 : Filtering out unwanted data

  • Lecture 1 :
  • Narrowing down and ordering result set - WHERE and ORDER clause
  • Lecture 2 :
  • Narrowing down result set - BETWEEN / NOT BETWEEN
  • Lecture 3 :
  • Narrowing down result set - IN and NOT IN operator
  • Lecture 4 :
  • Narrowing down result set - Pattern Matching : LIKE and Wildcards
  • Lecture 5 :
  • Wrap up - what we went over !

Section 7 : Expressions and Functions

  • Lecture 1 :
  • Dealing with nothing : NULL
  • Lecture 2 :
  • Working with strings : Concatenation and other string functions
  • Lecture 3 :
  • Working with dates : Date Functions
  • Lecture 4 :
  • Some System Functions
  • Lecture 5 :
  • Wrap up - what we went over !

Section 8 : Getting data out of multiple tables

  • Lecture 1 :
  • Joining multiple tables - INNER JOIN
  • Lecture 2 :
  • Join types - OUTER JOIN - LEFT / RIGHT / FULL
  • Lecture 3 :
  • Join types - CROSS JOIN
  • Lecture 4 :
  • Holy UNION !
  • Lecture 5 :
  • A bite of Sub…….queries
  • Lecture 6 :
  • Wrap up - what we went over !

Section 9 : Summarizing and Grouping data

  • Lecture 1 :
  • DISTINCT and ALL Predicates
  • Lecture 2 :
  • Aggregate Functions
  • Lecture 3 :
  • GROUP BY clause / HAVING clause
  • Lecture 4 :
  • WHERE and ORDER BY in aggregate queries
  • Lecture 5 :
  • Wrap up - what we went over !
learn-to-build-sql-query-ultimate-sql-and-database-concepts

Learn to Build SQL Query Ultimate S...

By : Jazeb Akram

Lecture 24

sql-server-tutorial

SQL Server tutorial

By : Shivprasad Koirala

Lecture 22

sql-for-newcomers-the-full-mastery-course

SQL for Newcomers - The Full Master...

By : Sameh Sharaf

Lecture 122

data-warehouse-etl-testing-data-quality-management-a-z

Data Warehouse ETL Testing & Data Q...

By : Lorenz De Smedt

Lecture 20

beginning-t-sql-for-sql-server-developer-data-analyst-dba

Beginning T-SQL for SQL Server Deve...

By : Vikas Munjal

Lecture 46

sql-server-programming

SQL Server Programming

By : Arunprakash P V

Lecture 12

Buy

$15

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now

Sign up and start learning
By signing up. you agree to our Terms of Use and Privacy Policy
Forget Password