Duration: 40 Days [1.5 Hours/Day]
Eligibility: 10th Passed
Advance SQL Course Syllabus
Fill this information
- Introduction to RDBMS-:Introduction to RDBMS, The Role of data, DBMS Concepts, Relational Model, RDBMS & SQL Server, Designing a database, Entity relationship model/diagram, Tables.
- Introducation to SQL-:What is SQL, why SQL, working with MySQL & SQL Server , SQL Server Architecture, Client/Server database system.
- Basic Query-:How to create / Drop database & Table, Datatypes in SQL,Select, Insert, delete, Update & alter.
- Operator & Functions-:Working with Operator in SQL Query, Distinct , Between , Limit Keyword, auto increament, Using Aggregate functions in Queries, String Function in Queries.
- Managing Tables and Joins-:Primary key,Foreign Key , Introduction to joins, types of join- inner join, outer join, self join & Join Relationship and Union.
- Various Clause-:Where, Like, Order By, Group By , execute sql queries with various clause.
- Index & Views-:what is index , create index, what is views, update view & droping views.
- Implementing Stored Procedures-:Introduction to variables, Stored Procedures, Defining Stored Procedures, Executing Stored Procedures, Using Parameters in Stored Procedures.
- Implementing Triggers-:What is Triggers,Types of Triggers, Creating Triggers, Benefits & Limitations, Triggers and Performance.
- TCL Commands & Database Backup & Restore-:Commit, Rollback, Savepoint SQL commands, Backup & Restored in SQL.
- Case study in SQL -:case study with big data.
