4-in-1 bundle: MySQL, PostgreSQL, Microsoft SQL & Oracle SQL

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

Learn concepts & compare syntax of 4 popular SQL dialects- PostgreSQL, MySQL, Microsoft SQL & Oracle SQL | SQL Bundle

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 MySQL

6 - Installing and Setting up MySQL

5 - Installing MS SQL

7 - Installing and Setting up MS SQL

6 - Installing Oracle SQL

8 - Installing and Setting up Oracle SQL

7 - Fundamental SQL statements

9 - CREATE in PostgreSQL

10 - CREATE in MySQL

11 - CREATE in MS SQL

12 - CREATE in OracleSQL

13 - INSERT in PostgreSQL

14 - INSERT in MySQL

15 - INSERT in MS SQL

16 - INSERT in Oracle SQL

17 - Import data from File in PostgreSQL

18 - Import data from File in MySQL

19 - Import data from File in MS SQL

20 - Import data from File in Oracle SQL

21 - SELECT statement in PostgreSQL

22 - SELECT statement in MySQL

23 - SELECT statement in MS SQL

24 - SELECT statement in Oracle SQL

25 - SELECT DISTINCT in PostgreSQL

26 - SELECT DISTINCT in MySQL

27 - SELECT DISTINCT in MS SQL

28 - SELECT DISTINCT in Oracle SQL

29 - WHERE in PostgreSQL

30 - WHERE in MySQL

31 - WHERE in MS SQL

32 - WHERE in Oracle SQL

33 - Logical Operators in PostgreSQL

34 - Logical Operators in MySQL

35 - Logical Operators in MS SQL

36 - Logical Operators in Oracle SQL

37 - UPDATE in PostgreSQL

38 - UPDATE in MySQL

39 - UPDATE in MS SQL

40 - UPDATE in Oracle SQL

41 - DELETE in PostgreSQL

42 - DELETE in MySQL

43 - DELETE in MS SQL

44 - DELETE in Oracle SQL

45 - ALTER Part 1 in PostgreSQL

46 - ALTER Part 2 in PostgreSQL

47 - ALTER in MySQL

48 - ALTER in MS SQL

49 - ALTER in Oracle SQL

8 - Restore and Backup in PostgreSQL

50 - Restore and Backup

51 - Debugging restoration issues

52 - Creating DB using CSV files

53 - Debugging summary and Code for CSV files.html

9 - Restore and Backup in MySQL

54 - Restoring and Backup in MySQL

55 - Restore and Backup in MySQL

10 - Restore and Backup in MS SQL

56 - Restoring and Backup in MS SQL

57 - Restoring and Backup in MS SQL

11 - Restore and Backup in Oracle SQL

58 - Restoring and Backup in Oracle SQL

12 - Selection commands Filteing

59 - IN in PostgreSQL

60 - IN in MySQL

61 - IN in MS SQL

62 - BETWEEN in PostgreSQL

63 - BETWEEN in MySQL

64 - BETWEEN in MS SQL

65 - IN BETWEEN in Oracle SQL

66 - LIKE in PostgreSQL

67 - LIKE in MySQL

68 - LIKE in MS SQL

69 - LIKE in Oracle SQL

13 - Selection commands Ordering

70 - Side Lecture Commenting in SQL

71 - ORDER BY in PostgreSQL

72 - ORDER BY in MySQL

73 - ORDER BY in MS SQL

74 - LIMIT in PostgreSQL

75 - LIMIT in MySQL

76 - LIMIT in MS SQL

77 - ORDER BY LIMIT in Oracle SQL

14 - Aliases

78 - AS in PostgreSQL

79 - AS in MySQL

80 - AS in MS SQL

81 - AS in Oracle SQL

15 - Aggregate Commands

82 - COUNT in PostgreSQL

83 - COUNT in MySQL

84 - SUM in PostgreSQL

85 - SUM in MySQL

86 - AVERAGE in PostgreSQL

87 - AVERAGE in MySQL

88 - MIN MAX in PostgreSQL

89 - MIN MAX in MySQL

90 - Aggregate Functions in MS SQL

91 - Aggregate Functions in Oracle SQL

16 - Group By Commands

92 - GROUP BY in PostgreSQL

93 - GROUP BY in MySQL

94 - GROUP BY in MS SQL

95 - HAVING in PostgreSQL

96 - HAVING in MySQL

97 - HAVING in MS SQL

