|
|
1. Basics of Data Visualization.html
|
HTML
|
2.4 KB
|
|
|
1. Data Cleaning in SQL.html
|
HTML
|
2.4 KB
|
|
|
1. Designing and Building Databases.html
|
HTML
|
307.2 B
|
|
|
1. Introduction to Descriptive Statistics in SQL.html
|
HTML
|
2 KB
|
|
|
1. Introduction to Hadoop and Spark.html
|
HTML
|
2.8 KB
|
|
|
1. Introduction to NoSQL databases.html
|
HTML
|
2.7 KB
|
|
|
1. Introduction to Windows Functions.html
|
HTML
|
1.8 KB
|
|
|
1. Introduction.html
|
HTML
|
204.8 B
|
|
|
1. Note on database downloads.html
|
HTML
|
204.8 B
|
|
|
1. Real-world data engineering and data analysis project using SQL.html
|
HTML
|
2.6 KB
|
|
|
1. SQL Best Practices and Performance Optimization.html
|
HTML
|
2.5 KB
|
|
|
1. SQL Joins.html
|
HTML
|
204.8 B
|
|
|
1. SQL Syntax.html
|
HTML
|
3.2 KB
|
|
|
1. What is CRUD.html
|
HTML
|
1.5 KB
|
|
|
10. Handling Large Datasets Partitioning, Sharding, Indexing Strategies.html
|
HTML
|
307.2 B
|
|
|
10. Introduction to MySQL Workbench.mp4
|
MP4
|
33.8 MB
|
|
|
10. LEAD() Function.mp4
|
MP4
|
34.7 MB
|
|
|
10. Perform a Delete Operation.mp4
|
MP4
|
23.9 MB
|
|
|
10. SQL Indexes.html
|
HTML
|
2.5 KB
|
|
|
10. SQL with Data Visualization Tools Tableau, PowerBI.html
|
HTML
|
2.5 KB
|
|
|
10. T-SQL CASE Expression.mp4
|
MP4
|
52.8 MB
|
|
|
11. FIRST_VALUE() Function.mp4
|
MP4
|
19.4 MB
|
|
|
11. Installing MySQL Workbench on Mac.mp4
|
MP4
|
44.5 MB
|
|
|
11. Partitioning, Sharding, Indexing Strategies.html
|
HTML
|
2.3 KB
|
|
|
11. SQL Constraints.html
|
HTML
|
2.6 KB
|
|
|
11. T-SQL SUBSTRING Function.mp4
|
MP4
|
24.1 MB
|
|
|
12. Installing PostgreSQL on Windows.mp4
|
MP4
|
45.1 MB
|
|
|
12. LAST_VALUE() Function.mp4
|
MP4
|
22.6 MB
|
|
|
12. T-SQL CONVERT Function.mp4
|
MP4
|
18.1 MB
|
|
|
13. Installing PostgreSQL on Mac.mp4
|
MP4
|
16.2 MB
|
|
|
13. NTH_VALUE() Function.mp4
|
MP4
|
20.2 MB
|
|
|
13. T-SQL CAST Function.mp4
|
MP4
|
36 MB
|
|
|
14. Installing PgAdmin for PostgreSQL on Mac.mp4
|
MP4
|
32.3 MB
|
|
|
14. Using Multiple Ranking Functions.mp4
|
MP4
|
30 MB
|
|
|
15. Connect PgAdmin to PostgreSQL Database Server.mp4
|
MP4
|
20.6 MB
|
|
|
16. Restore sample database to PostgreSQL Database Server.mp4
|
MP4
|
46.5 MB
|
|
|
17. Download Oracle Database Server.mp4
|
MP4
|
26.9 MB
|
|
|
18. Install Oracle Database Server.mp4
|
MP4
|
7.8 MB
|
|
|
19. What is SQLPlus.mp4
|
MP4
|
14.9 MB
|
|
|
2. Aggregate Functions.html
|
HTML
|
716.8 B
|
|
|
2. Create a database in multiple systems.mp4
|
MP4
|
39 MB
|
|
|
2. Data modeling.html
|
HTML
|
2.1 KB
|
|
|
2. Definition and Roles of a Data Analyst and Data Engineer.html
|
HTML
|
2.7 KB
|
|
|
2. Difference between SQL and NoSQL.html
|
HTML
|
2.9 KB
|
|
|
2. Introduction to Analytic Functions.mp4
|
MP4
|
21.6 MB
|
|
|
2. LEFT JOIN.mp4
|
MP4
|
29.5 MB
|
|
|
2. Project Approach (High-level overview.).html
|
HTML
|
2.8 KB
|
|
|
2. SQL Data Cleaning Examples.html
|
HTML
|
2.6 KB
|
|
|
2. SQL Data Types.html
|
HTML
|
2.4 KB
|
|
|
2. SQL Server Editions.mp4
|
MP4
|
28.2 MB
|
|
|
2. SQL best practices and performance optimization examples with Oracle Database.html
|
HTML
|
3 KB
|
|
|
2. SQL with Big Data Hive and SparkSQL.html
|
HTML
|
2.1 KB
|
|
|
2. STRING Functions.html
|
HTML
|
716.8 B
|
|
|
2. Tableau Public Desktop.mp4
|
MP4
|
7.2 MB
|
|
|
20. Connect SQLPLus to Oracle.mp4
|
MP4
|
14 MB
|
|
|
21. Create a new database user in Oracle with SQLPlus.mp4
|
MP4
|
8.6 MB
|
|
|
22. Create a new table in Oracle with SQLPlus.mp4
|
MP4
|
7.6 MB
|
|
|
23. What is Oracle SQL Developer.mp4
|
MP4
|
9.4 MB
|
|
|
24. Download Oracle SQL Developer.mp4
|
MP4
|
20 MB
|
|
|
25. Connect SQL Developer to Oracle.mp4
|
MP4
|
11.9 MB
|
|
|
26. What are Schemas.html
|
HTML
|
2.1 KB
|
|
|
27. Download Sample Oracle Schemas.mp4
|
MP4
|
11.9 MB
|
|
|
28. Unlock sample hr schema account.mp4
|
MP4
|
25.8 MB
|
|
|
29. Connect sample schema account to Oracle.mp4
|
MP4
|
8.5 MB
|
|
|
3. CONCAT() Function.mp4
|
MP4
|
13 MB
|
|
|
3. COUNT() Aggregate Function.mp4
|
MP4
|
44.6 MB
|
|
|
3. Database Design Principles.html
|
HTML
|
2.7 KB
|
|
|
3. Download MS SQL Server.mp4
|
MP4
|
23.2 MB
|
|
|
3. Examples of CRUD in multiple systems.html
|
HTML
|
2 KB
|
|
|
3. INNER JOIN.mp4
|
MP4
|
58.7 MB
|
|
|
3. Importance of SQL in Data Analysis and Data Engineering.html
|
HTML
|
2.4 KB
|
|
|
3. Importing and Exporting Data.html
|
HTML
|
2.3 KB
|
|
|
3. Introduction to Ranking Functions.mp4
|
MP4
|
3.3 MB
|
|
|
3. Project Steps.html
|
HTML
|
11.3 KB
|
|
|
3. Real-time processing with Stream SQL.html
|
HTML
|
1.7 KB
|
|
|
3. SQL Data Types Operations.html
|
HTML
|
3.1 KB
|
|
|
3. SQL Security Best Practices.html
|
HTML
|
2.3 KB
|
|
|
3. SQL-like Queries in NoSQL (e.g., MongoDB Query Language).html
|
HTML
|
3.3 KB
|
|
|
3. Tableau Public Desktop Overview Part 1.mp4
|
MP4
|
32.8 MB
|
|
|
3.1 World_Bank_CO2.xlsx
|
XLSX
|
1.9 MB
|
|
|
30. Unlock sample schema tables.mp4
|
MP4
|
26.6 MB
|
|
|
4. Backing Up and Restoring Databases.html
|
HTML
|
2.6 KB
|
|
|
4. Basic Syntax for Analytic Functions.mp4
|
MP4
|
12 MB
|
|
|
4. CHARACTER LENGTH Function.mp4
|
MP4
|
10.7 MB
|
|
|
4. Install MS SQL Server.mp4
|
MP4
|
62.1 MB
|
|
|
4. Introduction to Databases and SQL.html
|
HTML
|
2.6 KB
|
|
|
4. Introduction to triggers using PostgreSQL Database.mp4
|
MP4
|
26.3 MB
|
|
|
4. RIGHT JOIN.mp4
|
MP4
|
20.5 MB
|
|
|
4. SQL Data Definition Language (DDL).html
|
HTML
|
2.5 KB
|
|
|
4. SQL Operators.html
|
HTML
|
2.3 KB
|
|
|
4. SUM() Aggregate Function.mp4
|
MP4
|
20.1 MB
|
|
|
4. Tableau Public Desktop Overview Part 2.mp4
|
MP4
|
51.1 MB
|
|
|
4. What is T-SQL.mp4
|
MP4
|
7.4 MB
|
|
|
5. AVG () Aggregate Function.mp4
|
MP4
|
15.4 MB
|
|
|
5. Backup MySQL Databases.mp4
|
MP4
|
42.3 MB
|
|
|
5. Creating a database object.mp4
|
MP4
|
18.2 MB
|
|
|
5. Creating your first trigger - part 1.mp4
|
MP4
|
53.5 MB
|
|
|
5. Designing Tables and Relationships.html
|
HTML
|
3.2 KB
|
|
|
5. Examples of using String Functions.html
|
HTML
|
3.3 KB
|
|
|
5. Install SQL Server Management Studio - SSMS.mp4
|
MP4
|
36.6 MB
|
|
|
5. Note.html
|
HTML
|
102.4 B
|
|
|
5. SELF JOIN.mp4
|
MP4
|
39.6 MB
|
|
|
5. SQL Databases MS SQL, MySQL, PostgreSQL, Oracle SQL.html
|
HTML
|
2.2 KB
|
|
|
5. SQL Expressions.html
|
HTML
|
3 KB
|
|
|
5. Tableau Online.mp4
|
MP4
|
13.7 MB
|
|
|
6. Basic Database Concepts.html
|
HTML
|
2.5 KB
|
|
|
6. Connect SSMS to MS SQL Server.mp4
|
MP4
|
12.5 MB
|
|
|
6. Conversion Functions.html
|
HTML
|
614.4 B
|
|
|
6. Creating a table object.mp4
|
MP4
|
42.8 MB
|
|
|
6. Creating your first trigger - part 2.mp4
|
MP4
|
48.3 MB
|
|
|
6. Indexing for Performance.html
|
HTML
|
2.4 KB
|
|
|
6. MIN() Aggregate Function.mp4
|
MP4
|
10.4 MB
|
|
|
6. RANK() Function.mp4
|
MP4
|
21.6 MB
|
|
|
6. Restore MySQL Databases.mp4
|
MP4
|
26.5 MB
|
|
|
6. Tableau Data Sources.mp4
|
MP4
|
12 MB
|
|
|
6. What is a Subquery.mp4
|
MP4
|
21.1 MB
|
|
|
7. Building a Database.html
|
HTML
|
1.5 KB
|
|
|
7. Creating your first trigger - part 3.mp4
|
MP4
|
80.7 MB
|
|
|
7. DENSE_RANK() Function.mp4
|
MP4
|
26.5 MB
|
|
|
7. Examples of conversion functions.html
|
HTML
|
1.6 KB
|
|
|
7. MAX() Aggregate Function.mp4
|
MP4
|
12.2 MB
|
|
|
7. Nested subqueries.mp4
|
MP4
|
15.3 MB
|
|
|
7. Perform a Create Operation ( Inserting Data).mp4
|
MP4
|
30.6 MB
|
|
|
7. Restore sample database to MS SQL Server.mp4
|
MP4
|
32.6 MB
|
|
|
7. Transaction Control COMMIT, ROLLBACK, SAVEPOINT.html
|
HTML
|
2.3 KB
|
|
|
7. What is Power BI Desktop.mp4
|
MP4
|
11.8 MB
|
|
|
8. Date Functions.html
|
HTML
|
614.4 B
|
|
|
8. Group By, Having, and Order By Clauses.html
|
HTML
|
2.4 KB
|
|
|
8. Install Power BI Desktop.mp4
|
MP4
|
14.7 MB
|
|
|
8. Managing triggers.mp4
|
MP4
|
20.3 MB
|
|
|
8. MySQL Database Server Installation on Windows.mp4
|
MP4
|
69.6 MB
|
|
|
8. Perform a Read Operation.mp4
|
MP4
|
43 MB
|
|
|
8. ROW_NUMBER() Function.mp4
|
MP4
|
20.6 MB
|
|
|
8. SQL Views.mp4
|
MP4
|
14.6 MB
|
|
|
8. SQL for ETL (Extract, Transform, Load) Processes.html
|
HTML
|
2.2 KB
|
|
|
9. Advanced SQL techniques for data analysis PIVOT, UNPIVOT, CUBE, ROLLUP, etc..html
|
HTML
|
1.9 KB
|
|
|
9. Examples of using Date Functions.html
|
HTML
|
1.9 KB
|
|
|
9. Explore Power BI Desktop Interface.mp4
|
MP4
|
25.3 MB
|
|
|
9. LAG() Function.mp4
|
MP4
|
33.8 MB
|
|
|
9. MySQL Database Server Installation on Mac.mp4
|
MP4
|
39.3 MB
|
|
|
9. Normalization and denormalization.html
|
HTML
|
2.4 KB
|
|
|
9. Perform Update Operation.mp4
|
MP4
|
31.3 MB
|
|
|
9. Query Views.mp4
|
MP4
|
19.9 MB
|
|
|
9. Stored Procedures.html
|
HTML
|
1.7 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
