Querying Microsoft SQL Server Databases using T-SQL

Learn To Query Microsoft SQL Server Database using T-SQL
3.0 (2 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
30 students enrolled
Instructed by Skill Tree IT & Software / Other
$19
$85
78% off
Take This Course
  • Lectures 26
  • Length 3 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

Microsoft SQL Server is one of the most popular and widely used relational database management systems (RDBMS) in the world.
T-SQL is Microsoft’s own version of the standard SQL language used to query Microsoft SQL Server Databases.
Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organisations.
In this course you will Learn how to setup an SQL Sever environment as well as connect to and query the database using SQL Server Management Studio also known as SSMS. You will learn how to install the adventureworks2014 sample database which we will use for this course .You will learn to query one or many different tables using SELECT statements and also about Aliases and why they are used. You will learn about the various types of tables joins used to get data from multiple tables.
You will be able to Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures , Update database content with SQL and transaction handling and Retrieve data with filter conditions and from multiple tables using various types of join

Lectures include:
Writing SELECT queries
Write Transact SQL Queries
Table Joins
Aliases
Null Values
Query Multiple Tables


This is a hands-on practical course that is taught at a pace that you can follow along easily.
I look forward to welcoming you to the course.

What are the requirements?

  • Download and Install SQL Server . This will be covered in this course.

What am I going to get from this course?

  • Download and Install SQL Server
  • Connect to SQL Server Using SSMS
  • Know how to use SSMS Tool
  • Write Basic T-SQL Select Query
  • Create Aliases
  • Retrieve NuLL Values
  • Perform Table Joins
  • Get Data From Multiple Tables

What is the target audience?

  • This Course is meant for anyone not familiar with Microsoft SQL Server and T-SQL

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction and Lab Setup
Introduction
Preview
03:01
Download SQL Server
Preview
04:04
Install SQL Server
Preview
04:55
Hook up Sample Database
04:58
Download and Install SSMS
04:40
Section 2: Quering SQL Dtabase Using T-SQL
What is T-SQL
10:27
Basic SELECT Statement
12:58
Aliases
07:13
Using NULL
04:39
Table Joins
00:27
Inner Join
10:36
Left Outer Join
12:26
Right Outer Join
09:30
Full Outer Join
10:14
The Use Command
07:37
Table Joins Conclusion
01:56
Database Normalisation
14:16
Case Expressions
12:18
Using Comments
06:12
Section 3: Aggregate Functions
Introduction
02:17
AVG Function
07:52
SUM Function
07:19
MAX Function
06:53
MIN Function
06:53
COUNT Function
09:24
Using Multiple Aggregate Functions
05:11

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Skill Tree, Skill based learning

We are experienced company that provides quality video based training .
Our courses are easy to follow and understand and will take you from
an absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.
We have worked with companies of various sizes and provided consultancy services at various levels.
Thank you for learning with us and we hope your experience will be pleasant.

Ready to start learning?
Take This Course