Chandigarh Engineering College, Landran: CSE0610 Batch: 2009-04-12

Search This Blog

Friday, April 17, 2009

CSE 06-10 batch result uploaded directly!!

Friday, April 17, 2009
Here are the links to view the complete class result for CSE

Congrats Result is out!!

Result is published on ptu site.. WWW.PTU.AC.IN

Thursday, April 16, 2009

PTU Syllabus for B.Tech all branches

Thursday, April 16, 2009

IBS file limit problem solved

IBS file link reactivated...

HCL Infosystems Training

6 Months Training by HCL Infosystems
Deposit Amount Rs.100000/-
Marketing Training>> You will get back 7000/- per month
Development Training>>You will get back 5000/- per month
Minimum Requirements>> Throughout 60% and Above.

Seminar on Simulation

To be held in college on Saturday,18th April, 2009
at 10 AM to 1 PM
The list of eligible students lies with Anjul Hans.
All of you can check your names there.


Oracle Certification exam details

Duration: 120 minutes
Number of Questions: 52
Passing Score: 71%

Writing Basic SQL Select Statements
[ ] List the capabilities of SQL SELECT statements
[ ] Execute a basic SELECT statement
[ ] Differentiate between SQL statements and iSQL*Plus commands

Restricting and Sorting Data
[ ] Limit the rows retrieved by a query
[ ] Sort the rows retrieved by a query

Single-Row Functions
[ ] Describe various types of functions available in SQL
[ ] Use character, number, and date functions in SELECT statements
[ ] Use conversion functions

Displaying Data from Multiple Tables
[ ] Write SELECT statements to access data from more than one table using equality and nonequality joins
[ ] View data that generally does not meet a join condition by using outer joins
[ ] Join a table to itself using a self-join

Aggregating Data using Group Functions
[ ] Identify the available group functions
[ ] Use group functions
[ ] Group data using the GROUP BY clause
[ ] Include or exclude grouped rows by using the HAVING clause
[ ] Describe the types of problems that subqueries can solve
[ ] Define subqueries
[ ] List the types of subqueries
[ ] Write single-row and multiple-row subqueries

Producing Readable Output with iSQL*Plus
[ ] Produce queries that require a substitution variable
[ ] Produce more readable output
[ ] Create and execute script files

Manipulating Data
[ ] Describe each DML statement
[ ] Insert rows into a table
[ ] Update rows in a table
[ ] Delete rows from a table
[ ] Merge rows in a table
[ ] Control transactions

Creating and Managing Tables
[ ] Describe the main database objects
[ ] Create tables
[ ] Describe the datatypes that can be used when specifying column definition
[ ] Alter table definitions
[ ] Drop, rename and truncate tables

Including Constraints
[ ] Describe constraints
[ ] Create and maintain constraints

Creating Views
[ ] Describe a view
[ ] Create, alter the definition, and drop a view
[ ] Retrieve data through a view
[ ] Insert, update and delete data through a view

Creating Other Database Objects
[ ] Create, maintain and use sequences
[ ] Create and maintain indexes
[ ] Create private and public synonyms


Wednesday, April 15, 2009

Oracle Examination-Registered Students

Wednesday, April 15, 2009
Here is the list of registered students for oracle examination to be held on 25th April,2009
1.Garima Tokhi-CSE
3.Gagan Kalra-CSE
4.Jaspreet Kaur-CSE
5.Kanureet Kaur-CSE
7.Jaskiran Bhattal-CSE
8.Anjul Hans-CSE
9.Nandini Sharma-CSE
10.Megha Arora-IT

The test will be held in WebCom Technologies SCO-114-115 Sector 34, Chandigarh
It is near SSI in sector 34.
Test date is 25th April,2009 (Saturday)
Other details will be mailed/phoned to you all directly by Oracle India.


Tuesday, April 14, 2009

Oracle Module 1 test (update)

Tuesday, April 14, 2009
Forward dis msg 2all ur frnds...
Draft to be deposited tmrw morning(15/04/09)
Draft of Rs.3030/- in favour of Oracle India (P) Ltd.
payable at Bangalore
Other details needed>>
Name,Correspondence Address,City,PIN,EmailID,MobileNo,Res.Ph.No
Contact Anjul Hans  before 5PM today for any clarifications.

Sunday, April 12, 2009

MONDAY(13/04/09) declared as holiday

Sunday, April 12, 2009
Hello everyone.. Monday is declared as holiday in college..
and tuesday is working.. inform all ur friends about the same..
Chandigarh Engineering College, Landran CSE 0610
This blog is a part of CSE0610 information channel maintained by Anjul Hans
© 2009.