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

139,000 تومان

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

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

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

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