Skip to main content

Learn SQL From Scratch to Advanced topics

Learn SQL from Scratch to Advanced 

Nowadays, many IT company moreover depend on SQL  only. So this is one of the basic query language to start for new developers.

So track or to be master in SQL, the below topics should be covered.

List of Basic Topics :-

1, Should know what is frontend and backend developer 

2, What is DBMS, RDBMS ?

3, What is SQL ?

4, What are the database are there ?

Beginner Level SQL topics 

This are some beginner level SQL topics, if you are new to SQL this are the topics that should be covered first.

1, Oracle Basics 

2, List of Objects in SQL 

3, Clause and its usage 

4, Functions 

5, Sub Query 

6, Joins 

7, Decode and Case

8, Constraints

9, Important Data Dictionary Table like user_source, all_source, user_tables etc..,

Intermediate Level SQL topics (Creating Objects) 

When we are entering into objects this below topics should be covered. In 
this topics that we are creating database objects like tables, views, sequences, synonyms etc.

1, Data Definition Language 

2, Data Manipulation Language 

3, Transactional Control Language 

4, Data Control Language 

5, Data Retrieval 

6, Sequence

7, Materialized views 

8, Views 

9, Synonyms 

10, Index

11, Hints

12, Multi table Insert

Advanced Level SQL topics 

If you are mastered in the above two set means, this will be easy to complete. After completing advanced level topics its easy to crack the oracle certification too.

1, Analytical Functions

2, With clause

3, Set Operators

4, Pseudo columns

5, SQLLDR

6, Regular Expression

7, CUBE and ROLLUP

8, Dead Lock and Table Lock

9, Table Partition

10, Data Pump

11, Global Temporary Table

12, Normalization and De-normalization

13, Performance Tuning

14, External Table.

Labels:

Comments

Post a Comment

Thanks for commenting, we will always respond your comment.

Popular posts from this blog

Oracle SQL Interview Questions Series 1 [Basic]

Oracle SQL Interview Questions Series - 1 Oracle SQL Interview Questions covered in Eduflee, so complete all the series to get placed into the IT company. At present Structured Query Language is very important to enter into the Software company. After completing all the Interview series, you can crack many interviews with 100% assurance from my experience. Basic Questions for SQL interview Schema => User Records => Rows Fields => Columns Result set => Output 1, What are the Schema Objects in Oracle SQL ?     Table, View, Materialized view, Sequence, Synonyms, Index are the schema objects in SQL.     Table => Basic Unit of Storage [Rows and Columns]     View => Logical Representation of subject of records, It does not contains any data. So here data is logical.     Materialized View =>   It contains the data, it is also called as Snapshot. It contains data physically.     Sequence => It is a Numeric Value Generator     Synonyms => used to provide alternate nam
Post a Comment
Read more

Class 3 Functions in Oracle SQL

Functions in Oracle SQL Functions is one of the important features in Oracle SQL, with the help of this functions we can able to get the result as per our requirement. Functions in Oracle SQL contains Single Row Functions, Multiple Row Functions. Mainly those functions are used to returns value based on the input that which we given. And practicing this functions in oracle SQL, one can able to master in query writing. Functions is used to perform some actions like doing any calculations, grouping the data, conversion in type, date conversion etc. Types of Functions in Oracle SQL Functions in oracle is classified on the basis of the input which we are giving and getting the output, and they are: - Single Row Functions - Multiple Row Functions Single Row Functions in Oracle SQL Single Row Functions works on the single rows which will shows the result for that single rows only. If "n" number of inputs to give "n" number of outputs. From the above figure explains about
Post a Comment
Read more