Lectures 11,12,13,14 - Assignment4-5Lectures

Lectures 11,12,13,14 - Assignment4-5Lectures - Click to...

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

View Full Document Right Arrow Icon
3/17/10 Click to edit Master subtitle style Introduction to SQL And its use in Visual basic Structured Query Language
Background image of page 1

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

View Full DocumentRight Arrow Icon
3/17/10 SQL and VB In the next four lectures you will learn how to use the language “SQL”, and how to use it in VB programs to modify and retrieve data from databases. Numerous practice quizzes for SQL will be available, but you will not actually be tested on your knowledge of SQL until the midterm. Nevertheless, you will need to know it in order to do assignments 4 and 5 SQ
Background image of page 2
3/17/10 SQL: What is it? SQL stands for Structured Query Language . It was originally developed in the early 1970s by IBM as a way to manipulate and retrieve data stored in IBM’s relational DBMS, System R. It can be pronounced “Sequel” or “S- Q-L”. SQ
Background image of page 3

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

View Full DocumentRight Arrow Icon
3/17/10 When do we use SQL? SQL is most commonly used to retrieve data from a database. It is also commonly used to modify data. SQL also contains commands for creating tables and other database objects, and for maintaining data security through granting and denying privileges to users. SQ
Background image of page 4
3/17/10 How is SQL used? You can use SQL in Access using the Access Query Builder, which will be demonstrated in lab. All major DBMS’s, like Oracle and MySql, come with client tools which allow database managers and users to write SQL queries and send them to the database. The next slide shows a screen shot of SQ
Background image of page 5

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

View Full DocumentRight Arrow Icon
3/17/10 Choose a database here. Type the SQL here, then Execute. See the results here.
Background image of page 6
3/17/10 SQL and VB Programming It is fairly easy to create VB programs which interact with databases in all major DBMSs. Assignments 4, 5 and 6, and the final project, will be VB programs which interact with Access databases. I have created one such program, a simple tool which will help you to learn and practice SQL: The SQL Query Tool.
Background image of page 7

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

View Full DocumentRight Arrow Icon
3/17/10 SQL Query Tool 1. Select an Access database 2. Verify the connection is working 3. Type the query 4. Run the query 5. Results appear in a separate window.
Background image of page 8
3/17/10 What can we do with SQL? SQL has for major components: 1. DQL (Data Query Language): Used to retrieve data from a database. 2. DML (Data Manipulation Language): Used to modify the data in a database—inserting, updating, and deleting. 3. DDL (Data Definition Language): Used to design tables and other database objects. SQ
Background image of page 9

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

View Full DocumentRight Arrow Icon
3/17/10 DML: Action Queries The SELECT queries that you have seen so far are a part of DQL, Data Query Language, one of the four parts of SQL. SELECT queries can display data from tables in a variety of ways, but they do not modify the data. Data Manipulation Language, DML, is the part of SQL which is used to SQ
Background image of page 10
3/17/10 Action Queries in Access To run action queries using the Access query designer, you will have to okay it first by “enabling potentially harmful content”.
Background image of page 11

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

View Full DocumentRight Arrow Icon
3/17/10 DDL: INSERT INTO The INSERT INTO command is used to add rows to a table.
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/17/2010 for the course IOE 373 taught by Professor Bobgoodsell during the Winter '10 term at University of Michigan-Dearborn.

Page1 / 89

Lectures 11,12,13,14 - Assignment4-5Lectures - Click to...

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

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