Introduction to Transact-SQL

Focused View

Jess Pomfret

1:03:54

50 View

01 - Introduction

01 - Transact-SQL.mp4

00:57

02 - What you should know.mp4

01:11

03 - What is T-SQL.mp4

01:24

04 - CoderPad tour.mp4

01:43

02 - 1. Introducing SELECT

01 - Structure of a SELECT statement.mp4

02:48

02 - Aliasing columns and tables.mp4

01:51

03 - Adding calculations to your result set.mp4

02:03

04 - Solution Simple SELECT statement .mp4

01:01

03 - 2. Filtering the Result Set

01 - Filtering data with WHERE using equalities.mp4

01:48

02 - Handling inequalities with WHERE clauses.mp4

02:07

03 - Find rows where strings partially match.mp4

02:42

04 - Filtering numeric data.mp4

02:31

05 - Combining multiple operators into one WHERE clause.mp4

02:24

06 - Understanding how NULL data affects query results.mp4

01:51

07 - Solution Filtered SELECT statement.mp4

01:38

04 - 3. Manipulating the Result Set

01 - ORDER BY.mp4

02:19

02 - TOP.mp4

01:51

03 - DISTINCT.mp4

01:45

04 - Solution Intermediate SELECT statement.mp4

01:12

05 - 4. Joins

01 - INNER JOIN.mp4

03:43

02 - LEFT JOIN.mp4

02:36

03 - FULL OUTER JOIN.mp4

01:53

04 - Combining more than two tables.mp4

02:29

05 - Solution Joins.mp4

01:26

06 - 5. DDL and DML Creating and Changing Data

01 - Create a table.mp4

03:52

02 - Insert data into a table.mp4

02:54

03 - Update data within a table.mp4

02:33

04 - Delete data from a table.mp4

01:55

05 - TRUNCATE a table.mp4

01:56

06 - Update data with a join.mp4

02:30

07 - Conclusion

01 - Next steps.mp4

01:01

Description

Relational databases and SQL servers have been a cornerstone of businesses for decades, and as data growth increases at an exponential pace, learning to work with data held in SQL Server databases is more important than ever. In this course, Jess Pomfret introduces Transact-SQL, an extension of SQL used to interact with relational databases that includes additional programming constructs and features beyond standard SQL, particularly procedural programming. Jess starts with the basics, guiding you through your first SELECT statement to help you get the data you need out of a database. She then shows how to add functionality to help filter, manipulate, and present the results you need. By the end of this course, you’ll be well equipped to write the T-SQL you need to get the job done.

This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice alongside the course content to advance your programming skills.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Jess Pomfret

Instructor's Courses

Jess Pomfret is a Data Platform Architect and a Microsoft MVP. She started working with SQL Server in 2011, and enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell. She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She has also contributed to the SqlServerDsc module, adding several new resources to use when configuring your SQL Servers. She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.