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

PostgreSQL Mastery: In-Depth Training and Practical Projects

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

Unlock the full potential of PostgreSQL through comprehensive tutorials, hands-on projects, and real-world applications


1 - PostgreSQL Course
  • 1 - Introduction to PostgreSQL
  • 2 - Continue PostgreSQL Introduction
  • 3 - Drop Database
  • 4 - Drop Database Continue
  • 5 - Insert Into Table
  • 6 - Insert Into Table Continue
  • 7 - Adding Constraints
  • 8 - Numeric Types
  • 9 - Advantages of SQL Part 1
  • 10 - Advantages of SQL Part 2
  • 11 - Advantages of SQL Part 3
  • 12 - Constraints
  • 13 - Operators
  • 14 - Basic of Table
  • 15 - Constraints Concepts
  • 16 - Constraint Concept
  • 17 - Constraint Concept Continue
  • 18 - Primary Key
  • 19 - Foreign Key
  • 20 - Modifying Table Part 1
  • 21 - Modifying Table Part 2
  • 22 - Modifying Table Part 3
  • 23 - Modifying Table Part 4

  • 2 - Project On PostgreSQL ECommerce Reporting And Analysis
  • 24 - Introduction to Project
  • 25 - Introduction to Project Continue
  • 26 - Installation
  • 27 - Installation Continue
  • 28 - Managing Databases
  • 29 - Managing Tables
  • 30 - Managing Tables Continue
  • 31 - Datatypes
  • 32 - Constraints
  • 33 - Understanding Case Study Dataset
  • 34 - Import CSV Dataset Into Table
  • 35 - Querying the Database Tables
  • 36 - Querying the Database Tables Continue
  • 37 - Filtering the Records
  • 38 - Using Subqueries
  • 39 - Grouping Data
  • 40 - Using Joins Part 1
  • 41 - Using Joins Part 2
  • 42 - Using Joins Part 3
  • 43 - Grouping Sets
  • 44 - Grouping Sets Continue
  • 45 - Cube and Rollup
  • 46 - PGAdmin4
  • 47 - Reporting Introduction
  • 48 - Reporting Project Assignment Part 1
  • 49 - Reporting Project Assignment Part 2
  • 50 - Reporting Project Assignment Part 3

  • 3 - PostgreSQL Project Solving Employee Records Queries
  • 51 - Introduction to Project
  • 52 - Setting Up with PostgreSQL
  • 53 - Creating Employee Table
  • 54 - Appraisal Tables
  • 55 - Query for Joining Tables
  • 56 - Query For Appraisal
  • 57 - Query for Finding Salaries
  • 58 - Output of the Project

  • 4 - PostgreSQL 2023 Training
  • 59 - PostgreSQL Basic
  • 60 - Downloading of PostgreSQL
  • 61 - Installing and Configuring PostgreSQL
  • 62 - Tables Using Query
  • 63 - Inserting Records in Humanresource Database
  • 64 - Executing Queries from Command Line
  • 65 - Creating and Inserting Records in SampleDB
  • 66 - Creating and Inserting Records in SampleDB Continued
  • 67 - MultiInsert Statement
  • 68 - Statement
  • 70 - Assignment Explanation
  • 71 - Various Select Clause
  • 72 - Using Aggregate Function in Select
  • 73 - More on Aggregate Functions
  • 74 - Using More Clauses in Select Statement
  • 75 - Order by Clause
  • 76 - Char and Like Clause
  • 77 - More on Like Clause
  • 78 - Using Group by and Having Clause

  • 5 - PostgreSQL Tutorials The Fundamentals
  • 79 - Introduction to PostgreSQL
  • 80 - Benefits of PostgreSQL
  • 81 - Aspect of Database
  • 82 - Types of Data
  • 83 - Issuing Database Commands
  • 84 - Table Structure
  • 85 - Inserting Data in Table
  • 86 - Retrieving the Data
  • 87 - Sorting of Data
  • 88 - Analyzing of Various Queries
  • 89 - Destroying a Table
  • 90 - Customization of Queries
  • 91 - Understanding Null Values
  • 92 - Performing Complex Clause
  • 93 - Uses of Distinct Keyword
  • 94 - Set Show and Reset
  • 95 - SQL Aggregates
  • 96 - Group By and Having Clause
  • 97 - Concept of Joining Tables
  • 98 - Requirement for Joining Tables
  • 99 - Creating Join Tables
  • 100 - Inserting Customer Value
  • 101 - Three or Four Table Joins
  • 102 - Additional Join
  • 103 - One to Many Joins
  • 104 - Concept of Self Joins
  • 105 - Concept of Referential Integrity
  • 106 - Numbering Rows
  • 107 - Creating Functions for Sequences
  • 108 - Combining Selects
  • 109 - Understanding Subqueries
  • 110 - Executing Subqueries
  • 111 - Update with FROM Clause
  • 112 - Creating Tables using Select
  • 113 - Concept of Performance
  • 114 - Understanding PostgreSQL
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 34198
    حجم: 5272 مگابایت
    مدت زمان: 892 دقیقه
    تاریخ انتشار: ۲۰ مرداد ۱۴۰۳
    طراحی سایت و خدمات سئو

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