Aleena Bagwan

  PARTS OF SPEECH   TENSES   HELPING VERBS

Open SQLPLUS from CMD and type following credentials username: system password: akbar123 Or else type following command in CMD or RUM prompt sqlplus /  as  sysdba Example: How to create a table name "student" CREATE TABLE student(  id NUMBER,  firstname VARCHAR2(40),  fathername VARCHAR2(40),  surname VARCHAR2(40),  class NUMBER,  address VARCHAR2(50) ); Example: How to insert the new students records INSERT INTO student(id, firstname, fathername, surname, class, address)  VALUES(101, 'Aleena', 'Akbar', 'Bagwan', 7, 'Mumbai'); INSERT INTO student(id, firstname, fathername, surname, class, address)  VALUES  (102, 'Aliza', 'Akbar', 'Bagwan', 5, 'Mumbai'); INSERT INTO student(id, firstname, fathername, surname, class, address)  VALUES  (103, 'Alishba', 'Akbar', 'Bagwan', 0, 'Mumbai'); INSERT INTO student(id, firstname, fathername, surname, class, address)VALUES  (104, 'Dibyanka...

RDBMS (Database) software are used to store the data. Formally known RDBMS (Relational Database Management System) Informally known Database     1) MySQL 2) Oracle 3) Sybase 5) Postgre and there are many more SQL (Structure query langauge) is used to to work around these RDBMS or Database SQL is pronounced as "sequel" Q: write a SQL to select all student ? SELECT * FROM student; Q: write a SQL to select only firstname of all students ? SELECT firstname FROM student; Q: write a SQL to select only surname of all students ? SELECT surname FROM student; Q: write a SQL to select only firstname and fathername of all students ? SELECT firstname, fathername FROM student; Q: write a SQL to select all students whose fathername is "akbar" ? SELECT * FROM student WHERE fathername = "akbar"; Q: write a SQL to select all students whose class is graeter than or equal to 5 ? SELECT * FROM student WHERE class >= 5; Q: write a SQL to insert a new student record ? INSERT...

don't read successful stories , you will only get message. Read failure stories , you will get some ideas to get success a.p.j. abdul kalam

Few softwares you need DOWNLOAD, INSTALL and CONFIGURE (e.g. Java) Few softwares you need DOWNLOAD, INSTALL (e.g.Notepad++) Few softwares you need DOWNLOAD (e.g. Anydesk)

EVERY NEW DAY     IS ANOTHER CHANCE TO CHANGE YOUR LIFE   THANK YOU 😄

KB = Kilo Byte MB = Mega Byte GB  = Giga Byte TB = Tera Byte PB = Petra Byte 1024 Bytes = 1 KB 1024 KB = 1 MB 1024 MB = 1 GB 1024 GB  = 1 TB 1024 TB = 1 PB --------------------- Computer can understand only Binary (0 or 1) 1 byte = 8 bit (bit is either 0 or 1)