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.
© Copyright 2018