Oracle Complete Training Online

Learn oracle database and make your bright future

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.

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.

Overview

Section 1: Introduction

Lecture 1 INTRODUCTION TO ORACLE TOPICS

Lecture 2 ORACLE AND ITS IMPORTANCE BY MR. AMRIT KUMAR

Section 2: DDL-DATA DEFINITION LANGUAGE BY MR. AMRIT KUMAR

Lecture 3 HOW TO CREATE USER IN ORACLE BY MR. AMRIT KUMAR

Lecture 4 CHARACTER DATATYPE USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 5 NUMBER DATATYPE USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 6 DATE DATATYPE USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 7 LOB DATATYPE USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 8 PROPERTIES OF TABLE IN ORACLE BY MR. AMRIT KUMAR

Lecture 9 HOW TO CREATE TABLE IN ORACLE BY MR. AMRIT KUMAR

Lecture 10 HOW TO EXECUTE TABLE IN ORACLE BY MR. AMRIT KUMAR

Lecture 11 HOW TO APPLY PRIMARY KEY IN ORACLE BY MR. AMRIT KUMAR

Lecture 12 NULL/NOT NULL USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 13 OPERATORS USED IN ORACLE-IN/NOT IN OPERATOR BY MR. AMRIT KUMAR

Lecture 14 RELATIONAL AND LOGICAL OPERATOR USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 15 CONSTRAINT IN ORACLE BY MR. AMRIT KUMAR

Lecture 16 HOW TO APPLY FOREIGN KEY IN ORACLE BY MR. AMRIT KUMAR

Lecture 17 SOME QUESTION BASED ON BASIC OF ORACLE WITH SOLUTION BY MR. AMRIT KUMAR

Lecture 18 INSERT INTO COMMAND OF ORACLE BY MR. AMRIT KUMAR

Lecture 19 CREATING PRIMARY KEY ON TWO OR MORE FIELDS IN ORACLE BY MR. AMRIT KUMAR

Lecture 20 ALTER COMMAND OF ORACLE BY MR. AMRIT KUMAR

Lecture 21 ALTER COMMAND - TO ADD NEW COLUMN IN THE EXISTING TABLE

Lecture 22 ALTER COMMAND - TO ADD RESTRICTION IN THE EXISTING COLUMN

Lecture 23 ALTER COMMAND - TO MODIFY THE DATATYPE OF AN EXISTING TABLE

Lecture 24 ALTER COMMAND - TO CONVERT ONE DATATYPE INTO ANOTHER DATATYPE

Lecture 25 ALTER COMMAND - TO ENABLE/ DISABLE CONSTRAINT BY MR. AMRIT KUMAR

Lecture 26 ALTER COMMAND - TO ADD FOREIGN KEY CONSTRAINT IN ORACLE BY MR. AMRIT KUMAR

Lecture 27 ALTER COMMAND - TO DROP CONSTRAINT IN ORACLE BY MR. AMRIT KUMAR

Lecture 28 ALTER COMMAND - TO DROP COLUMN IN ORACLE BY MR. AMRIT KUMAR

Lecture 29 HOW TO DROP TABLE IN ORACLE BY MR. AMRIT KUMAR

Section 3: DML-DATA MANIPULATION LANGUAGE BY MR. AMRIT KUMAR

Lecture 30 QUERY IN ORACLE BY MR. AMRIT KUMAR

Lecture 31 HOW TO RETRIEVE RECORD FROM EXISTING TABLE BY MR. AMRIT KUMAR

Lecture 32 SOME QUERY OF ORACLE BY MR. AMRIT KUMAR

Lecture 33 LIBRARY FUNCTION IN ORACLE BY MR. AMRIT KUMAR

Lecture 34 SINGLE ROW FUNCTION IN ORACLE BY MR. AMRIT KUMAR

Lecture 35 ASCII(CHARACTER) FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 36 CHR(NUMBER) FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 37 CONCAT(TEXT1,TEXT2) FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 38 LOWER(STRING/COLUMN_NAME) FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 39 UPPER(STRING/COLUMN_NAME) FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 40 TO_NUMBER(TEXT) FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 41 TO_CHAR(NUMBER) FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 42 SYSDATE() FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 43 SUBSTR() FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 44 LENGTH() FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 45 HOW TO FIND TIME IN ORACLE BY MR. AMRIT KUMAR

Lecture 46 AGGREGATE FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 47 SUM() FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 48 AVG() FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 49 COUNT() FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 50 COUNT(*) FUNCTION USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 51 GROUP BY CLAUSE IN ORACLE BY MR. AMRIT KUMAR

Lecture 52 HAVING CLAUSE IN ORACLE BY MR. AMRIT KUMAR

Lecture 53 JOINING IN ORACLE BY MR. AMRIT KUMAR

Lecture 54 TYPES OF JOINING IN ORACLE BY MR. AMRIT KUMAR

Lecture 55 SELF JOINING USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 56 OUTER JOINING USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 57 NATURAL JOINING USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 58 EQUI JOINING USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 59 SUBQUERY USED IN ORACLE BY MR. AMRIT KUMAR

Lecture 60 DELETE IN ORACLE BY MR. AMRIT KUMAR

Lecture 61 UPDATE IN ORACLE BY MR. AMRIT KUMAR

Lecture 62 VIEW IN ORACLE BY MR. AMRIT KUMAR

Lecture 63 RETRIEVE VIEW IN ORACLE BY MR. AMRIT KUMAR

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