Database basics and sql commands part - 1

what is Database ?

I have student data

Sort it according to the city name

1. I want to find all students belong to same city say pune
2. find some student some brilliant students who have marks greater tha 80%
3. find all student whose name starts with letter A
4. find students who joined on or before some specific date

databse is a solution

i should have my data properly structured and kept some where

SQL - Structural Query language

we have a database has tables

-----------------------------------
SQL commands

1. show databases;

2. create database dbName;

3. select database

use dbName;

4. create table in the database;

create table tableName (rno int,name varchar(10) ...)

datatype variableName;
int rno;

5. to see the structure of your table

desc tableName;

6. to see the records in the table

select * from tableName ;

7. to insert records in the tables

insert into tblName value (val1,val2,......)

-----------------------------------------

different versions of select command

1. when you use * all the colums are displayed, but if you just want to show any specific colum (1 or more) then use below command

select col1,col2,col3 from tablename

2. select rno as student_no,name as student_name,marks as percentage from student

This command helps you to change the representational name of a column


select command with where clause

syntax : select * from student where condition



mysql-

For automation testing training (Online) - selenium + cucumber with java
call / WhatsApp: 9529802751(kalyani), 9657852251 (Amol)

To enroll for free demo classes click here :
https://scriptinglogic.org/enroll-selenium-cucumber/

Important links

tutorials : https://scriptinglogic.com
course Portal : https://scriptinglogic.in

Manual testing Playlist : https://lnkd.in/dXZWu7N
Core Java Playlist : https://lnkd.in/dbybFEk

Visit :https://scriptinglogic.org

Get my book on Amazon : https://amzn.to/2PuMOCK
(Practical Approach of Software Testing)

My socal links
Facebook:
https://www.facebook.com/amol.ujagare

Instagram :
https://www.instagram.com/aujagare

LinkedIn
https://www.linkedin.com/in/amolujagare

Twitter ;
http://twitter.com/amolujagare