Home / SQL & PL SQL
Online sql Certification Course | pl sql Online Training
Categories : IT & Software
- Duration : 80 hours
- Lectures : 80
- Video : 80 hours
- Level : Beginner To Advanced
- Prerequisite : --
Learn at your own pace
Online courses that permit learningat one's own pace
Industry experts to train you
Get trained directly from the domain specific industry experts
Become fit for the industry
Course is designed in a manner to make you fit for the industry
In this course, trainees will study in detail about the design and the development of relational databases. This modular training programme will teach you the SQL commands integrated into functions, stored procedures, packages, functions, and triggers (PL/SQL Programming), for updating, retrieving, and displaying the data.
To make the trainees gain the knowledge of SQL & PL SQL design and development, and prepare them for the industry.
Module -1
[SQL]SQL Developer
- Introductory concepts of DBMS
- RDBMS concept
- Relational Database Design
- Normalization
- Entity-Relationship Model
- Introduction to SQL
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data with clauses
- Using Single-Row Functions to Customize Output
- Reporting Aggregated Data Using the Group Functions
- Date,NVL & string functions
- Displaying Data from Multiple Tables using Joins
- Using Subqueries to Solve Queries
- Set Operators
- Managing Schema Objects with DDL Command
- Manipulating Data with DML Command
- constraint
- Views
- Indexing
- Controlling User Access with DCL Command
- Retrieving Data Using nested Subqueries
Module -2
[PL-SQL] PL SQL Developer
- Introduction to PL/SQL
- -Declaring PLSQL Variable
- Interacting with Oracle Server
- Writing Control Structures
- looping
- Cursor
- Stored Procedures and Functions creation
- Package
- Manipulating Large Objects
- Creating Triggers
Exit Profile
- SQL Developer
- SQL Support Engineer
- PL-SQL Developer
- Syllabus designed in accordance to the industry needs.
- Trainees get hands-on practical training during this course
- With this course, feel free to learn SQL & PL SQL
- Working professionals can update their knowledge and skills by joining this course.
- The MNCs and MLCs from the industry that have collaborated with CRBtech exceeds 500.
- Training sessions based on availability of trainees and trainer
- Training that would help the students in their academic projects
- Here is a modular online programme where 24*7 co-ordinator support is provided.
- Doubts and queries of students will be cleared in the Q&A sessions scheduled at the end of each topic.
- Trainees are provided help for their academic projects in this course.
- We have collaborated with 500+ MNCs and MLCs from the industry, which would pave way for the trainees in making their career. Whether the trainee gets the job or not, depends solely on his performance.
- Course Completion Certificate with a PAN India level recognition.
Enquire Now
SQL & PL SQL students also learn
Before joining CRB, I was lacking in technical, so CRB trained me very well in technical and gave lots of placement calls. now I am confident about speaking and facing interview. Sumant Sir taught us aptitude skills really well. I liked his technique. All the trainers and placement guys co-operate with us. Thank you, CRB.
CRBtech is the best placement company. My domain was IT. Both technical and non-technical trainers are very good and cooperative. They also provide training in communication skills and personality development.
CRB Tech helped me out to learn Foreign language in German which helped me to explore opportunities in a Foreign country. Today I am placed successfully in a company. I am grateful to the trainers and placement team.
It was a good experience for me. The technical session really helped me to know about actual mechanical design. I really improved myself from CRB. Soft skill and German session taught me many new things. I attended Aptitude session for the first time from here. English session helped me to speak better English. Placement Department helped me to get my first job.
CRB Tech helped to improve my technical as well as soft skills. It helped me thought out the placement as well and I finally got placed in Inspeero Technologies. Thank You, CRB for all your support.
After joining CRB, I improved myself a lot. I found a good improvement in myself. All faculties are very friendly and they always inspired me to move forward. They taught very well. Firstly, I was feeling that I can’t crack the interview easily, before joining the CRB. But because of CRB, I overcame my fear of facing the interview.
Previous
Next
Top categories courses
LEARN AT YOUR PLACE !
Select a course of your choice !
Enquire and get to know more about it !
Enroll and get started with learning !
LEARN AT YOUR PLACE !
- Select a course of your choice !
- Enquire and get to know more about it !
- Enroll and get started with learning !
