Rays Logo

Rays Edutech Pvt. Ltd.

Become Our Partner Certificate Verification Center Login Student Login
SQL Database Logo Rays


SQL (Structured Query Language) is the backbone of our education website, facilitating seamless communication with databases. It empowers us to efficiently manage, retrieve, and manipulate data, ensuring dynamic content delivery. Through SQL, we create and optimize queries, enabling users to access and interact with educational resources effortlessly. Its declarative nature streamlines data operations, fostering a robust and responsive learning environment on our platform. Embracing SQL enhances the educational experience by providing a solid foundation for data-driven decision-making and personalized user interactions.

Course Name Date & Time Take Demos
Advance Diploma in Computer Application with Taxation (ADCAT) 14/12/2023 View Details
Python Offer Batch 27/11/2023 View Details
Core JAVA(J2SE) 12/12/2023 View Details
C Language 11/12/2023 View Details
DS(Data Structure) 12/12/2023 View Details

Where it is used?


  • Life time validity (enroll one time and revise many times)
  • Interaction with the best faculty and Industry Experts
  • Small Batches to focus on each student
  • We focus on both theoretical and practical approaches in a parallel way.
  • You will be given the opportunity to work on a live project.
  • Outdoor activities to boost your confidence.
  • Presentation in class by the students.

Our Key Features:

  • Good Quality Material Notes
  • Smart Classes Available
  • Online Test
  • Chapter wise Assignments
  • Offline And Online Classes
  • Recorded class on Rays App
  • Eminent faculties of the IT Industry( Amazon, Wal-Mart, Oracle, Microsoft..)
  • Fully AC and Wi-Fi Campus.



  • Introduction to SQL
  • Advantages of SQL
  • Categorization of SQL

  • Create Command
    • To create an user
    • To create a table
  • Data type
  • Naming convention of table or column in SQL
  • Constraint/Restriction in SQL.
    • (a) null
    • (b) not null
    • (c)unique
    • (d) primary key
    • (e) check
  • Operators
    • (a) Relational / Comparison operators
    • (b) Logical operators
    • (c) Special operators
  • Foreign key restriction / constraints
  • On delete cascade restriction / constraints
  • Enabling / Disabling constraint
  • Alter command
    • Add clause
      • Add column into an existing table
      • Add constraints/restriction to an existing column
    • Drop clause
      • To drop constraints from an existing column
      • To drop column from an existing table
    • Modify clause
      • Modify a datatype/size of column
      • Change null type column into not null and vice versa
  • Drop command
    • To drop an existing user
    • To drop an existing table
  • Truncate command
  • Rename command

  • Insert command
    • (a) fixed / static method
    • (b) Dynamic method
  • Select command
    • (a) Select command with single table
      • Renaming column heading in query result
      • where clause
      • Operators with select statement
        • (a)Arithmetic operator
        • (b)Relational/comparison operator
        • (c)Logical operator
        • Special operator
      • About dual table
      • About pseudo column
        • -Level
        • -Rownum
        • -Sysdate
        • -Uid
      • Accepting a value interactively in query statement
      • Concatenation in SQL
      • Set operators with select statement
      • Aggregate function
      • Numeric function
      • Character function
      • Date function
      • Group by clause
      • Having clause
      • Order by clause
    • (b)Query based on multiple table
      • Joining in multiple table query
      • Types of joining
        • (i) Equi joinin
        • (ii) Natural joining
        • (iii) Self joining
        • (iv) Outer joining
      • Subquery / nested query
      • Types of subquery
        • >>Subquery introduce with unmodified comparison operator
        • >>Subquery introduce with
          • (a) modified comparison operator
          • (b) in and not in operator
          • (c) co- related query
        • >>Subquery introduce with exist or not exist
  • Delete command
    • Delete command used in single table
    • Delete command used in multiple table
  • Update command
    • Update command used on a single table
    • Update used on a multiple table

  • Create Command
    • Commit command
    • Rollback command
    • Grant command
      • Connect
      • Resource
      • DBA
    • Revoke

  • Creating views
  • Synonyms

Request A Demo!