SQL Bangla Tutorial .pdf

File information


Original filename: SQL Bangla Tutorial.pdf
Title: 6.SQL bangla tutorialsMicrosoft Word - 6.SQL bangla tutorials.docxMicrosoft Word - 6.SQL bangla tutorials.docx
Author: Hridoy

This PDF 1.6 document has been generated by PDFCreator Version 0.9.8 / GPL Ghostscript 8.64, and has been sent on pdf-archive.com on 09/05/2013 at 04:44, from IP address 180.234.x.x. The current document download page has been viewed 15980 times.
File size: 275 KB (16 pages).
Privacy: public file


Download original PDF file


SQL Bangla Tutorial.pdf (PDF, 275 KB)


Share on social networks



Link to this file download page



Document preview





e u (SQL)

o

SQL


o

SQL

o
o

SQL s n


o



o
o

i (Insert)
p i

o



o
o

(Query)
WHERE

o

QUERY IN

o
o

SQL Join
Left Join

o

Right Join



u | ( Dat abase t ut or i al i n Bangl a)
:
я

o i ! a #। e %& ' ( e ) e ( e
* %&' я ) + u
i я + ' , , o -#* . d я
।' + e 0 o i ) , я , я + t + t -# - , 2 - i ' 0
& -# e 3 ( ,3 ,яn ,+3n i # ( , ei -#* 2 6 k 3 e ) ( u
u+ k a- i i i # (
k (
2 ) 3 *
i i i я e 6 -# ( , я ।e e я* + , ) e 0
,e - -# o + я ( i # (।
eя # ( 3 2 o # * e 2 o # RDBMS (Relational Database
Management Software) e MySQL database software ( , (
e o i # : , c।e3 < o 3 ORACLE,SQL Server,MS ACCESS i # (।i c e* o
= + я e = ' ' - o = - o । ) ( MySQL = + , e* =
>n я + । ) MySQL e 6 ORACLE e n p e i,20/25% + - #।

e u u u - %& ( SQL Tut or i al i n Bangl a)
:
яo

SQL=Standard Query Language(uc k e k ess-cuell) e 6 a n (query)я #

e e = k= # 6* я.ei # 6* я ( ) s +
(Manipulate) e 6 a#
+ ) -MySQL,SQL Server,Oracle i # (। e 4thgeneration language. e +! G p g 6
# 6* я s
+ ) loop,branch.
e+ & e u , MySQL Dat abase a0 1 2 3 %& 4 ।

e u , 1
e )
)
Query )
- )
J )
+ )
) i # (

1 e u 5 + 6r &
:
я

XAMPP Control Panel - Apache e 6 MySQL
+ b uя e e L
http://localhost/xampp/ 2
e e (
Tools e a' phpMyadmin e k


e ) ui n 0 e - MySQL - = 3 i + ।ei ui n +
(
phpMyAdmin e u+ k ।e e 0 & я , ei ui n - + u ( k
, 3 , J i + + = e ), + n e я* )

