SQL Programming

Go to Problems

SQL Introduction

SQL is Structured Query Language, which is a programming language for storing, manipulating and retrieving data stored in a relational database.

SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.

SQL Process

When a SQL command is executed in any RDBMS, the system determines the best way to carry out your command and SQL engine figures out how to interpret the task.

Components like Query DispatcherOptimization EnginesClassic Query EngineSQL Query Engine etc are involved in this process.

Note: A classic query engine handles all the non-SQL queries, but a SQL query engine won't handle logical files.

 

Serious about Learning Databases ?

Learn this and a lot more with Scaler Academy's industry vetted curriculum.
Sql joins
Problem Score Companies Time Status
Performance Improvement 50
29:00
Minimum GPA 50
34:10
Number of offers 50
31:04
Neutral Reviewers 100
24:58
Movie Character 100
35:00
Short Films 100
31:20
Sql sub queries
Problem Score Companies Time Status
Study Selection 50
9:08
Study Update 50
17:37
Study Deletion 50
11:40
Job Offers 2.0 50
24:13
Actors and their Movies 100
38:27
Basic select
Problem Score Companies Time Status
Town Selection 50
7:59
Town Queries 50
5:19
Student Query 50
7:45
Country Filtration 50
6:05
Information Selector 50
3:45
Town Of Threes 50
8:21
Aggregation
Problem Score Companies Time Status
Firefighter's Average 50
10:10
Firefighter's Sum 50
6:14
Largest Difference 50
13:08
Distance Maximizer 50
15:34
Euclid's Distance 50
17:11
Big Salary 50
19:52
5'th Highest Marks 50
22:46
Famous Books 50
25:37
Chess Tournament 50
28:16
NULL sorting 50
22:32
I hate Vowels 50
25:06
Birthdays 50
16:52
Class Average 50
18:28
Tournament 2.0 50
25:11
Job Offer 50
22:29
Next And Previous 50
21:29
Advanced select
Problem Score Companies Time Status
Conditional Work 50
20:52
Role Ordering 50
27:12
Role Player 50
14:41
Role Counter 50
14:31
Vowel Country 50
13:53
Basic join
Problem Score Companies Time Status
Engineers Joined 50
24:22
Many Tables 50
20:12
Top Performer 50
26:52
Low and High Grades 50
21:24
Same Countries 50
21:15