DOC

Database Management MIS

By Pauline King,2014-12-29 13:49
13 views 0
Database Management MIS

    Database Management /MIS

     LAB/SQL (oracle)

    ; CREATE TABLE ; ALTER TABLE

    ; DROP TABLE

    ; CREATE INDEX ; DROP INDEX

    ; INSERT INTO

; SELECT

    ; SELECT DISTINCT ; WHERE Clause

    ; DELETE

    ; UPDATE

    ; AND & OR Operators ; LIKE operator

; Wildcard

    o %

    o _

    ; IN Operator

    ; BETWEEN operator ; SQL Alias

    ; SQL JOIN

    ; INNER JOIN

    ; LEFT JOIN

    ; RIGHT JOIN

    ; FULL JOIN

    ; UNION

; NOT NULL Constraint

    ; PRIMARY KEY Constraint

    ; FOREIGN KEY

    Aggregate Functions ; AVG()

    ; COUNT()

    ; FIRST()

    ; LAST()

    ; MAX()

    ; MIN()

    ; SUM()

    Main Entities

STUDENT

    COURSE

    TEACHER

    DEPARTMENT

    CLASS_ROOM

    SPECIALIZATION

Report this document

For any questions or suggestions please email
cust-service@docsford.com