Introduction to T-SQL for Data Analysts

Introduction to T-SQL for Data Analysts, available at $34.99, has an average rating of 4.2, with 6 lectures, based on 221 reviews, and has 1836 subscribers.

You will learn about 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. This course is ideal for individuals who are Students with no previous knowledge of SQL Server or T-SQL. It is particularly useful for Students with no previous knowledge of SQL Server or T-SQL.

Enroll now: Introduction to T-SQL for Data Analysts

Summary

Title: Introduction to T-SQL for Data Analysts

Price: $34.99

Average Rating: 4.2

Number of Lectures: 6

Number of Published Lectures: 6

Number of Curriculum Items: 6

Number of Published Curriculum Objects: 6

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction to T-SQL for Data Analysts using Microsoft SQL Server

Lecture 1: Introduction to T-SQL & Microsoft SQL Server

Lecture 2: Creating Databases & Tables

Lecture 3: Creating simple queries

Lecture 4: Filtering queries, Grouping Data, & Joining Tables

Lecture 5: Creating Views & Stored Procedures & Managing databases

Lecture 6: Course wrap up

Instructors

Steve Fox
Pragmatic Business Intelligence

Rating Distribution

1 stars: 5 votes
2 stars: 3 votes
3 stars: 25 votes
4 stars: 99 votes
5 stars: 89 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu