Oracle SQL Training by eduCBA - Online Course

by Jagranjosh

Oracle SQL Training by eduCBA - Online Course

Section 1: Oracle 9i Introduction 1 ER Modeling 2 Data Storage on Different Media 3 RDBMS and SQL 4 Select Statement with Column Alias and Arithmetic operators 5 Concatenation Operator, Literal, Elimi...View more

Specification

  • Category: os and database
  • Product Type: Online Course
Product Description

Section 1: Oracle 9i Introduction

1 ER Modeling

2 Data Storage on Different Media

3 RDBMS and SQL

4 Select Statement with Column Alias and Arithmetic operators

5 Concatenation Operator, Literal, Eliminating Duplicate rows

6 SQL iSQLplus and Displaying Table Structure

7 Basic SQL Select Statements-Practical Examples

8 Writing Basic SQL Select Statements

9 Where Clause and Comparison Conditions

10  Comparison Conditions

11 Logical and Order by Clause

12 Restricting and Sorting Data-Practical Examples 01

13 Restricting and Sorting Data-Practical Examples 02

14 Basic SQL Select Statements

15 Basic SQL Select Statements Continue

16 Character Function

17 Case Manipulation Function

18 Number, Arithmatic and Date Functions

19 Arithmetic with Dates

20 Conversion and RR YY Functions

21 CHAR Function with Dates

22 Nesting and General Functions

23 COALESCE Function

24 Practical Assignments

25 Practical exercise

26 Conversion Function

27 Practical Demonstration

28 Additional Examples

29 Additional Examples of Salary

 

Section 2: Displaying and Aggregating Data, Subqueries

30 Cartesian Product, EquiJoin

31 Non Equi, Outer and Self Joins

32 SQL 1999 Complaint Joins

33 Creating Three-Way Joins with the ON Clause

34 Displaying Data from Multiple Tables 1

35 Displaying Data from Multiple Tables 2

36 Displaying Data from Multiple Tables 3

37 Create Query 01

38 Create Query 02

39 Group Functions Syntax

40 MIN and MAX Functions

41 Groups of Data and Having Clause

42 IIIegal Querise Using Group Function

43 Aggregating Data Using Group Functions-Practical Examples

44 Aggregating Data Using Group Functions-Additional Examples 01

45 Aggregating Data Using Group Functions-Additional Examples 02

46 Subqueries

47 The HAVING Clause with Subqueries

48 Subqueries-Practical Examples-1

49 Subqueries-Practical Examples-2

50 Subqueries-Additional Examples 1

51 Subqueries-Additional Examples 2

 

Section 3: Producing Readable Output, Manipulating Data

52 Substitution Variables

53 Verify,Column,Break,Ttitle,Btitle commands

54 Producing Readable Output with iSQL-Practical Examples

55 Producing Readable Output with iSQL- Examples

56 Objectives and Insert Statement

57 Update, Delete and Merge

58 The UPDATE Statement Syntax

59 Database Transaction

60 ROLLBACK Statements

61 Manipulating Data-Session 8 Practical 1

62 Manipulating Data-Session 8 Practical 2

63 Manipulating Data-Session 8 Practical 3

64 Manipulating Data-Additional Examples 01

65 Manipulating Data-Additional Examples 02

66 Database Objects, Create Table

67 Tables in the Oracle Database

68 Alter Table , Drop Table

69 The SET UNUSED Option

70 Creating and Managing Tables-Practical Examples 01

71 Creating and Managing Tables-Practical Examples 02

72 Creating and Managing Tables-Additional Examples 01

73 Creating and Managing Tables-Additional Examples 02

74 Constraints, Type of Constraints and Defining Constraints

75 The UNIQUE Constraint

76 Adding, Disabling , Enabling Viewing Constraints

77 Adding, Disabling , Enabling Viewing Constraints- summary

78 Including Constraints-Practical Examples

