17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - Become An SQL Data Engineer - Data Analyst
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Mastering Data: Unleashing the Power of SQL for Future Data Analysts and Engineers
What you'll learn
Understand the roles and responsibilities of data analysts and data engineers.
Identify and use different types of SQL databases including MS SQL, MySQL, PostgreSQL, and Oracle SQL.
Write basic to complex SQL queries using various SQL syntax, operators, and functions.
Understand and implement data cleaning, , backup, and restoration in SQL.
Perform data analysis tasks using SQL, such as computing descriptive statistics and utilizing various functions and techniques for manipulating data.
Understand the principles of data engineering using SQL, including designing databases, handling ETL processes, and managing large datasets.
Implement SQL-like queries in NoSQL databases.
Understand the basics of Big Data technologies and how SQL interfaces with these tools.
Use SQL in conjunction with popular data visualization tools such as Tableau and PowerBI.
Apply SQL best practices and performance optimization strategies in real-world situations.
Gain a strong foundation in SQL, setting the stage for further learning and specialization in the fields of data analysis and data engineering.
Requirements
Basic Computer Literacy: Students should be comfortable using a computer, including file management and installing software.
Fundamental Math Skills: Familiarity with basic high school level mathematics is helpful, especially in areas such as statistics, since this course involves understanding and performing data analyses.
Basic Programming Knowledge: While not a strict prerequisite, having a general understanding of programming concepts like variables, loops, and functions can make learning SQL more accessible.
Understanding of Database Concepts: A basic understanding of databases, tables, and relationships is helpful but not required. The course will cover these topics in the early modules.
Software Requirements: Students will need to have a computer with internet access. Certain modules may require the installation of free database software (guidance will be provided during the course).
Motivation and Willingness to Learn: Above all, students should have an eagerness to learn new concepts and the commitment to practice and apply those skills through exercises and a capstone project.
Please note that this course is designed to accommodate students with varying levels of previous experience, and it covers all necessary foundational topics. Hence, anyone with a keen interest in data engineering and data analysis can benefit from the course, regardless of their background.
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1. Introduction to Data Analysis and Data Engineering/1. Introduction.html
2.3 KB
~Get Your Files Here !/1. Introduction to Data Analysis and Data Engineering/2. Definition and Roles of a Data Analyst and Data Engineer.html
2.7 KB
~Get Your Files Here !/1. Introduction to Data Analysis and Data Engineering/3. Importance of SQL in Data Analysis and Data Engineering.html
2.4 KB
~Get Your Files Here !/1. Introduction to Data Analysis and Data Engineering/4. Introduction to Databases and SQL.html
2.6 KB
~Get Your Files Here !/1. Introduction to Data Analysis and Data Engineering/5. SQL Databases MS SQL, MySQL, PostgreSQL, Oracle SQL.html
2.2 KB
~Get Your Files Here !/1. Introduction to Data Analysis and Data Engineering/6. Basic Database Concepts.html
2.5 KB
~Get Your Files Here !/10. SQL for Data Engineering/1. Designing and Building Databases.html
262 B
~Get Your Files Here !/10. SQL for Data Engineering/10. Handling Large Datasets Partitioning, Sharding, Indexing Strategies.html
351 B
~Get Your Files Here !/10. SQL for Data Engineering/11. Partitioning, Sharding, Indexing Strategies.html
2.3 KB
~Get Your Files Here !/10. SQL for Data Engineering/2. Data modeling.html
2.1 KB
~Get Your Files Here !/10. SQL for Data Engineering/3. Database Design Principles.html
2.7 KB
~Get Your Files Here !/10. SQL for Data Engineering/4. SQL Data Definition Language (DDL).html
2.5 KB
~Get Your Files Here !/10. SQL for Data Engineering/5. Designing Tables and Relationships.html
3.2 KB
~Get Your Files Here !/10. SQL for Data Engineering/6. Indexing for Performance.html
2.4 KB
~Get Your Files Here !/10. SQL for Data Engineering/7. Building a Database.html
1.5 KB
~Get Your Files Here !/10. SQL for Data Engineering/8. SQL for ETL (Extract, Transform, Load) Processes.html
2.2 KB
~Get Your Files Here !/10. SQL for Data Engineering/9. Normalization and denormalization.html
2.4 KB
~Get Your Files Here !/11. Working with NoSQL/1. Introduction to NoSQL databases.html
2.7 KB
~Get Your Files Here !/11. Working with NoSQL/2. Difference between SQL and NoSQL.html
2.9 KB
~Get Your Files Here !/11. Working with NoSQL/3. SQL-like Queries in NoSQL (e.g., MongoDB Query Language).html
3.3 KB
~Get Your Files Here !/12. Introduction to Big Data Technologies/1. Introduction to Hadoop and Spark.html
2.8 KB
~Get Your Files Here !/12. Introduction to Big Data Technologies/2. SQL with Big Data Hive and SparkSQL.html
2.1 KB
~Get Your Files Here !/12. Introduction to Big Data Technologies/3. Real-time processing with Stream SQL.html
1.7 KB
~Get Your Files Here !/13. Introduction to Data Visualization/1. Basics of Data Visualization.html
2.4 KB
~Get Your Files Here !/13. Introduction to Data Visualization/10. SQL with Data Visualization Tools Tableau, PowerBI.html
2.5 KB
~Get Your Files Here !/13. Introduction to Data Visualization/2. Tableau Public Desktop.mp4
7.2 MB
~Get Your Files Here !/13. Introduction to Data Visualization/3. Tableau Public Desktop Overview Part 1.mp4
32.8 MB
~Get Your Files Here !/13. Introduction to Data Visualization/3.1 World_Bank_CO2.xlsx
1.9 MB
~Get Your Files Here !/13. Introduction to Data Visualization/4. Tableau Public Desktop Overview Part 2.mp4
51.1 MB
~Get Your Files Here !/13. Introduction to Data Visualization/5. Tableau Online.mp4
13.7 MB
~Get Your Files Here !/13. Introduction to Data Visualization/6. Tableau Data Sources.mp4
12 MB
~Get Your Files Here !/13. Introduction to Data Visualization/7. What is Power BI Desktop.mp4
11.8 MB
~Get Your Files Here !/13. Introduction to Data Visualization/8. Install Power BI Desktop.mp4
14.7 MB
~Get Your Files Here !/13. Introduction to Data Visualization/9. Explore Power BI Desktop Interface.mp4
25.3 MB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/1. SQL Best Practices and Performance Optimization.html
2.5 KB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/2. SQL best practices and performance optimization examples with Oracle Database.html
3 KB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/3. SQL Security Best Practices.html
2.3 KB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/4. Introduction to triggers using PostgreSQL Database.mp4
26.3 MB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/5. Creating your first trigger - part 1.mp4
53.5 MB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/6. Creating your first trigger - part 2.mp4
48.3 MB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/7. Creating your first trigger - part 3.mp4
80.7 MB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/8. Managing triggers.mp4
20.3 MB
~Get Your Files Here !/14. SQL Best Practices Performance Optimization Triggers Stored Procedures/9. Stored Procedures.html
1.7 KB
~Get Your Files Here !/15. Capstone Project/1. Real-world data engineering and data analysis project using SQL.html
2.6 KB
~Get Your Files Here !/15. Capstone Project/2. Project Approach (High-level overview.).html
2.8 KB
~Get Your Files Here !/15. Capstone Project/3. Project Steps.html
11.3 KB
~Get Your Files Here !/2. Relational Databases Setup/1. Note on database downloads.html
162 B
~Get Your Files Here !/2. Relational Databases Setup/10. Introduction to MySQL Workbench.mp4
33.8 MB
~Get Your Files Here !/2. Relational Databases Setup/11. Installing MySQL Workbench on Mac.mp4
44.5 MB
~Get Your Files Here !/2. Relational Databases Setup/12. Installing PostgreSQL on Windows.mp4
45.1 MB
~Get Your Files Here !/2. Relational Databases Setup/13. Installing PostgreSQL on Mac.mp4
16.2 MB
~Get Your Files Here !/2. Relational Databases Setup/14. Installing PgAdmin for PostgreSQL on Mac.mp4
32.3 MB
~Get Your Files Here !/2. Relational Databases Setup/15. Connect PgAdmin to PostgreSQL Database Server.mp4
20.6 MB
~Get Your Files Here !/2. Relational Databases Setup/16. Restore sample database to PostgreSQL Database Server.mp4
46.5 MB
~Get Your Files Here !/2. Relational Databases Setup/17. Download Oracle Database Server.mp4
26.9 MB
~Get Your Files Here !/2. Relational Databases Setup/18. Install Oracle Database Server.mp4
7.8 MB
~Get Your Files Here !/2. Relational Databases Setup/19. What is SQLPlus.mp4
14.9 MB
~Get Your Files Here !/2. Relational Databases Setup/2. SQL Server Editions.mp4
28.2 MB
~Get Your Files Here !/2. Relational Databases Setup/20. Connect SQLPLus to Oracle.mp4
14 MB
~Get Your Files Here !/2. Relational Databases Setup/21. Create a new database user in Oracle with SQLPlus.mp4
8.6 MB
~Get Your Files Here !/2. Relational Databases Setup/22. Create a new table in Oracle with SQLPlus.mp4
7.6 MB
~Get Your Files Here !/2. Relational Databases Setup/23. What is Oracle SQL Developer.mp4
9.4 MB
~Get Your Files Here !/2. Relational Databases Setup/24. Download Oracle SQL Developer.mp4
20 MB
~Get Your Files Here !/2. Relational Databases Setup/25. Connect SQL Developer to Oracle.mp4
11.9 MB
~Get Your Files Here !/2. Relational Databases Setup/26. What are Schemas.html
2.1 KB
~Get Your Files Here !/2. Relational Databases Setup/27. Download Sample Oracle Schemas.mp4
11.9 MB
~Get Your Files Here !/2. Relational Databases Setup/28. Unlock sample hr schema account.mp4
25.8 MB
~Get Your Files Here !/2. Relational Databases Setup/29. Connect sample schema account to Oracle.mp4
8.5 MB
~Get Your Files Here !/2. Relational Databases Setup/3. Download MS SQL Server.mp4
23.2 MB
~Get Your Files Here !/2. Relational Databases Setup/30. Unlock sample schema tables.mp4
26.6 MB
~Get Your Files Here !/2. Relational Databases Setup/4. Install MS SQL Server.mp4
62.1 MB
~Get Your Files Here !/2. Relational Databases Setup/5. Install SQL Server Management Studio - SSMS.mp4
36.6 MB
~Get Your Files Here !/2. Relational Databases Setup/6. Connect SSMS to MS SQL Server.mp4
12.5 MB
~Get Your Files Here !/2. Relational Databases Setup/7. Restore sample database to MS SQL Server.mp4
32.6 MB
~Get Your Files Here !/2. Relational Databases Setup/8. MySQL Database Server Installation on Windows.mp4
69.6 MB
~Get Your Files Here !/2. Relational Databases Setup/9. MySQL Database Server Installation on Mac.mp4
39.3 MB
~Get Your Files Here !/3. SQL Fundamentals/1. SQL Syntax.html
3.2 KB
~Get Your Files Here !/3. SQL Fundamentals/2. SQL Data Types.html
2.4 KB
~Get Your Files Here !/3. SQL Fundamentals/3. SQL Data Types Operations.html
3.1 KB
~Get Your Files Here !/3. SQL Fundamentals/4. SQL Operators.html
2.3 KB
~Get Your Files Here !/3. SQL Fundamentals/5. SQL Expressions.html
3 KB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/1. What is CRUD.html
1.5 KB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/10. Perform a Delete Operation.mp4
23.9 MB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/2. Create a database in multiple systems.mp4
39 MB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/3. Examples of CRUD in multiple systems.html
2 KB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/4. What is T-SQL.mp4
7.4 MB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/5. Creating a database object.mp4
18.2 MB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/6. Creating a table object.mp4
42.8 MB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/7. Perform a Create Operation ( Inserting Data).mp4
30.6 MB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/8. Perform a Read Operation.mp4
43 MB
~Get Your Files Here !/4. SQL Syntax - Performing CRUD Operations/9. Perform Update Operation.mp4
31.3 MB
~Get Your Files Here !/5. Manipulating Data with SQL Functions/1. Introduction.html
161 B
~Get Your Files Here !/5. Manipulating Data with SQL Functions/10. T-SQL CASE Expression.mp4
52.8 MB
~Get Your Files Here !/5. Manipulating Data with SQL Functions/11. T-SQL SUBSTRING Function.mp4
24.1 MB
~Get Your Files Here !/5. Manipulating Data with SQL Functions/12. T-SQL CONVERT Function.mp4
18.1 MB
~Get Your Files Here !/5. Manipulating Data with SQL Functions/13. T-SQL CAST Function.mp4
36 MB
~Get Your Files Here !/5. Manipulating Data with SQL Functions/2. STRING Functions.html
686 B
~Get Your Files Here !/5. Manipulating Data with SQL Functions/3. CONCAT() Function.mp4
