Introduction to T-SQL for Data Analysts
4.6 (86 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.
1,367 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to T-SQL for Data Analysts to your Wishlist.

Add to Wishlist

Introduction to T-SQL for Data Analysts

In 60 minutes, learn 30 of the most important Transact-SQL (T-SQL) tasks that data analysts need to perform
4.6 (86 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.
1,367 students enrolled
Created by Steve Fox
Last updated 9/2014
English
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of this course students will be comfortable performing the core T-SQL tasks that data analysts perform on a daily basis. This will include activities such as writing T-SQL to :
  • Create databases and tables.
  • Select either all or a subset of data from a table.
  • Sort and filter records, including using wildcards.
  • Join database tables using Inner, Left, Right & Full Joins.
  • Manage Null & Non-Null records.
  • Aggregate data by groups, and to filter these groups.
  • Create Stored Procedures and Views.
  • Back up tables
  • Selectively delete data, tables or databases.
View Curriculum
Requirements
  • Microsoft SQL Server 2008, 2008 R2, 2012, or 2014. Obtaining a low or no-cost copy is discussed in the course.
Description

This course teaches students the core Transact SQL (T-SQL) skills and tasks that Data Analysts need to perform, such as how to connect to databases, define data extracts, query, & format data. This is a crash course, and in just over 1 hour, students will build a strong foundation knowledge of T-SQL.

This course is different from most other T-SQL courses, in that it focuses on skills required by data analysts. It avoids other tasks such as defining user permissions, building indexing, and designing databases that database administrators and designers focus on.

Because this course is tailored towards students wanting to develop data analyst skills, it is very compressed and in 60 minutes students will develop an understanding of 30 of the core T-SQL tasks data analysts perform.

The course, and supporting material is designed to enable students to follow along in real-time with the instructor. The course consists of 6 lectures, and assumes no prior understanding or experience with Microsoft SQL Server or writing code.

The T-SQL code provided with the course works with Microsoft SQL Server 2008, 2008 R2, SQL 2012, and SQL 2014. It will also work with all editions of SQL Server. How to obtain either a free, or low cost copy of Microsoft SQL Server is discussed in the course.

Who is the target audience?
  • Students with no previous knowledge of SQL Server or T-SQL.
Curriculum For This Course
Expand All 6 Lectures Collapse All 6 Lectures 01:00:48
+
Introduction to T-SQL for Data Analysts using Microsoft SQL Server
6 Lectures 01:00:48

This Lecture Covers

  • What is Transact -SQL?
  • Why a knowledge of T-SQL important for data analysts
  • Why this course differs from other T-SQL courses
  • Course prerequisites (there aren't any !)
  • The 30 key pieces of SQL code that will be taught in the course
  • How to obtain the code used in the course
  • How to obtain either a free or low cost copy of Microsoft SQL Server & install the software
  • An Introduction to SQL Server Management Studio, the environment that we write and execute T-SQL in
  • IntelliSense, a tool that helps you write error free T-SQL code
  • Code commenting and how it can be used to improve the understanding of code
Preview 12:39

This Lecture Covers

  • Creating a new databases and tables
  • Inserting data into tables
  • Using online tools to format T-SQL and make it more readable
  • Writing a simple query to return all rows and columns from a table
  • "USE" & "GO" commands with T-SQL
  • Square brackets or double quotes to define multi-word column names
  • Using the "F1" command to obtain additional information about elements of code
  • Executing sections of T-SQL code in isolation.
  • Graphical User Interface to return top 1000 rows.
  • Dangers associated with using "Select * " to return all rows & columns from a table
Creating Databases & Tables
09:49

This Lecture Covers

  • Returning just a subset of columns
  • Sorting records in ascending or descending order
  • Returning unique results from a column
  • Returning records greater or less than a value
  • Returning the top records
  • Using wildcards to search for values to return
Creating simple queries
09:21

This Lecture Covers
  • Filtering on multiple values using a WHERE clause
  • Returns results between two values.
  • Returning NULL and NON NULL values
  • Combining Filters
  • Aggregating data into Groups
  • Filtering Groups
  • Combining columns using CONCATENATE
  • Joining tables with INNER, LEFT & RIGHT, & FULL Joins
Filtering queries, Grouping Data, & Joining Tables
13:36

This Lecture Covers
  • Creating Views
  • Creating Stored Procedure
  • Updating records in a Table
  • Backing-up tables
  • Deleting specific values from a table
  • Removing just the data from a table
  • Deleting a table
  • Deleting a database
Creating Views & Stored Procedures & Managing databases
12:50

Recommendations for next steps

  • Obtaining access to a work database or editing the database used in the course
  • Using the T-SQL forum on Microsoft Developer Network (MSDN) to answer questions.
  • Practice !
Course wrap up
02:33
About the Instructor
Steve Fox
4.6 Average rating
86 Reviews
1,367 Students
1 Course
Pragmatic Business Intelligence

I am a Business Intelligence (BI) professional with 15+ years experience in the Tech industry. I have interest in building Business Intelligence teams, and enjoy mentoring and training young analysts. I have built Business Intelligence teams in organisations ranging from large established companies such as Microsoft UK, through to smaller fast growing tech companies. In my spare time I run a popular Business Intelligence & Analytics training blog called Analyticsinaction.com. I am currently the VP of Analytics & Insights for a New Zealand based Tech company that produces cloud based Point of Sale (POS) software.

When I am not at work or writing for my blog I spend as much time as possible with my wife & 3 children. With any time left over I enjoy sea kayaking, diving, fishing and spending time in the outdoors.