79 Including Constraints-Additional Examples

 

Section 4: Views, Database Objects, User Access

80 Creating, Modifying and Queering Views

81 Complex Views, Denying DML, Inline Views and Top n Analysis

82 Complex Views, Denying DML, Inline Views and Top n Analysis part summary

83 Creating Views-Practical Examples

84 Creating Views-Additional Examples

85 Creating Sequence, Modifying

86 NEXTVAL and CURRVAL Pseudo columns

87 Indexes and Synonyms

88 Other Database Objects-Practical Examples

89 Other Database Objects-Additional Examples

90 Controlling User Access

91 Granting System Privileges

92 Practice and Additional Practice Part-1

93 Practice and Additional Practice Part-2

94 SQL Workshop Examples 01

95 SQL Workshop Examples 02

96 SQL Workshop Examples 03

97 SQL Workshop Examples 04

98 SQL Workshop Examples 05

99 SQL Workshop Examples 06

100 SQL Workshop Examples 07

101 SQL Workshop Examples 08

102 Set Operators, Union, Union all, Intersect and Minus

103 Oracle Server and Set Operator

104 Oracle Server and Set Operator summary

105 Using SET Operators-Practical Examples

106 Using SET Operators-Additional Examples

 

Section 5: Date time functions, Advances DML Operations

107 Tz_offset, Current_date, Current_time  stamp, Local time stamp

108 Extract and Other timestamp data types

109 Extract and Other timestamp data types summary

110 Oracle9i Date time Functions-Practical Examples 01

111 Oracle9i Date time Functions-Practical Examples 02

112 Oracle9i Date time Functions-Additional Practice

113 Group, Having, Group by, Rollup and Cube

114 Grouping Functions, Grouping Set

115 Grouping Functions, Grouping Set, Composite columns and Concatenated grouping summary

116 Enhancements to the GROUP BY Clause 01

117 Enhancements to the GROUP BY Clause 02

118 Enhancements to the GROUP BY Clause-Additional Examples

119 Multiple-Column Sub queries

120 Column Comparisons

121 Correlated Sub queries

122 Correlated UPDATE

123 summary

124 Advanced Sub queries-Practical Examples 01

125 Advanced Sub queries-Practical Examples 02

126 Advanced Sub queries-Additional Example 01

127 Advanced Sub queries-Additional Example 02

128 Hierarchical Queries

129 Walking the Tree From the Bottom Up

130 Hierarchical Queries_summary

131 Hierarchical Retrieval-Practical Examples

132 Hierarchical Retrieval-Additional Examples

133 Review of the UPDATE Statement

134 Ranking Rows With the Level

135 Pivoting Insert, External Tables

136 Creating an External Table

137 create table summary

You May Also Be Interested In
  • Rs. 999
  • Rs. 299
  • (70% Off)

Promo Code SAVE25

Use promocode SAVE25 to get upto 25% discount on offer price Minimum Order value - Rs 50/-. Offer is valid for all Jagran Josh products.

Best Sellers

Oracle SQL Training by eduCBA - Online Course
Oracle SQL Training by eduCBA - Online Course

Section 1: Oracle 9i Introduction

1 ER Modeling

2 Data Storage on Different Media

3 RDBMS and SQL

4 Select Statement with Column Alias and Arithmetic op

Promo Code SAVE25

Use promocode SAVE25 to get upto 25% discount on offer price Minimum Order value - Rs 50/-. Offer is valid for all Jagran Josh products.

Specification
  • Category: os and database
  • Product Type: Online Course
Product Description

Section 1: Oracle 9i Introduction 1 ER Modeling 2 Data Storage on Different Media 3 RDBMS and SQL 4 Select Statement with Column Alias and Arithmetic operators 5 Concatenation Operator, Literal, Eliminating Duplicate rows 6 SQL iSQLplus and Displaying Table Structure 7 Basic SQL Select Statements-Pr ... Read More