Oracale Database

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

Beginner 0(0 Ratings) 6 Students enrolled
Created by Ulearn Academy Last updated Fri, 10-Jul-2020 English
What will i learn?
  • Concepts of Database, how to use SQL to retrieve & manipulate data and use PL/SQL to develop program units to implement business logic and rules

Curriculum for this course
82 Lessons 10:18:42
Section1
10 Lessons 01:21:37 Hours
  • Oracle Tutorial#1 Introduction of Oracle SQL | Basics of a database for beginner 00:05:14
  • Tutorial#2- how to Install Oracle SQL Database 11g 00:07:54
  • Tutorial #3 How to Install Oracle SQL Developer 00:08:31
  • Tutorial#4 Data Types in Oracle SQL Database | best for oracle SQL database beginners - Training 00:01:51
  • Tutorial#5 Why/When/Where we use data type in oracle database 00:17:50
  • Tutorial#6 Types(classification) of SQL statement in oracle data base 00:05:47
  • Tutorial#7 How to create table in oracle database| create table statement syntax 00:11:07
  • Tutorial#8 How to Rename/Modify/Add/Remove column of a table|Alter SQL Statement in oracle database 00:10:59
  • Tutorial#9 How to Rename Table in oracle SQL database 00:06:15
  • Tutorial#10 How to Drop Table in Oracle SQL database 00:06:09
  • Tutorial#11 How to Truncate Table in Oracle SQL database by rakesh malviya 00:06:01
  • Tutorial#12 How to Insert data into a table using SQL developer 00:13:01
  • Tutorial#13 How to delete row in oracle database| SQL delete Statement 00:08:04
  • Tutorial#14 How to Update rows using Update Statement in Oracle SQL database 00:05:42
  • Tutorial#15 How to use commit and rollback in SQL Developer|Transaction control language(TCL) 00:09:47
  • Tutorial#16 Execute SQL Select Statement| How to retrieve data from table 00:04:40
  • Tutorial#17 How Oracle SQL Query Work Internally 00:08:03
  • Tutorial#18 Logical operator Example in SQL| Types of Logical operators 00:05:10
  • Tutorial#19 Do you know all the Arithmetic operator in Oracle SQL Database 00:06:56
  • Tutorial# 20 Do you know all the Comparison operator in Oracle SQL Database 00:05:29
  • Tutorial#21 Like operator in Oracle database|SQL Wildcard characters 00:04:48
  • Tutorial#22 Easy way to learn IN OPERATOR in Oracle SQL Database| IN Operator in SQL 00:06:24
  • Tutorial#23 Learn How to combine two or more column/String using Concatenation Operator 00:07:57
  • Tutorial#24 Any operator in sql | 100% guarantee you will learn something new 00:09:12
  • Tutorial#25 How to use ALL comparison operator in Oracle SQL| ALL operator in Oracle with examples 00:07:19
  • Tutorial#26 How to use Between operator in Oracle SQL Database 00:08:21
  • Tutorial#27 How NULL value treated in Oracle SQL Database|IS NULL Operator 00:04:27
  • Tutorial#28 How to sort rows in oracle database| SQL Order by Clause 00:04:59
  • Tutorial#29 Types of SQL Functions in Oracle Database| Oracle SQL Function Classification 00:03:21
  • Tutorial#30 How to Convert Text From Upper Case to Lower Case in Oracle SQL Database 00:05:38
  • Tutorial#31 How to Convert Text From Lower Case to Upper Case in Oracle SQL Database 00:06:02
  • Tutorial#32 How to use INITCAP function in Oracle SQL | Make First Letter of String as Capital 00:04:26
  • Tutorial#33 How to Join two Columns using concatenation function in Oracle SQL Database 00:06:51
  • Tutorial#34 How to find the length of column in Oracle SQL | Length Function 00:05:00
  • Tutorial#35 How to Add Character using RPAD function in Oracle SQL Database 00:07:03
  • Tutorial#36 LPAD function in Oracle SQL Database | How to add string at front of string 00:10:08
  • Tutorial#37 How to Remove Character/Spaces/String from Column Using with LTRIM function in Oracle 00:06:16
  • Tutorial#38 How to Remove character/Spaces from Column Using with RTRIM function 00:07:09
  • Tutorial#39 How to Remove Character from Spaces/String/Column Using with TRIM function 00:09:57
  • Tutorial#40 NVL Function in oracle SQL with example 00:06:45
  • Tutorial#41 NVL2 function in oracle SQL database by rakesh malviya 00:07:37
  • Tutorial#42 INSTR function in Oracle SQL Database| How to find position of substring 00:12:33
  • Tutorial#43 SUBSTR function in Oracle SQL Database| How to get substring from String/column 00:10:23
  • Tutorial#44 To_char function | character conversion function in Oracle database 00:04:35
  • Tutorial#45 TO_NUMBER function | Convert varchar value into number format 00:04:24
  • Tutorial#46 Floor function | rounds down to the nearest whole number 00:03:39
  • 0:11 / 5:06 Tutorial#47 Ceil function| Round up the nearest whole number|number function in Oracle SQL database 00:05:07
  • Tutorial#48 How to use Power function in Oracle SQL Database| Number function in Oracle SQL 00:03:37
  • Tutorial#49 How to use ROUND Function in Oracle SQL Database|Number Function in Oracle Database 00:03:09
  • Tutorial#50 How to replace String/Column Value using Replace Function in Oracle SQL Database 00:05:47
  • Tutorial#51 How to use modulus function in Oracle SQL Database| MOD Function in SQL 00:03:34
  • Tutorial#52 MIN, MAX and AVG Aggregate Function in Oracle SQL Database|Group by Function in SQL 00:08:46
  • Tutorial#53 Count and Sum Aggregate Function in Oracle SQL Database| Group by Function in SQL 00:09:01
  • Oracle SQL Tutorial#54 Group by in oracle | Deep dive Database 00:13:10
  • Tutorial#55 Having Clause in Oracle SQL Database| Having Clause in SQL 00:10:48
  • Tutorial#56 what is Constraints and Types of Constraints in a Oracle SQL Database 00:03:02
  • Tutorial#57 How to use Not null Constraint in Oracle SQL Database| Not Null Constraint in SQL 00:09:51
  • Tutorial#58 How to Use Unique key Constraint in Oracle SQL Database| unique key Constraint in SQL 00:07:04
  • Tutorial#59 How to Use Primary key Constraint in Oracle SQL Database|Primary key Constraint in SQL 00:07:59
  • Tutorial#60 Foreign key constraint in Oracle SQL Database| How to Create FOREIGN KEY Constraints 00:14:58
  • Tutorial#61 Check constraint in Oracle SQL Database| How to Add Check Constraints 00:11:12
  • Tutorial#62 types of Oracle SQL Joins 00:04:39
  • Tutorial#63 Cross Join in SQL | Understand how joins works internally in oracle 00:10:27
  • Tutorial#64 Inner Join in SQL | Understand how inner join works internally in oracle SQL database 00:12:54
  • Tutorial#65 Left outer Join in SQL | Understand how Left Outer join works internally in oracle SQL 00:14:18
  • Tutorial#66 Right outer Join in Oracle SQL Database by Rakesh Malviya equal connect coach 00:11:43
  • Tutorial#67 Full outer Join in Oracle SQL Database 00:10:35
  • Tutorial#68 SubQuery in Oracle SQL Database by rakesh malviya 00:08:15
  • Tutorial#69 All in one 'set operator' in oracle SQL Database by equal connect coach 00:01:18
  • Tutorial#70 Union operator in Oracle SQL Database| Using Union Operator in Select Statement 00:07:16
  • Tutorial#71 Union All operator in Oracle SQL Database| Using Union All Operator in Select Statement 00:06:50
  • Tutorial#72 Intersect operator in Oracle SQL Database| Using Intersect Operator in Select Statement 00:04:20
  • Tutorial#74 Minus operator in Oracle SQL Database| Using Minus Operator in Select Statement 00:07:39
  • Tutorials#75 what is View in Oracle SQL Database 00:08:23
  • Tutorials#76 How to create SYNONYM in Oracle SQL Database 00:07:11
  • Tutorials#77 Oracle sequence - How to create sequence in Oracle SQL Database 00:10:11
  • SQL Tutorial#78 Basic pseudo columns in oracle Database 00:08:46
  • Oracle Tutorial#20 Dual table Database 00:04:44
  • Oracle SQL Tutorial#79 Runtime input to SQL query |substitution operator Oracle Database 00:04:59
  • Tutorial#1 Basics Of Oracle SQL for Beginners/newcomer/Student by Rakesh malviya/equal connect coach 00:08:10
  • Oracle Sql Tutorial#79 How to create/drop synonym in Oracle Database 00:09:13
  • Oracle SQL Tutorial#81 Privileges In oracle SQL database 00:10:02
Requirements
  • Working knowledge of Computers. Knowledge of programming is a plus.
+ View more
Description

Learn how to use Oracle Database to store, manipulate and query data.  It takes you from fundamentals of databases to creating program units to implement business logic and rules using PL/SQL.

The following are major topics covered:

  • What is 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 base table through view
  • What is 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
+ View more
Other related courses
About the instructor
  • 5 Reviews
  • 121 Students
  • 88 Courses
+ View more
Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
Free
Includes:
  • 10:18:42 On demand videos
  • 82 Lessons
  • Access on mobile and tv
  • Full lifetime access
  • Access on mobile and tv