Oracle Database for Beginners

Learn how to store, manipulate, query and process data in Oracle database using SQL and PL/SQL.

Oracle Database for Beginners

Learn how to store, manipulate, query and process data in Oracle database using SQL and PL/SQL.
92
views
1
Save
Share the link to this page
Copied

About the Class

This course will teach how to use Oracle database to store, manipulate and query data. It takes you from the fundamentals of databases to creating program units to implement business logic and rules using PL/SQL.

What will you learn in this course?

  • What are DBMS and RDBMS
  • How to get started with Oracle Database 18c XE and Oracle SQL developer
  • How to use SQL to retrieve, manipulate and create data
  • How to group data using GROUP BY and HAVING clauses
  • How to use different types of joins to get data from multiple tables
  • How to use subquery and correlated subquery to write complex queries
  • What is a view, advantages of view and how to manipulate the base table through a view
  • What is the index and how index improves performance
  • Implementing object-level security using object privileges
  • How to create and use regular expressions
  • Writing PL/SQL blocks to process data
  • Various control structures in PL/SQL
  • Handling exceptions
  • Explicit and implicit cursors
  • Creating procedures and functions to implement business logic
  • Creating database triggers to implement business rules
  • Dynamic SQL and collections

This course is meant for any beginner of DBMS who is interested in learning how to use DBMS, SQL and PL/SQL to build database-driven applications or to interact with the database in data analysis and data science.

Author

Srikanth Pragada

Software Trainer
I have been teaching programming languages for more than 28 years. I worked with more than 15 programming languages. Specialized in developing Web applications using Java, Microsoft.Net, Python and Angular Framework. I provide classroom and online training on C, Java, MS.NET, Oracle, Python, Data Science with Python and Angular through my...

School

Srikanth Pragada's School

Requirements

You should have a working knowledge of PC/Mac and knowledge of programming is a plus.

One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€65.66
List Price:  €93.81
You save:  €28.14
£56.18
List Price:  £80.26
You save:  £24.08
CA$96.40
List Price:  CA$137.73
You save:  CA$41.32
A$107.87
List Price:  A$154.11
You save:  A$46.23
S$95.25
List Price:  S$136.08
You save:  S$40.83
HK$548.53
List Price:  HK$783.65
You save:  HK$235.12
CHF 63.98
List Price:  CHF 91.40
You save:  CHF 27.42
NOK kr762.91
List Price:  NOK kr1,089.92
You save:  NOK kr327
DKK kr490.64
List Price:  DKK kr700.94
You save:  DKK kr210.30
NZ$117.76
List Price:  NZ$168.24
You save:  NZ$50.47
د.إ257.02
List Price:  د.إ367.19
You save:  د.إ110.16
৳7,677.38
List Price:  ৳10,968.15
You save:  ৳3,290.77
₹5,851.95
List Price:  ₹8,360.30
You save:  ₹2,508.34
RM333.74
List Price:  RM476.80
You save:  RM143.05
₦87,233.43
List Price:  ₦124,624.53
You save:  ₦37,391.10
₨19,453.72
List Price:  ₨27,792.22
You save:  ₨8,338.50
฿2,544.62
List Price:  ฿3,635.33
You save:  ฿1,090.70
₺2,265.05
List Price:  ₺3,235.93
You save:  ₺970.87
B$358.24
List Price:  B$511.79
You save:  B$153.55
R1,317.23
List Price:  R1,881.84
You save:  R564.60
Лв128.62
List Price:  Лв183.76
You save:  Лв55.13
₩96,628.19
List Price:  ₩138,046.19
You save:  ₩41,418
₪263.87
List Price:  ₪376.98
You save:  ₪113.10
₱3,959.57
List Price:  ₱5,656.78
You save:  ₱1,697.20
¥10,727.71
List Price:  ¥15,325.96
You save:  ¥4,598.25
MX$1,164.84
List Price:  MX$1,664.13
You save:  MX$499.29
QR254.81
List Price:  QR364.03
You save:  QR109.22
P960.24
List Price:  P1,371.84
You save:  P411.59
KSh9,098.70
List Price:  KSh12,998.70
You save:  KSh3,900
E£3,326.58
List Price:  E£4,752.47
You save:  E£1,425.88
ብር3,979.31
List Price:  ብር5,684.97
You save:  ብር1,705.66
Kz58,546.63
List Price:  Kz83,641.63
You save:  Kz25,095
CLP$67,475.25
List Price:  CLP$96,397.35
You save:  CLP$28,922.10
CN¥506.51
List Price:  CN¥723.62
You save:  CN¥217.11
RD$4,159.85
List Price:  RD$5,942.90
You save:  RD$1,783.05
DA9,426.32
List Price:  DA13,466.75
You save:  DA4,040.43
FJ$158.71
List Price:  FJ$226.74
You save:  FJ$68.02
Q544.83
List Price:  Q778.36
You save:  Q233.53
GY$14,647.93
List Price:  GY$20,926.52
You save:  GY$6,278.58
ISK kr9,909.88
List Price:  ISK kr14,157.58
You save:  ISK kr4,247.70
DH701.47
List Price:  DH1,002.14
You save:  DH300.67
L1,235.26
List Price:  L1,764.74
You save:  L529.47
ден4,036.76
List Price:  ден5,767.05
You save:  ден1,730.28
MOP$564.70
List Price:  MOP$806.75
You save:  MOP$242.05
N$1,315.52
List Price:  N$1,879.40
You save:  N$563.87
C$2,572.13
List Price:  C$3,674.63
You save:  C$1,102.50
रु9,333.57
List Price:  रु13,334.25
You save:  रु4,000.67
S/258.30
List Price:  S/369.02
You save:  S/110.71
K268.41
List Price:  K383.46
You save:  K115.05
SAR262.55
List Price:  SAR375.09
You save:  SAR112.53
ZK1,747.13
List Price:  ZK2,496.01
You save:  ZK748.88
L327.08
List Price:  L467.28
You save:  L140.19
Kč1,665.85
List Price:  Kč2,379.90
You save:  Kč714.04
Ft25,828.40
List Price:  Ft36,899.30
You save:  Ft11,070.90
SEK kr761.19
List Price:  SEK kr1,087.47
You save:  SEK kr326.27
ARS$60,557.36
List Price:  ARS$86,514.22
You save:  ARS$25,956.86
Bs485.16
List Price:  Bs693.12
You save:  Bs207.95
COP$267,004.46
List Price:  COP$381,451.29
You save:  COP$114,446.83
₡35,552.47
List Price:  ₡50,791.41
You save:  ₡15,238.94
L1,726.86
List Price:  L2,467.06
You save:  L740.19
₲517,422.09
List Price:  ₲739,206.10
You save:  ₲221,784.01
$U2,707.47
List Price:  $U3,867.98
You save:  $U1,160.51
zł282.05
List Price:  zł402.95
You save:  zł120.89

What's Included

Language: English
Level: Beginner
Skills: DBMS, RDBMS, PL/SQL, SQL, Oracle, Oracle Database
Age groups: All ages
Duration: 9 hours 7 minutes
28 Videos
1
Save
92
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.