Physics > Lab Experiment > Seneca CollegeDBS211 Lab 02 Introduction To SQL W21(1) (2 (All)

Seneca CollegeDBS211 Lab 02 Introduction To SQL W21(1) (2

Document Content and Description Below

Lab 02 – SQL Single Table Queries Objectives The purpose of this lab is to start learning SQL by writing basic SELECT and DML statements involving a single table. Submission Your submission wil ... l be a single SQL file with the solutions provided (with a .sql file extension)  Save your SQL statements as a script named: DBS211_L02_FirstName_LastName.sql  Locate, select, and submit the file to the Lab 02 link. Using comments to number the question answers, write the SQL code to complete the following tasks. Example Submission -- *********************** -- Name: Your Name -- ID: ######### -- Date: The current date -- Purpose: Lab 02 DBS211 -- *********************** -- Q1 SOLUTION -- SELECT * FROM TABLE; -- Q2 Solution – SELECT * FROM TABLE; Setup Create a new worksheet in SQL developer and add an appropriate comment header that includes your name, student id, the date and the purpose of the file (i.e. DBS211 – Lab 02). Style Guide Your SQL should be written using the standard coding style:  all keywords are to be in upper case  all user-defined names are to be in lower case (example: table and field names)  there should be a carriage return before each major part of the SQL statement (i.e. before SELECT, FROM, WHERE and ORDER BY) See the following sample: [Show More]

Last updated: 3 years ago

Preview 1 out of 4 pages

Buy Now

Instant download

We Accept: