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

جمع جزء: 1,512,000 تومان

مشاهده سبد خریدتسویه حساب

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
8
خانه » فروشگاه » Complete Guide to SQL for Data Engineering: from Beginner to Advanced

Complete Guide to SQL for Data Engineering: from Beginner to Advanced

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

Are you looking to get up and running with SQL as a data engineer, but not sure where to begin? In this course, instructor Deepak Goyal provides a comprehensive overview of SQL specifically targeted at data engineers, from basic queries and analytic tasks to advanced functions and data management.Find out why SQL is one of the most frequently and widely used programming languages for data engineers. Explore fundamental skills in data manipulation, queries, functions, views and stored procedures, indexes and performance, database security, debugging, ETL, and more. The course concludes with a real-world capstone project based on insurance claims analysis.

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time-all while using a tool that you'll likely encounter in the workplace. Check out the "Using GitHub Codespaces with this course" video to learn how to get started.


01 - Introduction
  • 01 - SQL for data engineering
  • 02 - What you should know
  • 03 - Using Codespaces

    • 02 - 1. SQL Introduction
  • 01 - What is SQL and why learn it
  • 02 - Role of SQL in data engineering
  • 03 - Setting up the SQL environment Install PostgreSQL
  • 04 - Walkthrough PostgreSQL

    • 03 - 2. SQL Basics
  • 01 - Introduction to databases and tables
  • 02 - SQL syntax and basic queries
  • 03 - Selecting and filtering data
  • 04 - Sorting data with ORDER BY
  • 05 - Combining conditions with AND and OR
  • 06 - Challenge Combine filter and ORDER BY
  • 07 - Solution Combine filter and ORDER BY

    • 04 - 3. Data Manipulation
  • 01 - Introduction to data manipulation
  • 02 - Inserting data into tables
  • 03 - Updating existing records
  • 04 - Deleting records from tables
  • 05 - Challenge Delete records
  • 06 - Solution Delete records

    • 05 - 4. Advanced Data Querying
  • 01 - Introduction to joins
  • 02 - Inner join explained
  • 03 - Left and right joins explained
  • 04 - Full outer joins
  • 05 - Using the UNION operator
  • 06 - Using the CASE statement for conditional logic
  • 07 - Using GROUP BY to aggregate data
  • 08 - Common aggregation functions SUM, AVG, COUNT, etc.
  • 09 - Filtering GROUP BY results with the HAVING clause
  • 10 - Challenge Joins
  • 11 - Solution Joins

    • 06 - 5. SQL Functions
  • 01 - Introduction to SQL functions
  • 02 - Using mathematical functions
  • 03 - Working with date functions
  • 04 - Working with time functions
  • 05 - String functions Concatenation and trimming
  • 06 - String functions Changing case and extracting substrings
  • 07 - Challenge Play with strings
  • 08 - Solution Play with strings

    • 07 - 6. SQL Analytical Functions
  • 01 - Introduction to analytical functions
  • 02 - Using the RANK() function
  • 03 - Using the DENSE RANK() function
  • 04 - Exploring the ROW NUMBER() function
  • 05 - Understanding the LAG() and LEAD() functions
  • 06 - Running totals with SUM() OVER()
  • 07 - Calculating moving averages
  • 08 - Challenge Find out the sum
  • 09 - Solution Find out the sum

    • 08 - 7. Views and Stored Procedures
  • 01 - Introduction to views
  • 02 - Creating and using views
  • 03 - Introduction to stored procedures
  • 04 - Creating and executing stored procedures
  • 05 - Challenge Select via view
  • 06 - Solution Select via view

    • 09 - 8. Indexes and Performance
  • 01 - Introduction to indexes
  • 02 - Creating and managing indexes
  • 03 - Understanding query performance
  • 04 - Basic performance tuning techniques
  • 05 - Challenge Indexes
  • 06 - Solution Indexes

    • 10 - 9. Database Security and User Management
  • 01 - Introduction to database security
  • 02 - Understanding users and roles in SQL
  • 03 - Creating users and assigning roles
  • 04 - Granting and revoking permissions
  • 05 - Using roles for permission management
  • 06 - Best practices for managing roles and permissions
  • 07 - Challenge Create a role
  • 08 - Solution Create a role

    • 11 - 10. Debugging Common Mistakes and SQL Errors
  • 01 - Understanding SQL syntax errors
  • 02 - Logical errors in SQL
  • 03 - Debugging NULL values
  • 04 - Practical example Debugging real SQL issues

    • 12 - 11. ETL Overview
  • 01 - What is ETL and its importance
  • 02 - ETL process flow
  • 03 - Common ETL tools

    • 13 - 12. Real-World Project
  • 01 - Capstone project Insurance claims analysis
  • 02 - Capstone project solution Insurance claims analysis

    • 14 - Conclusion
  • 01 - Next steps
    • 189,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 39689
    حجم: 803 مگابایت
    مدت زمان: 432 دقیقه
    تاریخ انتشار: ۲۲ مرداد ۱۴۰۳
    دسته بندی محصول
    LinkedIn Learning (Lynda)
    LinkedIn Learning (Lynda)
    مشاهده دوره های LinkedIn Learning (Lynda)
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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