Learn ORACLE-SQL database Online for Beginners

Learn oracle database and make your bright future

Created byAmrit Kumar

Last updated 12/2024

English

What you'll learn

They will learn the different kinds of ways to handle the oracle and what is the best way to create the database which will help them in software development.
This project include the different topics of oracle and its budget is nice one to attract the student and it cover all the basic to advance concept of oracle.
This project is amazing one for the student and its cover the basic to advance concept of oracle.
The student have to visit the course and its amazing course, they will learn about different topics of oracle and specially design for IT student.

Course content

5 sections • 63 lectures • 4h 46m total length

Introduction to oracle topics3:00
They will learn the basic as well as advance part of oracle which is mostly popular database.
Oracle and its importance by mr. Amrit kumar8:29
Student will get here the importance of oracle and its use for database management.so this will really help the student for bright future in oracle database management.

How to create user in oracle by mr. Amrit kumar6:52
Student will learn that how to create user in oracle and different commands that is most important in structure query language. So we can say that student can get more and more knowledge if they listen carefully and concentrate their mind for learning structure query language.
Character datatype used in oracle by mr. Amrit kumar31:33
In this lecture student will learn the datatype used in oracle. They will learn about the most important character datatype which is really important and oracle have given so many facility that how we can use it and what are the ways of using and where it is going to be used in oracle.
Number datatype used in oracle by mr. Amrit kumar27:58
In this lecture student will learn number datatype used in oracle. They will learn about the number datatype and its type which is most important part of oracle and oracle have given so many facility that how we can use it and where it is going to be used in oracle.
Date datatype used in oracle by mr. Amrit kumar8:02
In this lecture we will learn about the date datatype used in oracle.so through this video we will learn how to use date datatype in oracle and its format of implementing into the oracle database.
Lob datatype used in oracle by mr. Amrit kumar19:54
In this lecture we will learn lob datatypes and its type with feature of using the lob datatype which is most important concept of lob datatype.

Properties of table in oracle by mr. Amrit kumar13:44
In this lecture we will learn about the properties of table and its different terms that is used in oracle.
How to create table in oracle by mr. Amrit kumar13:27
In this lecture we are going to learn about the table and how we can create table in oracle. So it is very important topic because we will perform our work on table and everything is going to be done here in this table.
How to execute table in oracle by mr. Amrit kumar4:29
In this lecture we will learn about how to execute table in oracle and its really going to help you in the execution process through notepad in sql prompt.

How to apply primary key in oracle by mr. Amrit kumar5:14
In this lecture we will learn about how to apply primary key in oracle which is really important concepts of applying unique id in oracle.
Null/not null used in oracle by mr. Amrit kumar1:01
In this lecture we will learn about null/not null concept used in oracle.
Operators used in oracle-in/not in operator by mr. Amrit kumar2:49
In this lecture we wil learn about in/not in operator used in oracle.
Relational and logical operator used in oracle by mr. Amrit kumar7:04
In this lecture we will learn about relational and logical operator used in oracle.
Constraint in oracle by mr. Amrit kumar5:30
In this lecture we will learn about constraint in oracle and how we use constraint in oracle.
How to apply foreign key in oracle by mr. Amrit kumar7:40
In this lecture we wil learn about how to apply foreign key in oracle and concept about the foreign key.
Some question based on basic of oracle with solution by mr. Amrit kumar4:03
In this lecture we will learn about some question based on basic of oracle with solution.
Insert into command of oracle by mr. Amrit kumar10:27
In this lecture we will learn about insert into command of oracle.
Creating primary key on two or more fields in oracle by mr. Amrit kumar3:18
In this lecture we will learn about creating primary key on two or more fields in oracle.
Alter command of oracle by mr. Amrit kumar0:50
In this lecture we will learn about alter command of oracle.
Alter command - to add new column in the existing table by mr. Amrit kumar3:47
In this lecture we will learn about alter command - to add new column in the existing table.
Alter command - to add restriction in the existing column by mr. Amrit kumar2:15
In this lecture we will learn about alter command - to add restriction in the existing column
Alter command - to modify the datatype of an existing table by mr. Amrit kumar3:03
In this lecture we will learn about alter command - to modify the datatype of an existing table.
Alter command - to convert one datatype into another datatype by mr. Amrit kumar3:00
In this lecture we will learn about alter command - to convert one datatype into another datatype in oracle.
Alter command - to enable/ disable constraint by mr. Amrit kumar1:44
In this lecture we will learn about alter command - to enable/disable constraint in oracle.
Alter command - to add foreign key constraint in oracle by mr. Amrit kumar2:00
In this lecture we will learn about alter command - to add foreign key constraint in oracle.
Alter command - to drop constraint in oracle by mr. Amrit kumar4:05
In this lecture we will learn about alter command - to drop constraint in oracle.
Alter command - to drop column in oracle by mr. Amrit kumar2:01
In this lecture we will learn about alter command - to drop column in oracle.
How to drop table in oracle by mr. Amrit kumar0:38
In this lecture we will learn about how to drop table in oracle.

