Code Monkey home page Code Monkey logo

lab-intro-sql's People

Contributors

ironhack-edu avatar sandrabosk avatar

Stargazers

avatar avatar avatar

Watchers

avatar avatar

Forkers

catarinamcbatista sogunmola drhech bcarrero ernesto-yelamos leamartinez1411 vikasrathi1992 danny88o macarenagortazar cornettomlette louiscostes ferrazzolidicreddo ahmed-abdelmoteleb gabrielescarrer jast92 haggarw3 sdbrugman kymy91 kjakubowska88 urgpan n4d1n3 siloik schloss-simms caaarov josefin-b kokeshi777 jw15667 alliesegre mazim-co saranme rvergnani frmele vladtarverdov robonejan felixley arabellacm gg030 isg75 lupocordero polhervella horacioe14 johalruiz loretolf oriolsauleda lucaciceu hubert-trasch agathantavrazou joangali1997 n-1983 npferrari anastasia-mintz deepdesh tonyhathuc jalalkv jennipher0716 isabeljabs callmeishmaelh joriencaron inesrondeau lydiavanderputten elizabeth-sames sergioaisolutions renevans gonzalo-zurita enricocesaro amandasilvap hamzapektas raafat-hantoush mbarger2 joshmeldrum khawk89 gonszalo sanjamil 1francisco1 emiliawoldan myhaijay juliea1001 felagund93 ccastroblua gvcarbajal p-fuster gbraaf renejansen-in agchesneau arektarnawski saltmeyer ferran34160 javianalista tekiniggemann salwey fyanli edithdomingues minalborse joanabv kimerajoseph joluhergo zsborsos adleranne hajarrafi johanayf

lab-intro-sql's Issues

rephrase to clarify tasks and materials

@sandrabosk i worked through these instructions and had a go at rephrasing / adding more context

Links to sakila instructions to load database - specific to your client or you could run from command line
You can work with two sql query files - sakila-schema.sql (creates the schema) + sakila-data.sql inserts the data

The ERD is pictured above the instructions - not all tables are shown, but many of the key fields you will be using are visible

  1. Review the tables in the database.
  2. Explore tables by selecting all columns from each table or using the in built review features for your client
  3. Select one column from a table: Get film titles.
  4. Select one column from a table and alias it : Get unique list of film languages under the alias ‘language’ -NOTE we are not asking you to obtain the language per each film… but this is a good time to think about how you might get that information in the future.
  5. Using select statements and reviewing how many records are returned, can you find out how many stores and staff does the company have? Can you return a list of employee first names only?
  6. BONUS : How many unique days did customers rent movies in this dataset?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.