SQL & PL\SQL Online Training by Veera Deepika (English / Tamil)

Description

For contact with a database, SQL is used. It is the basic language for relational database management systems, according to the ANSI (American National Standards Institute). SQL statements are used to carry out activities, such as modifying database data or extracting database data.

PL / SQL makes it possible to submit a whole block of statements at one time to the database. This decreases network load and provides the apps with high performance. PL / SQL provides programmers with high flexibility as it can scan, transform, and update information in a database.

Training Outcome
  • Course Complete Certificate


Requirements
  • Bachelor Degree in Computer Science

Lessons

  • 27 Lessons
  • 30:00:00 Hours
  • • Introduction to DBMS • SQL Overview01:00:00
  • • Data Types & Constraints in SQL • SQL Database01:00:00
  • • Data Definition Language (DDL) • Data Manipulation Language (DML)01:00:00
  • Data Transaction Language (DTL)01:00:00
  • • Data Control Language (DCL) • Data Query Language (DQL)01:00:00
  • • SQL Operators • Character Functions01:00:00
  • • Number Functions • General Functions01:00:00
  • • Conversion Functions • Date Functions01:00:00
  • Multiple Row/Aggregate Functions01:00:00
  • Group By, Order By & Having Clause01:00:00
  • Subqueries01:00:00
  • Joins & its types01:00:00
  • Union, Union All & Minus01:00:00
  • Normalization01:00:00
  • SQL Interview Questions01:00:00
  • PL/SQL Overview01:00:00
  • Conditional control01:00:00
  • Iterative processing with loops02:00:00
  • Select Into & Records01:00:00
  • Exception handlers01:00:00
  • Cursors01:00:00
  • Stored procedures and Functions02:00:00
  • Packages01:00:00
  • Triggers01:00:00
  • Index & Its types01:00:00
  • Views01:00:00
  • PL/SQL Collections02:00:00

About instructor

Instructor
Name : Course Monkey
Reviews : 2 Reviews
Student : 1 Students
Courses : 114 Courses

Reviews

0
Based on 0 Reviews
1 Stars
2 Stars
3 Stars
4 Stars
5 Stars