[ WebToolTip.com ] Complete Guide to T-SQL for Data Analysts by Microsoft Press

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/01 - Introduction/01 - Complete guide to T-SQL for data analysts Introduction.mp4

23 MB

~Get Your Files Here !/01 - Introduction/01 - Complete guide to T-SQL for data analysts Introduction.srt

16 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/01 - Learning objectives.mp4

4.2 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/01 - Learning objectives.srt

2.7 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/02 - Introduction to SQL and T-SQL.mp4

8.1 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/02 - Introduction to SQL and T-SQL.srt

7.4 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/03 - Describe features of structured data.mp4

8.1 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/03 - Describe features of structured data.srt

7.0 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/04 - Describe features of semistructured data.mp4

7.0 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/04 - Describe features of semistructured data.srt

5.3 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/05 - Describe features of unstructured data.mp4

3.2 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/05 - Describe features of unstructured data.srt

2.5 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/06 - Describe common data storage mechanisms.mp4

12 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/06 - Describe common data storage mechanisms.srt

10 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/07 - Relational database concepts.mp4

38 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/07 - Relational database concepts.srt

30 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/08 - Describe features of transactional workloads.mp4

15 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/08 - Describe features of transactional workloads.srt

14 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/09 - Describe features of analytical workloads.mp4

16 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/09 - Describe features of analytical workloads.srt

18 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/10 - GitHub repository.mp4

3.3 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/10 - GitHub repository.srt

2.0 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/11 - Tool installation.mp4

11 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/11 - Tool installation.srt

8.6 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/12 - Database setup.mp4

11 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/12 - Database setup.srt

7.8 kB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/13 - Schema walkthrough.mp4

14 MB

~Get Your Files Here !/02 - 1. Data Concepts and Technical Setup/13 - Schema walkthrough.srt

8.9 kB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/01 - Learning objectives.mp4

5.6 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/01 - Learning objectives.srt

4.4 kB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/02 - Introduction to writing SQL.mp4

18 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/02 - Introduction to writing SQL.srt

14 kB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/03 - Basic SQL.mp4

23 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/03 - Basic SQL.srt

17 kB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/04 - Filtering result sets Basics.mp4

9.4 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/04 - Filtering result sets Basics.srt

7.0 kB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/05 - Filtering result sets Handling NULLS.mp4

16 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/05 - Filtering result sets Handling NULLS.srt

12 kB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/06 - Filtering result sets Next level.mp4

87 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/07 - Sorting result sets.mp4

22 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/07 - Sorting result sets.srt

16 kB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/08 - Single-row functions.mp4

60 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/09 - Aggregate functions.mp4

15 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/09 - Aggregate functions.srt

12 kB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/10 - Exercise.mp4

8.9 MB

~Get Your Files Here !/03 - 2. Writing Single Table Queries/10 - Exercise.srt

6.8 kB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/01 - Learning objectives.mp4

4.0 MB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/01 - Learning objectives.srt

2.9 kB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/02 - Introduction to joins.mp4

9.8 MB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/02 - Introduction to joins.srt

9.2 kB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/03 - INNER joins.mp4

5.6 MB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/03 - INNER joins.srt

4.9 kB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/04 - OUTER joins.mp4

15 MB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/04 - OUTER joins.srt

13 kB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/05 - CROSS joins.mp4

3.4 MB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/05 - CROSS joins.srt

3.2 kB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/06 - Special joins.mp4

19 MB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/06 - Special joins.srt

16 kB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/07 - Exercise.mp4

19 MB

~Get Your Files Here !/04 - 3. Joining Multiple Tables/07 - Exercise.srt

13 kB

~Get Your Files Here !/05 - 4. Writing Subqueries/01 - Learning objectives.mp4

3.6 MB

~Get Your Files Here !/05 - 4. Writing Subqueries/01 - Learning objectives.srt

2.6 kB

~Get Your Files Here !/05 - 4. Writing Subqueries/02 - Introduction to subqueries.mp4

1.8 MB

~Get Your Files Here !/05 - 4. Writing Subqueries/02 - Introduction to subqueries.srt

1.3 kB

~Get Your Files Here !/05 - 4. Writing Subqueries/03 - Self-contained subqueries.mp4

20 MB

~Get Your Files Here !/05 - 4. Writing Subqueries/03 - Self-contained subqueries.srt

12 kB

~Get Your Files Here !/05 - 4. Writing Subqueries/04 - Correlated subqueries.mp4

16 MB

~Get Your Files Here !/05 - 4. Writing Subqueries/04 - Correlated subqueries.srt

11 kB

~Get Your Files Here !/05 - 4. Writing Subqueries/05 - Exercise.mp4

8.2 MB

~Get Your Files Here !/05 - 4. Writing Subqueries/05 - Exercise.srt

5.2 kB

~Get Your Files Here !/06 - 5. Set Operators/01 - Learning objectives.mp4

5.5 MB

~Get Your Files Here !/06 - 5. Set Operators/01 - Learning objectives.srt

3.5 kB

~Get Your Files Here !/06 - 5. Set Operators/02 - Defining and rules for using set operators.mp4

21 MB

~Get Your Files Here !/06 - 5. Set Operators/02 - Defining and rules for using set operators.srt

17 kB

~Get Your Files Here !/06 - 5. Set Operators/03 - UNION.mp4

7.5 MB

~Get Your Files Here !/06 - 5. Set Operators/03 - UNION.srt

6.3 kB

~Get Your Files Here !/06 - 5. Set Operators/04 - EXCEPT.mp4

4.6 MB

