وب سایت تخصصی شرکت فرین
دسته بندی دوره ها
1

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 16216
    حجم: 2185 مگابایت
    مدت زمان: 443 دقیقه
    تاریخ انتشار: ۲۵ تیر ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید