Back

Price


(for 1 month access)

Level

Any Level

Instructor

R Kahn

Skills you will learn

Oracle, Server Management, SQL

About this course

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

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 JOINSINNER / 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

LORE ADVANTAGE

Lore delivers value at the intersection of learning, interests and skills.

Learn from Domain Experts

Access learning options recommended by industry experts, professionals and thought leaders.

Search & Compare

Quickly search, select and add learning options to your learning list.

Personalize your feed

Tell us more about yourself to access the latest learning options, curated just for you.