1. technology and computing
2. software
3. databases

DATABASE DESIGN USING SQL PROGRAMMING
ORGANIZING COMMITTEE
Patron:
REGISTRATION FORM:
Prof. (Dr.) M. S. Gujral
Principal
Name: _______________________________________
Designation: ________________________________
CCET (Deg. Wing), Chandigarh
Convenor:
Dr. Sunil K. Singh
Department: ________________________________
Professor & Head, CSE Dept.
Name of the institution: _____________________
______________________________________________
Co-coordinator:
Ms. Neetu Sharma
Asstt. Prof., CSE Dept.
Address: ____________________________________
City: ________________________________________
District: _____________________________________
State: _______________________________________
PIN code: ___________________________________
E-mail : _____________________________________
FACULTY DEVELOPMENT
PROGRAMME
Organizers:
Dr. R.B. Patel
Professor, CSE Dept.
ON
DATABASE DESIGN
USING SQL
PROGRAMMING
(04-05-2015 TO 08-05-2015)
Ms. Jaspreet Kaur
Asstt. Prof., CSE Dept.
Mr. Ashish Kalia
Asstt. Prof., CSE Dept.
Organized by
Contact No.: ________________________________
Ms. Madhavi Arora
Asstt. Prof., CSE Dept.
SPONSORING AUTHORITY:
Mr./Ms./Dr. ________________________________ is an
employee /research scholar of our institution/organization.
He/She will be permitted to attend the workshop , if
selected.
Place:
Date:
Sign with Seal
Head of the Institution
Mail the scan registration format at the given below email
id and submit the original registration form at the time of
FDP; if invited for participation.
Email ID : [email protected]
Ms. Jagreet Kaur
Asstt. Prof., CSE Dept.
Ms. Bikramjit Kaur
Asstt. Prof., CSE Dept.
Ms. Seema Bansal
Asstt. Prof., CSE Dept.
Ms. Sheetal Dabra
Asstt. Prof., CSE Dept.
Technical Assistance:
Mr. Mayank Arora
Programmer, CSE Dept.
Ms. Shaveta Goyal
Programmer, CSE Dept.
Mr. Harmeet Singh
Lab. Technician, CSE Dept.
DEPARTMENT OF
COMPUTER SCIENCE AND ENGINEERING
CHANDIGARH COLLEGE OF ENGINEERING
AND TECHNOLOGY (DEGREE WING)
Government Institute under Chandigarh (UT) Administration,
Affiliated to Panjab University , Chandigarh
Sector-26, Chandigarh. PIN-160019
0172-2750947, 2750943
Visit at: www.ccet.ac.in
ABOUT CCET (Degree Wing):
Chandigarh College of Engineering and Technology (CCET)
Degree Wing, Chandigarh, is an government institute under UT
Administration, Chandigarh, was established in 2002. CCET
(Degree Wing) has the reputation of being one of the premier
engineering college for imparting quality education in
Engineering & Technology which is located in the city beautiful
sector -26, Chandigarh. CCET (Degree Wing), Chandigarh, is
affiliated to Panjab University (PU), Sector 14, Chandigarh and
approved by the All India Council for Technical Education
(AICTE), Ministry of HRD, Government, of India, New Delhi.
CCET is well known for its huge infrastructure and state of
the art facilities. It is also known as Green Campus because it
has a unique environment friendly & energy efficient building
with fabulous architecture, lush verdant woods and landscape
gardens that provide an idyllic academic environment to our
students. CCET offers B.E. (Bachelor of Engineering) courses in
four streams i.e. Electronics and Communication Engineering,
Computer Science and Engineering, Mechanical Engineering,
Civil Engineering.
ABOUT THE DEPARTMENT:
Ever since its inception, The Department of Computer Sc. &
Engineering has been trying to meet the computing need of
various technologies and offering specially designed courses for
their students. Computer sc & engineering (CSE) is one of the
fastest-growing fields, and a number of studies show that
computer engineers are among the highest earners in the globe.
The various programs offered in the Computer Sc. &
Engineering department are well organized to provide a wide
spectrum of choices to the students are B.E., M.E.(In process to
start) and Ph.D. The basic objective of CSE department to
provide a competitive environment that will prepare the students
for success in designing, developing and innovation of various
technologies.
PROGRAMME OBJECTIVE:
This course engages faculty to analyze complex business
scenarios and create a data model—a conceptual representation
of an organization’s information. Participants implement their
database design by creating a physical database using SQL.
Basic SQL syntax and the rules for constructing valid SQL
statements are reviewed. This course culminates with a project
that challenges students to design, implement, and demonstrate a
database solution for a business or organization.
TARGET AUDIENCES:
 College/university faculty who teach computer science,
information technology, or a related subject.
 Familiarity with Database concepts.
AGENDA:
Teachers will attend a 5 day training which will cover topics of
Database Design and Programming with SQL. The curriculum
and resources are available online and the SQL commands will
be practiced on the online environment called Application
Express. The teachers will complete a group project on Data
Modeling and on successful completion of the course project,
they will become certified “Oracle Academy Instructor”,
which means they can then take this course back to their
students.
PROGRAMME SPEAKERS & TIMINGS:
Oracle, India & 9:00 a.m. to 5:00 p.m.
PROGRAMME HIGHLIGHTS:

SELECT Statements and Relational Database
Technology

Using the WHERE Clause

Restricting Rows and Introduction to Functions

Using Character, Number, and Date Functions

Using Single Row Functions

Executing Database Joins

Creating Subqueries

Using Complex SQL with Aggregated Data

Working with Group Functions

Constructing DML Statements

Working with DDL Statements

Ensuring Quality Query Results

Creating and Managing Views

Working with Sequences

Fundamentals of Database Security

Understanding Database Transactions

Oracle Proprietary Join Syntax

Project

Ensuring Quality Query Results – Advanced
Techniques

Introduction
IMPORTANT DATE:

What is Data Modeling?
Last Date of Receipt of Application: 7

th
Entity Relationship Diagramming
Applicant Selection Intimation

Supertypes, Subtypes, and Business Rules
FDP Date

Working with Entity Relationships

Unique Identifiers and Normalization

Arcs, Hierarchies, and Historical Data

ERD Project Presentation

Drawing Conventions and Generic Modeling

Transforming From Conceptual Model to Physical
Model

Introduction to SQL

Project

Presentation
April 2015
th
: 13 April 2015
: 4th - 8th May 2015
ACCOMODATION:
Accommodation will be arranged by the participants
themselves.
REGISTRATION FEES:
FDP is fully sponsored by Oracle and Chandigarh College of
Engineering and Technology (Degree Wing). Therefore, there is
no registration fee. Lunch and breakfast Included. Certificate of
Oracle Academy Instructor would be provided by the Oracle
and for, CCET (Deg. Wing) would be provide the certification of
participation.