SQL AND PLSQL

Enroll Now
4 Review
Categories
BackEnd

Oracle Combo

An introduction to the design and creation of relational databases. Topics include storing, retrieving, Updating and displaying data using Structured Query Language (SQL) integrated into Stored Procedures, Functions, Packages and Triggers (PL/SQL Programming).

Overview

  • Lectures 20
  • Test 2
  • Duration 80 hours
  • Skill level Beginner
  • Assessments Yes
Course Description

This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organization.

Prerequisite

Previous experience with at least one programming language

Learning Outcomes
  • Enhance the knowledge and understanding of Database analysis and design.
  • Enhance the knowledge of the processes of Database Development and Administration using SQL and PL/SQL.
  • Enhance Programming and Software Engineering skills and techniques using SQL and PL/SQL.
  • Preparation of background materials and documentation needed for Technical Support using SQL and PL/SQL.
  • Use the PL/SQL code constructs of IF-THEN-ELSE and LOOP types as well as syntax and command functions.
  • Solve Database problems using Oracle 9i SQL and PL/SQL. This will include the use of Procedures, Functions, Packages, and Triggers.

Curriculum

  • First Module
    • Session 1.Oracle SQL
      40 HRS
  • Second Module
    • Session 1.PL SQL
      40 HRS

Student FeedBack

Aashish Manchekar
Student

Due to pandemic I lost my job so I decided to switch My career Non-IT to IT Sector. I join impetus Consultrainer for π—¦π—€π—Ÿ π——π—²π˜ƒπ—²π—Ήπ—Όπ—½π—²π—Ώ course. They really know how to motivate student and how to made information so easy to understand. All the faculty are very much qualified and really helpful in providing assistance in every aspect. Every week they give assignment for the practice. They also provide placement. I got placed in NUCSOFT Mumbai with the help of Impetus consultrainer. This is best institute for freshers and also experience student. Special Thanks to Seema Mam, Bhavna Mam & Supriya Mam for developing and motivate me.

Vivek Shrivastava
Student

I am very glad to appreciate Impetus Consultrainers for excellent training Course Material & knowledge provided me to move ahead in PL/SQL world. I am very much satisfied with the management, Trainer, Practical & lab provided to built my confidence 100%. Special thanks to Poonam Sawant & Narendra Sir for their attention provided to achieve my GOAL. Employee like them makes student happy and company on top of the everything. My good wishes with the Impetus Consultrainers & Thanks a lot !!! Regard, Vivek Kumar Shrivastyava