ch030 - Concepts of Database Management Sixth Edition...

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

View Full Document Right Arrow Icon
Concepts of Database Management Sixth Edition Chapter 3 The Relational Model 2: SQL
Background image of page 1

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 2 Objectives Introduce Structured Query Language (SQL) Use simple and compound conditions in SQL Use computed fields in SQL Use built-in SQL functions Use subqueries in SQL
Background image of page 2
Concepts of Database Management 3 Objectives (continued) Group records in SQL Join tables using SQL Perform union operations in SQL Use SQL to update database data Use an SQL query to create a table in a database
Background image of page 3

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 4 Introduction SQL (Structured Query Language) Allows users to query a relational database Must enter commands to obtain the desired results Standard language for relational database manipulation
Background image of page 4
Concepts of Database Management 5 Getting Started with SQL If you are completing the work in this chapter using Microsoft Office Access 2003, Microsoft Office Access 2007, or MySQL version 4.1 or higher, the following sections contain specific information about your DBMS
Background image of page 5

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 6 Getting Started with Microsoft Office Access 2003 and 2007 If you are using the Access 2003 or 2007 version of the Premiere Products database provided with the Data Files for this text: Tables in the database have already been created You will not need to execute the CREATE TABLE commands to create the tables or the INSERT commands to add records to the tables
Background image of page 6
Concepts of Database Management 7 Getting Started with Microsoft Office Access 2003 and 2007 (continued) To execute the SQL commands shown in the figures in Access 2003 Open the Premiere Products database Click Queries on the Objects bar in the Database window, and then double-click the “Create query in Design view” option Click the Close button in the Show Table dialog box Click the View button list arrow on the Query Design toolbar, and then click SQL View The query opens in SQL view, ready for you to type your SQL commands
Background image of page 7

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 8 Getting Started with Microsoft Office Access 2003 and 2007 (continued) To execute SQL commands shown in the figures in Access 2007: Open the Premiere Products database Click the Create tab on the Ribbon Click the Query Design button in the Other group Click the Close button in the Show Table dialog box Click the View button arrow in the Results group on the Query Design Tools tab, then click SQL View The Query1 tab displays the query in SQL view, ready for you to type your SQL commands
Background image of page 8
Concepts of Database Management 9 Getting Started with MySQL MySQL-Premiere script provided with the Data Files for this text will: Activate the database Create the tables Insert the records To run a script in MySQL: Type the SOURCE command followed by the name of the file Press the Enter key
Background image of page 9

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 10 Getting Started with MySQL (continued) Before typing commands in MySQL, you must
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/20/2008 for the course IST 331 taught by Professor Sikder during the Spring '08 term at Cleveland State.

Page1 / 49

ch030 - Concepts of Database Management Sixth Edition...

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

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