SQL & Peoplesoft tutorials

Powered by Blogger.
  • Home
  • Peoplesoft Architecture
    • Internet Architecture
    • 2-tier
    • 3-tier
    • N-tier
  • Installations
  • Issues
  • Jenkins
  • AWS
  • How to?

Interview Questions


Share This:
Facebook Twitter Pinterest Linkedin
Newer Post Older Post Home

SQL Topics

  • SQL - Introduction
  • ACID Property
  • DBMS vs RDBMS
  • Codd's 12 Rules
  • Data Normalaization
  • Data Definition Language
  • Data Manipulation Language
  • Data Control Language
  • Transaction Control Language
  • Diff b/w Delete,Drop,Truncate
  • Order by
  • SQL - Having
  • SQL - Grouy by
  • SQL - Single-row-functions
  • SQL - Character Functions
  • SQL - Number Functions
  • SQL - Date Functions and Operators
  • SQL - Joins

Recent Posts

Archives

Search This Blog

Labels

How to? Installations Interview Questions Issues Migration Patch SQL

Popular Posts

  • Data Manipulation Language (DML) commands:
    Data Manipulation Language (DML) commands:   DML is abbreviation of Data Manipulation Langua...
  • Codd's Rule for RDBMS
    Codd's Rules: E.F Codd was a Computer Scientist who invented Relational model for Database management. Based on relational model, Re...
  • Diff b/w Delete, Truncate, Drop
    DELETE Deletes some or all rows of a table It is DML Commited Uncommitted deletes can be rolled back Yes, DELETE triggers fired ...
  • Number Functions | Round, Trunc , Mod, Power, Cos, Tan, Sqrt
    Number functions Number functions accept numeric input and return numeric values. This section describes some ofthe number functions. ...

Recent Posts

Created By OmTemplates | Distributed By Blogger Template