Fim sql
Download
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


How do I talk to a DBMS?

SQL

In one hour


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


Loan officer table

ACTUAL TABLE DIAGRAM

Loan Officer Table

LO id

f name

l name

phone



Reading the relationships
Reading the Relationships

1

6

One

5

2

Many

3

4


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


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