Database Tutorial

Course Tutorial Site

Site Admin

Archive for the ‘SQL’ Category

Database I Tutorials

without comments

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. Please understand that the blog will be evolving over time.

I played around with a number of concepts with presenting and organizing information. At the moment, a WordPress blog suits the purposes of organizing a set of tutorial materials. I’ve opted to take this direction because there isn’t a book that provides everything that seems useful, accessible, and readable for an undergraduate course in databases.

I hope to provide such a site with this blog. The industry has many databases that provide varied and important roles, but the Oracle, MySQL, and Microsoft SQL Server databases are the most widely used. It strikes me that MySQL is the most widely used database because of the GNU license. The InnoDB engine appears the best solution for implementing a transactional MySQL database. Commerically, midsize to large companies appear to use Oracle because of it’s scalability and broad set of features. Microsoft SQL Server appears positioned for small to midsized companies, and has wide adoption in city and county government.

Initially, my focus will be the Oracle and MySQL database. I’ll broaden that coverage as time permits to include Microsoft SQL Server. I’ve opted to organize the blog with pages, nesting relative pages beneath summary pages. You can open the summary pages to find the subordinate page names and brief descriptions of their contents. Eventually, I plan to provide an index because while searches are powerful they sometimes don’t pinpoint a single page when pages have similar or related contents.

I’m also using JQuery to employ page folding and tabbing. This allows you to focus on a item of interest without seeing 10 pages of content at once. You can read HowToBrowsePages for more information on folding and tabbing.

The summaries of the tutorials are:

    Lesson 1: Installations
    Learn what a relational database and SQL are, and expose you to implementations.
    Lesson 2: Tables
    Learn what database tables and constraints are; and how to create them in Oracle
    Lesson 3: Modeling Data
    Learn how to model the relationship between tables in Entity Relationship Diagrams (ERDs).
    Lesson 4: Inserting Data
    Learn how to insert data into tables with and without dependencies on data in other tables.
    Lesson 5: Querying Data
    Learn how to query data from related tables by using the relationship between primary and foreign keys.
    Lesson 6: Integration
    Learn how to change database structures, insert complex data, and insert data derived from data; and work with filtering, converting, and generating data that leverages multiple table joins and sets.
    Lesson 7: Aggregation
    Learn how to aggregate and use aggregated data sets.
    Lesson 8: Transformations
    Learn how to perform transformations and selective aggregations.
    Lesson 9: LAMP Deployments
    Learn how to work with transactions and large objects in an n-tier LAMP environment – demonstrating ODBC connection models and deployment architectures.
    Lesson 10: JDBC Library
    Learn how to work with transactions and large objects in a two-tier environment – demonstrating JDBC connections and deployment architectures.
    Lesson 11: DBA Tools I
    Learn how to work with metadata, views, and database tuning of SQL statements through indexes.
    Lesson 12: DBA Tools II
    Learn how to work with database recovery and backup tools.

Written by michaelmclaughlin

July 21st, 2009 at 8:07 pm