Other
SQL for Data Analysis & Data Science
Torrent info
Torrent Files List
[TutsNode.com] - SQL for Data Analysis & Data Science (Size: 2.53 GB) (Files: 185)
[TutsNode.com] - SQL for Data Analysis & Data Science
29. Extra1 Scrape the Web & Saving Data to a Database
1. How to Srcape a website.mp4
1. How to Srcape a website.srt
2. Scrape a webpage using Pandas and LXML Python Modules.mp4
2. Scrape a webpage using Pandas and LXML Python Modules.srt
3. Visualization of the Scarped Data.mp4
3. Visualization of the Scarped Data.srt
4. Save The Scraped Data to a Database.mp4
4. Save The Scraped Data to a Database.srt
1. Introduction
1. Course Introduction.mp4
1. Course Introduction.srt
2. PostgreSQl database Download & Install
1. PostgreSQl Download & Install.mp4
1. PostgreSQl Download & Install.srt
2. Create Database.mp4
2. Create Database.srt
3. Restore Database.mp4
3. Restore Database.srt
3.1 ERD + License.pdf
3.2 Airlines.sql
3. Test You Self (1)
1. Test You Self (1).html
2. Test You Self (1) Solution.html
4. Database Airlines Overview
1. Database Overview 1.mp4
1. Database Overview 1.srt
1.1 ERD + License.pdf
2. Database Overview 2.mp4
2. Database Overview 2.srt
2.1 ERD + License.pdf
5. SQL Basics
1. SQL Data Types.mp4
1. SQL Data Types.srt
2. Select Statement.mp4
2. Select Statement.srt
3. Select Challenge Solution.mp4
3. Select Challenge Solution.srt
4. Select Statement For all Airlines Database Tables.mp4
4. Select Statement For all Airlines Database Tables.srt
5. Distinct.mp4
5. Distinct.srt
6. Where Clause.mp4
6. Where Clause.srt
7. Operators used with Where Clause.mp4
7. Operators used with Where Clause.srt
8. Where Clause + AND & Where Clause + OR.mp4
8. Where Clause + AND & Where Clause + OR.srt
9. Where Clause + LIKE.mp4
9. Where Clause + LIKE.srt
10. LIMIT & ORDER BY.mp4
10. LIMIT & ORDER BY.srt
11. FETCH vs LIMIT.mp4
11. FETCH vs LIMIT.srt
12. (Where Clause + BETWEEN & IN) & AS.mp4
12. (Where Clause + BETWEEN & IN) & AS.srt
13. NOT IN.mp4
13. NOT IN.srt
14. ISNULL & IS NOT NULL.mp4
14. ISNULL & IS NOT NULL.srt
15. CAST.mp4
15. CAST.srt
6. Test You Self (2)
1. Test You Self (2).html
2. Test You Self (2) Solution.html
7. SQL Basics Challenge
1. SQL Basics Challenge.html
2. SQL Basics Challenge Solution.html
8. SQL Aggregations
1. COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE.mp4
1. COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE.srt
2. SUM( ) Function.mp4
2. SUM( ) Function.srt
3. MIN( ) , MAX( ) & AVG( ) Functions.mp4
3. MIN( ) , MAX( ) & AVG( ) Functions.srt
4. GROUP BY & HAVING.mp4
4. GROUP BY & HAVING.srt
9. Test You Self (3)
1. Test You Self (3).html
2. Test You Self (3) solution.html
10. SQL Aggregation Challenge
1. SQL Aggregation Challenge.html
2. SQL Aggregation Challenge Solution.html
11. SQL Conditional
1. CASE.mp4
1. CASE.srt
2. NULLIF().mp4
2. NULLIF().srt
3. COALESCE() Function in SQL.mp4
3. COALESCE() Function in SQL.srt
12. Test You Self (4)
1. Test You Self (4).html
2. Test You Self (4) solution.html
13. SQL Conditional Challenge
1. SQL Conditional Challenge.html
2. SQL Conditional Challenge Solution.html
14. SQL Time Data management
1. Overview of Time Functions in PostgreSQL.mp4
1. Overview of Time Functions in PostgreSQL.srt
2. TIMESTAMP EXTRACT().mp4
2. TIMESTAMP EXTRACT().srt
3. DATE_TRUNC() & DATE_PART().mp4
3. DATE_TRUNC() & DATE_PART().srt
4. DATE IN PostgreSQL & CURRENT_DATE & now( ).mp4
4. DATE IN PostgreSQL & CURRENT_DATE & now( ).srt
15. SQL Joins
1. INNER JOIN.mp4
1. INNER JOIN.srt
2. Joins Types.mp4
2. Joins Types.srt
2.1 JOINS.pdf
3. LEFT OUTER JOIN.mp4
3. LEFT OUTER JOIN.srt
4. Deep understanding of LEFT JOIN.mp4
4. Deep understanding of LEFT JOIN.srt
5. RIGHT OUTER JOIN.mp4
5. RIGHT OUTER JOIN.srt
6. FULL OUTER JOIN.mp4
6. FULL OUTER JOIN.srt
7. CROSS JOIN.mp4
7. CROSS JOIN.srt
8. UNION, UNION ALL, INTERSECT & EXCEPT.mp4
8. UNION, UNION ALL, INTERSECT & EXCEPT.srt
9. SELF JOIN.mp4
9. SELF JOIN.srt
10. USING.mp4
10. USING.srt
11. NATURAL JOIN.mp4
11. NATURAL JOIN.srt
16. Test You Self (5)
1. Test You Self (5).html
2. Test You Self (5) solution.html
17. SQL JOINS Challenge
1. SQL JOINS Challenge.html
2. SQL JOINS Challenge Solution.html
18. Intermediate SQL
1. Sub-queries.mp4
1. Sub-queries.srt
2. SQL Sub-query + EXISTS OR ANY OR ALL.mp4
2. SQL Sub-query + EXISTS OR ANY OR ALL.srt
3. Common Table Expression.mp4
3. Common Table Expression.srt
19. Test You Self (6)
1. Test You Self (6).html
2. Test You Self (6) solution.html
20. SQL Sub-query Challenge
1. SQL Sub-query CTE Challenge.html
2. SQL Sub-query CTE Challenge Solution.html
21. Advanced PostgreSQL Functions
1. Math Functions.mp4
1. Math Functions.srt
2. Window Functions OVER().mp4
2. Window Functions OVER().srt
3. Window Functions RANK() + OVER() & NTILE() + OVER().mp4
3. Window Functions RANK() + OVER() & NTILE() + OVER().srt
4. Window Functions OVER() + LEAD().mp4
4. Window Functions OVER() + LEAD().srt
5. Window Functions OVER() + LAG().mp4
5. Window Functions OVER() + LAG().srt
22. Advanced SQL
1. GROUPING SETS(), ROLLUP(), CUBE().mp4
1. GROUPING SETS(), ROLLUP(), CUBE().srt
2. SELECT Statement + INTO & SELECT Statement + INTO + IN.mp4
2. SELECT Statement + INTO & SELECT Statement + INTO + IN.srt
3. VIEW().mp4
3. VIEW().srt
23. Test You Self (7)
1. Test You Self (7).html
2. Test You Self (7) Solution.html
24. PostgreSQL String Functions
1. PostgreSQL POSITION Function.mp4
1. PostgreSQL POSITION Function.srt
2. STRPOS() & REPLACE() in PostgreSQL.mp4
2. STRPOS() & REPLACE() in PostgreSQL.srt
3. PostgreSQL LEFT(), RIGHT(), BTRIM() & SPLIT_PART() Functions.mp4
3. PostgreSQL LEFT(), RIGHT(), BTRIM() & SPLIT_PART() Functions.srt
4. PostgreSQL CONCAT Function.mp4
4. PostgreSQL CONCAT Function.srt
5. PostgreSQL LOWER(), UPPER() & INITCAP() Functions.mp4
5. PostgreSQL LOWER(), UPPER() & INITCAP() Functions.srt
25. Test You Self (8)
1. Test You Self (8).html
2. Test You Self (8) solution.html
26. Python + PostgreSQL introduction
1. Python Download & Install.mp4
1. Python Download & Install.srt
2. Online jupyter lab.mp4
2. Online jupyter lab.srt
3. Using CMD & Python Pip.PyPi to Install Jupyter Lab & Pandas.mp4
3. Using CMD & Python Pip.PyPi to Install Jupyter Lab & Pandas.srt
4. Jupyter Commands.html
5. Using Python to load and querying PostgreSQL Database.mp4
5. Using Python to load and querying PostgreSQL Database.srt
6. Runnig SQL Query Using Python Panadas Module.mp4
6. Runnig SQL Query Using Python Panadas Module.srt
7. Using Python Pandas Package to load PostgreSQL the Data Output file.mp4
7. Using Python Pandas Package to load PostgreSQL the Data Output file.srt
27. Using Python in Data Analysis of PostgreSQL Data output
1. Data Analysis Process Overview.mp4
1. Data Analysis Process Overview.srt
2. Pandas Methods.mp4
2. Pandas Methods.srt
3. Pandas Data Analysis.mp4
3. Pandas Data Analysis.srt
4. Pandas data visualization.mp4
4. Pandas data visualization.srt
5. Sampling Error.mp4
5. Sampling Error.srt
28. Final Exam
1. Final Exam.html
2. Final Exam Solution.html
30. Bonus Section -Thank You
1. Bonus Section -Thank You.html
TutsNode.com.txt
[TGx]Downloaded from torrentgalaxy.to .txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch SQL for Data Analysis & Data Science Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
