Become an SQL Data Engineer/Data Analyst

سرفصل های دوره

Mastering Data: Unleashing the Power of SQL for Future Data Analysts and Engineers

1. Introduction to Data Analysis and Data Engineering

1. Introduction.html

2. Definition and Roles of a Data Analyst and Data Engineer.html

3. Importance of SQL in Data Analysis and Data Engineering.html

4. Introduction to Databases and SQL.html

5. SQL Databases MS SQL, MySQL, PostgreSQL, Oracle SQL.html

6. Basic Database Concepts.html

2. Relational Databases Setup

1. Note on database downloads.html

2. SQL Server Editions

3. Download MS SQL Server

4. Install MS SQL Server

5. Install SQL Server Management Studio - SSMS

6. Connect SSMS to MS SQL Server

7. Restore sample database to MS SQL Server

8. MySQL Database Server Installation on Windows

9. MySQL Database Server Installation on Mac

10. Introduction to MySQL Workbench

11. Installing MySQL Workbench on Mac

12. Installing PostgreSQL on Windows

13. Installing PostgreSQL on Mac

14. Installing PgAdmin for PostgreSQL on Mac

15. Connect PgAdmin to PostgreSQL Database Server

16. Restore sample database to PostgreSQL Database Server

17. Download Oracle Database Server

18. Install Oracle Database Server

19. What is SQLPlus

20. Connect SQLPLus to Oracle

21. Create a new database user in Oracle with SQLPlus

22. Create a new table in Oracle with SQLPlus

23. What is Oracle SQL Developer

24. Download Oracle SQL Developer

25. Connect SQL Developer to Oracle

26. What are Schemas.html

27. Download Sample Oracle Schemas

28. Unlock sample hr schema account

29. Connect sample schema account to Oracle

30. Unlock sample schema tables

3. SQL Fundamentals

1. SQL Syntax.html

2. SQL Data Types.html

3. SQL Data Types Operations.html

4. SQL Operators.html

5. SQL Expressions.html

4. SQL Syntax - Performing CRUD Operations

1. What is CRUD.html

2. Create a database in multiple systems

3. Examples of CRUD in multiple systems.html

4. What is T-SQL

5. Creating a database object

6. Creating a table object

7. Perform a Create Operation ( Inserting Data)

8. Perform a Read Operation

9. Perform Update Operation

10. Perform a Delete Operation

5. Manipulating Data with SQL Functions

1. Introduction.html

2. STRING Functions.html

3. CONCAT() Function

4. CHARACTER LENGTH Function

5. Examples of using String Functions.html

6. Conversion Functions.html

7. Examples of conversion functions.html

8. Date Functions.html

9. Examples of using Date Functions.html

10. T-SQL CASE Expression

11. T-SQL SUBSTRING Function

12. T-SQL CONVERT Function

13. T-SQL CAST Function

6. SQL Joins and Subqueries

1. SQL Joins.html

2. LEFT JOIN

3. INNER JOIN

4. RIGHT JOIN

5. SELF JOIN

6. What is a Subquery

7. Nested subqueries

8. SQL Views

9. Query Views

10. SQL Indexes.html

11. SQL Constraints.html

7. Working with Data in SQL

1. Data Cleaning in SQL.html

2. SQL Data Cleaning Examples.html

3. Importing and Exporting Data.html

4. Backing Up and Restoring Databases.html

5. Backup MySQL Databases

6. Restore MySQL Databases

7. Transaction Control COMMIT, ROLLBACK, SAVEPOINT.html

8. Data Analysis and Descriptive Statistics in SQL

1. Introduction to Descriptive Statistics in SQL.html

2. Aggregate Functions.html

3. COUNT() Aggregate Function

4. SUM() Aggregate Function

5. AVG () Aggregate Function

6. MIN() Aggregate Function

7. MAX() Aggregate Function

8. Group By, Having, and Order By Clauses.html

9. Advanced SQL techniques for data analysis PIVOT, UNPIVOT, CUBE, ROLLUP, etc..html

9. Data Analysis using SQL window and Analytic functions

1. Introduction to Windows Functions.html

2. Introduction to Analytic Functions

3. Introduction to Ranking Functions

4. Basic Syntax for Analytic Functions

5. Note.html

6. RANK() Function

7. DENSE RANK() Function

8. ROW NUMBER() Function

9. LAG() Function

10. LEAD() Function

11. FIRST VALUE() Function

12. LAST VALUE() Function

13. NTH VALUE() Function

14. Using Multiple Ranking Functions

10. SQL for Data Engineering

1. Designing and Building Databases.html

2. Data modeling.html

3. Database Design Principles.html

4. SQL Data Definition Language (DDL).html

5. Designing Tables and Relationships.html

6. Indexing for Performance.html

7. Building a Database.html

8. SQL for ETL (Extract, Transform, Load) Processes.html

9. Normalization and denormalization.html

10. Handling Large Datasets Partitioning, Sharding, Indexing Strategies.html

11. Partitioning, Sharding, Indexing Strategies.html

11. Working with NoSQL

1. Introduction to NoSQL databases.html

2. Difference between SQL and NoSQL.html

3. SQL-like Queries in NoSQL (e.g., MongoDB Query Language).html

12. Introduction to Big Data Technologies

1. Introduction to Hadoop and Spark.html

2. SQL with Big Data Hive and SparkSQL.html

3. Real-time processing with Stream SQL.html

13. Introduction to Data Visualization

1. Basics of Data Visualization.html

2. Tableau Public Desktop

3.1 World Bank_CO2.xlsx

3. Tableau Public Desktop Overview Part 1

4. Tableau Public Desktop Overview Part 2

5. Tableau Online

6. Tableau Data Sources

7. What is Power BI Desktop

8. Install Power BI Desktop

9. Explore Power BI Desktop Interface

10. SQL with Data Visualization Tools Tableau, PowerBI.html

14. SQL Best Practices Performance Optimization Triggers Stored Procedures

1. SQL Best Practices and Performance Optimization.html

2. SQL best practices and performance optimization examples with Oracle Database.html

3. SQL Security Best Practices.html

4. Introduction to triggers using PostgreSQL Database

5. Creating your first trigger - part 1

6. Creating your first trigger - part 2

7. Creating your first trigger - part 3

8. Managing triggers

9. Stored Procedures.html

15. Capstone Project

1. Real-world data engineering and data analysis project using SQL.html

2. Project Approach (High-level overview.).html

3. Project Steps.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training