1Z0-171: Oracle Database 23ai SQL Associate

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

The SELECT statement, functions and more. Oracle Database 19c, 21c, 23c, 23ai using Oracle SQL Developer. 1Z0-171 exam.

1 - Introduction

1 - Introduction

2 - Welcome to Udemy.html

3 - The Udemy Interface

4 - Do you want autotranslated subtitles in more languages.html

5 - Curriculum

6 - DateFormats190520.pdf

6 - NumberFormats190514.pdf

6 - Resources.html

2 - Install Oracle Express Edition and SQL Developer

7 - Download and Install Oracle Express Edition

8 - Download and Install Oracle SQL Developer and connect to our database

9 - Solving connection errors

3 - The SELECT statement an overview

10 - 5 The SELECT and FROM clauses

11 - 4 Renaming fields using column aliases including using the AS keyword

12 - 5 Semicolons and comments

13 - 5 9 The WHERE clause

14 - 5 6d The GROUP BY clause and the DISTINCT keyword

15 - 5 21 The HAVING clause and information about error messages

16 - 13a 13c The ORDER BY clause

17 - Remembering the order of the clauses

18 - Practice Activity Number 1.html

19 - Practice Activity Number 1 The Solution

4 - 8b Session 1 Creating tables First pass

20 - Creating a table using the GUI and using DDL

21 - 35a Inserting values

22 - 35c 44 Deleting the data then the table

23 - Practice Activity Number 2.html

24 - Practice Activity Number 2 The Solution

5 - Session 1 The DUAL table and Number types

25 - 7 8 Using the DUAL table and rules of precedence for arithmetic expressions

26 - Practice Activity Number 3 Writing mathematical queries.html

27 - Practice Activity Number 3 The Solution

28 - 40 Creating sample table Run Script v Run Statement

29 - 41 The NUMBER data type

30 - Do you want to use the comma as a decimal point

31 - 8a FLOATing data types

32 - Practice Activity Number 4.html

33 - Practice Activity Number 4 The Solution

6 - Session 1 Number functions

34 - Numeric functions POWER SQRT EXP LN LOG ABS SIGN and trigonometric

35 - 15 Rounding functions including ROUND TRUNC and MOD functions

36 - Practice Activity Number 5.html

37 - Practice Activity Number 5 The Solution

7 - Session 1 String data types and functions

38 - 6 Using CHAR and VCHAR with concatenation operator literal character strings

39 - NCHAR and NVARCHAR Character Data Types

40 - 13 String Functions

41 - 7b NULL an introduction

42 - 7b 17 Useful NULL functions

43 - Practice Activity Number 5.html

44 - Practice Activity Number 5 The Solution

8 - Session 1 Converting numbers to strings and strings to numbers

45 - 18 Joining a string to a number using implicit conversions

46 - 19a 20 Converting a number to a string Part 1

47 - 19a Converting a number to a string Part 2

48 - 19b Converting a string to a number including the CAST function

49 - 5a 14b International conversions

50 - Practice Activity Number 6.html

51 - Practice Activity Number 6 The Solution

9 - Session 1 Date data types and functions

52 - DATE and TIMESTAMP data types

53 - 14 16 Date extraction functions

54 - 19a Converting dates to strings

55 - 19a Converting times to strings

56 - 19c Converting strings to timestamps using the TODATE conversion function

57 - Practice Activity Number 7.html

58 - Practice Activity Number 7 The Solution

10 - Creating and querying part of a table

59 - 42 Creating the TBLEMPLOYEE table

60 - 40 Adding and modifying additional columns

61 - 13 35a SELECTing only part of a table strings

62 - 9 SELECTing only part of a table numbers

63 - 16 SELECTing only part of a table dates

11 - Practice Activities

64 - 40 41 Practice Activity Number 8 Creating Tables.html

65 - 40 41 Practice Activity Number 8 The Solution

66 - InsertEmployeeDataScript.txt

66 - Populating the Practice Activity tables.html

67 - Populating the Practice Activity tables The Solution

68 - Practice Activity Number 9.html

69 - Practice Activity Number 9 The Solution

12 - Summarising and ordering data

70 - 5 Summarising and ordering data

71 - 5 21 Revising all 6 clauses including adding Criteria on summarised data

72 - Practice Activity 10.html

73 - Practice Activity 10 The Solution

74 - 12 More about COUNT and using ORDER BY NULLS FIRSTLAST

75 - Practice Activity Number 11.html

76 - Practice Activity Number 11 The Solution

13 - Adding a second table

77 - Adding a second table

78 - 2 Importing data and showing tables graphically

78 - InsertTransactionDataScript.txt

