SQL_Self_Paced_Training

SQL_Self_Paced_Training - Self-Paced SQL Exercise Version...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Self-Paced SQL Exercise Version 3.5
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Basic SQL Exercises © Ingres Corporation © Ingres Corporation Page 2 Contents 1 Introduction 4 1.1 Reference Material . ................................................................ 4 1.2 Install Ingres . ........................................................................ 4 2 Setup 5 2.1 Extract setup Materials . .......................................................... 5 2.2 Creating a Database and loading data. ...................................... 7 2.2.1 Creating database and Connecting . .................................. 7 2.2.2 Building Tables . ............................................................. 8 2.2.2.1 Getting Help . ....................................................... 8 2.2.2.2 Creating Tables . .................................................. 9 2.2.3 Loading Tables with Data . ............................................. 10 2.2.4 Verify the Data Load . ................................................... 10 2.2.5 Troubleshooting . ......................................................... 11 3 Database Design 13 4 Exercises 14 4.1 Simple Retrievals . ................................................................ 14 4.1.1 Using Simple Views . ..................................................... 16 4.2 Data Manipulation . ............................................................... 17 4.2.1 Adding and changing data . ........................................... 17 4.3 Transaction Processing . ........................................................ 20 4.4 Joining Tables . ..................................................................... 22 4.5 Views Based on More Than One Table . .................................... 23 SQL Functions . ............................................................................ 24 4.5.1 Conversion and date functions . ..................................... 25 4.6 Unions and Subqueries . ........................................................ 26 4.6.1 Changing Data Using Subqueries . .................................. 28 5 Solutions 29 5.1 Simple Retrievals . ................................................................ 29 5.1.1 Using Simple Views . ..................................................... 30 5.2 Data Manipulation . ............................................................... 31 5.2.1 Adding and changing data . ........................................... 31 5.3 Transaction Processing . ........................................................ 34
Background image of page 2
Basic SQL Exercises © Ingres Corporation © Ingres Corporation Page 3 5.4 Joining Tables . ..................................................................... 36 5.5 Views Based on More than One Table . .................................... 37 5.6 SQL Functions . .................................................................... 38 5.6.1 Conversion and date functions . ..................................... 39 5.7 Unions and Subqueries . ........................................................ 40 5.7.1 Changing Data Using Subqueries . .................................. 41
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/15/2011 for the course ECKOW 123 taught by Professor Riuyt during the Spring '11 term at University of Damascus.

Page1 / 42

SQL_Self_Paced_Training - Self-Paced SQL Exercise Version...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online