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.1 (67 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,195 students enrolled
Instructed by Steve Fox Development / Databases
$19
$20
5% off
Take This Course
  • Lectures 6
  • Length 1 hour
  • 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 8/2014 English

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.

What are the requirements?

  • Microsoft SQL Server 2008, 2008 R2, 2012, or 2014. Obtaining a low or no-cost copy is discussed in the course.

What am I going to get from this course?

  • 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.

What is the target audience?

  • Students with no previous knowledge of SQL Server or 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 to T-SQL for Data Analysts using Microsoft SQL Server
12:39

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
09:49

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
09:21

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
13:36
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
12:50
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
02:33

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 !

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Steve Fox, 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.

Ready to start learning?
Take This Course