In this course the student will understand the various SQL statements and how they are used and must be encrypted. After this course the student will independently manipulate data in tables, can create objects and can access information about objects.
Topics
*Tables
Table, column and row
Primary key
Foreign key
*SQL Queries
*SQL syntax
*Data Manipulation Language (DML)
Select
INSERT INTO
UPDATE
DELETE
*Data Definition Language (DDL)
CREATE
ALTER
DROP
*Data Control Language (DCL)
GRANT
REVOKE
COMMIT
ROLLBACK
*Advanced SQL
*Features
Prerequisites
Course 1DB2
Coursedays
2 days
Class
Classroom with assignments online
Special
Assignments are made by MySQL database
Also possible with DB2 online environment at the customer's location
