SQL Course Curriculum

SQL Course Curriculum

  • SQL Overview
    1. SQL-Introduction
    2. SQL-RDBMS Concepts
    3. SQL-Databases
    4. SQL-Syntax
    5. SQL-Datatypes
    6. SQL-Operators
    7. SQL-Expressions
    8. SQL-Create Database
    9. SQL-Drop Database
    10. SQL-Select Database
  • Data Definition Language(DDL)
    1. SQL-Create Table
    2. SQL-Alter Table
    3. SQL-Drop Table
    4. SQL-Constraints
    5. SQL-Not Null Constraint
    6. SQL-Unique Constraint
    7. SQL-Primary Key Constraint
    8. SQL-Foreign Key Constraint
    9. SQL-Check Constraints
    10. SQL-Index
    11. SQL-Auto Increment
    12. SQL-Dates
    13. SQL-Views
  • Data Manipulation Language(DML)
    1. SQL-Insert record into a table
    2. SQL-Update record into a table
    3. SQL-Delete record from a table
  • Data Query Language(DQL)
    1. SQL-What is Query ?
    2. SQL-Select Statement
    3. SQL-Select Distinct
    4. SQL-Where Clause
    5. SQL- And, Or, Not
    6. SQL- OrderBy Clause
    7. SQL-Select Top
    8. SQL-Min and Max
    9. SQL-Count, Avg, Sum
    10. SQL-Like
    11. SQL-Wildcards
    12. SQL-In, Between , Aliases
    13. SQL-Joining
    14. SQL-Inner Join
    15. SQL-Left Join, Right Join and Full Join
    16. SQL- Self Join
    17. SQL- Union, Group By, Having
    18. SQL-Exists
    19. SQL-Any, All
    20. SQL-Null Functions
  • Transaction Control Language
    1. SQL-Transaction Overview
    2. SQL-Database Security
    3. SQL-Injection

Contant Us

0674-2361252
9439202111

SQL Projects


Warning: include(D:\WebHosting\silansoftware.com\application\views\errors\html\error_php.php): failed to open stream: No such file or directory in D:\WebHosting\silansoftware.com\system\core\Exceptions.php on line 268

Warning: include(): Failed opening 'D:\WebHosting\silansoftware.com\application\views\errors\html\error_php.php' for inclusion (include_path='.;C:\php\pear') in D:\WebHosting\silansoftware.com\system\core\Exceptions.php on line 268

Warning: include(D:\WebHosting\silansoftware.com\application\views\errors\html\error_php.php): failed to open stream: No such file or directory in D:\WebHosting\silansoftware.com\system\core\Exceptions.php on line 268

Warning: include(): Failed opening 'D:\WebHosting\silansoftware.com\application\views\errors\html\error_php.php' for inclusion (include_path='.;C:\php\pear') in D:\WebHosting\silansoftware.com\system\core\Exceptions.php on line 268