General discussion


Database development

By hansemso ·
Hi, y'all. New to IT. I was just wondering, what is database programming? Is it like learning C++? Or are they talking about something else?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

What is database programming?

by deborasumopayroll In reply to Database development

A database is a repository of information managed by a database engine which ensures integrity of data and fast access to the data.
A very common implementation of a database is a Relational Database Management System (RDBM). To users, the information in a database can be accessed by using Structured Query Language a database language common to most databases. However, SQL only provides commands to access and manipulate the data in the database.
For any complex application, there commonly is a need for conditions, branching, and loops. None of these are a part of the SQL language. In order to fill this gap, many common programming languages allow integration with SQL through a common library such as Open Data Base Connectivity (ODBC), Object Linking and Embedding (OLE), and sometimes with application programming interfaces or libraries supplied with the database.
In addition, most databases now have a simple language of their own which allows simple control for applications which do not need the full power of standard languages like c++ and Pascal. These simple languages are used to write stored procedures and are proprietary to each database.

Related Discussions

Related Forums