Learn SQL with me

introduction to SQL

SQL stands for "structure query language" and be pronounced as "SQL" OR "SEQUEL". It is a special purpose language used to define , and manipulate data in RDBMS. SQL provides a set of statements for storing and retrieving data to and from a relational data base . The original version called SEQUEL(Structure english query language) was designed by IBM in mid 1970, SQL was first introduce as commercial database system in 1979 by Oracle corporation

Comments

Post a Comment

Popular posts from this blog

UNIT-I Data structure

Note:-please watch this blog in desktop mode. Below provide are links 1.Data Structure and it's types 2.Algorithm,Pseudocode, Flow-chat 3.Single-Dimensional Array 4.Two-dimensional Array 5.Multi-Dimensional-Array   6.Stack 7.Notations For Arthamati Expression 8.Converting Infix expression to postfix Is Comment:-Remaining question well be posted as soon as possible.
Read more

Infix to postfix converstion

  Infix to Postfix Conversation  Procedure :- 1.Scan the infix string from left to right . 2.Initialise an empty stack  3.If the scanned character is an operand,add to the postfix string . 4.If the scanned character is an operator, and if the stack is empty push the character to stack. 5.Repeat 4 steps till the characters are scanned. 6.After all characters are scanned, we have to add any character that the stock may have to the postfix string . 7.If stock is not empty add Top stack to postfix string and pop the stack. 8.Repeat the steps as long as stack is not empty. Conversation Infix to Postfix Ex:- (a+b)*(c-d) in put out put (a+b)*(c-d) (+b)*(c-d)  b*(c-d) *(c-d) *(-d)  *(-) * Empty -  a a+ ab+ ab+c ab+cd ab+cd- ((ab+)(cd-))
Read more

Data structure

Image
  Definition :- Allocating of data elements in Computer memory and retrieving data elements from computer memory is called data structures. How many ways we can organise the data elements in Computer memory.  How many ways we can retrieve in the data elements (called retrieving )from computer memory. Data Structure is a way of collection and organising data in such a way that we can perform operations on this data in an efficient way .So ,that verious operations can be performed on it easily. →Data structure mainly classified into two types.  Linear data structures   Non-linear data structures 1]Linear data structure :- In this element formed in an organised sequence. i.e ,elements are organised in sequential order . Ex:-Array,stock ,queue ,linked list Arrays :- An   array is a data structure that contains a group of elements typically these elements are all of the same datatype . Such as an integer or string array are commonly used in computer pr...
Read more