Databases

You Will need a PDF reader to view these file.

It is recommended that you download a copy of Adoby Reader. Click HereAdobeReader to get your free copy.

You can scroll down the page to see the titles or you can click on a topic below to go directly to the information. If you should have any problems with the materials on this page please leave a comment at the bottom of this page or go to the Contact Us Page


 

Topics:

Postgre SQL
(PostgreSQL Functions By Example Beginner) (Introduction to PostgreSQL Beginner)

Microsoft Access
(Access: using operators and functions in queries Advanced) (Access 2013 Create web-based databases Intermediate) (Building Access 2010 databases Intermediate) (Cleansing Excel data for import into Access Intermediate) (Access 2013: Intermediate to advanced queries Intermediate) (Access 2010: Buttons and macros Intermediate) (Access 2013: databases for researchers Beginner) (Access 2013: An introduction Beginner) (Access 2010: An introduction Beginner) (Access 2013: Intermediate to advanced queries Intermediate) (Simple Invoicing Database with MS Access 2013 Advanced) (Quick Start Guide Access 2013 Beginner) (Access Database Design) (Microsoft Access 2007 Tutorial) (Access 2010 An Essential Guide) (Creating Queries and Reports (Access)) (Customized Reports using Access 2010) (Access Queries (Office 2010)) (Using and designing Access 2010 databases) (A Quick Microsoft Access 2007 Tutorial)

SQL
(A MySQL Tutorial for beginners Beginner) (Advanced MySQL Performance Optimization) (MySQL Cluster Tutorial Intermediate) (MySQL Replication Tutorial Beginner) (SQL language course material)

Other Data Bases
(db4o tutorial Intermediate) (Databases course book)  (SQL & SQL*Plus for Beginners) (Oracle Database 11g: SQL Fundamentals) (Oracle/SQL Tutorial) (Basic and Advanced Database) (How to Install SQL Server 2008) (SQL Server 2008)


 

 

PostgreSQL Functions By Example Beginner

PostgreSQL Functions By Example course material, tutorial training, a PDF file by Joe Conway. 41 pages

Table of Contents:

  • What are Functions?
  • How are they Used?
  • What Forms Can They Take?
  • SQL Functions
  • Procedural Languages
  • Internal Functions
  • C Language Functions
  • Language Availability
  • Creating New Functions
  • Dollar Quoting
  • Function Overloading
  • Changing Existing Functions
  • Behavior with Null Input Values
  • Security Attributes
  • Custom Operator and  Aggregate
  • SETOF with OUT Arguments
  • INSERT RETURNING
  • PL/pgSQL
  • Control Structures: FOR … LOOP
  • …etc

Back to Topics


 

 

Introduction to PostgreSQL Beginner

Introduction to PostgreSQL The Open Source Object Relational Database Management System, PDF document by A. Elein M ustain. 91 Pages.

Table of Contents:

  • PostgreSQL Features
  • Installation and Configuration
  • Maintenance and Monitoring
  • Command Line Interface
  • Database Basics in PostgreSQL

Back to Topics


Microsoft Access


 

 

Access: using operators and functions in queries Advanced

This document aims to cover all the query language elements (expressions, functions etc) that are available for you to use in your queries, and on your forms and reports. 18 Pages.

Table of Contents:

  • Null values
  • Operators
  • Arithmetic operators
  • Character operator
  • Logical operators
  • Relational operators
  • Character matching
  • Functions
  • Aggregate functions
  • Domain aggregate functions used for subset of records
  • Number functions
  • Character functions
  • Date functions
  • Conversion functions
  • Other functions
  • Special values
  • Handling dates and times
  • Other format elements
  • Financial functions

Back to Topics


 

 

Access 2013 Create web-based databases Intermediate

Access 2013 Create web-based databases course material, tutorial training, a PDF file by University of Bristol IT Services. 10 pages.

Contents:

Aims and Learning Objectives

Access web apps can only be used via Microsoft’s SharePoint. The easiest way to gain access to SharePoint is to subscribe to SharePoint Online, which is available from Microsoft for an annual fee.

