Scribd
Upload
8 views2 pages

SQL Developer Internship Guide

The document outlines a SQL Developer Internship task focused on data insertion, updating, and deletion, requiring the use of SQL statements. It includes guidelines for handling NULL values, a list of interview questions related to SQL concepts, and submission instructions for a GitHub repository. The task emphasizes self-research, debugging, and the use of free tools, with a specific submission time window.

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
8 views2 pages

SQL Developer Internship Guide

The document outlines a SQL Developer Internship task focused on data insertion, updating, and deletion, requiring the use of SQL statements. It includes guidelines for handling NULL values, a list of interview questions related to SQL concepts, and submission instructions for a GitHub repository. The task emphasizes self-research, debugging, and the use of free tools, with a specific submission time window.

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 2 : Data Insertion and Handling Nulls

Objective: Practice inserting, updating, and deleting data.


Tools :DB Fiddle / SQLiteStudio
Deliverables: SQL file with INSERT, UPDATE, DELETE statements

Hints/Mini Guide:

1. Use INSERT INTO for adding rows


2. Handle missing values using NULL or default
3. Use UPDATE and DELETE with WHERE conditions

Outcome: A populated database with clean and consistent data

Interview Questions:

1. Difference between NULL and 0?


2. What is a default constraint?
3. How does IS NULL work?
4. How do you update multiple rows?
5. Can we insert partial values?
6. What happens if a NOT NULL field is left empty?
7. How do you rollback a deletion?
8. Can we insert values into specific columns only?
9. How to insert values using SELECT?
10. What is ON DELETE CASCADE?

Key Concepts: DML, Null handling

📤 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