Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Server: Transact-SQL Basic Data Retrieval

via Pluralsight

Overview

Learn how to construct SELECT statements to retrieve data from SQL Server databases, applicable for developers from SQL Server 2005 onwards

If you need to retrieve data from a SQL Server database then you need to know how to use the SELECT statement. This course starts with the basics of a SELECT statement and its various sub-clauses, and progresses to how to select from multiple data sources in the same statement and a comprehensive section on the functions available to manipulate, aggregate, and convert data during the select operation. More then fifty demos help to give you a thorough understanding of how to perform these essential operations, all using a freely-available demo environment that you're shown how to set up and configure. This course is perfect for developers who need to query SQL Server databases to retrieve data, from complete beginners through to more experienced developers who can use some of the modules as reference material. The information in the course applies to all versions from SQL Server 2005 onwards.

Syllabus

  • Introduction 3mins
  • Setting Up a Transact-SQL Learning Environment 36mins
  • Writing a Basic SELECT Statement 51mins
  • Querying Multiple Data Sources 49mins
  • Using Functions 92mins

Taught by

Joe Sack

Reviews

4.4 rating at Pluralsight based on 707 ratings

Start your review of SQL Server: Transact-SQL Basic Data Retrieval

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.