Scribd
Upload
7 views2 pages

Oracle SQL Basics and Joins Training

This document outlines a 2-day training course on Oracle DB and SQL, covering key concepts of RDBMS and SQL. Topics include SQL developer tools, SELECT statements, WHERE clause usage, various types of joins, subqueries, and DDL/DML operations. The course also addresses constraints and methods for updating and modifying table contents.

Uploaded by

Vanita Koushik
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

Oracle SQL Basics and Joins Training

This document outlines a 2-day training course on Oracle DB and SQL, covering key concepts of RDBMS and SQL. Topics include SQL developer tools, SELECT statements, WHERE clause usage, various types of joins, subqueries, and DDL/DML operations. The course also addresses constraints and methods for updating and modifying table contents.

Uploaded by

Vanita Koushik
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

3.

Oracle DB and SQL


Duration :2 Days

1. Introduction to RDBMS Concepts Introduction to SQL


The SQL developer
Restriction and projection
Retrieving Information from Tables
Performing Single Table SELECT Statements
Selecting All Columns from a Table
2. Using where clause
3. Operators with where clause
4. Comparison
5. Logical
6. Special
7. Like
8. Null
9. Using Column Aliases
10. Merging Column Output Using Concatenation
11. Displaying Distinct Rows
12. Sorting Rows Using the ORDER BY Clause
13. Using the Set Operators
14. Rules for Set operators
15. Using the UNION ALL / UNION / INTERSECT / MINUS Operator
16. [Link] to Joins
17. 22.2JOINS with SQL-99 Syntax
18. [Link] to Inner join,outerjoins(left,right,full)
19. Introduction to Non equijoin, Self Join,Cross Joins
20. Introduction to Natural,Using
21. Introduction to subqueries
22. Types of Subqueries
23. Writing Single Row Subqueries
24. Writing Multiple Row Subqueries
25. Using IN , ANY, ALL with a Multiple Row Subquery
26. Introduction to DDL,DML
27. Constraints
Notnull,Unique,Primary,foreign,Check
Drop /flashback
Truncate
Rename
28. Updating rows (using case,decode)
29. Removing Rows Using the DELETE Statement
30. Changing Table Contents (ALTER)
Add(New columns/constraints)
Modify(null to [Link],size)
Drop (columns/constraints)
Rename (columns/constraints)
Enable/Disable constraints

You might also like