SQL Training Course Syllabus

complete-sql-training-course-in-rishikesh

SQL Training Course Details

  • RDBMS Concepts

    Introduction to RDBMS, The Role of data, DBMS Concepts, Relational Model, RDBMS & SQL Server, Designing a database, Entity relationship model/diagram, Tables
  • Introduction

    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, Data types in SQL,Select, Insert, delete, Update & alter
  • Operator & Functions

    Working with Operator in SQL Query, Distinct , Between , Limit Keyword, auto increment, 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 & drop 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

Course Duration

01 Months ( 2 Hour Daily )
02 Months ( 1 Hour Daily )

Eligibility

10th Qualified

Advertisement


Tags

SQL Course
SQL Training Course
SQL Training Course in Rishikesh
SQL Course in Rishikesh
CTTC Course in Rishikesh
DCA in Rishikesh
Computer Courses in Rishikesh
Computer Centre in Rishikesh
Computer Institute in Rishikesh
Computer Coaching in Rishikesh