General
About CSC
Organisation

People
Process for CSC hosting
School Models
Role of Local Organisers
Other Roles

Participants
Past Schools

2004 2005 2006 2007 2008 2009 2010 2011

Diploma at CSC
Sport at CSC
Inverted CSCs

iCSC05 iCSC06 iCSC08 iCSC10 iCSC11

Special schools

School@chep06

Inverted School 2005

CSC 2005

CSC2005 Overview

Practical Information

Programme

Schedule

Lecturers

Participants

Organisers

 
Examination results
 
Grants from EU -FP6

Eligibility Conditions

Level of grant support

How to apply
CSC-Live
New  Lecture videos
New  Photo-Contest
New  Updated news
New  Social activities

CSC-Live

     

inverted CERN School of Computing 2005 23-25 February 2005, CERN

Programme Overview

Data Management and Data Bases

Advanced Software Development Engineering

Web Services
in Distributed Computing

Schedule

Lecturers

Lecturer Bios

Printable Version

SQL: basics and recent advances

   

Wednesday 23 February

 
11:30 12:25 Lecture 2 SQL: basics and recent advances Miguel Anjo

At the end of this lecture it is expected that the participants have heard about the main features available for interacting with a database. The base of the session is to look in detail at all the possibilities of database queries, with particular attention to advanced SELECT forms. Most of the session will be based on SQL92 standard and a small part on Oracle features.

1. DML basics: insert/update/delete


2. SELECT basics

  • '||', column pseudonyms, NVL

  • union, union all, intersect, minus

  • restricting: where, in, like, distinct, and/or, not, is [not] null, any, all

  • sorting: order by, asc/desc

  • aggregation: count, sum, max, avg, group by, having

  • joins: equijoins, outerjoins

  • charater manipulation functions: contat, length, lower, upper, ltrim, substr, ...

  • numeric functions: abs, ceil, floor, mod, power, round, sign, sqrt, trunc, ...

  • date functions: to_date, last_day, next_day, NLS_DATE_FORMAT, round, sysdate, trunc

  • convertion functions: to_char, to_date, to_number

  • other functions: decode, greatest, least, nvl, uid, user, vsize

3. Advanced SELECT

  • self joins

  • subqueries, inline views, rownum

  • correlated subqueries

4. Indexes b-tree


5. Transactions


6. Multi-dimensional aggregation
 

 

iCSC
All on iCSCs
News
Registration

Post-reg.

Handouts
Forum
Programme

Data Theme

Lecture1

Lecture2

Lecture3

Lecture4

Lecture5

All lectures

Soft Theme

Lecture1

Lecture2

Lecture3

Lecture4

Lecture5

Lecture6

All lectures

WS Theme

Lecture1

Lecture2

Lecture3

All lectures

Exercises New
FAQ
Social Events

 

Feedback: Computing (dot) School (at) cern (dot) ch
Last update: Thursday, 14. November 2013 11:48

Copyright CERN