Enter Title

Acronyms

100

SQL

Structured Query Language

200

RDMS

Relational Database Management System

300

DBMS

Database Management System

400

SSMS

SQL Server Management Studio

500

ANSI

American National Standards Institute

SSMS

100

Shortcut to execute a query

F5

200

It is where the databases, tables, view stored procedures, users, etc are listed.

Object Explorer

300

It is where we can build and execute our queries.

Query Editor

400

TRUE or FALSE

You can create multiple databases.

TRUE

500

How to connect to a database when running a query?

1. Select from dropdown.

2. USE <database? GO

SQL Fundamentals 1

100

SQL statement used to extract data from a database

SELECT

200

How to select a column named "customerId" from a table named "Customers"?

SELECT customerId FROM Customers

300

Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as <WORKER_NAME>.

SEELCT FIRST_NAME AS WORKER_NAME FROM Worker

400

Write an SQL query to print details of the Workers whose FIRST_NAME contains ‘a’.

SELECT * FROM Worker WHERE FIRST_NAME LIKE '%a%';

500

Write an SQL query to show the top n (say 10) records of a table named Worker sorted by salary.

SELECT TOP 10 * FROM Worker ORDER BY Salary DESC

SQL Fundamentals 2

100

SQL Statement used to update data in database

UPDATE

200

How to select all the columns from a table named "Customers"?

SELECT * FROM Customers

300

Write an SQL query to print all Worker details from the Worker table order by FIRST_NAME Ascending.

SELECT * FROM Worker ORDER BY FIRST_NAME

400

Write an SQL query to print details of the Workers whose SALARY lies between 100000 and 500000.

SELECT * FROM Worker WHERE SALARY BETWEEN 100000 AND 500000

500

Write an SQL query to clone a new table from another table.

SELECT * INTO newTable FROM oldTable

SQL Fundamentals 3

100

SQL Statement used to delete data in database.

DELETE

200

How to select all unique values from all the columns of a table named "Customers"?

SELECT DISTINCT * FROM Customers

300

Write an SQL query to print details for Workers with the first name as “Vipul” and “Satish” from Worker table.

SELECT * FROM Worker WHERE FIRST_NAME IN ('Vipul','Satish');

400

TRUE/FALSE

Numeric values need Single quotation marks (')

FALSE

500

SQL Statement that deletes all the data from a table but not the table itself

TRUNCATE