SQL Problem Solving Tutorial For IT Students 2021

Tech Bholi presents SQL problem solving tutorial for IT students. SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.

Timestamps:
0:00 Intro
0:28 Create Database
0:55 Create Table In Database
02:30 Insert Data In Table
05:21 List all id,employee name and job in the employee table
05:52 List all the columns of emp table
06:20 If the given salary is monthly salary, list the name and annual income of each employee
07:06 If the given salary is monthly salary, list the names and annual salary of each employee if Rs 300 raise was given to each employee
07:55 Display the name of employee as NAME, job as JOB and salary as SALARY
08:40 If employee with job teacher are given commission, list the names and annual income of each employee
09:36 Display all the unique id from emp table
10:00 Display different job types
10:30 List the name, job, annual salary and id of all employees, Sort the names in ascending order
11:20 List the names and annual salary of each employees and sort them in order of employees who earn more
12:20 List the names, id and salary of all teachers
13:02 Find the name of all employees who work in id greater than 5
13:32 Find all employees whose commission is greater than their salary
14:06 Find all employees whose annual salary between 200000 and 300000
14:46 Find all the employees whose id is one of these (2,4,6,8)
15:24 List all the employees whose name start with S
16:02 List all employees whose name start with A and have exactly 7 characters in their names
16:46 Find all employees who have no salary
17:17 Find all employees whose salary does not lie between 30000 and 20000
18:28 Find all employees whose job does not start with T
19:10 Find all employees who have salary
19:45 Find all teachers who earn between 10000 and 20000
20:32Find all employees who are teacher or earn between 20000 and 40000
21:25 List all doctors and engineers with salaries over 20000
22:15 List all details of employees in id 5,8 in alphabetical order of name
23:20 List the name and salary of all teacher in id 5
23:52 Display the names o employees who have BA or MI in their names
24:42 Display the details of all employees who have worked more than 5 years
25:28 Give a raise of 10000 in salary and 500 in commission to all employees who have worked more than 5 years and display their names, job,hiredate and annual income in ascending order of name
26:55 Update data in the table
28:00 Delete data in the table
28:42 Add attribute in the table
29:32 Delete an attribute in the table
30:22 Delete a table
30:50 Delete Database

Created by: Bholi Ansari
Edited by: Bholi ansari
Thumbnail Maker: Suresh Dahal

More Videos:

#sql #sqlite #sqlinterviewquestions #sqlite_crud_operations #sqlinterviewquestionsandanswers #ssqlixie