Prerequisites
NA
Learning Objective
This training program will help participants to learn
- The concept of Database, tables, relationship between tables present in databse.
- Understand the basics of SQL.
- Perform data retrieval operations to execute execute SELECT statements to query data from single and multiple tables and using various clauses such as WHERE, GROUP BY, HAVING, and ORDER BY to filter and sort data
- Manipulate data to insert, update, delete records from tables.
- Manage database structure by creating and modifying database schemas with CREATE, ALTER, and DROP statements.
- Querying techniques using squbquery, joins, union etc.
- learn SQL functions such as aggregate functions ( COUNT, SUM, AVG) for summerizing data, Scalar functions (eg. UPPER, LOWER etc.) for data transformation.
- Develop practical skills by solving real-world problems by designing and implementing efficient SQL queries
Content Outline
Topics :
1. what is Database, tables, Relationships.
2. DBMS/RDBMS concept.
3. Constraints & its types
Lab
1. Lab session to demonstrate how to create database, tables. Followed by interactive discussion session.
Topics
1. what is SQL.
2.why it is widely used and important ?
3.What features makes it an indispensable tool for database management and data analysis.
Lab
1. Theoaratical concept & Installation Process. Followed by interactive discussion session.
Topics
1. What is Operators.
2. why operators are important in SQL.
3. Different types of Operators used in SQL. (detailed practical sessions on each operator)
Lab
1. These topics will be covered using practical examples with sample datasets
Topics
1. Aggregate function
2. Understand the concept of Grouping, having & where clause.
3. Understand the concept of Sorting.
4. Use of Distinct keywords
5. Aggregate function using Grouping
Lab
These topics will be covered using practical examples on sample datasets. This will also include all possible scenarios covered in Topic 3.
Topics
1. Different types of statements :
a) DDL – Data Definition Language – the various commands in DDL are :- Create, Drop, Truncate, Alter, Rename
b) DML – Data Manipulation Language – the various commands in DML are :- Insert, Update, Delete
c) TCL – Transaction Control Language – the various commands in TCL are :- Rollback, Commit, Savepoint
Lab
1. This concept will be explained by demonstrating a practical example of how to create a table, load data into it, and perform other operations such as updating and deleting.
2. Followed by interactive discussion session.
3. At the end of this module, an assignment will be shared to perform all the statements with datasets.
Lab
1. This session is entirely practical, and data will be provided to solve the challenges using subqueries.
2. Followed by interactive discussion session.
Topics
1. Join concept
2. Types of joins
3. Application of each join in real world.
Lab
1. Each join strategy will be explained using sample datasets. At the end of this session, they will be provided with real-time data to solve challenges using joins and other concepts explained in above topics.
Topics
All pre defined functions mentioned below will be covered:
1. GROUP functions
2. CHARACTER functions
3. NUMERIC functions
4. DATE functions
5. SPECIAL functions
Lab
1.Each functions will be covered using Sample Datasets.
Lab
1.Will explain this using pictorial representation and relationship with tables.
Will Solve the challenges using all the topics covered and will provide assigments at the end for practise