Database Programming with SQL

  • Start Date: March 2018
  • Duration: (06:00 PM - 9:00 PM)
  • Number of sessions: 10
  • Class Schedule: Sun, Tue, Thu
  • Total Hours: 20
  • Certificate: Yes

Fee: Tk. 10,000

Book your Seat

Hotline: +8801976 002 001, +88 02 9615991

info@cloudsolutionltd.com

ashim@cloudsolutionltd.com

  • Class:01

Introduction to:

  • Oracle Database
  • Relational Database Technology
  • Oracle Application Express
  • Anatomy of a SQL Statement
  • Class:02

Retrieving Data by SQL (Structured Query Language):

  • Query Commands

Data Change Commands:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • MARGE

Database Structure Change Commands:

  • DROP
  • RENAME
  • TRUNCATE
  • COMMENT
  • Class:03

SELECT and WHERE:

  • Columns, Characters, and Rows
  • Limit Rows Selected
  • Comparison Operators

WHERE, ORDER BY, and Using Functions:

  • Logical Comparisons and Precedence Rules
  • Sorting Rows
  • Using Functions on SQL
  • Class:04

Single Row Functions:

  • Case and Character Manipulation
  • Number Functions
  • Date Functions
  • Conversion Functions
  • NULL Functions
  • Conditional Expressions

JOINs:

  • Cross Joins and Natural Joins
  • Join Clauses
  • Inner versus Outer Joins
  • Self-Joins and Hierarchical Queries
  • Oracle Equijoin and Cartesian Product
  • Oracle Non-equijoins and Outer Joins
  • Class:05

Group Functions:

  • Group Functions
  • Oracle Non-equijoins and Outer Joins
  • Using GROUP BY and HAVING Clauses
  • Using Set Operators

Subqueries:

  • Fundamentals of Sub-queries
  • Single-Row Sub-queries
  • Multiple-Row Sub-queries
  • Correlated Sub-queries
  • Class:06

DML (Database Manipulating Language):

  • INSERT Statements
  • Updating Column Values and Deleting Rows
  • DEFAULT Values, MERGE, and Multi-Table Inserts

DDL (Database Definition Language):

  • Creating Tables
  • Using Data Types
  • Modifying a Table
  • Class:07

Constraints:

  • Intro to Constraints; NOT NULL and UNIQUE Constraints
  • PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
  • Managing Constraints

Views:

  • Creating Views
  • DML Operations and Views
  • Managing Views
  • Class:08

Sequences and Synonyms:

  • Working with Sequences
  • Indexes and Synonyms

Privileges and Regular Expressions:

  • Controlling User Access
  • Creating and Revoking Object Privileges
  • Regular Expressions
  • Class:09

DCL (Data Control Language):

  • Data Control by using

TCL (Transaction Control Language):

  • Database Transactions by using
  • Class:10

Final Exam & Review

  • Testing
  • Final Exam Review
profile

Ashim Kumar Sikder

CTO, Cloud Solution Ltd.

8 years working experience in Apex

Read More
profile

Md Zahidul Islam

Senior Software Developer

2 years working experience in Apex

Read More
  • Who can participate
  • Beginer can participate. Basic SQL, HTML skills are helpful, but not essential
  • Methodology
  • The training is fully hands on. Our strategy is making confidence by doing through hands on labs with real life example as well as power point presentation
  • Reference Oracle Training
  • Vendor Certification: After complete this training course you can attend Oracle Vendor exam
  • Tea-break and Lunch during the workshop

  • Certificate after course