Scribd
Upload
8 views2 pages

SQL Developer Internship: Creating Views

The document outlines a SQL Developer Internship task focused on creating and using views, emphasizing the importance of data abstraction and security. It includes guidelines for task completion, interview questions related to views, and submission instructions for a GitHub repository. The objective is to understand reusable SQL logic through practical application and self-research.

Uploaded by

shanne724
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: Creating Views

The document outlines a SQL Developer Internship task focused on creating and using views, emphasizing the importance of data abstraction and security. It includes guidelines for task completion, interview questions related to views, and submission instructions for a GitHub repository. The objective is to understand reusable SQL logic through practical application and self-research.

Uploaded by

shanne724
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 7:Creating Views

Objective: Learn to create and use views


Tools :DB Browser for SQLite / MySQL Workbench
Deliverables: View definitions and usage examples

Hints/Mini Guide:

1. Use CREATE VIEW with complex SELECT


2. Use views for abstraction and security

Outcome: Understand reusable SQL logic

Interview Questions:

1. What is a view?
2. Can we update data through a view?
3. What is a materialized view?
4. Difference between view and table?
5. How to drop a view?
6. Why use views?
7. Can we create indexed views?
8. How to secure data using views?
9. What are limitations of views?
10. How does WITH CHECK OPTION work?

Key Concepts: Views, Data Abstraction

📤 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