Oracle SQL Fundamental Course

Training


Oracle Database 19c: SQL Fundamentals Course

The Oracle Database 19c: SQL Fundamentals course is designed to introduce students to Oracle Database 19c technology and the powerful SQL programming language. Throughout the course, participants will develop essential SQL skills that allow them to write queries against single and multiple tables and manipulate data effectively.

Course Highlights:
  • Retrieving Data Using the SQL SELECT Statement.
  • Restricting and Sorting Data.
  • Customizing Output with Single-Row Functions.
  • Utilizing Conversion Functions and Conditional Expressions.
  • Aggregating Data Using Group Functions.
  • Joining Data from Multiple Tables.
  • Solving Queries with Subqueries.
  • Employing Set Operators.
  • Managing Tables with DML Statements.

This course equips students with the practical skills necessary to harness the capabilities of Oracle Database 19c effectively. Join us to enhance your SQL proficiency!


Course Contents:

1. Introduction (12:34)
2. Retrieving Data with SELECT STATEMENT (15:21)
3. Restricting and sorting data (09:58)
4. Using Single row function to customize output (09:58)
5. Using conversion function and conditional expression (09:58)
6. Using group functions (09:58)
7. Joining tables (09:58)
8. Using subqueries (09:58)
9. Using Set operator (09:58)
10. Managing tables using DML Operation (09:58)
11. Introduction to Data defination langauge (09:58)
12. Introduction to Data dictionary views (09:58)
13. Creating sequence, synonyms and indexes (09:58)
14. Creating Views (09:58)
15. Managing schema objects (09:58)
16. Retrieving data using Subqueries (09:58)
17. Manupulating data using Subqueries (09:58)
18. Controlling user access (09:58)
19. Manipulating Data Using Advanced Queries (09:58)
20. Managing Data in Different Time Zones (09:58)