OCP license.E01.130624

OCP license

---

class : .00 - .45

SQL Fundamental l

SQL Fundamental ll -> additional practices(x)

administration workshop l

administration workshop ll

sql -> 5 day kkkkkkk

week1. sql, ....... ... .. . . . .. .  . .. . arcitecture

week2. 파라미터, 테이블, 사용자 관리, 데이터베이스 설치, 보안 감사 , 성능 모니터링, 백업 및 복구 기본적인것. load, unload

week3. backup, recobery, 자동화 데이터베이스, 암호화.....

데이터베이스가 꺼지면..

  1. $ lsnrctl start
  2. $ sqlplus / as sysdba
     SQL> startup
  3. $ emctl start dbconsole

Database : mysql //  mssql // oracle // cubrid // db2 ...

RDBMS -> Relational Database Management Systems

Database object : 

scala datatype : number, character, etc...

Datamodeling !! 

데이터 베이스 장점 : 일관성(consistency), 정확성(accuracy), 공유 ..

Realtion database concept : 

1. 

* : 필수

o : 선택

# : primary key 식별키(=고유키) : auto_increment

1. 필드 : 한개의 값

2. 튜플 : select data

3. 컬럼 : 한 ㅣ.. 

* Basic select statme 

SELECT * | { [DISTINCT] column | expression [alias], ...} FROM table;

                                                                           ㄴ 별칭

* : can display all columns of data in a  table

 - oracle database start ..

[oracle@ocpdba sysconfig]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 24 13:39:53 2013 Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup

Writing SQL StateMents

 - SQL statements are note case-sensitive.

 - SQL statement can be on one or more lines.

 - Keywords cannot be abbreviated or split across lines.

 - Clauses are usually placed on separate lines.

 - Indents are used to enhance readability.

 - In iSQL*Plus can optionally be terminated by a semicolon(;). But SQL*plus, you are required to end each SQL statement with a semicolon(;).

Column Heading Defaults

  iSQL*Plus :

    - Default heading alignment : center

    - Default Heading display : Uppercase

  SQL*Plus :

    - Cahracter and Date Column hadings are left-aligned

    - Number column hading are right-aligned

    - Default heading display : Uppercase

Defining a Null value

  - A null is value that is unvailable, unassigned, unknowmm or inapplication.

  - A null is not the same as a zero or a blank space.

* Arithmetic expressions containing a null value evaluate to null.

Using column Aliases

  - if you use to space of column aliases space, then you can ".

  example)   select last_name as name, commission_pct comm from employees;

  example2) select last_name as "Name", commission_pct "Annual Salary" from employees;

Concatenation Operator

  - Links columns or character strings to other columns

  - ls represented by two vertical bars (ll)

  - Creates a resultant column that is a character expression.

  - You can use to using literal character strings 

      :: example) select last_name || ' is a ' || job_id as "employ details" from employees;

What is "Dummy table" ??

  - you can calcurate use to dual table.

    example )   select 4 + 2 from dual.

    example2 ) select 'It''s real database class'  from dual;

select 'It;s real database class'  from dual;

Duplicate Rows

  - The default display of queries is all rows, including duplicate rows.

* Using the WHERE clause

* Using the BETWEEN condition

*Using the IN Conditon

*Using the LIKE condition

If you do can NUll , then...

  example ) select * from employees where manager_id is NULL;

* AND Truth Table

*  OR Truth Table

* Not Truth Table

... WHERE job_id                  NOT IN ('AC_ACCOUNT', 'AD_VP')

... WHERE salary                  NOT BETWEEN 10000 AND 15000

... WHERE last_name           NOT LIKE '%A%'

... WHERE commission_pct  IS NOT NULL

* Rules of Precedence ( ★ precedence NOT >> AND >> OR ★ )