Brief Introduction
In 60 minutes, learn 30 of the most important Transact-SQL (T-SQL) tasks that data analysts need to performDescription
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.
Requirements
- Requirements
- Microsoft SQL Server 2008, 2012, 2014 or 2016. Obtaining a low or no-cost copy is discussed in the course.
Steve Fox
4.1 Raiting
SQL for Beginners with Microsoft SQL Server Database
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Step by Step guide for learning SQL. Go from Zero to Hero and learn SQL with Microsoft SQL Server Database. Data is a every where....
Managing Big Data with MySQL
- 4.7
-
![]()
![]()
![]()
![]()
![]()
This course is an introduction to how to use relational databases in business analysis. About this Specialization and Course About this Specialization...
Prepare Data for Exploration
- 4.8
-
![]()
![]()
![]()
![]()
![]()
This is the third course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs....
Introduction to Data Engineering
- 4.7
-
![]()
![]()
![]()
![]()
![]()
This course introduces you to the core concepts, processes, and tools you need to know in order to get a foundational knowledge of data engineering....
