This course is for all BCA/MCA/BSc.IT/B.Tech students who have SQL in their curriculum. (Syllabus may change to match with Student's requirement)
It covers the following major topics along with Two real-life database design projects
- RDBMS Introduction and Various databases
- Create, Insert, Logical Operators, Conditional Operators
- SQL Functions
- Group by / Order by operations
- Alter tables to modify the existing table structure
- Sub-queries
- Database constraints
- Joins
- Update and Delete data
- Database Views
- SQL for ORACLE/MS SQL SERVER/PostgreSQL etc.
- SQL/PLSQL/Stored Procedures,Functions/Database Triggers
- Access database in a Programming language like Java/C#/Javascript etc.
- Two database design projects
During the course, all examples and exercise are related mostly with IT industry so that the user can get a real-life idea about the actual use of the database.
Additionally, the tutor will also help to solve a student's college or classroom or project work-related queries.
The student will also get help in designing a database that is a part of his/her college project work.