Become an SQL Data Engineer/Data Analyst
https://DevCourseWeb.com
Published 6/2023 Created by Bluelime Learning Solutions MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English | Duration: 144 Lectures ( 8h 27m ) | Size: 2.13 GB
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. |
[ DevCourseWeb.com ] Udemy - Become an SQL Data Engineer - Data Analyst
-
Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here !
1. Introduction to Data Analysis and Data Engineering
-
1. Introduction.html (2.3 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.4 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.5 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.3 KB)
-
11. Partitioning, Sharding, Indexing Strategies.html (2.3 KB)
-
2. Data modeling.html (2.1 KB)
-
3. Database Design Principles.html (2.7 KB)
-
4. SQL Data Definition Language (DDL).html (2.5 KB)
-
5. Designing Tables and Relationships.html (3.2 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.4 KB)
11. Working with NoSQL
-
1. Introduction to NoSQL databases.html (2.7 KB)
-
2. Difference between SQL and NoSQL.html (2.9 KB)
-
3. SQL-like Queries in NoSQL (e.g., MongoDB Query Language).html (3.3 KB)
12. Introduction to Big Data Technologies
-
1. Introduction to Hadoop and Spark.html (2.8 KB)
-
2. SQL with Big Data Hive and SparkSQL.html (2.1 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.2 MB)
-
3. Tableau Public Desktop Overview Part 1.mp4 (32.8 MB)
-
3.1 World_Bank_CO2.xlsx (1.9 MB)
-
4. Tableau Public Desktop Overview Part 2.mp4 (51.1 MB)
-
5. Tableau Online.mp4 (13.7 MB)
-
6. Tableau Data Sources.mp4 (12.0 MB)
-
7. What is Power BI Desktop.mp4 (11.8 MB)
-
8. Install Power BI Desktop.mp4 (14.7 MB)
-
9. Explore Power BI Desktop Interface.mp4 (25.3 MB)
14. SQL Best Practices Performance Optimization Triggers Stored Procedures
-
1. SQL Best Practices and Performance Optimization.html (2.5 KB)
-
2. SQL best practices and performance optimization examples with Oracle Database.html (3.0 KB)
-
3. SQL Security Best Practices.html (2.3 KB)
-
4. Introduction to triggers using PostgreSQL Database.mp4 (26.3 MB)
-
5. Creating your first trigger - part 1.mp4 (53.5 MB)
-
6. Creating your first trigger - part 2.mp4 (48.3 MB)
-
7. Creating your first trigger - part 3.mp4 (80.7 MB)
-
8. Managing triggers.mp4 (20.3 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.8 KB)
-
3. Project Steps.html (11.3 KB)
2. Relational Databases Setup
-
1. Note on database downloads.html (0.2 KB)
-
10. Introduction to MySQL Workbench.mp4 (33.8 MB)
-
11. Installing MySQL Workbench on Mac.mp4 (44.5 MB)
-
12. Installing PostgreSQL on Windows.mp4 (45.1 MB)
-
13. Installing PostgreSQL on Mac.mp4 (16.2 MB)
-
14. Installing PgAdmin for PostgreSQL on Mac.mp4 (32.3 MB)
-
15. Connect PgAdmin to PostgreSQL Database Server.mp4 (20.6 MB)
-
16. Restore sample database to PostgreSQL Database Server.mp4 (46.5 MB)
-
17. Download Oracle Database Server.mp4 (26.9 MB)
-
18. Install Oracle Database Server.mp4 (7.8 MB)
-
19. What is SQLPlus.mp4 (14.9 MB)
-
2. SQL Server Editions.mp4 (28.2 MB)
-
20. Connect SQLPLus to Oracle.mp4 (14.0 MB)
-
21. Create a new database user in Oracle with SQLPlus.mp4 (8.6 MB)
-
22. Create a new table in Oracle with SQLPlus.mp4 (7.6 MB)
-
23. What is Oracle SQL Developer.mp4 (9.4 MB)
-
24. Download Oracle SQL Developer.mp4 (20.0 MB)
-
25. Connect SQL Developer to Oracle.mp4 (11.9 MB)
-
26. What are Schemas.html (2.1 KB)
-
27. Download Sample Oracle Schemas.mp4 (11.9 MB)
-
28. Unlock sample hr schema account.mp4 (25.8 MB)
-
29. Connect sample schema account to Oracle.mp4 (8.5 MB)
-
3. Download MS SQL Server.mp4 (23.2 MB)
-
30. Unlock sample schema tables.mp4 (26.6 MB)
-
4. Install MS SQL Server.mp4 (62.1 MB)
-
5. Install SQL Server Management Studio - SSMS.mp4 (36.6 MB)
-
6. Connect SSMS to MS SQL Server.mp4 (12.5 MB)
-
7. Restore sample database to MS SQL Server.mp4 (32.6 MB)
-
8. MySQL Database Server Installation on Windows.mp4 (69.6 MB)
-
9. MySQL Database Server Installation on Mac.mp4 (39.3 MB)
3. SQL Fundamentals
-
1. SQL Syntax.html (3.2 KB)
-
2. SQL Data Types.html (2.4 KB)
-
3. SQL Data Types Operations.html (3.1 KB)
-
4. SQL Operators.html (2.3 KB)
-
5. SQL Expressions.html (3.0 KB)
4. SQL Syntax - Performing CRUD Operations
-
1. What is CRUD.html (1.5 KB)
-
10. Perform a Delete Operation.mp4 (23.9 MB)
-
2. Create a database in multiple systems.mp4 (39.0 MB)
-
3. Examples of CRUD in multiple systems.html (2.0 KB)
-
4. What is T-SQL.mp4 (7.4 MB)
-
5. Creating a database object.mp4 (18.2 MB)
-
6. Creating a table object.mp4 (42.8 MB)
-
7. Perform a Create Operation ( Inserting Data).mp4 (30.6 MB)
-
8. Perform a Read Operation.mp4 (43.0 MB)
-
9. Perform Update Operation.mp4 (31.3 MB)
5. Manipulating Data with SQL Functions
-
1. Introduction.html (0.2 KB)
-
10. T-SQL CASE Expression.mp4 (52.8 MB)
-
11. T-SQL SUBSTRING Function.mp4 (24.1 MB)
-
files
|
udp://tracker.torrent.eu.org:451/announce udp://tracker.tiny-vps.com:6969/announce http://tracker.foreverpirates.co:80/announce udp://tracker.cyberia.is:6969/announce udp://exodus.desync.com:6969/announce udp://explodie.org:6969/announce udp://tracker.opentrackr.org:1337/announce udp://9.rarbg.to:2780/announce udp://tracker.internetwarriors.net:1337/announce udp://ipv4.tracker.harry.lu:80/announce udp://open.stealth.si:80/announce udp://9.rarbg.to:2900/announce udp://9.rarbg.me:2720/announce udp://opentor.org:2710/announce |