fim sql
Download
Skip this Video
Download Presentation
FIM: SQL

Loading in 2 Seconds...

play fullscreen
1 / 21

FIM: SQL - PowerPoint PPT Presentation


  • 143 Views
  • Uploaded on

FIM: SQL. Stefano Grazioli. Critical Thinking. Lab 11:30-1:00 Easy meter . How do I talk to a DBMS?. SQL. In one hour. Before Querying…. Figure out what data is available Ask about the data model and the data dictionary, but… …they may not have it.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' FIM: SQL' - duer


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
fim sql

FIM: SQL

Stefano Grazioli

critical thinking
Critical Thinking
  • Lab 11:30-1:00
  • Easy meter
before querying
Before Querying….
  • Figure out what data is available
  • Ask about the data model andthe data dictionary, but…
  • …they may not have it.

A picture of the contents of the database

A text description of the contents of the database (e.g. columns content)

smallbank ltd

SmallBank Ltd.

Database example

navigating the relationship join
Navigating the Relationship (join)

foreign key: a PK in another table, used to link the two tables

different dialects
Different “Dialects”

Chen

ModifiedChen (IE)

IDEF1X

0:n

1:1

works in

Employee

Dept

works in

Employee

Dept

works in

Employee

Dept

Dept

Employee

winit

WINIT

What Is NewIn Technology?

homework

Homework

SQL Practice

slide14
SQL
  • Structured Query Language
  • The standard language for databases
  • 70s:

- Codd

- SEQUEL – Structured English QUEry Language

  • commercialized it in 1979
  • 1986 ISO/ANSI
  • Sometimes sought as a required skill in interviews
sql example a query
SQL EXAMPLE: A QUERY

SELECT First_Name, Last_Name, ssn

FROM StudentTbl

WHERE gpa > 3.0

ORDER BYLast_Name;

4 2 basic sql commands
4+2 BASIC SQL COMMANDS
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • CREATE
  • DROP
interacting with a db 1
Interacting with a DB (1)

SQL

Web server

Data (Customer, Product, Order)

Your browser

DBMS

You

On your local machine(e.g., laptop, lab PC)

On a Server

interacting with a db 2
Interacting with a DB (2)

SQL

Data (Customer, Product, Order)

Some BIsoftware

DBMS

You

On your local machine(e.g., laptop, lab PC)

On a Server

Example: Tableau, Excel

interacting with a db 3
Interacting with a DB (3)

SQL

SmallBank DB

(Loan, Loan Officer, Customer…)

Visual Studio

SQL ServerDBMS

You

Your local machine(e.g., laptop, lab PC)

Server

F-sg6m-s4.comm.virginia.edu

DEMO

suggestions
Suggestions

Make sure that you can access

the DB asap(this afternoon).

Come to office hours or lab if you cannot.

you do the talking
You do the talking
  • Name, Major
  • Learning Objectives
  • Things you like about the class
  • Things that can be improved
  • Attitude towards the Tournament
ad