This then lets you host, use and share Access web apps from any Internet-enabled device. This document will be of no use if you do not have access to SharePoint Online.

This document assumes that you are experienced at designing and building Access databases so, rather than dwelling on these aspects, concentrates on the core building blocks – the ‘must knows’ –necessary for getting an Access web app online.

The core learning objectives for this document are to:

  • Set up a new SharePoint Online Site to host your app
  • Choose, ‘launch’ and use an Access web app from a template
  • Modify your new Access web app

Note on versions of Access:

This document is only relevant to Access 2013 and will be of no use if using earlier versions of Access.

Back to Topics


 

 

Building Access 2010 databases Intermediate

This pdf course provides participants with the basic skills necessary to develop a simple Access 2010 database from a paper-based design.  35 Pages.

Contents:

Aims and Learning Objectives

This course provides participants with the basic skills necessary to develop a simple Access 2010 database from a paper-based design.

The core learning objectives for this course are to:

  • Gain a simple overview of the core relational database concepts
  • Build a simple database from a paper-based design – to achieve this candidates will:
    • Create tables and set relationships between tables
    • Import pre-existing data and enter data manually
    • Use the wizard to create and use data entry forms to simplify data input
    • Base a form on a parameter query to view filtered data (if time allows)
    • Add automation to a form using buttons and macros (if time allows)

Note on versions of Access:

  • Access 2013 users: should have little problem using this document.
  • Access 2007 users: should have few problems using this document if they keep in mind that the 2007 Office button has been replaced by a File tab in 2010 and that various command icons have moved, mostly to new locations within the same Ribbon tab.
  • Access 2003 users: this document will be of little or no use.

Back to Topics


 

 

Cleansing Excel data for import into Access Intermediate

This document provides you with experience of the tasks that you will have to do if you want to import data held in Excel into Access tables. PDF file. 16 Pages.

Contents:

Aims and Learning Objectives

By the end of this workbook, you will be able to:

  • explain the problems that can be encountered if data is not consistently entered
  • cleanse Excel data for import into a simple, multi-table Access database;
  • import cleansed Excel data into multiple Access tables;
  • create relationships between the tables;
  • modify the tables so that data input via Access is simplified

Table of Contents:

  • Spreadsheet examples
  • Spreadsheet with cleansed data
  • Spreadsheet without cleansed data
  • Prepare cleansed data for import into Access
  • The identified data model and fields
  • Split the spreadsheet data into three worksheets
  • Remove duplicate values from Label and Artist worksheets
  • Split the Artist column into two separate columns
  • Create Access tables from Excel data
  • Add relationships and test the data
  • Add dropdowns that show artist and label details

Back to Topics


 

 

Access 2013: Intermediate to advanced queries Intermediate

This document takes you through some intermediate to advanced queries. The assumption is that you are able to build simple one and multi-table queries using wildcards, and simple operators, such as equals, greater than and so on. 30 Pages.

Table of Contents:

  • Task 1 Opening the practice database 
  • Task 2 Query wizards
  • Task 3 Simple expressions and functions
  • Task 4 Grouped queries
  • Task 5 Relational operators
  • Task 6 Parameter queries
  • Task 7 Action queries 
  • Task 8 The iif function
  • Task 9 Crosstab query
  • Task 10 Date handling
  • Task 11 Define your own group values
  • Task 12 Nested queries 
  • Task 13 Calculating percentages
  • Task 14 Unmatched queries
  • Task 15 Using SQL to join two sets of query results

Back to Topics


 

 

Access 2010: Buttons and macros Intermediate

Access 2010 Buttons and macros course material, tutorial training, a PDF file on 14 pages.

You can add buttons to Access data entry forms that, when clicked, perform one or more specified actions. You can create buttons either by using the Button Wizard, though there are limited options using this, or by building a macro and then creating a button that you press to run the macro.

Okay, so the next question is what is a macro? Macros consist of an action, or a list of actions, designed to perform, automatically, one or more tasks, such as opening a form, printing a report or finding a subset of records based on specific criteria.In short, buttons and macros are about automating your database. However, you don’t have to manually press a button to run a specific macro and can instead tell Access when to run a macro based on a specific event, such as tabbing into or out of a field or on entering data that matches specific criteria.

