COURSE OUTLINE:
Relational Database Fundamentals
* Overview of Relational Database Concepts
* Relational Databases and Relational Database Management Systems
* SQL, DML and DDL Languages
Data types, operators and expressions (the basics)
* Displaying Table Structures
* Column Datatypes
* SELECTing Column Data From a Table or View
* SELECT DISTINCT Values
* COUNTing Rows
* Restricting Rows using the WHERE Clause
* Sorting Results Using ORDER BY
* Joining Multiple Tables
* Using Column and Table Aliases
Query Techniques
* Outer Joins
* Joining a Table to Itself
* Subqueries
* Hierarchical Queries
* Grouping, Filtering and Sorting Query Results
* Tips for Developing Complex SQL Queries
Data Manipulation Language (DML)
* INSERT into Tables
* UPDATE Table Data
* DELETE from Tables
* TRUNCATE Tables
* Controlling Transactions
Creating a Database
* Database Development Methodology Overview
* Building a Logical Data Model eg ER Diagrams
* Transforming to Physical Design
* Database Construction using DDL
Database Objects Management
* Dropping Tables, Indexes and Views
* ALTERing Tables, Indexes and Views
* Enabling and Disabling Constraints
* Managing Security
Procedures
* Aim and Use
* CREATE PROCEDURE
* Temporary Tables
* Control of Program Flow
* ALTER and DROP PROCEDURE
* Implementation Differences
User-Defined Functions
* Aim and Use
* CREATE FUNCTION
* Comparison with Stored Procedures
* ALTER and DROP FUNCTION
Triggers
* Definition and Benefits of Use
* Alternatives (e.g., Constraints)
* CREATE TRIGGER
* Event Handling and Trigger Execution
* Nested and Recursive Triggers
* ALTER and DROP TRIGGER
0 comments:
Post a Comment