Scribd
Upload
6 views2 pages

SQL Developer Internship Guide

The document outlines a SQL Developer Internship task focused on writing basic SELECT queries to extract data from tables using tools like DB Browser for SQLite or MySQL Workbench. It includes guidelines for using SQL commands such as SELECT, WHERE, ORDER BY, and LIMIT, along with interview questions to test understanding of key concepts like filtering and projection. Participants are required to submit their work via a GitHub repository by a specified deadline.

Uploaded by

vankalohitha01
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

SQL Developer Internship Guide

The document outlines a SQL Developer Internship task focused on writing basic SELECT queries to extract data from tables using tools like DB Browser for SQLite or MySQL Workbench. It includes guidelines for using SQL commands such as SELECT, WHERE, ORDER BY, and LIMIT, along with interview questions to test understanding of key concepts like filtering and projection. Participants are required to submit their work via a GitHub repository by a specified deadline.

Uploaded by

vankalohitha01
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL DEVELOPER INTERNSHIP

Task 3: Writing Basic SELECT Queries

Objective:Extract data from one or more tables.


Tools :DB Browser for SQLite / MySQL Workbench
Deliverables:SQL script with SELECT, WHERE, ORDER BY, LIMIT

Hints/Mini Guide:

1. Use SELECT * and specific columns


2. Apply WHERE, AND, OR, LIKE, BETWEEN
3. Sort with ORDER BY

Outcome: Clear understanding of how to retrieve data

Interview Questions:

1. What does SELECT * do?


2. How do you filter rows?
3. What is LIKE '%value%'?
4. What is BETWEEN used for?
5. How do you limit output rows?
6. Difference between = and IN
7. How to sort in descending order?
8. What is aliasing?
9. Explain DISTINCT.
10. What is the default sort order?

Key Concepts: Filtering, Projection

📤 Submit Here:
After completing the task, paste your GitHub repo link and submit it using the link below:
👉 [Submission Link ]
📌 Task Submission Guidelines
⏰ Time Window:
You can complete the task anytime between 10:00 AM to 10:00 PM on the given day. Submission link closes at
10 :00 PM
🔍 Self-Research Allowed:
You are free to explore, Google, or refer to tutorials to understand concepts and complete the task effectively.
🛠 Debug Yourself:
Try to resolve all errors by yourself. This helps you learn problem-solving and ensures you don’t face the same
issues in future tasks.
💸 No Paid Tools:
If the task involves any paid software/tools, do not purchase anything. Just learn the process or find free
alternatives.
📁 GitHub Submission:
Create a new GitHub repository for each task.
Add everything you used for the task — code, datasets, screenshots (if any), and a short [Link] explaining
what you did.
📤 Submit Here:
After completing the task, paste your GitHub repo link and submit it using the link below:
👉 [Submission Link ]

You might also like