98 - GROUP BY HAVING in Oracle SQL

17 - Conditional Statement

99 - CASE WHEN in PostgreSQL

100 - CASE WHEN in MySQL

101 - CASE WHEN in MS SQL

102 - CASE WHEN in Oracle SQL

18 - JOINS

103 - Introduction to Joins

104 - Concepts of Joining and Combining Data

105 - Preparing the data

106 - Inner Join in PostgreSQL

107 - Inner Join in MySQL

108 - Inner Join in MS SQL

109 - Inner Join in Oracle SQL

110 - Left Join in PostgreSQL

111 - Left Join in MySQL

112 - Left Join in MS SQL

113 - Right Join in PostgreSQL

114 - Right Join in MySQL

115 - Right Join in MS SQL

116 - Full Outer Join in PostgreSQL

117 - Full Outer Join in MySQL

118 - Full Outer Join in MS SQL

119 - Left Right Full Outer Join in Oracle SQL

120 - Cross Join in PostgreSQL

121 - Cross Join in MySQL

122 - Cross Join in MS SQL

123 - Cross Join in Oracle SQL

124 - Intersect and Intersect ALL in PostgreSQL

125 - Intersect in MySQL

126 - Except in PostgreSQL

127 - Except in MySQL

128 - Union in PostgreSQL

129 - Union in MySQL

130 - Intersect Except Union in MS SQL

19 - Subqueries

131 - Subqueries Subquery in WHERE clause in PostgreSQL

132 - Subqueries Subquery in FROM clause in PostgreSQL

133 - Subqueries Subquery in SELECT in PostgreSQL

134 - Subqueries in MySQL

135 - Subqueries in MS SQL

136 - Subqueries in Oracle SQL

20 - Views and Indexes

137 - VIEWS in PostgreSQL

138 - VIEWS in MySQL

139 - VIEWS in MS SQL

140 - VIEWS in Oracle SQL

141 - INDEX in PostgreSQL

142 - INDEX in MySQL

143 - INDEX in MS SQL

144 - INDEX in Oracle SQL

21 - String Functions

145 - LENGTH in PostgreSQL

146 - LENGTH in Oracle SQL

147 - UPPER LOWER in PostgreSQL

148 - UPPER LOWER in Oracle SQL

149 - REPLACE in PostgreSQL

150 - REPLACE in Oracle SQL

151 - TRIM LTRIM RTRIM in PostgreSQL

152 - TRIM LTRIM RTRIM in Oracle SQL

153 - CONCATENATION in PostgreSQL

154 - CONCATENATION in Oracle SQL

155 - SUBSTRING in PostgreSQL

156 - SUBSTRING in Oracle SQL

157 - LIST AGGREGATION in PostgreSQL

158 - LIST AGGREGATION in Oracle SQL

159 - String Functions Part 1 in MySQL

160 - String Functions Part 2 in MySQL

161 - String Functions in MS SQL

22 - Mathematical Functions

162 - CEIL FLOOR in PostgreSQL

163 - RANDOM in PostgreSQL

164 - SETSEED in PostgreSQL

165 - ROUND in PostgreSQL

166 - POWER in PostgreSQL

167 - Mathematical Functions in MySQL

168 - Mathematical Functions in MS SQL Part 1

169 - Mathematical Functions in MS SQL Part 2

170 - Mathematical Functions in Oracle SQL

23 - DateTime Functions

171 - CURRENT DATE TIME in PostgreSQL

172 - AGE in PostgreSQL

173 - EXTRACT in PostgreSQL

174 - DateTime Functions in MySQL

175 - DateTime Functions in MS SQL

176 - DateTime Function in Oracle SQL

177 - Extract in Oracle SQL

24 - Data type conversion

178 - Data Type conversion to string in PostgreSQL

179 - Data Type conversion to Number and Date in PostgreSQL

180 - Data Type conversion in MySQL

181 - Data Type conversion in MS SQL

25 - PATTERN STRING MATCHING

182 - PATTERN MATCHING BASICS

183 - Advanced pattern matching Part 1 REGULAR EXPRESSIONS

184 - Advanced pattern matching Part 2 REGULAR EXPRESSIONS

185 - Pattern matching in MySQL

186 - Pattern matching in MS SQL

187 - Pattern matching in Oracle SQL

26 - Congratulations

188 - The final milestone

189 - Bonus Lecture.html

53,700 تومان

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

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

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

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