SQL/MYSQL Training In Pitampura Delhi

 

  •   SQL/ MySQL (Database )
    • DATABASE MGMT. SYSTEM (DBMS)
    • DBMS TERMINOLOGIES
    • RELATIONAL DATABASE
    • Introduction to SQL/MySQL
    • SQL DATA TYPES
    • INTEGRITY CONSTRAINTS
    • CREATING TABLES BASED ON INTEGRITY CONSTRAINTS
    • INSERT, UPDATE, DELETE
    • SELECT COMMAND
    • WHERE (RETRIEVAL OF SELECTED ROWS)
    • WORKING WITH EXPRESSIONS
    • CHECKING MULTIPLE CONDITIONS (AND, OR, NOT OPERATOR)
    • EXISTS, NOT EXISTS
    • BETWEEN, NOT BETWEEN
    • ARRANGING RECORD (ORDER BY)
    • DISTINCT CLAUSE
    • WORKING WITH NULL VALUES
    • SQL FUNCTIONS
      • AGGREGATE FUNCTIONS
      • ARITHMETIC FUNCTIONS
      • CHARACTER/STRING FUNCTIONS
      • DATE FUNCTIONS
    • GROUPING RESULTS (GROUP BY)
    • PLACING CONDITIONS ON GROUPS (HAVING CLAUSE)
    • TABLE ALIASES
    • JOINS
      • MULTI-TABLE JOINS
      • EQUI JOIN
      • CARTESIAN JOIN
      • OUTER JOINS
    • UNIONS IN SQL
    • INDEXES IN SQL

Quick Contact

Are You Looking For SQL/MYSQL Training ?
Open chat