Java, .NET, PHP, PYTHON, ANGULAR, ML, Data Science, Testing, CI Tutorials in Easy Languages.

"Best Software Training, Internship, Project Development center of Indore India, Helpline 780506-3968"

What is Database?


The database is used to store information permanently under database software using DBMS, RDBMS, and ORDBMS.

DBMS means Database management System:-     It is used to store data using file patterns, we can not establish a relationship between records.  means we can not create primary key and foreign key concepts .for example .xls,.xlsx, Foxpro, and the XML file is the example of DBMS.

RDBMS  Relational Database Management System:-   Using this we can store records using rows and tuples, which means using RDBMS we can establish a relationship between tables using primary key and foreign key.

MYSQL,ORACLE, MS-SQL,Sybase,IBM DB2.

SQL Language is used in the RDBMS pattern, SQL means Structured query language which provides a set of commands to perform the operation.

ORDBMS  Object-Relational Database Management System:-
Using this we can store records using Object Pattern similar to Object-oriented programming language.

ORACLE 12c,13,c.......   ORDBMS.


Cloud Database System:-

It is stored under cloud platforms, AWS, Window Azure, Heroku these are could platforms to provide readymade solutions to databases.


Software tools:-=

download XAMPP Server, it provides MYSQL  Console Editor and GUI Editor PHPMyadmin

How to open MYSQL Console Editor

First, go into c:/xampp/mysql/bin path and open command prompt from there and write the following Syntax to open MYSQL Console

mysql -u username -p password

e.g   mysql -u root -p 12345





Important Command-List Of SQL:-

Important Command List:-
1) Create Command:-
  
    it is used to create database and tables.

    create table tablename(columnname datatype,columnname datatype)


2)  Insert Command

     it is used to add record into table.

     insert into tablename(columnname1,columnname2) values('values1','values2');

3)   Update Command
 
     it is used to modify the record from tables.
     
     update tablename set columnname=columnname1, columnname=columnname2 where      columnname=value;   

4)   Delete Command
     it is used to delete the record from tables.
   
     delete from tablename where columnname=value.

5)   Select Command
     it is used to display the record from tables
      
     select * from tablename;
     select col1,col2 from tablename


6)   Alter Command:-

     it is used to add column in table.

     alter table tablename add columnname datatype;
      
     it is used to drop column from table
   
     alter table tablename drop column columnname

     it is used to rename columnname
 
     alter table tablename change oldcolumn  newcolumn datatype.

7)   drop commnad:-

     It is used to delete the table structure.
     drop table tablename.

8)   truncate command:-
     It is used to delete all rows from tables.

     truncate table tablename.
     
       

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 
Important Command List:-
1) Create Command:-
  
    it is used to create database and tables.

    create table tablename(columnname datatype,columnname datatype)


2)  Insert Command

     it is used to add record into table.

     insert into tablename(columnname1,columnname2) values('values1','values2');

3)   Update Command
 
     it is used to modify the record from tables.
     
     update tablename set columnname=columnname1, columnname=columnname2 where      columnname=value;   

4)   Delete Command
     it is used to delete the record from tables.
   
     delete from tablename where columnname=value.

5)   Select Command
     it is used to display the record from tables
      
     select * from tablename;
     select col1,col2 from tablename


6)   Alter Command:-

     it is used to add column in table.

     alter table tablename add columnname datatype;
      
     it is used to drop column from table
   
     alter table tablename drop column columnname

     it is used to rename columnname
 
     alter table tablename change oldcolumn  newcolumn datatype.

7)   drop commnad:-

     It is used to delete the table structure.
     drop table tablename.

8)   truncate command:-
     It is used to delete all rows from tables.

     truncate table tablename.
     
       

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 
Create:-  It is used to create a table

Create Table Tablename(Columnname dataytype,Columnname datatype,...);

Create Table Student(rno int,sname varchar(50));

Insert:-   Add record using rows:-

insert into Student(rno,sname) values(rno,sname);

Update:-  Update data of the particular row

update tablename set columnname=values ,columnname=values where columnname=value.

Delete:-  Delete data from row

delete from table name where columnname=value;

Select:-    to show record from the database

select * from tablename;

select * from Student;

select * from student where rno=100;






Post a Comment

POST Answer of Questions and ASK to Doubt

Previous Post Next Post