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

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

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

تولید کننده: Udemy