79 - Writing a JOIN query

80 - 24 26 27 Different types of JOIN

81 - 24 26 Using NATURAL JOINs

82 - 24 26 Old notation joins

83 - Practice Activity Number 12.html

84 - Practice Activity Number 12 The Solution

14 - Adding a third table

85 - DISTINCT subqueries and creating a third table

86 - 6a 6c JOINing three tables

86 - InsertDepartmentDataScript.txt

87 - Practice Activity Number 13.html

88 - Practice Activity Number 13 The Solution

15 - Find missing data and delete and update data

89 - 26 Missing data

90 - 35c Deleting data

91 - 35b Updating data

92 - Practice Activity Number 14.html

93 - Practice Activity Number 14 The Solution

16 - Database terminology

94 - 1 3 The relationship of a database and SQL

95 - 34 What are transactions

96 - 34 Implicit and explicit transactions

97 - 34 Savepoints and rollback to savepoints

98 - Formatting in Oracle SQL Developer

17 - 47 Apply how to manage constraints Part 1

99 - 47 Problems with our existing database and introducing constraints

100 - 47 Unique constraints what are they

101 - 47 Unique constraints in action using a single column

102 - 47 Unique constraints in action using multiple columns

103 - The Default clause

104 - 2 47 Check constraint and how constraints are represented in ERD

105 - Practice Activity Number 15.html

106 - Practice Activity Number 15 The Solution

18 - 47 Apply how to manage constraints Part 2

107 - Primary key

108 - Primary key in practice

109 - Adding IDENTITY to our Primary Key

110 - Foreign key what is it

111 - Foreign key in practice

112 - 2 How are constraints shown in ERDs

113 - Practice Activity Number 16.html

114 - Practice Activity Number 16 The Solution

19 - 48 Explain managing views

115 - Creating views

116 - Altering and dropping views

117 - Adding new rows to views

118 - HidingUnhiding Columns In Views

119 - Practice Activity Number 17.html

120 - Practice Activity Number 17 The Solution

20 - Combining sets

121 - 31 33c 33d UNION and UNION ALL

122 - 32 33a 33b INTERSECT and MINUS

123 - 10 11 Substitution variables and DEFINE and VERIFY commands

124 - CASE statement

125 - NVL NVL2 and Coalesce

126 - Practice Activity Number 18.html

127 - Practice Activity Number 18 The Solution

21 - The MERGE statement

128 - 20b MERGE statement in theory

129 - 20b Lets Build our MERGE statement

130 - 20b Lets expand our MERGE statement

131 - 20b Merge with additional columns

132 - Practice Activity Number 19.html

133 - Practice Activity Number 19 The Solution

22 - Group functions

134 - Adding Totals

135 - ROLLUP GROUPING and GROUPINGID

136 - GROUPING SETS

137 - Practice Activity Number 20.html

138 - Practice Activity Number 20 The Solution

23 - 16 Subqueries

139 - The WHERE clause

140 - WHERE and NOT

141 - ANY SOME and ALL

142 - The FROM clause

143 - The SELECT clause

144 - 16d Correlated subquery WHERE EXISTS

145 - Practice Activity Number 21.html

146 - Practice Activity Number 21 The Solution

24 - 16g Session 5 WITH clause and getting the top rows

147 - Top 5 from various categories

148 - WITH statement

149 - Generating a list of numbers

150 - Grouping numbers

151 - Selecting the third row using rownum and OFFSET and FETCH

152 - Deleting the second row of results

153 - Practice Activity Number 22.html

154 - Practice Activity Number 22 The Solution

25 - CTE statement

155 - 4c 6bSelfJoin

156 - Recursive CTE

26 - Time Zone and Interval data types

157 - Time Zone data types

158 - Time Zone functions

159 - Interval data types

160 - Interval functions

27 - Sequences and Data Dictionary

161 - Data Dictionary

162 - Defining Sequences

163 - Using Sequences

164 - Practice Activity Number 23.html

165 - Practice Activity Number 23 The Solution

28 - Indexes

166 - Heaps

167 - BTree

168 - Indexes

169 - Practice Activity Number 24.html

170 - Practice Activity Number 24 The Solution

29 - Users Privileges and Roles

171 - Users and Schema

172 - What are System and Object Privileges

173 - Granting system and object privileges to users and roles

174 - Namespaces

175 - Privileges Data Dictionary

30 - Miscellaneous

176 - Dropping columns and making them UNUSED

177 - Flashback Tables

178 - Create and use External Tables

179 - NonEqui Joins

180 - MultiTable INSERT statements

31 - Congratulations

181 - Taking the exam

182 - Well done

139,000 تومان

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

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

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

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