Aims and Learning Objectives

By the end of this course you will be able to:

  • create buttons to automate your database;
  • create simple macros;
  • create macros that do different things depending on the situation;
  • create message boxes using macros

Back to Topics


 

 

Access 2013: databases for researchers Beginner

free Access 2013 An introduction to databases for researchers course material, tutorial training, a PDF file on 17 pages.

Aims and Learning Objectives

This course provides an introduction to databases for researchers. By the end of this course, you will be able to:

  • decide what type of database tool might best suit your research needs and understand the importance of including database design and development costings in your Data Management Plan;
  • manage and filter data for analysis in a pre-existing small scale research database using Microsoft Access, the University’s site-licensed, small-scale, relational database software;
  • explain what you should use the database for and when to use specialist analysis software;
  • explain open data format requirements in relation to relational databases and output data from the database in acceptable open formats;
  • explain the need for a rigorous set of metadata when sharing/archiving your data at the end of the project as well as use the database software to create some of this metadata

Table of Contents

  • Task 1 Opening the course database
  • Task 2 Managing the data
  • Task 3 Filtering datasets for use in analysis
  • Task 4 Filtering data from multiple tables
  • Task 5 Bulk-changing data values (if we have time)
  • Task 6 Exporting datasets for analysis and sharing
  • Task 7 Creating metadata from within Access.

Back to Topics


 

 

Access 2013: An introduction Beginner

A introduction to MS access 2013, course material, tutorial training, a PDF file on 18 pages.

In Access 2013 data is stored in tables. Each table holds data about a specific ‘thing’ and is related to at least one other table. Although the data is held in tables, the best way to access and edit data is not within these tables, but by using data entry forms. Queries are used to filter the data and also to do other things, some of which we will see on this course. Reports let you group the data together in printer-friendly format.

Table of Contents:

  • Document information
  • Opening the course database
  • Using the data entry form
  • Using queries to view specific data
  • Single table query: adding simple criteria, showing, sorting
  • Wildcards and operators
  • And/Or criteria
  • Running, modifying and exporting saved queries
  • Multi-table queries
  • Multi-table query with different table joins
  • Create an update query (if we have time)
  • Create a grouped report based on a query

Back to Topics


 

 

Access 2010: An introduction Beginner

In Access 2010 data is stored in tables. Each table holds data about a specific ‘thing’ and is related to at least one other table. Although the data is held in tables, the best way to access and edit data is not within these tables, but by using data entry forms. Queries are used to filter the data and also to do other things, some of which we will see on this course. Reports let you group the data together in printer-friendly format.

Aims and Learning Objectives

This course provides an introduction to Access 2010 databases. By the end of this course,

you will be able to:

  • navigate within and between data entry forms;
  • edit, add, delete, sort, find and filter data;
  • create simple single, multi-table and action queries;
  • create a simple grouped report based on a multi-table query.

Note: this document cannot be used with Access 2003; those using Access 2007 or Access 2013 will find minor differences.

Back to Topics


 

 

Access 2013: Intermediate to advanced queries Intermediate

This document shows you how to do things with queries that take you slightly ‘beyond the norm’. PDF file on 30 pages.
Aims and Learning Objectives
This document shows you how to do things with queries that take you slightly ‘beyond the norm’. It is not supposed to be exhaustive – no Access query workbook ever could be – but it shows you some of the less-trodden paths. The intention is to give you some hints and tips as to what can be done with queries so as to make you experiment further on your own.

The core learning objectives for this course are to:
• explain what you can do with Access queries beyond viewing subsets of data;
• create queries using a range of operators, functions and expressions;
• create a query to calculate totals;
• customise a crosstab query in the Query Design window;
• use different table joins to alter query results;
• create queries to sort data into ranges (e.g. age: 1 – 10, age: 11 – 20 and so on);
• join two sets of query results together using SQL.

Back to Topics


 

 

