Basic awareness about database

Status
Not open for further replies.
A

aneesholv

Advanced Member level 4
Joined
May 23, 2011
Messages
119
Helped
0
Reputation
0
Reaction score
0
Trophy points
1,296
Location
India ,kerala
Visit site
Activity points
2,118
Can you give a basic awareness about access and sql database because Iam fresher in this field ? Also I want to know how a database work with an application software (I mean how a sftware connect to a database ) ? ,and also what is the difference between various database extensions for Eg: .mdb, .ldf ,.ldf ?


Regards
Aneesh T V
 

aneesholv said:
Can you give a basic awareness about access and sql database because Iam fresher in this field ?
Click to expand...

There are many article in the web and search in Google.

aneesholv said:
Also I want to know how a database work with an application software (I mean how a sftware connect to a database ) ?
Click to expand...

Search example code from CodeProject - Your IT Resource

aneesholv said:
,and also what is the difference between various database extensions for Eg: .mdb, .ldf ,.ldf ?
Click to expand...

*.mdb associate with Microsoft Access database
*.mdf is SQL Database (Microsoft SQL Server)
*.ldf is SQL transactional log files (Microsoft SQL Server)
 
SQL is a language to access database. Sql contains 2 language: DDL & DML. You connect into database via ODBC or Generic connection. Database can be used on personal or buisness application. There are many type of database free or shareware.

For free database for you can try firebird,Mysql,Postgress. I also used free database for building application.
 

Status
Not open for further replies.

Similar threads

Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…