Book Online Tickets for 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). Tr

Learn Complete SQL Programming

 

  • Early Bird Offer

    Pay eary and Save Big

    Sale Date Ended

    INR 999
    Sold Out
  • Participation fees

    Sale Date Ended

    INR 6999
    Sold Out

Invite friends

Contact Us

Page Views : 43

About The Event

 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.

 

More Events From Same Organizer

Similar Category Events