Oracle SQL Online Training

Best oracle online training

SQL BASICS:           

1. What is database?
2. Overview
3. Introduction to SQL
4. Advantages of SQL
5. RDBMS Concepts
6. Databases
7. Syntax
8. Data Types
9. Operators
10. Expressions
11. Create Database
12. Drop Database
13. Select Database
14. Create Table
15. Drop Table
16. Insert Query
17. Select Query
18. Where Clause
19. AND & OR Clauses
20. Update Query
21. Delete Query
22. Like Clause
23. Top Clause
24. Order By
25. Group By
26. Distinct Keyword
27. Sorting Results

Advanced SQL

1. Implementing Constraints
2. Complex SQL – Merge query
3. Complex SQL – Intersect
4. Complex SQL – Minus
5. Complex SQL – Using Joins
6. Complex SQL – Unions Clause
7. Complex SQL – Hierarchical queries
8. Complex SQL – Aggregate functions
9. Complex SQL – Super aggregate functions
10. NULL Values
11. Alias Syntax
12. creating Indexes
13. Alter Command
14. Truncate Table
15. Using Views
16. Having Clause
17. Transactions
18. Wildcards searches
19. Date Functions
20. Temporary Tables
21. Clone Tables
22. Sub Queries
23. Using Sequences
24. Handling Duplicates
25. Using Sequence
26. Select for Update