,
e + +ei
+ skp ' , ।
e ) ui n (
-e e u # u+ k ।

e u # k + e k e i SQL n , ।

e u s 5 u ( SQL St at ement Tut or i al i n Bangl a)
:
я

= * я e u s n e d ) । )
e u s n 0 ( friends e
k , ।
SELECT*FROM friends
e u n case sensitive a- : ‘select*from friends’e 6 SELECT*FROM friends ( i e
я o u + , ।
SQL DML o DDM
e u di = 1
DDL-Data Defination Language:e ( , i # ( , ।index(keys) G , ,( 0
'# 6 ) * , , '# constraints R ( , i # (।* t+! DDL statement * ,
CREATE DATABASE- ,
ALTER DATABASE- m ( ,
CREATE TABLE- ,

ALTER TABLE- m ( ,
CREATE INDEX- INDEX ,
DROP INDEX- INDEX 3 )
DML-Data Manipulation Language
Query (a n ) e 6 update SQL e DML a6= ( , ।
SELECT- -
UPDATE- + (, * ()
DELETE- - -# 3 (
INSERT INTO- -# J

e u , >2 ? ( SQL Dat abase Cr eat i on Tut or i al i n
Bangl a)
:
я

MySQL e я = * e , ।CREATE DATABASE ei s n ( e 0
, ।XAMPP
3 ? -
e 6 b uя e e L http://localhost/
en ( e e (
Tools e a' phpMyadmin e k = & SQL # k ।
e
(CREATE DATABASE designer) e 6 go k # e , *

e ( ( designer e 3।

k
e e ' - + e - e 0 k # ,
i
s n 0 # ,
USE database_name( ) 0 # ,
database_name e я * i 0 ( ( ।)
B
e ap я 3
s n
DROP DATABASE database_name( ) 0 3
database_name e я * i 0 ( ( ।)
e 3 ,
) 2 (undo) m , i - я0 ,
) p я 0 3 ( ।

e u , >2 ? u (
u ( SQL Tabl e Cr eat i on Tut or i al
i n Bangl a)
:
я

s n 0 m +
CREATE TABLE table_name( )
table_name e я * i 0 ( ( ।)u( , :
designer ) 0 3 k ( ( ( )e 6 SQL # k
n0
1.CREATE TABLE `designer`.`test` (
2.`id` INT( 10 )NOT NULL AUTO_INCREMENT PRIMARYKEY ,
3.`first name` VARCHAR( 15 ) NOT NULL ,
4.`last name` VARCHAR( 15 ) NOT NULL ,
5.`email` VARCHAR( 20 ) NOT NULL,
6.`course name` VARCHAR( 20 ) NOT NULL DEFAULT'WDAD',
7.`mobile` INT( 12 ) NOT NULL
8.)

e GO k # test e , ) designer database e a' ।


u+ # #
p- i 0 ( , c test e ।2 i ( , c id e
i ) INT(10)
a- # : +! 6 # , (id +! 6 # i , ) o 1, o 20 o 230 )e 6 100 = 6 # , e + 3 NOT
NULL ) ei 0 2 ) । + AUTO_INCREMENT e , c + ) ( id ( ,
1 Y o । = & PRIMARY KEY e e s e * t+! e 6 + o я
* ।

e u i& C s 5 u ( SQL I nser t St at ement i n Bangl a)
: яo
яo

e u (SQL) ( + e e ' (row) J + ।e e (row)e , J
+ । ) :
INSERT INTO test (id, first name, last name, email, course name,mobile)
VALUES
(8, 'Rahman', 'Abidur', ' a_rahman@yahoo.com', ‘WDAD’, ‘01195229300’)

= +d 3 J ) ( e u+ ) p 0 2 l я # # - ।( id, first
name, last name e* , e e 0 2l)
2l
) ( p 0 2 l # - ,
J ,
INSERT INTO test VALUES
‘WDAD’, ‘01195229300’)

(8,

'Rahman',

'Abidur',

' a_rahman@yahoo.com',

+
i = ' ( \ J + । )
1.INSERT INTO test(firstname, lastname) VALUES (‘Harun', ‘Rashid')

+d 3
i e ( \ e J + ।
1.INSERT INTO test SET id = 9

e a # # 2l* 2 2l # - ।

e u p i ? u ( SQL Pr i mar y Key Tut or i al i n Bangl a)
:
я

1.e ( p 0 entries a #/ ( (uniquely)
h /= k , ।
2. + e e ' p i , ( + । ) i ei p i i + p 0
(row) a #/ ( (uniquely)
h ।
3.) ( e ' p i , , * e p i .e e i p i
- ।

5.p i 2 - ।
5. * 0u ) 0 ) ( i first name p i e ) (
, я - , - o - o e - ) o m 3 ,
+ first name last name p i e 16 +) n e PRIMARY
KEY ) o ) a # (unique) , ।eя # e ) id number PRIMARY
KEY , , ( iя id o e , ।e a + ) (first name,last name e
= = ,email e = = i i e L i # ( - ) J ।

e u , ,+ B ( SQL Tabl e Del et e Show Tut or i al i n
Bangl a)
:
я

SHOW TABLE ei s n 0 ( e ( ) ।
DESCRIBE TABLE ei s n ( s я +t ( ) । ) DESCRIBE test e0
0
(
TABLE ALTERATI ON
+ = + = MYSQL e + 2 i a a+= + )
1.alter table table_name add PRIMARY KEY (col_name,...)

2.alter table table_name ADD UNIQUE (col_name,...)
3.alter table table_name DROP PRIMARY KEY
4.alter table table_name ALTER [COLUMN] col_name {SET DEFAULT literal
|DROP DEFAULT}

e d + ) * , ,PRIMARY KEY - i # ( + ।
1.alter table table_name drop column column_name

e table_name e я * column_name e я * ( oi - 0 3
( + ।
1.alter table table_name add column column_name data_type [NULL/not NULL]

e ( e ) * + ।e * o।

e u u (
u ( SQL Quer y Tut or i al i n Bangl a)
:
я

- e ( SELECT s n 0 # , , । )
select

* from

test

e + test 0 + , я 2 ।
*e я * ) ( ( , = ' oi * ( । )
SELECT firstname,lastname FROM

test

SELECT s n ( ( \ a6=o e ( + a- # : R ( + k + (

। )
select JOB, SAL from EMPLOYEES Limit 10

' + e employees e 3 , я - i + k t u+ n0 10
0 ( ।

e u WHERE Clause ,
:
я

e ( n ) । )
1.select JOB, SAL from EMPLOYEES where SAL > 1500

2 employees ) ( salary 1500 e u+ ( -# e ( ।
1.SELECT * FROM Persons
2.WHERE City='Sandnes'

' + person 3 e + = ' ( -#
) sandnes =, - , u+

, ।
SQL kk single quote e e - - = * - ।
6 # (Numeric) = ) ।
e
SELECT * FROM Persons WHERE FirstName='Tove
e
SELECT * FROM Persons WHERE FirstName=Tove
6 # k t e ,
e
SELECT * FROM Persons WHERE Year=1965
e
SELECT * FROM Persons WHERE Year='1965'
WHERE clause e condition R (
a+ * # , )

R


R


AND e u( , :
1.SELECT * FROM Persons
2.WHERE FirstName='Tove'
3.AND LastName='Svendson'

OR e u( , :
1.SELECT * FROM Persons
2.WHERE FirstName='Tove'
3.OR FirstName='Ola'

AND,OR Operator e - # , condition ) + । )
u( , :
u( ,
1.SELECT * FROM Persons WHERE
2.LastName='Svendson'
3.AND (FirstName='Tove' OR FirstName='Ola')

QUERY DI STI NCT
e 3 p # - + ।
n0 ( ei p eY +
1.select distinct DEPTNO from EMPLOYEE

a- # : employee - dept e m e i + n a - i e i + n m n
e a - i ? ei n0 ( ei p eY m ।
QUERY ORDERBY
1.select ENAME, DEPTNO, HIREDATE from EMPLOYEE
2.order by DEPTNO [asc], HIREDATE desc

e ) * ( * 3 - Y(ascending)e 6 Y - 3 (descending) я ( + ।
QUERY BETWEEN
1.select EMPNO, ENAME, SAL from EMP where SAL between 1500 and 2500
2.select ENAME from EMP where HIREDATE between ’02-APR-81’ and ’08-SEP-81

e ( ( \ e + '# a6= ( + ।
1.SELECT productCode, FROM products
2.WHERE buyPrice NOT BETWEEN 20 AND 100

e AND i # ( # , QUERY o (k + ।

e u i& ( SQL Quer y I N Tut or i al i n Bangl a)
:
я

1.select *

from DEPT where DEPTNO in (20,30)

( + n ( o ) ( + n m 20 30।
1.SELECT officeCode, city FROM offices
2.WHERE country IN ('USA','France')
3.
4.
5.SELECT officeCode, city FROM offices
6.WHERE country NOT IN ('USA','France')

e* = s , statement * ( i a ) ।

a0 n QUERY ( SQL Joi n Tut or i al i n Bangl a)
:
я

a0 n QUERY U+
e k = ) SELECT statement ( e - e ( ) । n s
p g 6 e k t = ' e e - ( e a * 3 3
k - । i + SELECT statement e - SQL JOIN m! ( + ।
e *d 0 m +
1.SELECT column_list
2.FROM table_1
3.[INNER |LEFT |RIGHT] table_2 ON conditions_2
4.[INNER |LEFT |RIGHT] table_3 ON conditions_3
5.…
6.WHERE conditions

JOIN keyword 0 SQL statement e - # : , ( i ' - я # ) oi
* '# ( \ '# m u+ t , । * '# e 0 0 Keys(e* Foreign key ) e '# m ) k - ।
Primary Key , c e ( 3 \)) p 0 (row)я # a #(unique).

“Persons” 0 (
P_Id

LastName

FirstName

Address

City

1

Hansen

Ola

Timoteivn 10

Sandnes

2

Svendson

Tove

Borgvn 23

Sandnes

3

Pettersen

Kari

Storgt 20

Stavanger

e “Persons” p i , c “P_Id”e , c ( 0 (row) “P_Id” o e i , ।ei “P_Id”i
( 0 row ( ) (o ( 0 row e e i , ।e + 0 (
O_Id

OrderNo

P_Id

1

77895

3

2

44678

3

3

22456

1

4

24562

1

5

34764

15

k# “O_Id” 0 “Orders” Primary Key e 6 e “P_Id” ( “Persons” # k (
p(= , 3 ( i।ei ( 0 '# “P_Id” 0 '# e 0 m 3।

u( , * ' JOIN 3 e (
JOIN,LEFT JOIN,RIGHT JOIN,FULL JOIN
SQL I NNER JOI N
INNER JOIN - i ) = ( u+ t । )
1.SELECT column_name(s)
2.FROM table_name1
3.INNER JOIN table_name2
4.ON table_name1.column_name=table_name2.column_name

u( , :
Persons table
P_Id

LastName

FirstName

Address

City

1

Hansen

Ola

Timoteivn 10

Sandnes

2

Svendson

Tove

Borgvn 23

Sandnes

3

Pettersen

Kari

Storgt 20

Stavanger

Orders table
O_Id

OrderNo

P_Id

1

77895

3

2

44678

3

3

22456

1

4

24562

1

5

34764

15

“P_Id” ( ( 0 m ) k e - ) ( # k ( (
i ( order ) i , , INNER
JOIN # , + ।
1.SELECT Persons.LastName,Persons.FirstName,Orders.OrderNo
2.From Persons

3.INNER JOIN Orders
4.ON Persons.P_Id=Orders.P_Id
5.Order BY Persons.LastName

Result , e
LastName

FirstName

OrderNo

Hansen

Ola

22456

Hansen

Ola

24562

Pettersen

Kari

77896

Pettersen

Kari

44678

INNER JOIN (row) 2 : + d ) ( 0 '# + k e - ।) ( Persons table e Orders table e e (row) - k t i 0 ( ।

e u V я & u ( SQL Lef t Joi n Tut or i al i n Bangl a)
:
я

e (table1) - ) (o a # (table_2,table_3...) - e - । )
1.SELECT column_name(s)
2.FROM table_name1
3.LEFT JOIN table_name2
4.ON table_name1.column _name=table_name2.column_name

' u+ - # k e 6 ( k (
i
,
1.SELECT Persons.Lastname,FirstName,Orders.OrderNo
2.FROM Persons
3.LEFT JOIN Orders
4.ON Persons.P_Id=Orders.P_Id
5.ORDER BY Persons.LastName

Result ,

LastName

FirstName

OrderNo

Hansen

Ola

22456

Hansen

Ola

24562

Pettersen

Kari

77896

Pettersen

Kari

Svendson

Tove

44678

LEFT JOIN o 0 Left table(Persons) - * 3 ) (o Right table(Orders) e - e
i।

e u i я & u ( SQL Ri ght Joi n Tut or i al i n Bangl a)
:
я

e0 a # # (table_2,table_3) - ) (o - e - । )
1.SELECT Persons.Lastname,FirstName,Orders.OrderNo
2.FROM Persons
3.RIGHT JOIN Orders
4.ON Persons.P_Id=Orders.P_Id
5.ORDER BY Persons.LastName

e 6 e 2 2
( ।
LastName

FirstName

OrderNo

Hansen

Ola

22456

Hansen

Ola

24562

Pettersen

Kari

77896

Pettersen

Kari

44678
34764

SQL FULL JOI N
e ) ( # k k , e 6 k ( - # k (
i ,
SELECT statement # , , ।
1.SELECT Persons.Lastname,FirstName,Orders.OrderNo
2.FROM Persons
3.FULL JOIN Orders
4.ON Persons.P_Id=Orders.P_Id
5.ORDER BY Persons.LastName

Result:
LastName

FirstName

OrderNo

Hansen

Ola

22456

Hansen

Ola

24562

Pettersen

Kari

77896

Pettersen

Kari

44678

Svendson

Tove
34764


Related documents


introduction to sql language
sql bangla tutorial
gsdatabasesimplified 1
sql injection
relational databases l2 notes
us business card request form final 6 26 14

Link to this page


Permanent link

Use the permanent link to the download page to share your document on Facebook, Twitter, LinkedIn, or directly with a contact by e-Mail, Messenger, Whatsapp, Line..

Short link

Use the short link to share your document on Twitter or by text message (SMS)

HTML Code

Copy the following HTML code to share your document on a Website or Blog

QR Code

QR Code link to PDF file SQL Bangla Tutorial.pdf