Tuesday, January 17, 2017
bsdi facebook  bsdi twitter  bsdi linkedin  bsdi youtube bsdi google plus

moto

Daffodil Education Network

Admission Going On for the session 2016-17 in Diploma in Computer, Electrical, Civil, Textile, Garments Design & Pattern Making & Medical Technology, Dental,Pathology, Pharmacy

Database Design & Development

Preface about the Workshop: Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This course is  first step towards success as an Oracle professional.Learn concepts of relational databases, to create database structures and to store, retrieve, and manipulate data. Here  learn to query using Basic SQL Statements, restrict, sort, perform single row functions and group the queried data.Write advanced SELECT statements and use advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Query multiple tables, perform nested queries, implement constraints, use date and time functions, and create sequences and views.Learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output. Demonstrations and hands-on practice reinforce the fundamental concepts. The SQL Workshop will enhance your learning experience of SQL

Benefit of Jobsbd Learning Certificate course:

Recognized Certificate: Your certificate will be recognized by Oracal academy.
Access to E-Library: After attending the workshop you will be given a limited time access to Daffodil International University E-library to browse relevant books for free.
Online Access to workshop Resource: You will also be given a login id for Jobsbd learning to access online resource particular to the workshop.
Online Tracking: Your participation or certificates can be tracked by the employers through the tracking ID provided with your certificate. 
Online Testing Center: Our education partner Daffodil International University is affiliated testing centre of VUE and Prometric.

Target Group(Who Should Attend?):

 

  • Graduates with an interest in application Programming, Oracle Technology.
  • Adult learners with technical backgrounds, Software Developers.

 Eligibility:

  • Basic understanding of Computer Operating System

Delivery Method:

  • Linear Demonstration - 50%
  • Case and Practice Exercise - 50%F

 

·     Interactive Lecture

·     Power Point Presentation

·     Case Study

·     Group Work

·     handout etc

Key Topics (The major contents of the sessions):
1st Session: 
Writing a Basic SQL Statement

·     Describing the SQL Select Capabilities

·     Executing a Basic Select Statement with the Mandatory Clauses

·     Differentiating Between SQL and iSQL*Plus Commands

Restricting and Sorting Data

·     Limiting the Rows Retrieved by a Query

·     Sorting the Rows Retrieved by a Query

 

2nd Session:

Single Row Functions

·     Describing Various Types of Functions Available in SQL

·     Using a Variety of Character, Number, and Date Functions in SELECT Statements

·     Explaining What the Conversion Functions Are and How They Are Used

·     Using Control Statements

Displaying Data from Multiple Tables

·     Writing SELECT Statements to Access Data from More Than One Table

·     Describing the Cartesian Product

·     Describing and Using the Different Types of Joins

·     Writing Joins Using the Tips Provided

3rd Session:
Aggregating Data by Using Group Functions

·     Identifying the Different Group Functions Available

·     Explaining the Use of Group Functions

·     Grouping Data by Using the GROUP BY Clause

Writing Subqueries

·     Describing the Types of Problems That Subqueries Can Solve

·     Describing Subqueries

·     Listing the Types of Subqueries

·     Writing Single-Row and Multi-Row Subqueries

·     Describing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved

4th Session:
Producing Readable Output with iSQL*Plus

·     Producing Queries That Require an Input Variable

·     Customizing the iSQL*Plus Environment

·     Producing More Readable Output

·     Creating and Executing Script Files

5th Session:
Manipulating Data

·     Describing Each Data Manipulation Language (DML) Command

·     Inserting Rows into a Table

·     Updating Rows in a Table

·     Deleting Rows from a Table

·     Merging Rows into a Table

·     Controlling Transactions

$1·     Describing Transaction Processing

$1·     Describing Read Consistency and Implicit and Explicit Locking

6th Session:
Creating and Managing Tables

·     Describing the Main Database Objects

·     Creating Tables

·     Describing the Oracle Data Types

·     Altering Table Definitions

·     Dropping, Renaming, and Truncating Tables

Including Constraints

·     Describing Constraints

·     Creating and Maintaining Constraints

 7th Session:

Creating Views

$1·     Describing Views and Their Uses

$1·     Creating a View

$1·     Retrieving Data by Means of a View

$1·     Inserting, Updating, and Deleting Data Through Views

$1·     Dropping Views

$1·     Altering the Definition of a View

$1·     Inline Views

$1·     Top 'N' Analysis

Other Database Objects

$1·     Creating, Maintaining, and Using Sequences

$1·     Creating and Maintaining Indexes

$1·     Creating Private and Public Synonyms

$1·    

8th Session:
Controlling User Access

$1·     Understanding the Concepts of Users, Roles, and Privileges

$1·     Granting and Revoking Object Privileges

$1·     Creating Roles and Granting Privileges to Roles

$1·     Creating Synonyms for Ease of Table Access

Using Set Operators

$1·     Describing the Set Operators

$1·     Obeying the Set Operators Rules and Guidelines

$1·     Using a Set Operator to Combine Multiple Queries into a Single Subquery

$1·     Controlling the Order of Rows Returned

9th Session:
Oracle 10g Datetime Functions

$1·     Using DATETIME Functions

$1·     Using the NVL2 Function to Handle NULL Values

Enhancements to the GROUP BY Clause

$1·     Using ROLLUP as an Extension to the GROUP BY Clause to Produce Subtotal Values

$1·     Using CUBE as an Extension to the GROUP BY Clause to Produce Cross-Tabulation Values

$1·     Using the GROUPING Function to Identify the Row Values Created by ROLLUP or CUBE Operators

$1·     Using GROUPING SETS to Produce a Single Result Set That Is Equivalent to a UNION ALL Approach

$1·     Using the WITH Clause

10th Session:
Advanced Subqueries

$1·     Multiple-Column Subqueries

$1·     Writing a Subquery in the FROM Clause

$1·     Writing and describing Correlated Subquery

$1·     Using EXISTS and NOT EXISTS Operators

$1·     Updating and Deleting Rows Using Correlated Subqueries

$1·     Using Scalar Subqueries in SQL

11th Session:
Hierarchical Retrieval

$1·     Discussing the Benefits of the Hierarchical Query

$1·     Ordering the Rows Retrieved by a Query in a Hierarchical Manner

$1·     Formatting Hierarchical Data so That It Is Easy to Read

$1·     Excluding Branches from the Tree Structure

12th Session:
Oracle10g Extensions to DML and DDL Statements

$1·     Discussing Multitable Inserts

$1·     Creating and Using External Tables

$1·     Naming the Index and Using the CREATE INDEX Command at the Time of Creating Primary Key Constraint

 

13th Session:
SQL Workshop

$1·      Applying Techniques Learned in This Course

$1·     Practical Project

Question and answer

Facilities:

- State-of-art lab facilities

- Access to online resources

Fees