Simple Invoicing Database with MS Access 2013 Advanced

Simple Invoicing Desktop Database with MS Access 2013 tutorial training, a PDF file by David W. Gerbing.

Contents

  • Create a New Database
  • Customer and Product Tables
  • Database Structure
  • The Invoice
  • Enhance the Invoice
  • Process an Invoice
  • Query the Database
  • Database Report

Back to Topics


 

 

Quick Start Guide Access 2013 Beginner

Microsoft Access 2013 looks different from previous versions, so we created this guide to help you minimize the learning curve. PDF file. 6 Pages.

Contents

  • What can I find on the Account tab?
  • Where did the Back Up option go?
  • Things you might be looking for
  • What happened to the Pivot Chart feature?
  • What is an Access app?
  • Long Text is the new Memo
  • How to work with people who don’t yet have Access 2013
  • What’s on the Info tab?
  • Can I convert my Access database into an Access app?

Back to Topics


SQL


 

 

A MySQL Tutorial for beginners Beginner

A MySQL Tutorial for beginners training, PDF file by tizag.com on 58 pages.

Table of Contents:

  • PHP / MySQL Tutorial
  • MySQL Setup Guide
  • MySQL Admin
  • MySQL Syntax
  • MySQL Database
  • MySQL Connect
  • MySQL Tables
  • MySQL Insert
  • MySQL Query
  • MySQL Fetch Array
  • MySQL Select
  • MySQL Where
  • MySQL Order By
  • MySQL Joins
  • MySQL LEFT JOIN
  • MySQL Update
  • MySQL Delete
  • MySQL Database Backups
  • MySQL GROUP BY – Aggregate Functions
  • MySQL Aggregate Functions – COUNT()
  • MySQL Aggregate Functions – SUM()
  • MySQL Aggregate Functions – AVG()
  • MySQL Aggregate Functions – MIN()
  • MySQL Aggregate Functions – MAX()
  • MySQL – SQL Injection Prevention
  • MySQL Date – Formats
  • MySQL Time – Formats
  • MySQL Index – Overclock Your Tables

Back to Topics


 

 

Advanced MySQL Performance Optimization

Advanced MySQL Performance Optimization, tutorial training, a PDF file by Peter Zaitsev, Tobias Asplund. 138 Pages.

Table of Contents:

  • A bit of Performance/Benchmarking theory
  • Application Architecture issues
  • Schema design and query optimization
  • Sever Settings Optimizations
  • Storage Engine Optimizations
  • Replication
  • Clustering
  • Hardware and OS optimizations
  • Real world application problems

Back to Topics


 

 

MySQL Cluster Tutorial Intermediate

MySQL Cluster Tutorial course material, tutorial training, O’Reilly MySQL Conference & Expo 2010, Apr. 12 2010. PDF file by Andrew Hutchings, Andrew Morgan, Geert Vanderkelen. 81 Pages.

Contents

  • Introduction
  • Installation and Configuration
  • Starting & Using MySQL Cluster
  • Administer MySQL Cluster
  • MySQL Cluster Manager
  • Fault tolerance
  • Online Backup
  • NDB Info
  • NDB API
  • MySQL Cluster Connector for Java
  • Schema considerations
  • Scaling and Performance
  • Geographical Replication
  • Security

Back to Topics


 

 

MySQL Replication Tutorial Beginner

MySQL Replication Tutorial course material and tutorial training, presentation PDF by Lars Thalmann, Mats Kindahl. 114 Pages.

Table of Contents:

  • Concepts
  • Configuring Replication
  • Replication Topologies
  • Replication Commands
  • Use Cases
  • Row-based replication
  • Binary Log
  • Implementation
  • Cluster Replication
  • Tools and Techniques

Back to Topics


DB2


 

 

db4o tutorial Intermediate

db4o is the native Java, .NET and Mono open source object database. This documentation and tutorial is intended to get you started with db4o and to be a reliable companion while you develop with db4o. 218 Pages.

