Work force development program

Oracle WDP Program:

  • Receive free Oracle software licenses and support for students and faculty ,having cost near about 5 Crore.
  • 50% discount on training products from Oracle including instructor-led training (ILTs), Live Virtual Class (LVC), Training on Demand (TOD) and Self Study CD ROMs (SSCDs) and Training on Demand (TOD).
  • By using the curriculum developed by Oracle institute prepare a new generation of knowledgeable IT specialists.
  • 25% discount on Oracle certification exams:
    • Instructors, students and technical support staff from WDP member departments are eligible to obtain the 25% discount.
  • 50% discount on Self Test Software:
    • A unique partnership making available high quality practice tests to WDP members seeking Oracle certification status.

Objectives :-

  • To provide students the knowledge of various database systems ,java technology ,primavera, embedded java that student will use to complete the software project & solve industry problem.
  • Student would get an opportunity to do global certification on recent technology which certified the skills in particular technology.

Outcomes Excepted

  • Enhance the technical skills related to recent trends in software industry.
  • Global certification in particular domain.
  • Develop a system to meet desired needs of economic, environmental, social, ethical, health.

Softwares Provied Under Oracle WDP

Sr. No.DepartmentName of Software
1Computer Science & EnggOracle database 12C
2Oracle database 11g
3Oracle NoSql Database
4Oracle Big Data
5Oracle Mobile application Framework
6Oracle Solaris 10 OS
7R12 Oracle eBusiness
8Oracle Linux 7
9Oracle SOA Suite 11g
10Oracle BI 11g
11R12 .x Oracle Inventory Management
12JDK Open Source
13Civil & Mech. EnggPrimavera P6
14Primavera Contract Management
15Primevera Portfolio Management
16Electronics EnggJava ME Embedded

Oracle WDP Co-ordinator 

DSC_6182

 

Name- Mr. Navnath P. Jadhav

Designation- Assistant Professor

Qualification- M.TECH(CSE)

Department- Computer Science & Engineering

Designed Syllabus for Database & Java Course

Database

Introduction

  • Describe the features of Oracle Database 12c
  • Describe the salient features of Oracle Cloud 12c
  • Explain the theoretical and physical aspects of a relational database
  • Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)

Retrieving Data using the SQL SELECT Statement

  • Explain the capabilities of SQL SELECT statements
  • Execute a basic SELECT statement

Restricting and Sorting Data

  • Limit the rows that are retrieved by a query
  • Sort the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime

Using Single-Row Functions to Customize Output

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

  • Describe various types of conversion functions that are available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply conditional expressions in a SELECT statement

Reporting Aggregated Data Using the Group Functions

  • Identify the available group functions
  • Describe the use of group functions
  • Group data by using the GROUP BY clause
  • Include or exclude grouped rows by using the HAVING clause

Displaying Data From Multiple Tables Using Joins

  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins
  • Join a table to itself by using a self-join
  • View data that generally does not meet a join condition by using OUTER joins
  • Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries

  • Define subqueries
  • Describe the types of problems that the subqueries can solve
  • Describe the types of subqueries
  • Write single-row and multiple-row subqueries
  • Using the SET Operators
  • Describe set operators
  • Use a set operator to combine multiple queries into a single query
  • Control the order of rows returned

Managing Tables using DML statements

  • Truncate data
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Control transactions

Introduction to Data Definition Language

  • Categorize the main database objects
  • Explain the table structure
  • Describe the data types that are available for columns
  • Create a simple table
  • Explain how constraints are created at the time of table creation
  • Describe how schema objects work

 

Java

Java Basics 

  • Define the scope of variables 
  • Define the structure of a Java class
  • Create executable Java applications with a main method; run a Java program from the command line; including console output.
  • Import other Java packages to make them accessible in your code
  • Compare and contrast the features and components of Java such as: platform independence, object orientation, encapsulation, etc.

Working With Java Data Types 

  • Declare and initialize variables (including casting of primitive data types)
  • Differentiate between object reference variables and primitive variables
  • Know how to read or write to object fields
  • Explain an Object's Lifecycle (creation, "dereference by reassignment" and garbage collection)
  • Develop code that uses wrapper classes such as Boolean, Double, and Integer.  

Using Operators and Decision Constructs 

  • Use Java operators; including parentheses to override operator precedence
  • Test equality between Strings and other objects using == and equals ()
  • Create if and if/else and ternary constructs 
  • Use a switch statement 

Creating and Using Arrays 

  • Declare, instantiate, initialize and use a one-dimensional array
  • Declare, instantiate, initialize and use multi-dimensional array

Using Loop Constructs 

  • Create and use while loops
  • Create and use for loops including the enhanced for loop
  • Create and use do/while loops
  • Compare loop constructs
  • Use break and continue  

Working with Methods and Encapsulation 

  • Create methods with arguments and return values; including overloaded methods
  • Apply the static keyword  to methods and fields  
  • Create and overload constructors; including impact on default constructors
  • Apply access modifiers
  • Apply encapsulation principles to a class
  • Determine the effect upon object references and primitive values when they are passed  into methods that change the values

Working with Inheritance 

  • Describe inheritance and its benefits
  • Develop code that demonstrates the use of polymorphism; including overriding and object type versus reference type
  • Determine when casting is necessary
  • Use super and this to access objects and constructors
  • Use abstract classes and interfaces

Handling Exceptions 

  • Differentiate among checked exceptions, unchecked exceptions, and Errors
  • Create a try-catch block and determine how exceptions alter normal program flow
  • Describe the advantages of Exception handling 
  • Create and invoke a method that throws an exception
  • "Recognize common exception classes (such as NullPointerException, ArithmeticExcpetion, ArrayIndexOutOfBoundsException, ClassCastException)"

Working with Selected classes from the Java API 

  • Manipulate data using the StringBuilder class and its methods
  • Creating and manipulating Strings
  • Create and manipulate calendar data using classes from java.time.LocalDateTime,  java.time.LocalDate, java.time.LocalTime, java.time.format.DateTimeFormatter, java.time.Period 
  • Declare and use an ArrayList of a given type 
  • Write a simple Lambda expression that consumes a Lambda Predicate expression
  • Conducted Retake test on “Oracle Database 12c:SQL fundamental”
  •  Conducted retake Certification exam on “Oracle Database 12c:SQL fundamental” on 09th September 2016

Appeared students :27

 Result of Global Certification Exam

  • 12 students global certified by “Oracle Database 12c:SQL fundamentals” out of 6 students got above 90%

No.Name of StudentScore
1Hupare Priti 95%
2 Hogade Hrishikesh93%
3 Patil Abhinandan 91%
4Gajare Pallavi91%
5Kore Maheshwari 91%
6Banne Poonam90%
7Rukaiya Jamadar88%
8Kulkarni Omkar 85%
9Kore Banshankari 85%
10 Jeswani Komal 81%
11Shah Vinit 66%
12Shewale Jyoti 65%

© 2017 Sharad Institute of Technology, College of Engineering All rights reserved.