Pluralsight Developer SQL Playbook | 8D7DAA1F7C21717A857E50A947DDAE2CE2A9E9A9

Pluralsight Developer SQL Playbook

Name	Pluralsight - Developer s T-SQL Playbook	DOWNLOAD Copy Link
Total Size	456.3 MB
Total Files	51
Hash	8D7DAA1F7C21717A857E50A947DDAE2CE2A9E9A9

/01 Introduction/
01 01 Introduction.mp4	10.5 MB
/02 Working with Tables/
02 01 Creating a Table.mp4	13.4 MB
02 02 Primary Keys - Integer.mp4	10.4 MB
02 03 Primary Keys - GUID.mp4	6.6 MB
02 04 Primary Keys - Auto-incrementing.mp4	11.5 MB
02 05 Tangent - Choosing a Primary Key.mp4	16.1 MB
02 06 Composite Keys.mp4	11.7 MB
02 07 Defining Columns.mp4	8.8 MB
02 08 Basic Column Constraints.mp4	21.7 MB
02 09 Column Defaults.mp4	6.5 MB
02 10 Naming Conventions.mp4	10.2 MB
/03 Working with Data/
03 01 Inserting Data.mp4	12.5 MB
03 02 Bulk Inserts.mp4	8.4 MB
03 03 Updates.mp4	6.5 MB
03 04 Updates with Criteria.mp4	4.3 MB
03 05 Bulk Updates.mp4	4.5 MB
03 06 Delete.mp4	3.4 MB
03 07 Bulk Deletes.mp4	5.8 MB
/04 Querying Data/
04 01 Installing Chinook.mp4	4.8 MB
04 02 Simple Select.mp4	5.6 MB
04 03 Select Columns.mp4	7.6 MB
04 04 Aliasing Columns.mp4	5.8 MB
04 05 Column Expressions.mp4	4.5 MB
04 06 Tangent - Naming Things.mp4	7.4 MB
/05 Joining Tables/
05 01 Inner Joins.mp4	16.0 MB
05 02 Subqueries.mp4	9.6 MB
05 03 Left and Right Joins.mp4	9.2 MB
05 04 Full Joins.mp4	3.0 MB
/06 Filtering, Sifting, and Sorting Data/
06 01 Ordering Results.mp4	6.1 MB
06 02 Limiting Results.mp4	3.3 MB
06 03 Sequential Ordering.mp4	7.8 MB
06 04 Filtering by Sets.mp4	6.2 MB
06 05 Offsetting Results.mp4	7.4 MB
/07 Aggregates and Analysis/
07 01 Basic Aggregates.mp4	8.3 MB
07 02 Grouping Results.mp4	6.4 MB
07 03 A Simple Sales Query.mp4	7.9 MB
07 04 Tangent - Checking Your Numbers.mp4	10.5 MB
07 05 Constraining Aggregate Results.mp4	10.1 MB
/08 Many to Many and Self-referencing Relationships/
08 01 Adding Data to a Many to Many.mp4	5.0 MB
08 02 Querying a Many to Many.mp4	8.6 MB
08 03 Many to Many Table Constraints.mp4	23.9 MB
08 04 Querying a Self-referencing Table Using a Join.mp4	13.1 MB
08 05 Querying a Self-referencing Table with a Subquery.mp4	9.6 MB
/09 Essential String and Date Functions/
09 01 Querying Strings with a Partial Match.mp4	19.9 MB
09 02 Partial String Results with Substring.mp4	9.6 MB
09 03 Editing String Results with Replace.mp4	5.9 MB
09 04 Fixing Bad Data with Trim.mp4	8.9 MB
09 05 Fixing Bad Data with Rtrim Len and Datalength.mp4	10.9 MB
09 06 Slicing Dates with Datepart.mp4	6.6 MB
09 07 Doing Date Math with Datediff.mp4	9.8 MB
09 08 Summary and Goodbye.mp4	4.2 MB
Total files 51