Learn Oracle

Where to start learning Oracle?

Step 1: Download Express Edition and SQL Developer.
http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

Step 2: Create Emp, Dept tables and insert seed data
https://livesql.oracle.com/apex/livesql/file/content_O5AEB2HE08PYEPTGCFLZU9YCV.html

Step 3: Understand each statement with the help of Oracle documentation and try.
https://sites.google.com/site/instantoracle/oracle-sql-queries-practice
Big Thanks to Mr. Srinivas Aithagani for providing extensive list of queries to practice.

Here we learn by example. How business statement looks, how we write query, learning with example…i.e cause and effect.

Step 4: Oracle Reference
http://docs.oracle.com/cd/E11882_01/index.htm

As backup, above content SQL Statements were downloaed and provied in the form of following files.
oracle_emp_dept_ddl
oracle_practice_dml

————————-

Types of JOINS
https://www.techonthenet.com/oracle/joins.php
https://docs.oracle.com/cd/B28359_01/server.111/b28286/queries006.htm#SQLRF52331

————————-

Database SQL Language Reference
https://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm

Oracle Data Types:
https://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements001.htm
https://www.techonthenet.com/oracle/datatypes.php

Oracle built-in functions / regular expressions
https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions001.htm

Normalization
http://www.studytonight.com/dbms/database-normalization.php

SQL Query Optimization:
https://docs.oracle.com/database/121/TGSQL/tgsql_optcncpt.htm
Also check “Explain Plan” option in SQL Developer

Table partitioning:
https://docs.oracle.com/cd/B28359_01/server.111/b32024/partition.htm
Examples: https://livesql.oracle.com/apex/livesql/file/content_EW51YHTOHS6IXN7QQ8AFD28O.html

Indexes
https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm

Stored Procedures / Functions
https://docs.oracle.com/cd/B28359_01/appdev.111/b28843/tdddg_procedures.htm

Database Performance Tuning:
https://docs.oracle.com/cd/B28359_01/server.111/b28274/toc.htm

Preventing SQL Injection / Attacks
https://docs.oracle.com/cd/E58500_01/pt854pbh1/eng/pt/tpcd/task_PreventingSQLInjection-0749b7.html#topofpage
http://www.dba-oracle.com/security/sql_injection_attacks.htm

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s