Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to T-SQL for Data Analysts
Rating: 4.3 out of 5(225 ratings)
1,838 students

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
Created bySteve Fox
Last updated 9/2014
English

What you'll 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.

Course content

1 section • 6 lectures • 1h 0m total length

  • Introduction to T-SQL & Microsoft SQL Server12: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
  • Creating Databases & Tables9: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
  • Creating simple queries9: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
  • Filtering queries, Grouping Data, & Joining Tables13: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
  • Creating Views & Stored Procedures & Managing databases12: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
  • Course wrap up2: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 !

Requirements

  • Microsoft SQL Server 2008, 2012, 2014 or 2016. 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 to 2016. 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 this course is for:

  • Students with no previous knowledge of SQL Server or T-SQL.

Report abuse