Learn SQL (Oracle or MS-SQL or MySQL) - Classroom and Live Online
About the Event
Due to increasing demand, we run this program every two months or as per registrations. Contact us for custom event.
Details:
This is a program to teach you Oracle SQL in 24 hours -
- Have you been wondering about what is SQL?
- Were you hesitant to ask someone?
- Are you looking for an IT Professional to teach you SQL?
If you are seeking genuine learning and not brand value then read on ...
Palium is pleased to bring you the option to learn SQL over 2 weekends. The classes will cover practical hands-on so that you can learn it the right way.
The course curriculum covers all aspects of how to write and use commands in SQL. It will also cover the areas that are different in MS SQL and T SQL to ensure you get a holistic learning. The focus will be on Oracle SQL.
Target Audience:
1. Developers intending to work in Oracle technical area
2. Project Managers
3. Technical Architects
4. College graduates from any background wishing to move to IT
The course outline covers -
• Introduction to Oracle SQL
• Basics of RDBMS
• Using SQL commands
• Manipulating and sorting data
• Using single row sub-function
• Using group functions
• Working with data from multiple tables
• Using subqueries and set operators
• Data Manipulation (DML) commands
• Data definition (DDL) commands
• Working with other objects – Views, Synonyms etc
• Managing Objects with Data Dictionary Views
• Controlling User Access
• Manage Schema Objects
• Manipulating Large Data Sets
• Generating Reports by Grouping Related Data
• Managing Data in Different Time Zones
• Retrieving Data Using Subqueries
• Hierarchical Retrieval of data
• Regular Expression Report
What you will get:
1) Hands-on practice of concepts discussed in class
2) Participation certificate from Oracle
3) Courseware from Oracle
4) Option to appear for Oracle Certification exam
About the Trainer:
The trainer is a IT Professional with vast experience of working in the area of Oracle database administration with large mnc company.
Duration: 24hrs
Venue: Salt Lake
Price: Rs. 5,750/
(Extra fees payable for Oracle certificate and courseware)
Contact Barindra @ 91- 90510 92035