Archive for the ‘SQL’ Category
Database I Tutorials
Welcome, this is the course tutorial site. You can use the search box to the right to find things when you’re not sure which week they’re in, or you can navigate to a week’s pages on the right or use the menu below. Please understand that the blog may evolve over time.
I played around with a number of concepts to organize and present essential materials to acquire real skill with SQL. At present, the course focuses on Oracle SQL because it is the most robust and widely used relational database engine. These web pages and external references to other web content replace the cost and utility of a textbook.
I’m also using JQuery to employ page folding and tabbing. This allows you to focus on a item of interest without seeing the detail content. at once. You can read HowToBrowsePages for more information on folding and tabbing.
The summaries of the tutorials are:
- Week 1: Installations
- Learn about hierarchical, networked, and relational databases; introduce you to how to navigate Oracle’s SQL*Plus Command-line Interface (CLI); and how basic SQL queries work.
Display weekly details →
- Week 2: Tables
- Learn about records, tables, Data Definition Language (DDL) commands, and database constraints.
Display weekly details →
- Week 3: Modeling Data
- Learn data modeling definitions, theory, and normalization process; learn how to use common lookup tables; who-audit columns to manage row-level security; and the
INSERTstatement. - Week 4: Inserting Data
- Learn how to insert data into a series of tables, how to use scalar subqueries to discovery primary key columns, and how to use automatic numbering for ID columns.
Display weekly details →
- Week 5: Querying Data through SQL Joins
- Learn how to query data from two and three related tables by using the relationship between primary and foreign key columns.
- Week 6: Table Maintenance
- Learn how to change the structure of database tables that hold data; learn how to use the
UPDATEstatement; and learn how to add, change, and remove columns and constraints. - Week 7:
SELECT-list Decision Making - Learn how to use the
CASEoperator, negation, set operators; and introduces how to the concept of aggregation. - Week 8: Insert data from queries
- Learn how to perform transformations and selective aggregations.
Display weekly details →
- Week 9: External Tables
- Learn how to work with Oracle’s external tables and multicolumn indexes.
Display weekly details →
- Week 10: Outer Join Selection
- Learn how to use outer joins to select data and generate new primary key columns when data is missing from the query result.
Display weekly details →
- Week 11:
MERGEStatement - Learn how to use the
MERGEstatement with outer join queries to populate table data conditionally.Display weekly details →
- Week 12: Selective Aggregation
- Learn how to use the
CASEoperator with aggregation functions.Display weekly details →
- Week 13: LAMP Architecture
- Learn how to use the LAMP (Linux, Apache, MySQL, and Perl/PHP/Python) web deployment stack. It uses pre-coded PHP programs to demonstrates how you upload and display large text and image files.
Display weekly details →
- Week 14: Dynamic Web Pages
- Learn how to create dynamic web pages by linking the output to the contents of a relational database.
