SQL Server 101 : Microsoft SQL Server for Absolute Beginners

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

SQL Server 101 : Microsoft SQL Server for Absolute Beginners. With the help of this course you can An absolute beginner’s tutorial to quickly learn Microsoft SQL Server from scratch using Management Studio and T SQL..

This course was created by Rashid Khan. It was rated 4.1 out of 5 by approx 10701 ratings. There are approx 94069 users enrolled with this course, so don’t wait to download yours now. This course also includes 4 hours on-demand video, 1 Article, 22 Supplemental Resources, Full lifetime access, Access on mobile and TV & Certificate of Completion.

What Will You 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.

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
Rating:
4.6

Download Links

Get Download Link

Related Courses

Writing Advanced SQL Queries on Microsoft SQL Server

70-461 Session 3: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 5: Querying Microsoft SQL Server 2012 (T-SQL)

70-461 Session 4: Querying Microsoft SQL Server 2012 (T-SQL)

Microsoft 70-464 Developing Microsoft SQL Server 2012 Da…

Querying Microsoft SQL Server Databases using T-SQL

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

T-SQL For Beginners: Learn to Query SQL Server Databases

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

MS SQL SERVER (T-SQL) Concepts – Raise above beginner level

Beginner Data Analysis Using SQL and Microsoft SQL Server

Beginner Data Analysis Using SQL and Microsoft SQL Server

Microsoft SQL Server 101

Microsoft SQL Server 101

Microsoft SQL Server For Beginners

Microsoft SQL Server For Beginners

MICROSOFT SQL SERVER: A Beginner to Advanced Guide

MICROSOFT SQL SERVER: A Beginner to Advanced Guide

Querying Microsoft SQL Server For Beginners

Querying Microsoft SQL Server For Beginners

Microsoft SQL Server Database Training For Beginners

Microsoft SQL Server Database Training For Beginners

Learn SQL with Microsoft SQL Server

Learn SQL with Microsoft SQL Server

70-461 Session 2: Querying Microsoft SQL Server (T-SQL)

70-461 Session 2: Querying Microsoft SQL Server (T-SQL)

Writing Advanced SQL Queries on Microsoft SQL Server

Writing Advanced SQL Queries on Microsoft SQL Server

70-461 Session 6: Querying Microsoft SQL Server (T-SQL)

70-461 Session 6: Querying Microsoft SQL Server (T-SQL)
Go To Top