Pluralsight SQL Server Fundamentals | 91A0AB26413A11F5E03358A29718A837943A9B09

Pluralsight SQL Server Fundamentals

Name	Pluralsight - SQL Server Fundamentals	DOWNLOAD Copy Link
Total Size	1.2 GB
Total Files	148
Hash	91A0AB26413A11F5E03358A29718A837943A9B09

/1. Introduction to SQL Server/
01. Overview.wmv	1.4 MB
02. What is SQL Server.wmv	1.5 MB
03. Application.wmv	5.9 MB
04. Using SSMS.wmv	5.9 MB
05. Drop a Database.wmv	1.2 MB
06. Add a Database.wmv	10.0 MB
07. Using T-SQL.wmv	11.3 MB
08. sqlcmd.wmv	17.8 MB
09. sqlps.wmv	12.0 MB
10. T-SQL Language.wmv	11.3 MB
11. Metadata.wmv	20.6 MB
12. T-SQL Example.wmv	18.7 MB
13. Scripting Objects.wmv	4.8 MB
14. Linq To Sql.wmv	7.6 MB
15. Linq to Sql Example.wmv	11.6 MB
16. SMO.wmv	5.7 MB
17. Analysis and Reporting.wmv	10.0 MB
18. SSAS.wmv	3.4 MB
19. SSIS.wmv	3.2 MB
20. SSRS.wmv	2.8 MB
21. Summary.wmv	5.2 MB
22. References.wmv	1.5 MB
/2. CTE's and Ranking/
01. CTE and Ranking Overview.wmv	3.4 MB
02. Common Table Expressions.wmv	5.2 MB
03. Demo CTE.wmv	29.2 MB
04. Top.wmv	2.3 MB
05. Demo Top.wmv	13.5 MB
06. Ranking.wmv	3.7 MB
07. Row Number.wmv	2.8 MB
08. Demo Row Number.wmv	14.2 MB
09. Rank and DenseRank.wmv	3.7 MB
10. Demo Rank and DenseRank.wmv	4.8 MB
11. NTile.wmv	2.9 MB
12. Demo Ntile.wmv	8.2 MB
13. Partitioning.wmv	4.2 MB
14. Demo Partitioning.wmv	6.9 MB
15. Aggregate Partitions.wmv	3.1 MB
16. Demo Aggregate Partitions.wmv	12.2 MB
17. Summary.wmv	3.8 MB
/2. Using Group By and Having/
01. Overview and Examples.wmv	13.3 MB
02. Basic Group By.wmv	36.0 MB
03. Using Aggregate Functions and Having.wmv	43.3 MB
04. Trimming Input And Summary.wmv	38.1 MB
/3. CTE's and Ranking/
01. CTE and Ranking Overview.wmv	3.4 MB
02. Common Table Expressions.wmv	5.2 MB
03. Demo CTE.wmv	29.2 MB
04. Top.wmv	2.3 MB
05. Demo Top.wmv	13.5 MB
06. Ranking.wmv	3.7 MB
07. Row Number.wmv	2.8 MB
08. Demo Row Number.wmv	14.2 MB
09. Rank and DenseRank.wmv	3.7 MB
10. Demo Rank and DenseRank.wmv	4.8 MB
11. NTile.wmv	2.9 MB
12. Demo Ntile.wmv	8.2 MB
13. Partitioning.wmv	4.2 MB
14. Demo Partitioning.wmv	6.9 MB
15. Aggregate Partitions.wmv	3.1 MB
16. Demo Aggregate Partitions.wmv	12.2 MB
17. Summary.wmv	3.8 MB
/3. Hierarchies/
01. Title.wmv	109.5 KB
02. Overview.wmv	983.7 KB
03. HierarchyidTree.wmv	2.3 MB
04. Why use hierarchyid.wmv	1.1 MB
05. Hierarchyid properties.wmv	3.0 MB
06. Demo Basic Properties.wmv	4.5 MB
07. Demo Manually finding descendants.wmv	4.8 MB
08. Finding Descendents.wmv	1.3 MB
09. Demo IsDescendantOf.wmv	6.6 MB
10. Adding Nodes.wmv	1.6 MB
11. Demo Adding nodes between.wmv	5.2 MB
12. Demo Adding nodes beforeafter.wmv	6.2 MB
13. Demo Adding hierarchyid column to table.wmv	11.9 MB
14. DemoIncrementally adding hierarchyid to table.wmv	8.1 MB
15. GetReparentedValue.wmv	1.7 MB
16. Demo Moving node.wmv	3.0 MB
17. Depth & Breadth.wmv	2.2 MB
18. Demo Indexes and triggers.wmv	8.2 MB
19. Summary.wmv	986.5 KB
/4. Managing Query Plans/
01. Overview.wmv	1,000.0 KB
02. Query Plans.wmv	2.3 MB
03. Query Optimizer.wmv	3.1 MB
04. Plan Reuse.wmv	3.0 MB
05. Example Plan Cache.wmv	16.0 MB
06. Example Stored Procedure Plan.wmv	17.2 MB
07. Ad hoc Expressions.wmv	3.5 MB
08. Example Ad hoc Optimization.wmv	10.5 MB
09. Example Ad hoc Off.wmv	1.6 MB
10. Parameterization.wmv	3.1 MB
11. Example Parameterization.wmv	28.4 MB
12. Example ADO.NET Parameters.wmv	9.1 MB
13. Plan Guides.wmv	3.3 MB
14. Kinds of Plan Guides.wmv	4.9 MB
15. Example Plan Guide.wmv	15.9 MB
16. Managing Plan Guides.wmv	1.3 MB
17. Example Managing Plan Guides.wmv	18.9 MB
18. Example Plan Guide From Handle.wmv	8.4 MB
19. Example Object Plan Guide.wmv	7.4 MB
20. Example Optimize For.wmv	11.6 MB
21. Example Template Plan Guide.wmv	11.8 MB
22. Summary.wmv	2.0 MB
/5. Recursion, Pivoting, and Sampling/
01. Overview.wmv	1.5 MB
02. Recursive Query.wmv	1.8 MB
03. Numeric Recursion Example.wmv	4.3 MB
04. Tabular Recursion Example.wmv	8.9 MB
05. Aggregate Recursion Example.wmv	2.3 MB
06. Pivot.wmv	1.3 MB
07. Cross-Tab Example.wmv	8.5 MB
08. Group By Equivalent.wmv	3.9 MB
09. Unpivot.wmv	4.5 MB
10. Entity Attribute Value.wmv	3.5 MB
11. Entity Attribute Example.wmv	6.0 MB
12. Sampling.wmv	1.8 MB
13. Sampling Example.wmv	12.9 MB
14. Summary.wmv	803.1 KB
/6. Security I/
01. Overview.wmv	1.9 MB
02. Databases and Security.wmv	2.2 MB
03. Authentication and Authorization.wmv	2.3 MB
04. Principals.wmv	4.8 MB
05. Example Managing Principals.wmv	1.4 MB
06. Example Server Principals.wmv	13.5 MB
07. Example Database Principals.wmv	28.9 MB
08. Example Role Principals.wmv	3.7 MB
09. Objects.wmv	7.1 MB
10. Authorization and Permissions.wmv	5.4 MB
11. Covering Permissions.wmv	1.9 MB
12. Example Authorizing Principals.wmv	12.6 MB
13. Example Using Permissions.wmv	20.0 MB
14. Example Impersonation.wmv	13.1 MB
15. Groups and Roles.wmv	1.2 MB
16. Example Groups and Roles.wmv	20.2 MB
17. Summary.wmv	2.1 MB
18. References.wmv	758.2 KB
/7. Security II/
01. Overview.wmv	4.4 MB
02. Schemas.wmv	2.7 MB
03. Schemas Example.wmv	48.7 MB
04. Schemas Summary.wmv	7.5 MB
05. Roles.wmv	2.3 MB
06. Server Roles.wmv	1.4 MB
07. Database Roles.wmv	1.3 MB
08. Roles Example.wmv	46.1 MB
09. Roles Summary.wmv	2.9 MB
10. Execution Context.wmv	1.2 MB
11. Changing Execution Context.wmv	1.4 MB
12. Execution Context Scope.wmv	1.7 MB
13. Execution Context Example.wmv	35.8 MB
14. Execution Context Summary.wmv	2.7 MB
15. Summary.wmv	1.8 MB
Total files 148