SQL

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