Logo PLOUG

 Plan pracy
Aktualności
Misja koła
Terminarz
Plan pracy
Foto
Ciekawe linki
Pliki do pobrania
Zawody SQL-owe



Poniżej tematyka spotkań Koła Naukowego Technologie Oracle
w roku akademickim 2011/2012:
 
Tematy główne oraz przykładowe zagadnienia szczegółowe:
Na zielono tematy "przerobione"

Intruduction to Oracle 11g RDBMS

Retrieving Data Using the SQL SELECT
     Basic SELECT Statement
     Arithmetic Expressions
     Null Value
     Using Column Aliases
     Duplicate Rows

Restricting and Sorting Data
   
Limiting Rows - using the WHERE
    Using Comparison Conditions
    Using theconditions: BETWEEN, IN, LIKE, NULL
    Using the operators: AND, OR, NOT
    Sorting by using the ORDER BY Clause

Using Single-Row Functions to Customize Output
    SQL Functions
    Character Functions
    Number Functions (ROUND, TRUNC, MOD)
    Date Functions
    Conversion Functions (TO_CHAR, TO_NUMBER, TO_DATE)
    NVL Function (NVL, NVL2, NULLIF, COALESCE)
    CASE Expression
    DECODE Function

Reporting Aggregated Data Using the Group Functions
    Group Functions (AVG, SUM, MIN, MAX, COUNT)
    Using the DISTINCT Keyword 4-9
    Group Functions and Null Values 4-10
    Creating Groups of Data: GROUP BY Clause Syntax 4
    Grouping by More Than One Column 4-
    Illegal Queries Using Group Functions 4
    Restricting Group Results with the HAVING

Displaying Data from Multiple Tables
    Types of Joins
    Joining Tables Using SQL2 and SQL3
    Creating Natural Joins
    Creating Joins with the USING Clause
    Using Table Aliases
    Creating Joins with the ON Clause
    Self-Joins Using the ON Clause
    Creating Three-Way Joins with the ON Clause
    Non-Equijoins
    Outer Joins
    INNER Versus OUTER Joins
    LEFT OUTER JOIN
    RIGHT OUTER JOIN
    FULL OUTER JOIN
    Cartesian Products
    Creating Cross Joins

Using Subqueries to Solve Queries
    Subquery Syntax
    Types of Subqueries
    Single-Row Subqueries
    Using Group Functions in a Subquery
    The HAVING Clause with Subqueries   
    Multiple-Row Subqueries
    Using the ANY, ALL Operator in Multiple-Row Subqueries
    Null Values in a Subquery

Using the Set Operators
    Set Operators (UNION, UNION ALL, INTERSECT, MINUS)

Manipulating Data
    Data Manipulation Language
    INSERT Statement Syntax
    Creating a Script
    Copying Rows from Another Table
    UPDATE Statement Syntax
    DELETE Statement
    TRUNCATE Statement
    Using a Subquery in an INSERT Statement
    Database Transactions
    Advantages of COMMIT and ROLLBACK Statements
    Controlling Transactions

Using DDL Statements to Create and Manage Tables
    Database Objects
    Naming Rules
    CREATE TABLE Statement
    Creating Tables
    Data Types
    Constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK)
    ALTER TABLE Statement

Creating Other Schema Objects
    Database Objects 
    Creating,
modifying and removing a View?
    CREATE SEQUENCE Statement: Syntax
    NEXTVAL and CURRVAL Pseudocolumns
    Using a Sequence 
    Creating an Index 
    Creating and Removing Synonyms

Controlling User Access

Privileges, Creating Users, System Privileges, Roles, Object Privileges

Manage Schema Objects

Altering table, Constraints

Manipulating Large Data Sets

Multitable INSERT StatementsPivoting INSERTMerging Rows 

Generating Reports by Grouping Related Data

GROUP BY with ROLLUP and CUBE OperatorsGROUPING [SET] Function

Managing Data in Different Time Zones

Time Zones, TIMESTAMP,INTERVAL Data Types

Retrieving Data Using Subqueries

Multiple-Column Subqueries, Scalar Subquery Expressions, Correlated Subqueries,

Using the EXISTS Operator, The WITH Clause

Hierarchical Retrieval

Natural Tree StructureHierarchical QueriesWalking the Tree

Regular Expression

Meta CharactersPerforming Basic SearchesRegular Expressions and Check Constraints