~Get Your Files Here !/06 - 5. Set Operators/04 - EXCEPT.srt

3.9 kB

~Get Your Files Here !/06 - 5. Set Operators/05 - INTERSECT.mp4

4.4 MB

~Get Your Files Here !/06 - 5. Set Operators/05 - INTERSECT.srt

3.7 kB

~Get Your Files Here !/06 - 5. Set Operators/06 - Exercise.mp4

9.4 MB

~Get Your Files Here !/06 - 5. Set Operators/06 - Exercise.srt

5.2 kB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/01 - Learning objectives.mp4

6.5 MB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/01 - Learning objectives.srt

4.4 kB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/02 - Inserting data.mp4

30 MB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/02 - Inserting data.srt

20 kB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/03 - Updating data.mp4

22 MB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/03 - Updating data.srt

13 kB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/04 - Deleting data.mp4

7.0 MB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/04 - Deleting data.srt

5.3 kB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/05 - Truncating a table.mp4

5.9 MB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/05 - Truncating a table.srt

5.3 kB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/06 - Exercise.mp4

15 MB

~Get Your Files Here !/07 - 6. Manipulate Data in a Database/06 - Exercise.srt

9.9 kB

~Get Your Files Here !/08 - 7. Design a Database/01 - Learning objectives.mp4

5.3 MB

~Get Your Files Here !/08 - 7. Design a Database/01 - Learning objectives.srt

3.5 kB

~Get Your Files Here !/08 - 7. Design a Database/02 - System development lifecycle (SDLC).mp4

8.0 MB

~Get Your Files Here !/08 - 7. Design a Database/02 - System development lifecycle (SDLC).srt

7.2 kB

~Get Your Files Here !/08 - 7. Design a Database/03 - Logical design.mp4

13 MB

~Get Your Files Here !/08 - 7. Design a Database/03 - Logical design.srt

12 kB

~Get Your Files Here !/08 - 7. Design a Database/04 - Normalization.mp4

18 MB

~Get Your Files Here !/08 - 7. Design a Database/04 - Normalization.srt

16 kB

~Get Your Files Here !/08 - 7. Design a Database/05 - Exercise.mp4

8.5 MB

~Get Your Files Here !/08 - 7. Design a Database/05 - Exercise.srt

6.8 kB

~Get Your Files Here !/09 - 8. Build a Database/01 - Learning objectives.mp4

5.6 MB

~Get Your Files Here !/09 - 8. Build a Database/01 - Learning objectives.srt

3.9 kB

~Get Your Files Here !/09 - 8. Build a Database/02 - Creating and managing tables.mp4

18 MB

~Get Your Files Here !/09 - 8. Build a Database/02 - Creating and managing tables.srt

17 kB

~Get Your Files Here !/09 - 8. Build a Database/03 - Data integrity constraints.mp4

18 MB

~Get Your Files Here !/09 - 8. Build a Database/03 - Data integrity constraints.srt

17 kB

~Get Your Files Here !/09 - 8. Build a Database/04 - Speeding data access Indexing.mp4

4.6 MB

~Get Your Files Here !/09 - 8. Build a Database/04 - Speeding data access Indexing.srt

4.5 kB

~Get Your Files Here !/09 - 8. Build a Database/05 - Create interfaces to the database using VIEWS.mp4

3.6 MB

~Get Your Files Here !/09 - 8. Build a Database/05 - Create interfaces to the database using VIEWS.srt

3.3 kB

~Get Your Files Here !/09 - 8. Build a Database/06 - Exercise.mp4

26 MB

~Get Your Files Here !/09 - 8. Build a Database/06 - Exercise.srt

16 kB

~Get Your Files Here !/10 - 9. Manage a Database/01 - Learning objectives.mp4

4.0 MB

~Get Your Files Here !/10 - 9. Manage a Database/01 - Learning objectives.srt

3.2 kB

~Get Your Files Here !/10 - 9. Manage a Database/02 - Controlling user access.mp4

7.5 MB

~Get Your Files Here !/10 - 9. Manage a Database/02 - Controlling user access.srt

6.6 kB

~Get Your Files Here !/10 - 9. Manage a Database/03 - Transactions.mp4

16 MB

~Get Your Files Here !/10 - 9. Manage a Database/03 - Transactions.srt

13 kB

~Get Your Files Here !/10 - 9. Manage a Database/04 - Metadata.mp4

11 MB

~Get Your Files Here !/10 - 9. Manage a Database/04 - Metadata.srt

6.8 kB

~Get Your Files Here !/11 - 10. Exploring the Road Ahead/01 - Learning objectives.mp4

6.1 MB

~Get Your Files Here !/11 - 10. Exploring the Road Ahead/01 - Learning objectives.srt

4.5 kB

~Get Your Files Here !/11 - 10. Exploring the Road Ahead/02 - Other T-SQL constructs Next level.mp4

6.2 MB

~Get Your Files Here !/11 - 10. Exploring the Road Ahead/02 - Other T-SQL constructs Next level.srt

6.2 kB

~Get Your Files Here !/11 - 10. Exploring the Road Ahead/03 - Peek into Azure databases.mp4

16 MB

~Get Your Files Here !/11 - 10. Exploring the Road Ahead/03 - Peek into Azure databases.srt

15 kB

~Get Your Files Here !/12 - Conclusion/01 - Complete guide to T-SQL for data analysts Next steps.mp4

5.9 MB

~Get Your Files Here !/12 - Conclusion/01 - Complete guide to T-SQL for data analysts Next steps.srt

3.9 kB

~Get Your Files Here !/Bonus Resources.txt

70 B