Database introduction and normal table creation queries

 Day 39 - (25-03-2025)                 

   DataBase

 

Database name-college

 Student(roll,name,city)

 Faculty(name,designation,subject)

l The database is a collection of entity (tables). 

Entity is a collection of record

 

ü Types of database:-

I. Local database

II. Global database (web database)

 

ü Database Elements:-

I.  Location

II. User name

III. Password

IV. Catalogue-(name of database)

 

ü Datbase Terminology:-

Ex- Roll name city  -> this are called field

   101    A      Ngp 

       102    B        pune

 

ü Field (column heading ):-  

a. Single value field :- which should always be unique  . ex-(roll no).

i.  Multivalue field :- which can accept similar  data ex.- (name- first name, last name and etc).

ii. Null Field :- accept the blank data .

ü How to create database in dot framework?

There are two specify architecture used in database handling :-

1. Connect architecture:- (inbuilt enviroment )

2. Disconnect architecture:- (using database software).

 

 

v Sql server database

1. It is a platform independent database

2. It support web application.

3. Extension of sql server (.mdf ).

 

v Database queries :- Set of command to perform the specify operation in a database

v Type of queries :-

1. Execute queries :- only display data record.(select )

2. Execute non queries:- Changes or updaate your data from the table ex:- (insert update delect) .

3. All queries is to be executed in the query editor windows.

 

ü How to open the query editor ?

 

ü Type of datatype in database

1. Int

2. Varchar

3. Nvarchar

4. Date

5. Image

 

u Create table queries

 

Ex-CREATE TABLE student(roll INT,name VARCHAR(50));

 

 

u How to display table strucutes.

Ex- SP_HELP student;

Comments

Post a Comment

Popular posts from this blog

Store procedure Data Base handling (procedure_insert).

Image
  Ø  Store procedure Data Base handling  (procedure_insert). 1.  Include procdure library (system.data). 2.  Pass procedure name to sqlcommand parameters. Syntax :- com= new sqlcommand(“procedure name”,connection object) 3.  Set the command type (store procedure) Syntax :-com.CommandType=commandtype.storeprocedure     STORE PROCEDURE CREATE   PROCEDURE  PROCON   ( @ROLL1 AS    INT   ,  @NAME1 AS   VARCHAR ( 50 ))   AS     BEGIN   INSERT   INTO  DEMO   ( ROLL ,   NAME   )   VALUES ( @ROLL1 ,  @NAME1 )     END   ;             using  System; using  System.Collections.Generic; using  System.Linq; using  System.Web; using  System.Web.UI; using  System.Web.UI.WebControls; using  System.Data; using  System.Data.SqlClient;     public   partial   class   ...
Read more

ViewState for state management

  v  ViewState :- I.  It is used to store data value in a single webpage. II.  The ViewState cannot transfer the  data between one page to another page . v  How to create ViewState? Sytanx:- ViewState[“var”]=Control; Ex.- ViewState[“Email”]=Textbox1.text;   v  How to access ViewState data value? Syntax:-control=ViewState[“var”].Tostring(); Ex:-Label1.text=ViewState[“Email”].tostring();   Code:- using  System; using  System.Collections.Generic; using  System.Linq; using  System.Web; using  System.Web.UI; using  System.Web.UI.WebControls;   namespace  WebApplication1 {      public   partial   class   stateview  : System.Web.UI.Page     {          protected   void  Page_Load( object  sender, EventArgs e)         {        ...
Read more

Database joining

Image
  l  Database joining :- 1.  Joining is a special type of operation perform between 2 tables. 2.  With the help of joining we get the result between multiple data. l  Joining property:- 1.  Common field (column) 2.  Using table object Syntax :-  table name.column name 3.  To activate joining operaton we need  ON  KEYWORD. ü  TYPES OF JOINING:- 1.  INNER JOIN  :- Inner join returns all records from multiple data where the join condition is equal. Ex:- CREATE   TABLE  invent   (  id INT   ,   name   VARCHAR ( 20 )); INSERT   INTO  invent values ( 101 , 'rahul' ),( 103 , 'thosar' ),( 102 , 'asus' );   CREATE   TABLE  product   ( id INT   ,  cost int );   INSERT   INTO  product VALUES ( 201 , '1000' ),( 202 , '2000' ),( 203 , '30000' );   SELECT  invent . id ,  invent . name ,  product . cost FROM  invent INN...
Read more