Fim sql
This presentation is the property of its rightful owner.
Sponsored Links
1 / 21

FIM: SQL PowerPoint PPT Presentation


  • 107 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

FIM: SQL

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


Fim sql

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)


Real world examples fragments

Real World Examples(fragments)


Smallbank ltd

SmallBank Ltd.

Database example


Loan officer table

ACTUAL TABLE DIAGRAM

Loan Officer Table

LO id

f name

l name

phone


Data model smallbank ltd

Data Model: SmallBank,Ltd.

One

Many


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


Fim sql

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


  • Login