Learn Complete SQL Programming

 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.