Software Lab
SQL Lab › Playground

SQL Playground

Write and run real SQL. The database runs locally in your browser.

Results
Run a query to see results.

Indexes

BENEFIT

البحث يصير أسرع. بدون index قاعدة البيانات تمر على كل الصفوف. مع index تذهب مباشرة إلى الصفوف المطابقة.

DOWNSIDE

كل INSERT أو UPDATE أو DELETE يحدّث الـ index أيضًا، فالكتابة تصير أبطأ والـ index يأخذ مساحة إضافية. لا تضفه على عمود نادر الاستخدام.

Missions › SQL

SQL Missions

Complete the challenges to test your skills.

XP 0
MISSION 01+100 XP

Find the administrators

Write a query to find all users with the role 'admin'.

Investigation › Incident #1042

Incident #1042

Multiple failed login attempts were detected overnight. Use SQL to investigate what happened.

SECURITY ALERT

You are the junior security analyst. Identify the suspicious account, source IP, number of attempts, and last successful login.

01Identify the suspicious account.
02Find the source IP address.
03Determine how many failed attempts occurred.
04Find the last successful login.
05Write a short incident summary.