Pay eary and Save Big
Sale Date Ended
Sale Date Ended
SQL PROGRAMMING COURSE DETAILS
Course Material: Textbook by the trainers & presentation material
Course Details: This course is designed to train and prepare you for Oracle Database SQL Certified Associate Certification (1Z0-071). Training will provide understanding of SQL language, data modelling and using SQL to create and manipulate tables in an Oracle Database.
Topics covered:
1. Introduction
2. Retrieving Data using the SQL SELECT Statement
3. Restricting and Sorting Data
4. Using Single-Row Functions to Customize Output
5. Using Conversion Functions and Conditional Expressions
6. Reporting Aggregated Data Using the Group Functions
7. Displaying Data from Multiple Tables Using Joins
8. Using Subqueries to Solve Queries
9. Set Operators
10. Managing Tables using DML statements
11. Introduction to Data Definition Language
12. Introduction to Data Dictionary Views
13. Creating Sequences, Synonyms, Indexes
14. Creating Views
15. Managing Schema Objects
16. Retrieving Data by Using Subqueries
17. Manipulating Data by Using Subqueries
18. Controlling User Access
19. Project Guidance
Duration - 1 month
Monday to Friday - 5:30pm to 7pm starting 18th Oct - 20 days
Trainer: Trainer has over 18 years of experience and is a author of the book on SQL Programming
Notes, lecture videos will be shared with the participants.