GitHub for Learners
Oracle Database: Introduction to SQL
Associated Exam :
1Z0-071
1Z0-061
1

Constraints

View Video
2

Oracle SQL Commands

View Video
1

Practical Examples.

Download
2

Example of To_date function.

Download
3

Joins : - fetching data from one or more than one table is called join. Detail description with practical defined in attache file.

Download
4

Sub-query : - sub-query is called nesting query.Inner query execute first and than outer query. Detail description defined in the attached file.

Download
5

A rule that restricts the values in a database.

View Video
6

Practical Example for first two chapter in SQL book.

Download
7

Restricting and Sorting Data In Oracle.

Download
8

Functions in SQL

Download
9

Some Additional Functions in SQL.

Download
10

Group Functions

Download
11

Joins : - Examples of joins defined in attached file.

Download
12

Example of Sub queries defined in the attached file.

Download
13

Set Operator Example

Download
14

DML Transactions

Download
15

Creation of Sequence,synonyms and indexes.

Download
16

Creation of Views..

Download
17

Managing Constrains..

Download
18

Manipulating Data Items Using Sub query.

Download
19

Creating and Managing User and Roles.

Download
20

Multi-Table Insert Example..

Download
21

SQL for Data Warehousing and Analytics: What’s New in Oracle Database 12c Release 2

Download
22

This article makes an introduction to the key built-in datatypes in Oracle database.

23

Columnn Invisible and Visible ================================ SQL> create table tbl(empno number,ename varchar2(10),deptno number invisible); Table created. SQL> set line 100 SQL> desc tbl Name Null? Type ----------------------------------------------------- -------- ------------------------------------ EMPNO NUMBER ENAME VARCHAR2(10) SQL> set colinvisible on SQL> SQL> desc tbl Name Null? Type ----------------------------------------------------- -------- ------------------------------------ EMPNO NUMBER ENAME VARCHAR2(10) DEPTNO (INVISIBLE) NUMBER SQL> alter table tbl 2 modify deptno visible; Table altered. SQL> desc tbl Name Null? Type ----------------------------------------------------- -------- ------------------------------------ EMPNO NUMBER ENAME VARCHAR2(10) DEPTNO NUMBER CREATE TABLE t_id_col (empno NUMBER GENERATED AS IDENTITY,ename VARCHAR2(20)) insert into t_id_col(empno,ename)values(null,'A') [will return error] SELECT column_name, data_default, user_generated, identity_column FROM user_tab_cols WHERE table_name='T' create table t1(empno number generated by default on null as identity,ename varchar2(10)); insert into t_id_col(empno,ename)values(null,'A') [will not return error]

1

Practicals

Download
1

Using Joins

View Video
1

Constraint in Oracle SQL

View Link
2

Creating Joins in Oracle SQL

View Link