The Department of Computer Application in Association with Integral University Center for Advanced Training, Integral University, Lucknow organized two-day workshop on ‘SQL from Scratch’ for the MCA 1st Year students. The Two-day workshop, with 4-hours of active engagement, was organized from 27th May to 28th May 2022 in face-to-face mode using white board and projector of CA Smart Class.
For advertisement, we have created a banner and circulated the same on student’s whatsapp groups and released a notice on departmental notice board with the complete details about this workshop along with the registration link. Total 87 students registered the workshop and 57 students have attended the workshop and received an e-Certificate. One batch was created to start the course and we have scheduled workshop session on Friday in evening time and on Saturday it was scheduled in the morning time to deliver the face-to-face sessions with daily assignments, self-learning materials, collaborative learning through discussion forums & groups. The entire workshop sessions of the batch were successfully delivered by Mr. Farooq Ahmad (Assistant Professor, Department of Computer Application and Coordinator, IUCAT).
Learning skills of the students were excellent. They attended the workshop with full dedication and clarified their doubts and queries during the interactive sessions of this workshop. Total 57 students successfully attended the workshop and received an e-Certificate. The distribution of e-Certificate was based on student’s attendance and submitted assignments. SQL (Structured Query Language) is a domain-specific programming language designed for managing data held in a relational database management system (RDBMS). It enables you to access and manipulate databases.SQL is used to interact with the database. In every business, the core and essential part is management of data. On data various CRUD operations is performed such as Create, Read, Update and Delete.
Data is a very important part of application client can perform CRUD (Create, Read, Update and delete) operation. A database is a systematic approach to storing the data. Data is created by using SQL. In Database, data is in tabular format such as rows and columns. SQL has DDL (Data Manipulation language). DDL commands are used to create, alter, modify database objects, add a constraint, remove the constraint and modify the constraint for that we use Create, alter, modify, truncate and drop. Another SQL command s is DML (Data Manipulation Language). These commands are used to insert, update and delete data from the database.DML commands are insert, update and delete. DCL (Data control language) is used to access privileges to the user. DCL commands grant and revokes which give specific access to the user and remove access for a database object. TCL (Transaction Control Language) is used to manage the transaction with the database. TCL commands are commit rollback and save point.SQL select query is used to get back data from the database based on what query performs. The select query has various clauses such as from, where, group by and having. We can perform various advance data selection techniques such as including INNER JOIN, LEFT JOIN, Subquery, and UNION.SQL has built-in functions while we fetch data from the table such as string function, math/number function, and date function.Leaning of SQL programming is essential and important skills for beginners to make a career in IT as well as experience to enhance the skills for better opportunities. SQL is a basic skill set for IT industry; it helps in functional, support and technical consultant.SQL knowledge is implemented in Data mining various SQL queries are used. In Data collection SQL is used to collect data from different sources and combine data to perform an operation. Big data tool like Sqoop, Apache, Hadoop require SQL proficiency. Hence SQL programmer’s demand is huge hence learning SQL is an important skill.
After completion of the workshop sessions, there was a questionnaire session in which students cleared their doubts with the expert. More than 85 students from the Department of Computer Application have participated in the Workshop. Students learned about the simple and advanced SQL used in database applications programming and explored SQL applications during the workshop.
The Workshop was organized by Department of Computer Application in association with Integral University Center for Advanced Training under the able guidance of Dr. Mohammad Faisal, HOD, Department of Computer Application, Integral University, Lucknow and was coordinated by Mr. Farooq Ahmad (Assistant Professor, Department of Computer Application and Coordinator, IUCAT).
Key Highlights of the training:
-
It was a face-to-face interactive learning workshop.
-
Total 87 students registered to the workshop.
-
57 students successfully attended the workshop and received an e-Certificate.
-
Two-day workshop, with 4-hours of active engagement consisting of self-learning materials, collaborative learning through discussion forums & groups.
-
Learning support by Resource person and Facilitators.
Content delivered during the workshop:
• Introduction to SQL and its development environments
• SQL data types and literals
• Types of SQL commands
• SQL Operators and their Procedure
• Add New Rows to a Table
• Change the Data in a Table
• Use the DELETE and TRUNCATE Statements
• List the capabilities of SQL SELECT statements
• Use arithmetic expressions and NULL values in the SELECT statement
• Invoke Column aliases
• Concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Display the table structure using the DESCRIBE command
• Write queries with a WHERE clause to limit the output retrieved
• Describe the comparison operators and logical operators
• Describe the rules of precedence for comparison and logical operators
• Usage of character string literals in the WHERE clause
• Write queries with an ORDER BY clause
• Sort the output in descending and ascending order
• Apply the NVL, NVL2 functions to data
• List the differences between single row and multiple row functions
• Manipulate strings using character functions
• Manipulate numbers with the ROUND, TRUNC, and MOD functions
• Usage of the aggregation functions in SELECT statements to produce meaningful reports
• Describe the AVG, SUM, MIN, and MAX function
• How to handle Null Values in a group function?
• Divide the data in groups by using the GROUP BY clause
• Exclude groups of date by using the HAVING clause
• Use of HAVING clause
• Write SELECT statements to access data from more than one table
• Join Tables Using SQL
• View data that does not meet a join condition by using outer joins
• Join a table to itself by using a self join
• Create Cross Joins
• Use a Subquery to Solve a Problem
• Single-Row Subqueries
• Group Functions in a Subquery
• Use a SET operator to combine multiple queries into a single query
• Describe the UNION, UNION ALL, INTERSECT, and MINUS Operators
• Use the ORDER BY Clause in Set Operations
Glimpses of Workshop:
