DATABASE & SQL/PLSQL

adplus-dvertising
Introduction (SQL)
Previous Home Next
                                                                              
  1. DDL (Data Definition Language)

  2. DML (Data manipulation language)

  3. DCL  and TCL

  4. Displaying Rows Using Logical & List Operators

  5. Displaying Rows Using Comparison & Range Operators

  6. Displaying Rows Using String Operator

  7. IS NULL and IS NOT NULL keywords & ORDER BY Clause

  8. Limits the rows by using

  9. TOP keyword & DISTINCT keyword

  10. Using Aggregate Functions

  11. Using GROUP BY Clause

  12. Using COMPUTE BY Clause

  13. Using String Functions

  14. DATE Functions

  15. Mathematical Functions

  16. Some System Functions

  17. Joins  

  18. Inner Join   

  19. Outer Join

  20. Cross Join

  21. Equi Join

  22. Natural Join

  23. Self Join

  24. Sub queries with EXITS Clause

  25. Queries with modified Comparison Operators

  26. Extracting Data Into Another Table

  27. Using UNION Operator

  28. How to create a Data Base in SQL server

  29. .mdf, .ndf and .ldf extension files

  30. Viewing, Renaming and Deleting a Database

  31. Data Integrity

  32. Creating Constraints

  33. PRIMARY KEY Constraint

  34. The UNIQUE Constraint

  35. The FOREIGN KEY Constraint

  36. The CHECK Constraint

  37. The DEFAULT Constraint

  38. INDEXES

  39. CLUSTERED Index

  40. NONCLUSTERED Index

  41. How to Create an Index

  42. Programming in SQL Server

  43. The IF...ELSE Statement and BEGIN...END Statement

  44. The CASE statement and WHILE statement

  45. Stored Procedures

  46. How To Create Stored Procedure

Previous Home Next