RDBMS – RDBMS full form is Relational Database Management Systems. It forms the basis for SQL, DB2, Oracle etc. It is based on the relational model defined by E.F.Codd Table in SQL In RDBMS, the organization of data is in the form of tables. A table is a collection of related data entities and is an …
SQL is a database language that has commands to create, manipulate etc the database. All the commands can be broadly classified into following categories: DDL Commands DML Commands DCL Commands TCL Commands DDL(Data Definition Language) Commands: Data Definition Language commands in SQL are used to define the database schema. These commands deal with description of …
SQL DDL,DML,DCL,TCL COMMANDS – Free SQL Tutorial Read More »
SQL Aggregate functions are described in this article. SQL functions are like average , sum , count , first last etc. SQL Aggregate functions Consider the following Student table with ID, Marks, Age,Name as columns. +—-+——-+—–+———–+ | Table Name – Student | +—-+——-+—–+———–+ | ID | MARKS | AGE | NAME | +—-+——-+—–+———–+ | 1 …
SQL Aggregate Functions – Free Tutorial and Online Training Read More »
In SQL, there are a lot of library functions used while working with Date in Databases. The given below are the list of SQL date functions along with examples. SQL Date Functions NOW(): NOW() function returns the current date and time of the system. Example: Query: Select NOW (); Result: 2018-14-21 15:08:05 CURDATE(): CURDATE() functions …
SQL Date Functions – Free Tutorial and Online Training Read More »
In SQL, there are various data types for string like VARCHAR, CHAR, RAW, VARCHAR2 etc. But, when the SQL character functions are used, the output data type is VARCHAR2. SQL Character functions It can be broadly classified into two categories: Case Manipulation functions Character Manipulation functions Case Manipulation Functions in SQL : LOWER(): LOWER() returns …
SQL Character Functions – Free Tutorial and Online Training Read More »