DevCourseWeb com Udemy Become an SQL Data Engineer Data Analyst | DA5B315B54753C4D20A56E6F4677093BF41570A5

DevCourseWeb com Udemy Become an SQL Data Engineer Data Analyst

Name	[ DevCourseWeb.com ] Udemy - Become an SQL Data Engineer - Data Analyst	DOWNLOAD Copy Link
Total Size	2.3 GB
Total Files	147
Last Seen	2024-10-05 23:49
Hash	DA5B315B54753C4D20A56E6F4677093BF41570A5

/
Get Bonus Downloads Here.url	0.2 KB
/.../1. Introduction to Data Analysis and Data Engineering/
1. Introduction.html	2.4 KB
2. Definition and Roles of a Data Analyst and Data Engineer.html	2.7 KB
3. Importance of SQL in Data Analysis and Data Engineering.html	2.5 KB
4. Introduction to Databases and SQL.html	2.6 KB
5. SQL Databases MS SQL, MySQL, PostgreSQL, Oracle SQL.html	2.2 KB
6. Basic Database Concepts.html	2.6 KB
/.../10. SQL for Data Engineering/
1. Designing and Building Databases.html	0.3 KB
10. Handling Large Datasets Partitioning, Sharding, Indexing Strategies.html	0.4 KB
11. Partitioning, Sharding, Indexing Strategies.html	2.3 KB
2. Data modeling.html	2.2 KB
3. Database Design Principles.html	2.8 KB
4. SQL Data Definition Language (DDL).html	2.6 KB
5. Designing Tables and Relationships.html	3.3 KB
6. Indexing for Performance.html	2.4 KB
7. Building a Database.html	1.5 KB
8. SQL for ETL (Extract, Transform, Load) Processes.html	2.2 KB
9. Normalization and denormalization.html	2.5 KB
/.../11. Working with NoSQL/
1. Introduction to NoSQL databases.html	2.7 KB
2. Difference between SQL and NoSQL.html	3.0 KB
3. SQL-like Queries in NoSQL (e.g., MongoDB Query Language).html	3.4 KB
/.../12. Introduction to Big Data Technologies/
1. Introduction to Hadoop and Spark.html	2.9 KB
2. SQL with Big Data Hive and SparkSQL.html	2.2 KB
3. Real-time processing with Stream SQL.html	1.7 KB
/.../13. Introduction to Data Visualization/
1. Basics of Data Visualization.html	2.4 KB
10. SQL with Data Visualization Tools Tableau, PowerBI.html	2.5 KB
2. Tableau Public Desktop.mp4	7.5 MB
3. Tableau Public Desktop Overview Part 1.mp4	34.4 MB
3.1 World_Bank_CO2.xlsx	2.0 MB
4. Tableau Public Desktop Overview Part 2.mp4	53.6 MB
5. Tableau Online.mp4	14.4 MB
6. Tableau Data Sources.mp4	12.6 MB
7. What is Power BI Desktop.mp4	12.4 MB
8. Install Power BI Desktop.mp4	15.4 MB
9. Explore Power BI Desktop Interface.mp4	26.6 MB
/.../14. SQL Best Practices Performance Optimization Triggers Stored Procedures/
1. SQL Best Practices and Performance Optimization.html	2.6 KB
2. SQL best practices and performance optimization examples with Oracle Database.html	3.1 KB
3. SQL Security Best Practices.html	2.4 KB
4. Introduction to triggers using PostgreSQL Database.mp4	27.5 MB
5. Creating your first trigger - part 1.mp4	56.1 MB
6. Creating your first trigger - part 2.mp4	50.6 MB
7. Creating your first trigger - part 3.mp4	84.7 MB
8. Managing triggers.mp4	21.2 MB
9. Stored Procedures.html	1.7 KB
/.../15. Capstone Project/
1. Real-world data engineering and data analysis project using SQL.html	2.6 KB
2. Project Approach (High-level overview.).html	2.9 KB
3. Project Steps.html	11.6 KB
/.../2. Relational Databases Setup/
1. Note on database downloads.html	0.2 KB
10. Introduction to MySQL Workbench.mp4	35.4 MB
11. Installing MySQL Workbench on Mac.mp4	46.6 MB
12. Installing PostgreSQL on Windows.mp4	47.3 MB
13. Installing PostgreSQL on Mac.mp4	17.0 MB
14. Installing PgAdmin for PostgreSQL on Mac.mp4	33.9 MB
15. Connect PgAdmin to PostgreSQL Database Server.mp4	21.6 MB
16. Restore sample database to PostgreSQL Database Server.mp4	48.8 MB
17. Download Oracle Database Server.mp4	28.2 MB
18. Install Oracle Database Server.mp4	8.2 MB
19. What is SQLPlus.mp4	15.6 MB
2. SQL Server Editions.mp4	29.6 MB
20. Connect SQLPLus to Oracle.mp4	14.7 MB
21. Create a new database user in Oracle with SQLPlus.mp4	9.0 MB
22. Create a new table in Oracle with SQLPlus.mp4	7.9 MB
23. What is Oracle SQL Developer.mp4	9.8 MB
24. Download Oracle SQL Developer.mp4	21.0 MB
25. Connect SQL Developer to Oracle.mp4	12.4 MB
26. What are Schemas.html	2.1 KB
27. Download Sample Oracle Schemas.mp4	12.4 MB
28. Unlock sample hr schema account.mp4	27.1 MB
29. Connect sample schema account to Oracle.mp4	8.9 MB
3. Download MS SQL Server.mp4	24.4 MB
30. Unlock sample schema tables.mp4	27.9 MB
4. Install MS SQL Server.mp4	65.2 MB
5. Install SQL Server Management Studio - SSMS.mp4	38.4 MB
6. Connect SSMS to MS SQL Server.mp4	13.1 MB
7. Restore sample database to MS SQL Server.mp4	34.1 MB
8. MySQL Database Server Installation on Windows.mp4	73.0 MB
9. MySQL Database Server Installation on Mac.mp4	41.2 MB
/3. SQL Fundamentals/
1. SQL Syntax.html	3.3 KB
2. SQL Data Types.html	2.5 KB
3. SQL Data Types Operations.html	3.1 KB
4. SQL Operators.html	2.4 KB
5. SQL Expressions.html	3.1 KB
/.../4. SQL Syntax - Performing CRUD Operations/
1. What is CRUD.html	1.5 KB
10. Perform a Delete Operation.mp4	25.0 MB
2. Create a database in multiple systems.mp4	40.9 MB
3. Examples of CRUD in multiple systems.html	2.1 KB
4. What is T-SQL.mp4	7.8 MB
5. Creating a database object.mp4	19.1 MB
6. Creating a table object.mp4	44.9 MB
7. Perform a Create Operation ( Inserting Data).mp4	32.0 MB
8. Perform a Read Operation.mp4	45.0 MB
9. Perform Update Operation.mp4	32.9 MB
/.../5. Manipulating Data with SQL Functions/
1. Introduction.html	0.2 KB
10. T-SQL CASE Expression.mp4	55.4 MB
11. T-SQL SUBSTRING Function.mp4	25.3 MB
12. T-SQL CONVERT Function.mp4	19.0 MB
13. T-SQL CAST Function.mp4	37.7 MB
2. STRING Functions.html	0.7 KB
3. CONCAT() Function.mp4	13.6 MB
4. CHARACTER LENGTH Function.mp4	11.2 MB
5. Examples of using String Functions.html	3.4 KB
6. Conversion Functions.html	0.7 KB
7. Examples of conversion functions.html	1.7 KB
8. Date Functions.html	0.6 KB
9. Examples of using Date Functions.html	2.0 KB
/.../6. SQL Joins and Subqueries/
1. SQL Joins.html	0.2 KB
10. SQL Indexes.html	2.6 KB
11. SQL Constraints.html	2.7 KB
2. LEFT JOIN.mp4	30.9 MB
3. INNER JOIN.mp4	61.5 MB
4. RIGHT JOIN.mp4	21.5 MB
5. SELF JOIN.mp4	41.5 MB
6. What is a Subquery.mp4	22.1 MB
7. Nested subqueries.mp4	16.0 MB
8. SQL Views.mp4	15.3 MB
9. Query Views.mp4	20.9 MB
/.../7. Working with Data in SQL/
1. Data Cleaning in SQL.html	2.4 KB
2. SQL Data Cleaning Examples.html	2.7 KB
3. Importing and Exporting Data.html	2.3 KB
4. Backing Up and Restoring Databases.html	2.7 KB
5. Backup MySQL Databases.mp4	44.4 MB
6. Restore MySQL Databases.mp4	27.7 MB
7. Transaction Control COMMIT, ROLLBACK, SAVEPOINT.html	2.4 KB
/.../8. Data Analysis and Descriptive Statistics in SQL/
1. Introduction to Descriptive Statistics in SQL.html	2.0 KB
2. Aggregate Functions.html	0.7 KB
3. COUNT() Aggregate Function.mp4	46.8 MB
4. SUM() Aggregate Function.mp4	21.1 MB
5. AVG () Aggregate Function.mp4	16.2 MB
6. MIN() Aggregate Function.mp4	11.0 MB
7. MAX() Aggregate Function.mp4	12.7 MB
8. Group By, Having, and Order By Clauses.html	2.4 KB
9. Advanced SQL techniques for data analysis PIVOT, UNPIVOT, CUBE, ROLLUP, etc..html	1.9 KB
/.../9. Data Analysis using SQL window and Analytic functions/
1. Introduction to Windows Functions.html	1.8 KB
10. LEAD() Function.mp4	36.4 MB
11. FIRST_VALUE() Function.mp4	20.4 MB
12. LAST_VALUE() Function.mp4	23.7 MB
13. NTH_VALUE() Function.mp4	21.2 MB
14. Using Multiple Ranking Functions.mp4	31.5 MB
2. Introduction to Analytic Functions.mp4	22.7 MB
3. Introduction to Ranking Functions.mp4	3.4 MB
4. Basic Syntax for Analytic Functions.mp4	12.5 MB
5. Note.html	0.1 KB
6. RANK() Function.mp4	22.6 MB
7. DENSE_RANK() Function.mp4	27.8 MB
8. ROW_NUMBER() Function.mp4	21.6 MB
9. LAG() Function.mp4	35.4 MB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 147