Journey to SQL

I have developed student record information system with Sql server connectivity + visual Studio database . Going for cascade it .

Capture

Capture2

Capture3

Capture4

 

 

 


Structured Query Language  –  for accessing databases.

Database Tables

A database has  one or more than one more table . Each table is identified by a name (e.g. “Students” or “Teachers”). Tables contain (rows) with data.

Below is a selection from the “Students” table:

Students ID Students Name Student Contact Address City Postal Code Country
1 Ahsan 92111111 Obere Str. 57 Berlin 12209 Germany
2 Umer 92000000 Avda. de la Constitución 2222 México D.F. 05021 Mexico
3 Daniel 92333333 Mataderos 2312 México D.F. 05023 Mexico
4 Sana 92444444 120 Hanover Sq. London WA1 1DP UK
5 Muhammad 92555555 Berguvsvägen 8 Luleå S-958 22 Sweden

 

SELECT * FROM Students;

– extracts data from a database

 

Advertisements