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

SQL for Non-Programmers

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

New technologies allow data to be shared, accessed, and analyzed more easily than ever before, even by non-data science professionals. Regardless of your industry, technical background, or current role, you can now leverage data to make better business decisions with the easy-to-use SQL Data Query Language. This course covers some of the most basic, fundamental SQL commands for non-programmers and non-data science professionals.

Join instructor Christina Stathopoulos as she demonstrates the skills required to independently and confidently access and analyze your data, utilizing key commands, functions, and joins such as SELECT, ORDER BY, WHERE, GROUP BY, HAVING, CASE, wildcards, UNION, and more. Along the way, test out your new skills in the exercise challenges at the end of each section.


01 - Introduction
  • 01 - Intro Why SQL and why nnow
  • 02 - What you should know
  • 03 - Set up with SQLite and SQLiteStudio

  • 02 - 1. Getting Started with Relational Databases, SQL, and DQL
  • 01 - Relational databases
  • 02 - Database structuring through normalization
  • 03 - The power of SQL
  • 04 - DQL for all

  • 03 - 2. Basic Commands
  • 01 - Getting started with SQL
  • 02 - Retrieving data with SELECT
  • 03 - Formatting your query
  • 04 - Putting order to your data with ORDER BY
  • 05 - Filtering your data with WHERE
  • 06 - Filtering your data with multiple conditions
  • 07 - Challenge Practice with basic commands
  • 08 - Solution Basic commands solved

  • 04 - 3. Aggregate Functions
  • 01 - Getting started with aggregate functions
  • 02 - Making aggregate functions work for you
  • 03 - Group data using GROUP BY
  • 04 - Filter on groups of data with HAVING
  • 05 - Challenge Practice with aggregate functions
  • 06 - Solution Aggregate functions solved

  • 05 - 4. Multiple Table Joins
  • 01 - Combining tables with an Equijoin
  • 02 - From Equijoins to Inner Joins
  • 03 - Other types of SQL joins
  • 04 - Challenge Practice with multiple table joins
  • 05 - Solution Multiple table joins solved

  • 06 - 5. Advanced Commands
  • 01 - Categorize data with CASE
  • 02 - Beyond basic CASE statements
  • 03 - Creating Calculated Fields
  • 04 - Matching data with wildcards
  • 05 - Combining data with UNION
  • 06 - Challenge Practice with advanced commands
  • 07 - Solution Advanced commands solved

  • 07 - 6. Conclusion
  • 01 - Recommendations and next steps
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 34514
    حجم: 349 مگابایت
    مدت زمان: 171 دقیقه
    تاریخ انتشار: 20 مرداد 1403
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید