INTERMEDIATE SQLTOPICS

INTERMEDIATE SQL TOPICS

A seminar presented by: Christine Rivera, MBA, MS Senior Statistician/Data Scientist Bob Freeman, PhD Director, Research Technology Operations

Portions may be re-used with Attribution

? 2017 President & Fellows of Harvard College.

TOPICS

v Importing & Exporting v Altering your Database Structure v Views v Optimizing Queries with Indexes v Optimizing Queries with EXPLAIN v Q&A

IMPORTING & EXPORTING

IMPORTING AND EXPORTING

? From text files:

? ? GUI (Navicat)

? From sql dump (backup) files

? Import & export backup files via command line :

? mysql ?h HOST -u USER ?p DATABASE < FILE ? mysqldump -h HOST -u USER -p DATABASE| gzip -c > FILE.sql.gzip

? Import & export backup files via GUI (Navicat)

? From other database systems

IMPORTING & EXPORTING SAMPLE DATA



? All flights that departed from NYC (e.g. EWR, JFK and LGA) to destinations in the United States, Puerto Rico, and the American Virgin Islands) in 2013

? 336,776 flights in total

? To help understand what causes delays, it also includes a number of other useful datasets.

? Contains the following data tables:

o flights: all flights that departed from NYC in 2013 o weather: hourly meteorological data for each airport o planes: construction information about each plane o airports: airport names and locations o airlines: translation between two letter carrier codes and names

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download