Pluralsight Developer SQL Playbook | F306D410E1AB13D30E1AB54D76E1525DA5413341

Pluralsight Developer SQL Playbook

Name	Pluralsight - Developer s T-SQL Playbook	DOWNLOAD Copy Link
Total Size	448.5 MB
Total Files	51
Hash	F306D410E1AB13D30E1AB54D76E1525DA5413341

/01. Introduction/
01_01-Introduction.mp4	7.7 MB
/02. Working with Tables/
02_01-Creating a Table.mp4	8.8 MB
02_02-Primary Keys Integer.mp4	7.1 MB
02_03-Primary Keys GUID.mp4	4.6 MB
02_04-Primary Keys Autoincrementing.mp4	8.2 MB
02_05-Tangent Choosing a Primary Key.mp4	13.5 MB
02_06-Composite Keys.mp4	10.8 MB
02_07-Defining Columns.mp4	7.0 MB
02_08-Basic Column Constraints.mp4	19.1 MB
02_09-Column Defaults.mp4	6.1 MB
02_10-Naming Conventions.mp4	10.5 MB
/03. Working with Data/
03_01-Inserting Data.mp4	9.2 MB
03_02-Bulk Inserts.mp4	7.4 MB
03_03-Updates.mp4	8.2 MB
03_04-Updates with Criteria.mp4	5.3 MB
03_05-Bulk Updates.mp4	5.3 MB
03_06-Delete.mp4	3.9 MB
03_07-Bulk Deletes.mp4	6.7 MB
/04. Querying Data/
04_01-Installing Chinook.mp4	4.7 MB
04_02-Simple Select.mp4	4.3 MB
04_03-Select Columns.mp4	8.1 MB
04_04-Aliasing Columns.mp4	6.0 MB
04_05-Column Expressions.mp4	4.7 MB
04_06-Tangent Naming Things.mp4	7.7 MB
/05. Joining Tables/
05_01-Inner Joins.mp4	18.5 MB
05_02-Subqueries.mp4	8.4 MB
05_03-Left and Right Joins.mp4	8.9 MB
05_04-Full Joins.mp4	2.7 MB
/06. Filtering, Sifting, and Sorting Data/
06_01-Ordering Results.mp4	7.9 MB
06_02-Limiting Results.mp4	4.3 MB
06_03-Sequential Ordering.mp4	10.9 MB
06_04-Filtering by Sets.mp4	8.5 MB
06_05-Offsetting Results.mp4	9.6 MB
/07. Aggregates and Analysis/
07_01-Basic Aggregates.mp4	9.1 MB
07_02-Grouping Results.mp4	5.4 MB
07_03-A Simple Sales Query.mp4	8.4 MB
07_04-Tangent Checking Your Numbers.mp4	14.1 MB
07_05-Constraining Aggregate Results.mp4	9.8 MB
/08. Many to Many and Selfreferencing Relationships/
08_01-Adding Data to a Many to Many.mp4	5.9 MB
08_02-Querying a Many to Many.mp4	9.9 MB
08_03-Many to Many Table Constraints.mp4	27.4 MB
08_04-Querying a Selfreferencing Table Using a Join.mp4	13.4 MB
08_05-Querying a Selfreferencing Table with a Subquery.mp4	9.7 MB
/09. Essential String and Date Functions/
09_01-Querying Strings with a Partial Match.mp4	18.3 MB
09_02-Partial String Results with Substring.mp4	8.7 MB
09_03-Editing String Results with Replace.mp4	5.1 MB
09_04-Fixing Bad Data with Trim.mp4	7.5 MB
09_05-Fixing Bad Data with Rtrim Len and Datalength.mp4	9.6 MB
09_06-Slicing Dates with Datepart.mp4	6.7 MB
09_07-Doing Date Math with Datediff.mp4	12.7 MB
09_08-Summary and Goodbye.mp4	2.3 MB
Total files 51