Title: Class Outline 18
Course: KVCC BUS210 > Section: Class Outlines

1.      Introduction to SQL

a.      History

i.           SEQUEL

b.      Standards

c.      Different Styles/Dialects

i.           MYSQL

ii.           ORACLE

iii.           Microsoft SQL Server

2.      What SQL Is not

3.      What SQL is

a.      The ideals

i.           Create structures

ii.           Perform data management

iii.           Complex queries

iv.           Minimal user effort

v.           Easy to learn

vi.           Is portable

b.      SQL Functions

i.           Data definition language DDL - Create DB objects

1.      Commands

ii.           Data manipulation language DML - Manipulate data

1.      Commands

c.      SQL allows you to command "what" without knowing "how"

d.      Query - a spur of the moment question

i.           Questions

ii.           Actions

4.      Data definition commands

a.      Database model

i.           Business Rules

ii.           Items from ERD

b.      Creating the Database

i.           Using the RDBMS

c.      Database Schema - logical group of database objects

d.      Data Types

i.           Numeric

ii.           Character

iii.           Date

e.      Creating Table Structure

f.       SQL Constraints

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 18.pdf