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

PostgreSQL and Oracle SQL for beginners

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

Learn popular SQL dialects, PostgreSQL & Oracle SQL. Learn SQL concepts & compare syntax of PostgreSQL & Oracle SQL


1 - Introduction
  • 1 - Introduction

  • 2 - Course Resources
  • 2 - Course Resources.html
  • 3 - This is a milestone

  • 3 - Setting up PostgreSQL and PGAdmin
  • 4 - Installing PostgreSQL and pgAdmin in your PC
  • 5 - If pgAdmin is not opening.html

  • 4 - Installing Oracle SQL
  • 6 - Installing and Setting up Oracle SQL

  • 5 - Fundamental SQL statements
  • 7 - CREATE in PostgreSQL
  • 8 - CREATE in Oracle SQL
  • 9 - INSERT in PostgreSQL
  • 10 - INSERT in OracleSQL
  • 11 - Import data from File in PostgreSQL
  • 12 - Import data from File in OracleSQL
  • 13 - SELECT statement in PostgreSQL
  • 14 - SELECT statement in OracleSQL
  • 15 - SELECT DISTINCT in PostgreSQL
  • 16 - SELECT DISTINCT in OracleSQL
  • 17 - WHERE in PostgreSQL
  • 18 - WHERE in OracleSQL
  • 19 - Logical Operators in PostgreSQL
  • 20 - Logical Operators in OracleSQL
  • 21 - UPDATE in PostgreSQL
  • 22 - UPDATE in OracleSQL
  • 23 - DELETE in PostgreSQL
  • 24 - DELETE in OracleSQL
  • 25 - ALTER Part 1 in PostgreSQL
  • 26 - ALTER Part 2 in PostgreSQL
  • 27 - ALTER in Oracle SQL

  • 6 - Restore and Backup in PostgreSQL
  • 28 - Restore and Backup
  • 29 - Debugging restoration issues
  • 30 - Creating DB using CSV files
  • 31 - Debugging summary and Code for CSV files.html

  • 7 - Restore and Backup in Oracle SQL
  • 32 - Restoring and Backup in Oracle SQL

  • 8 - Selection commands Filtering
  • 33 - IN in PostgreSQL
  • 34 - BETWEEN in PostgreSQL
  • 35 - IN BETWEEN in Oracle SQL
  • 36 - LIKE in PostgreSQL
  • 37 - LIKE in Oracle SQL

  • 9 - Selection commands Ordering
  • 38 - Side Lecture Commenting in SQL
  • 39 - ORDER BY in PostgreSQL
  • 40 - LIMIT in PostgreSQL
  • 41 - ORDER BY Limit in Oracle SQL

  • 10 - Aliases
  • 42 - AS in PostgreSQL
  • 43 - AS in OracleSQL

  • 11 - Aggregate Commands
  • 44 - COUNT in PostgreSQL
  • 45 - SUM in PostgreSQL
  • 46 - AVERAGE in PostgreSQL
  • 47 - MIN MAX in PostgreSQL
  • 48 - Aggregate Functions in OracleSQL

  • 12 - Group By Commands
  • 49 - GROUP BY in PostgreSQL
  • 50 - HAVING in PostgreSQL
  • 51 - GROUP BY HAVING in Oracle SQL

  • 13 - Condition Statements
  • 52 - CASE WHEN in PostgreSQL
  • 53 - CASE WHEN in Oracle SQL

  • 14 - JOINS
  • 54 - Introduction to Joins
  • 55 - Concepts of Joining and Combining Data
  • 56 - Preparing the data
  • 57 - Inner Join in PostgreSQL
  • 58 - Inner Join in Oracle SQL
  • 59 - Left Join in PostgreSQL
  • 60 - Right Join in PostgreSQL
  • 61 - Full Outer Join in PostgreSQL
  • 62 - Left Right Full outer join in Oracle SQL
  • 63 - Cross Join in PostgreSQL
  • 64 - Cross Join in Oracle SQL
  • 65 - Intersect and Intersect ALL in PostgreSQL
  • 66 - Except in PostgreSQL
  • 67 - Union in PostgreSQL

  • 15 - Subqueries
  • 68 - Subqueries Subquery in WHERE clause in PostgreSQL
  • 69 - Subqueries Subquery in FROM clause in PostgreSQL
  • 70 - Subqueries Subquery in SELECT in PostgreSQL
  • 71 - Subqueries in Oracle SQL

  • 16 - Views and Indexes
  • 72 - VIEWS in PostgreSQL
  • 73 - VIEWS in Oracle SQL
  • 74 - INDEX in PostgreSQL
  • 75 - INDEX in Oracle SQL

  • 17 - String Functions
  • 76 - Length in PostgreSQL
  • 77 - Length in Oracle SQL
  • 78 - UPPER LOWER in PostgreSQL
  • 79 - UPPER LOWER in OraleSQL
  • 80 - REPLACE in PostgreSQL
  • 81 - REPLACE in OracleSQL
  • 82 - TRIM LTRIM RTRIM in PostgreSQL
  • 83 - TRIM LTRIM RTRIM in Oracle SQL
  • 84 - CONCATENATION in PostgreSQL
  • 85 - CONCATENATION in Oracle SQL
  • 86 - SUBSTRING in PostgreSQL
  • 87 - SUBSTRING in Oracle SQL
  • 88 - LIST AGGREGATION in PostgreSQL
  • 89 - LIST AGGREGATION in Oracle SQL

  • 18 - Mathematical Functions
  • 90 - CEIL FLOOR in PostgreSQL
  • 91 - RANDOM in PostgreSQL
  • 92 - SETSEED in PostgreSQL
  • 93 - ROUND in PostgreSQL
  • 94 - POWER in PostgreSQL
  • 95 - Mathematical Functions in Oracle SQL

  • 19 - DateTime Functions
  • 96 - CURRENT DATE TIME in PostgreSQL
  • 97 - AGE in PostgreSQL
  • 98 - DateTime Functions in Oracle SQL
  • 99 - EXTRACT in PostgreSQL
  • 100 - Extract in Oracle SQL

  • 20 - Data Type conversion
  • 101 - Data Type conversion to string in PostgreSQL
  • 102 - Data Type conversion to Number and Date in PostgreSQL

  • 21 - PATTERN STRING MATCHING
  • 103 - PATTERN MATCHING BASICS
  • 104 - Advanced pattern matching Part 1 REGULAR EXPRESSIONS
  • 105 - Advanced pattern matching Part 2 REGULAR EXPRESSIONS
  • 106 - Pattern matching in Oracle SQL

  • 22 - Congratulations
  • 107 - The final milestone
  • 108 - Bonus Lecture.html
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 6241
    حجم: 3896 مگابایت
    مدت زمان: 539 دقیقه
    تاریخ انتشار: 3 اسفند 1401
    طراحی سایت و خدمات سئو

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