RQ7 COMMANDS PT2520

PT2520
SQL COMMANDS FOR FUN……..
VL#8
TOPIC: FUNCTIONAL COMMANDS IN SQL 2008
NAME: Darius Murdock DATE: November 6, 2014
VL#8: SECURITY IN SQL AND ROLES IN SQL SERVER
1. How do you create Query in SQL? COMMAND OR GUI?
SQL:
COMMAND: SELECT ASTRICTS (*) FROM TableName
GUI: Right Click New Database

2. Define statement in SQL will give you output with records starting with T.

3. Define INNER JOIN AND WRITE DOWN One example:

4. What is EQI Join?

5. What is the structure or command used in Joining Tutor table with session based on tutorkey as primary and foreign key.
With Following fields:
Lastname
Studentkey
Firstname
sessionstatus

6. Give an example for WHERE Clause:
SELECT * FROM SALES WHERE TOTAL = PRICE*QUANTITY

7. Give an example for Aliasing. Like, Group By, Having, Count, Max. Datepart.
TutorLastname AS [LName]

8. List 10 commands you learned in SQL:
CREATE TABLE - creates a new database table
ALTER TABLE - alters a database table
DROP TABLE - deletes a database table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
SELECT - get data from a database table
UPDATE - change data in a database table
DELETE - remove data from a database table
INSERT INTO - insert new data in a database table
GROUP BY

9. What command do you use to get total of students with age over 25?
SELECT COUNT (*) AS “TOTAL OVER 25”

10. The role of AND OR, and Between in SQL query and give an example for each one.

11. _______________Clause sets a conditional statement, and it can be used with any type of SQL query

12 .______________temporarily assigns a table column a new name

13.______________It is used to extract data from databases

14. ______________is the command used to insert new data (a new row) into a table by specifying a list of values to be inserted into each table column.

15. ____________links together two or more conditional statements for increased filtering when running SQL commands

16.