Contents

  • First Glance
  • First Steps
  • Querying
  • Structured objects
  • Collections and Arrays
  • Inheritance
  • Deep graphs
  • Transactions
  • Client/Server
  • SODA Evaluations
  • Constructors
  • Translators
  • Configuration
  • Classloader issues
  • Servlets
  • Encryption
  • Refactoring and “Schema Evolution”
  • Maintenance
  • .NET Specific Notes
  • Data Binding

Back to Topics


 

Databases course book

Databases course book course material and tutorial training, PDF file on 44 pages.

Table of Contents:

  • Introduction
  • Relational databases (Level 2)
  • Microsoft access (Level 1)
  • Mysql (Level 5)
  • SQL language for Mysql (Level 5)
  • Designing a database (Level 2)
  • Technical documentation (Level 9)

Back to Topics


 

 

Access Database Design

Microsoft Access Database Design course material and training tutorial, PDF file on 22 pages.

Table of Contents:

  • Course Description
  • Understanding Databases
  • Data Organization
  • Table Design
  • Keys and Relationships
  • Database Design Process
  • Creating a New Database
  • Creating Tables
  • Table Design View
  • Creating Relationships
  • Populating the Database

Back to Topics


 

 

Microsoft Access 2007 Tutorial

Microsoft Access 2007 Tutorial course material and training, PDF file on 49 pages.

Table of Contents

  • Getting Familiar with Microsoft Access 2007 for Windows
  • Creating Microsoft Access Tables
  • Working with Microsoft Access Tables
  • Sorting, Filtering, and Creating Relationships
  • Creating Microsoft Access Queries
  • Creating Forms
  • Creating Reports

Back to Topics


 

 

Access 2010 An Essential Guide

Microsoft Access 2010 An Essential Guide course material and training tutorial, PDF file on 25 pages.

Table of Contents:

  • Introduction
  • Starting Microsoft Access
  • Part 1: Using an Existing Table
  • Searching for a Particular Record
  • Sorting
  • Adding, Editing and Deleting Records
  • Selecting Records
  • Using a Form
  • Using a Report
  • Part 2 : Creating a New Table
  • Creating a Data Entry Form
  • Importing Data
  • Part 3: Relating Tables Together
  • Creating a Report
  • Leaving Access
  • Appendix

Back to Topics


 

Creating Queries and Reports (Access)

Access 2010: Creating Queries and Reports course material and training, PDF file on 69 pages.

Table of Contents:

  • Course Goals and Objectives
  • Select Queries
  • Action Queries
  • Parameter Query
  • Reports
  • Appendix
  • Parameter Query with Two Prompts
  • Make-Table Query
  • Append Query
  • Find Duplicates Query Wizard
  • Crosstab Query
  • Moving Data To and From Excel

Back to Topics


 

Customized Reports using Access 2010

Customized Reports using Microsoft Access 2010 course material and tutorial training, PDF file on 24 pages.

At the end of this course you will be able to:

  • Obtaining InfoSource Table Access
  • Data Security and You
  • Plan your question and results before you begin
  • HUB, Istrategy, and Your Data – What you need to know
  • Understanding Relational Databases

Back to Topics


 

Access Queries (Office 2010)

Access Queries (Office 2010) course material and training tutorial, PDF file on 25 pages.

Table of Contents:

  • Course Description
  • What is a Query?
  • Filters
  • Queries
  • Creating a Query
  • Using Design View to Create Queries
  • Query Utilities
  • Calculations
  • Grouping Records
  • Parameter query
  • Query Properties
  • Crosstab Query
  • Action Queries
  • Saving Query Results in a Table
  • Find Duplicates Query

Back to Topics


 

Using and designing Access 2010 databases

Using and designing Access 2010 databases course material and training tutorial, PDF file on 79 pages.

Table of Contents:

  • Task 1 Opening the Student2010 database
  • Task 2 The Navigation pane and setting tabbed display
  • Task 3 Working with tables
  • Task 4 Create a new table and set the primary key
  • Task 5 Relationships within a database
  • Task 6 Importing data from a non-Access source
  • Task 7 Customising a table
  • Task 8 Create single and multi-table select queries
  • Task 9 Create a query to calculate totals
  • Task 10 Create a query with an expression
  • Task 11 Create an Update query
  • Task 12 Create a Parameter query
  • Task 13 Using Forms
  • Task 14 Create a form with subform using Form Wizard
  • Task 15 Customising a form – basics
  • Task 16 Customising a form – more advanced methods
  • Task 17 Add a dropdown box
  • Task 18 Add a calculation to a form
  • Task 19 Using filters
  • Task 20 Using and creating reports
  • Task 21 Customising a report
  • Task 22 Produce mailing labels
  • Task 23 More table practice (optional task)
  • Task 24 More easy queries (optional task)
  • Task 25 More advanced queries (optional task)
  • Task 26 More advanced forms (optional task)

Back to Topics


 

A Quick Microsoft Access 2007 Tutorial

A Quick Microsoft Access 2007 Tutorial course material and training tutorial, By Charles W. Neville, © Charles W. Neville, with modification by Leith Chan, Vicky Wong and Steven Lu, PDF file on 44p.

Table of Contents:

  • Getting Started
  • Adding and Changing Data
  • Simple Queries
  • Creating Append Queries
  • Creating QBE Queries
  • Multi-table QBE Queries
  • SQL Queries

Back to Topics


 

SQL & SQL*Plus for Beginners

SQL & SQL*Plus for Beginners course material and training tutorial, PDF file on 187 pages.

Table of Contents:

  • Getting Started
  • Introduction to SQL & SQL*Plus
  • Row & Group Functions
  • Querying More Than One Table
  • Modifying Data & the Database
  • More SQL*Plus

Back to Topics


 

Oracle Database 11g: SQL Fundamentals

Oracle Database 11g: SQL Fundamentals course material and training, PDF file on 499 pages.

Table of Contents:

  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Sub-queries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects

Back to Topics


 

Oracle/SQL Tutorial

Oracle/SQL Tutorial course material and training, writing by Michael Gertz, PDF file on 66 pages.

Table of Contents:

  • SQL Structured Query Language
  • SQL*Plus (Minimal User Guide, Editor Commands, Help System)
  • Oracle Data Dictionary
  • Application Programming
  • Integrity Constraints and Triggers
  • System Architecture

Back to Topics


 

Basic and Advanced Database

Basic and Advanced Database courses material and training (PDF file 25 pages)

Table of Contents:

  • Introduction
    •  Overview of a Database Management System
  • Data models
    •  Entity-relationship model
    •  Relational Model
  • SQL
  • Normalization
    •  Basic Concepts
    •  First Normal Form
    •  Second Normal Form
    •  Third Normal Form
    •  Boyce-Codd Normal Form
    •  Normalization algorithms
  • References

Back to Topics


 

How to Install SQL Server 2008

A Step by Step guide to installing SQL Server 2008 simply and successfully with no prior knowledge – course material and training (PDF file 32 pages)

A Step by Step guide to installing SQL Server 2008 simply and successfully with no prior knowledge

Developers and system administrators will find this installation guide useful, as will seasoned DBAs. It will teach you the basics required for a typical, problem-free installation of SQL Server 2008, allowing you to add other components later if you wish.

Back to Topics


 

 

SQL Server 2008

SQL Server 2008 course material and training (PDF file 71 pages)

Table of Contents:

  • Welcome
  • What’s New in SQL Server 2008 R2?
  • SQL Server 2008 R2 Feature Review
  • Key Features at a Glance
  • Trusted, Scalable Platform
  • IT and Developer Efficiency

Back to Topics


 

SQL language course material

SQL language course material and training (PDF file 97 pages)

Table of Contents:

  • Introduction
  • Restricting and Sorting Data
  • Single Row Functions
  • Displaying Data From Multiple Tables
  • Aggregating Data using Group Functions
  • Sub Queries
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constarints
  • Views
  • Other Database Objects
  • Index
  • Set Operators

Back to Topics


 

 



Please leave a comment about the contents on this page Only. Thank You! 🙂

Back to Topics

Leave a Reply

Your email address will not be published. Required fields are marked *