Query in oracle by mr. Amrit kumar1:33
In this lecture we will learn about query in oracle.
How to retrieve record from existing table by mr. Amrit kumar3:46
In this lecture we will learn about how to retrieve record from existing table.
Some query of oracle by mr. Amrit kumar2:19
In this lecture we will learn about some query of oracle.
Library function in oracle by mr. Amrit kumar0:52
In this lecture we will learn about library function in oracle.
Single row function in oracle by mr. Amrit kumar2:01
In this lecture we will learn about single row function in oracle.
Ascii(character) function used in oracle by mr. Amrit kumar2:56
Chr(number) function used in oracle by mr. Amrit kumar2:08
Concat(text1,text2) function used in oracle by mr. Amrit kumar3:06
Lower(string/column_name) function used in oracle by mr. Amrit kumar2:33
In this lecture we will learn about lower(string/column_name) function used in oracle
Upper(string/column_name) function used in oracle by mr. Amrit kumar2:53
In this lecture we will learn about upper(string/column_name) function used in oracle.
To_number(text) function used in oracle by mr. Amrit kumar1:59
In this lecture we will learn about to_number(text) function used in oracle.
To_char(number) function used in oracle by mr. Amrit kumar2:00
In this lecture we will learn about to_char(number) function used in oracle.
Sysdate() function used in oracle by mr. Amrit kumar2:02
In this lecture we will learn about sysdate() function used in oracle.
Substr() function used in oracle by mr. Amrit kumar2:45
Length() function used in oracle by mr. Amrit kumar2:13
In this lecture we will learn about length() function used in oracle.
How to find time in oracle by mr. Amrit kumar2:30
In this lecture we will learn about how to find time in oracle.
Aggregate function used in oracle by mr. Amrit kumar1:14
In this lecture we will learn about aggregate function used in oracle.
Sum() function used in oracle by mr. Amrit kumar1:45
In this lecture we will learn about sum() function used in oracle.
Avg() function used in oracle by mr. Amrit kumar2:07
In this lecture we will learn about avg() function used in oracle.
Count() function used in oracle by mr. Amrit kumar1:40
In this lecture we will learn about count() function used in oracle.
Count(*) function used in oracle by mr. Amrit kumar1:00
In this lecture we will learn about count(*) function used in oracle.
Group by clause in oracle by mr. Amrit kumar3:06
In this lecture we will learn about group by clause in oracle.
Having clause in oracle by mr. Amrit kumar2:52
In this lecture we will learn about having clause in oracle.
Joining in oracle by mr. Amrit kumar4:27
In this lecture we will learn about joining in oracle and its concept in oracle.
Types of joining in oracle by mr. Amrit kumar0:52
In this lecture we will learn about types of joining in oracle.
Self joining used in oracle by mr. Amrit kumar2:26
In this lecture we will learn about self joining used in oracle.
Outer joining used in oracle by mr. Amrit kumar2:24
In this lecture we will learn about outer joining used in oracle.
Natural joining used in oracle by mr. Amrit kumar2:00
In this lecture we will learn about natural joining used in oracle.
Equi joining used in oracle by mr. Amrit kumar2:05
In this lecture we will learn about equi joining used in oracle.
Subquery used in oracle by mr. Amrit kumar2:34
In this lecture we will learn about subquery used in oracle and its concept of using the query and subquery in oracle.
Delete in oracle by mr. Amrit kumar3:26
In this lecture we will learn about delete in oracle and how we can use the concept of delete in oracle.
Update in oracle by mr. Amrit kumar3:22
In this lecture we will learn about update in oracle and how we can use the concept of update in oracle.
View in oracle by mr. Amrit kumar2:16
In this lecture we will learn about the concept of view in oracle.
Retrieve view in oracle by mr. Amrit kumar1:31
In this lecture we will learn about retrieve view in oracle.

Requirements

No programming experience is needed because in oracle it is all about the simple english concept to build the database and student can easily understand the concept of oracle database.

Description

This course is going to teach you about oracle database. we have divided oracle into two part. First parts deals with data definition language(ddl) of structure query language and the second parts deals with data manipulation language(dml) of structure query language. Structure query language is the most important database in which we deals about ddl and dml and also do query in it. Query is the part of data manipulation language(dml).In ddl part we deals with the concept of creating the table , inserting into the table and altering the table and we also came to know about the concept of dropping the table. As far as Data Manipulation Language is concern we do query in it and we also learn about that how to retrieve records from existing table and we also came to know about how we can do operations like delete, update and view in oracle and sql(structure query language) is used to perform operations on the records stored in the database, such as updating records, inserting records, deleting records, creating and modifying database tables, views, etc.

Sql is not a database system, but it is a query language.

Suppose you want to perform the queries of sql language on the stored data in the database. You are require to install any database management system in your system. So its going to be most interesting for you.

So Learn Oracle Database And Make Your Bright Future.

Who this course is for:

All the computer science student and specially those student who wanted to build their career in information technology(IT) and software development.

Learn ORACLE-SQL database Online for Beginners

What you'll learn

Explore related topics

Course content

Introduction to oracle and its importance2 lectures • 11min

How to create user and datatype used in oracle5 lectures • 1hr 34min

Properties of table and how to create and execute table in oracle.3 lectures • 32min

DDL-Data Definition Language by mr. Amrit kumar19 lectures • 1hr 10min

DML-Data Manipulation Language by mr. Amrit kumar34 lectures • 1hr 19min

Requirements

Description

Who this course is for: