Don't like banners? Log in and we will make sure you see no banners. For free.
PluralSight - Learning Path - Querying Data with T-SQL from SQL Server

PluralSight - Learning Path - Querying Data with T-SQL from SQL Server

Size
4.4 GB
Seeders
0
Leechers
3
Files
98
Category
Added
at 10:36pm GMT+1
Infohash
91decd8ea382284065d7e8f4521b95951317c74c
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
[ DevCourseWeb.com ] Learning Path - Querying Data with T-SQL from SQL Server



If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com







Last updated 5/2023

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English + vtt | Duration: 19h 17m | Size: 2.9 GB



T-SQL is Microsoft's implementation of SQL (Structured Query Language) used to query and manage data in the SQL Server relational database. This skill will teach you how to use T-SQL to query data from SQL Server



What You Will Learn

Querying data with the SELECT statement

Filtering data with the WHERE clause

Combining data with JOINs

Aggregating data

Inserting, updating, and deleting data



Table of Courses

Querying Data Using T-SQL

Combining and Filtering Data with T-SQL 2019

T-SQL Data Manipulation Playbook

Capturing Logic with Stored Procedures in T-SQL

T-SQL Functions Playbook

Querying JSON, XML, and Temporal Data with T-SQL

Handling Errors in T-SQL



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com



Get More Tutorials and Support Us -->> https://FreeCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...



Image error



Image error

File list
  • PluralSight - Learning Path - Querying Data with T-SQL from SQL Server
  • ~Get Your Files Here !/Bonus Resources.txt 386 B
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/01. Version Check.mp4 713.4 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/01. Version Check.vtt 7 B
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/02. Introduction.mp4 4.4 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/02. Introduction.vtt 3.7 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/03. What Is a Stored Procedure.mp4 3.7 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/03. What Is a Stored Procedure.vtt 3.5 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/04. Comparing Data Fetching Options.mp4 8 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/04. Comparing Data Fetching Options.vtt 7.2 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/05. Primary Stored Procedure Benefits.mp4 3.8 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/05. Primary Stored Procedure Benefits.vtt 3.4 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/06. Demo - Creating Test Environment.mp4 16.9 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/06. Demo - Creating Test Environment.vtt 7.5 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/07. Demo - Minimizing Modifications.mp4 7 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/07. Demo - Minimizing Modifications.vtt 3.8 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/08. Exploring Security Benefits.mp4 3.2 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/08. Exploring Security Benefits.vtt 3.3 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/09. Demo - Limiting User Access.mp4 7.5 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/09. Demo - Limiting User Access.vtt 3.7 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/10. Exploring Performance Gains.mp4 3.1 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/10. Exploring Performance Gains.vtt 3.4 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/11. Demo - Execution Plan Reuse.mp4 14.5 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/11. Demo - Execution Plan Reuse.vtt 6.1 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/12. Disadvantages of Stored Procedures.mp4 3.7 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/12. Disadvantages of Stored Procedures.vtt 3.9 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/13. Summary.mp4 2.4 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/13. Summary.vtt 2.3 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/01. Introduction.mp4 4 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/01. Introduction.vtt 3.6 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/02. Creating Our Stored Procedure.mp4 3 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/02. Creating Our Stored Procedure.vtt 2.8 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/03. Exploring New Syntax and Executing.mp4 4.6 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/03. Exploring New Syntax and Executing.vtt 4.2 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/04. Naming Stored Procedures.mp4 3.9 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/04. Naming Stored Procedures.vtt 3.7 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/05. Demo - Creating and Executing.mp4 14.2 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/05. Demo - Creating and Executing.vtt 7.7 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/06. Demo - Scripting Stored Procedures.mp4 12.9 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/06. Demo - Scripting Stored Procedures.vtt 6.6 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/07. Exploring Parameters.mp4 3.3 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/07. Exploring Parameters.vtt 3.5 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/08. Demo - Adding Parameters.mp4 15.6 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/08. Demo - Adding Parameters.vtt 7.8 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/09. Exploring Debugger.mp4 3 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/09. Exploring Debugger.vtt 2.8 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/10. Demo - Debugging Code.mp4 12.8 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/10. Demo - Debugging Code.vtt 7 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/11. Reviewing Best Practices.mp4 4.1 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/11. Reviewing Best Practices.vtt 4.3 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/12. Summary.mp4 2.9 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/12. Summary.vtt 2.6 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/01. Introduction.mp4 4.9 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/01. Introduction.vtt 4.3 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/02. Building Queries in Stored Procedures.mp4 2.4 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/02. Building Queries in Stored Procedures.vtt 2.6 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/03. Reviewing Temporary Objects.mp4 4.2 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/03. Reviewing Temporary Objects.vtt 4.1 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/04. Creating Temporary Objects.mp4 3.5 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/04. Creating Temporary Objects.vtt 3.2 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/05. Demo - Adding Queries to Stored Procedures.mp4 19.9 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/05. Demo - Adding Queries to Stored Procedures.vtt 9 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/06. Demo - Using Temporary Objects.mp4 21.1 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/06. Demo - Using Temporary Objects.vtt 10.6 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/07. Exploring Table Valued Parameters.mp4 5 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/07. Exploring Table Valued Parameters.vtt 5 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/08. Demo - Table Valued Parameters.mp4 8.7 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/08. Demo - Table Valued Parameters.vtt 4.4 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/09. Examining Sp_executesql.mp4 4.7 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/09. Examining Sp_executesql.vtt 4 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/10. Demo - Using Sp_executesql.mp4 14.8 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/10. Demo - Using Sp_executesql.vtt 6.4 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/11. Implementing a Debug Flag.mp4 2.8 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/11. Implementing a Debug Flag.vtt 3 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/12. Demo - Adding a Debug Flag.mp4 9.2 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/12. Demo - Adding a Debug Flag.vtt 4.1 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/13. Summary.mp4 2.7 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/13. Summary.vtt 2.6 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/1. Course Overview/1. Course Overview.mp4 3.5 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/1. Course Overview/1. Course Overview.vtt 2.4 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/1. Introduction.mp4 5.1 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/1. Introduction.vtt 4.8 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/2. Creating a Baseline.mp4 4.1 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/2. Creating a Baseline.vtt 3.8 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/3. Demo - Gathering Baseline Stats.mp4 20.1 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/3. Demo - Gathering Baseline Stats.vtt 9.3 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/4. Busting Performance Myths.mp4 4.4 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/4. Busting Performance Myths.vtt 3.8 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/5. Demo - Temp Table Myth.mp4 12.9 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/5. Demo - Temp Table Myth.vtt 5.5 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/6. Demo - Select 1 Versus Select.mp4 12.1 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/6. Demo - Select 1 Versus Select.vtt 5.4 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/7. Exploring Parameter Sniffing.mp4 3.5 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/7. Exploring Parameter Sniffing.vtt 3.5 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/8. Demo - Parameter Sniffing.mp4 23.3 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/8. Demo - Parameter Sniffing.vtt 10.1 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/9. Summary.mp4 2.6 MB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/9. Summary.vtt 2.5 KB
  • ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/1. Introduction.mp4 2.9 MB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.