• STUDENT PROFILE
• Name :Vaja Rahul P.
• Enrollment no. :200040116008
• Branch : Information technology
• Domain : Python Developer
Under the guidance of : Prof. Riya Kaku
Department : Information Technology
Contact No. : 98259 18784
Email id : rdkaku@gardividyapith.ac.in
• Qspider Training Institute
• QSpiders is the world’s ace software training organization with an aim to
bridge the gap between the demands of the industry and the curriculum of
educational institutions.
• With centers across the Globe, the institute is a platform where young
minds are given the opportunity to build successful careers.
”QSpiders is a place where businesses find talent and dreams take flight.“
161728 Placed Students who have graduated in IT/CS/IS
Address : No. 5th & 6th Floor, Peninsula Plaza Between Stadium Circle & Swastik Cross Road, Chimanlal
Girdharlal Rd, Ahmedabad, Gujarat 380009
• Company Layout
• Work plan
• Week 1 : 20 January 2025
Day 1 : Introduction to SQL and Databases
• I learned the basics of SQL, including its importance in managing databases.
• We covered DBMS (Database Management System) and RDBMS (Relational Database
Management System) concepts.
• I also explored different types of DBMS such as hierarchical, network, and relational DBMS.
• The session included a brief history of SQL and how it evolved over time.
• We also discussed the relational model and how data is organized into tables, with relationships
between them.
Day 2 : Understanding SQL Data Types
• I gained a deeper understanding of SQL data types.
• Topics covered included CHAR, VARCHAR, PRECISION, SCALE, DATE, TIMESTAMP, ad others.
• We discussed when to use each type, with examples to clarify their differences.
Day 3 : Constraints and Keys in SQL
• I learned about various SQL constraints such as UNIQUE, NOT NULL, CHECK, PRIMARY
KEY, FOREIGN KEY, AUTO INCREMENT, BOOLEAN, and DEFAULT.
• The instructor provided examples for each to demonstrate how they help ensure data integrity.
Day 4 : SQL Overflow, DDL, and DML
•We explored the concept of SQL overflow and how it can affect data management.
•I learned about Data Definition Language (DDL) commands: CREATE, RENAME, ALTER, DROP, and
how they manage database structures.
•We also covered Data Manipulation Language (DML) commands: INSERT, UPDATE, DELETE, with
practical examples.
•The session included an introduction to Transaction Control Language (TCL), focusing on commands like
COMMIT, ROLLBACK, and SAVEPOINT.
•Finally, we touched on Data Query Language (DQL) and how SELECT and various types of joins are used
in SQL.
Day 5 : SQL Query Writing Practice
•I learned about the FROM clause, which marks the beginning of query execution.
•We focused on writing SELECT queries and how to structure them effectively.
•We had office practice where I wrote queries and completed a task based on the concepts learned so far.
• Week 2 : 27 January 2025
Day 6 : Assignment & Query Practice
• Worked on an assignment to practice SQL queries, applying learned concepts to improve query-
writing skills through hands-on examples.
• This gave me an opportunity to apply what I learned and improve my skills through practical
examples.
Day 7 : SQL Aliases and Distinct Clause
• I studied how to use aliases and the DISTINCT clause in SQL queries.
• The examples helped me understand how aliases make queries more readable and how
DISTINCT is used to eliminate duplicate records.
Day 8 : SQL Selection, Where Clause, and Assignment
• I learned about the WHERE clause and how to filter data based on conditions.
• We also explored literals in SQL and how they are used in queries.
• Another assignment was given to practice these concepts further.
Day 9: SQL Joins & Aggregation
• Learned different types of joins (INNER, LEFT, RIGHT, FULL) and how to combine data from
multiple tables. Practiced aggregate functions like SUM, AVG, and COUNT.
Day 10 : Subqueries & Nested Queries
• Understood how to write subqueries and nested queries to retrieve data efficiently. Applied them in
practical scenarios to optimize complex queries.
THANK YOU!!
