Description
Course info
Rating
(19)
Level
Beginner
Updated
Sep 10, 2019
Duration
3h 10m
Description

Are you looking to start out or brush up on your skills in T-SQL? In this course, Combining and Filtering Data with T-SQL, you will learn foundational knowledge of how to work with data and T-SQL. First, you will learn how to format and calculate data, and about logic functions. Next, you will discover how to join data from two or more tables. Finally, you will explore how to aggregate data to find the sum, minimum, maximum, count, and average values, as well as learn about intermediary tables. When you are finished with this course, you will have the skills and knowledge to write queries, validate results from a query, and work with variables.

About the author
About the author

Tamara Pattinson is the founder of JET Technical (www.jettechnical.com) and has been involved in the IT world and project management for over 20 years. As a former Dean of Computer Science she taught the full gamut of software development languages, SQL, database administration and design, and project management.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Tamara Pattinson, and I'd like to welcome you to my course, Combining and Filtering Data with T-SQL. I've been involved with programming and database management for over 20 years and I'm a former dean of computer science, so I enjoy teaching and I have a passion for technology, which is why I'm so excited to bring this course to you and help you begin your journey to learning the structured query language. Some of the major topics we'll cover include formatting and calculating data in a query, logic functions, joining data from two or more tables, aggregating data to find the sum, minimum, maximum count, and average values, and intermediary tables. By the end of this course, you'll have the knowledge to write queries that will return result sets using methods, joins, temporary tables, and set operators. Validate the results from the query, work with variables, declaring and setting their values, to create queries that can be used for ad hoc reporting. From here, you should feel comfortable diving into the more advanced SQL techniques for creating view, writing stored procedures, user defined functions, and even designing and creating your own databases. I'm not expecting you to have any prior knowledge of programming or the structured query language. If you're just starting out or you're looking to brush up on your skills, this is the right place to begin. I hope you'll join me in this course, Combining and Filtering Data with T-SQL, at Pluralsight.