Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

SQL Server 101 :Microsoft SQL Server for Absolute Beginners

Rashid Khan, Microsoft Certified BusinessIntelligence

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
44 Videos (3h 52m)
    • Learn SQL online with Rashid Khan

      1:18
    • Course and Instructor Introduction

      5:03
    • Pre-requisites & Different Editions

      6:20
    • Downloading Express Edn & Sample DB

      2:49
    • Installation & Configuration of SQL Server

      18:42
    • sa Login

      4:02
    • Module 01: Wrap Up-what we covered,so far!

      1:12
    • What is RDBMS ?

      12:13
    • Where does SQL Server fits in?

      2:16
    • Basic Database Objects

      16:08
    • MDF LDF physical files

      3:08
    • Module 02: Wrap Up-what we covered,so far!

      1:22
    • SQL Server Management Studio (SSMS)

      6:31
    • SSMS : Object Explorer

      5:12
    • SSMS : Query Editor

      5:59
    • SSMS : System Databases

      4:20
    • Module 03: Wrap Up-what we covered,so far!

      0:58
    • SELECT literals

      4:46
    • FROM clause

      6:27
    • Column Names - SELECT List

      3:06
    • Rearranging column names

      0:32
    • Module 04: Wrap Up-what we covered,so far!

      0:53
    • WHERE clause & ORDER BY clause

      16:45
    • BETWEEN & NOT BETWEEN operators

      9:05
    • NOT IN operator

      4:53
    • Pattern Matching & Wild Cards

      10:48
    • Module 05: Wrap Up-what we covered,so far!

      0:51
    • NULLs

      5:56
    • String Functions

      14:49
    • Date Functions

      7:26
    • System Functions

      5:01
    • Module 06: Wrap Up-what we covered,so far!

      1:42
    • INNER JOIN

      8:49
    • OUTER JOIN

      8:09
    • CROSS JOIN

      1:57
    • UNION

      3:03
    • Subqueries

      4:12
    • Module 07: Wrap Up-what we covered,so far!

      1:31
    • DISTINCT / ALL predicates

      2:22
    • Aggregate Functions

      3:14
    • GROUP BY clause

      3:48
    • Aggregate Queries

      3:30
    • Module 08: Wrap Up-what we covered,so far!

      1:00
    • Bonus

      0:04

About This Class

f5c3f693

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.

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

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

4

Students

--

Projects

0

Reviews (0)

Rashid Khan

Microsoft Certified BusinessIntelligence

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 deliv...

See full profile