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