Database programming classes are typically part of a computer programming, information technology, database design, or computer science degree program. These classes and courses can be found at every level of post-secondary education, from two-year colleges to graduate schools. Certificate programs in database programming also exist, especially with Oracle- or Microsoft-centric technologies.
Students in a certificate or degree programs in the field usually learn to make and use simple databases and initiate simple queries before they begin studying the processes of using programming languages to develop more complex databases. Students also take courses that teach them to use structured query language (SQL) and make Web applications that utilize database technologies.
Topics in typical database programming classes include the following:
- Database theory
- History of database technologies
- Basic network security
- Database design
- Database management systems such as Microsoft SQL Server, Oracle, and Microsoft Access.
- Object-oriented programming with languages like Java
- Open-source database technologies like MySQL
- Web database programming
List of Classes
Introduction to Databases and Programming
This overview course focuses on the uses of relational and object-oriented databases for storing and managing information. Topics covered include computer database terminology and the evolution of the modern database. Database management systems (DBMS) such as Oracle, MySQL, Microsoft SQL Server, and Microsoft Access are introduced along with query languages. Hands-on instruction includes the creation of simple databases, inputting data, and developing basic queries.
Relational Database Programming
A relational database contains sets of data with related information. Students study relational theory, data modeling, and logical organization of data and query languages before constructing their own relational data sets and database. Functions, limitations, and design challenges of working with relational databases are discussed.
Database Programming Languages
Students study programming languages such as Perl, Ruby, and Java in this course. The differences between object-oriented languages, embedded query languages, and logic-based languages are all discussed.
Programming in SQL
Structured query language (SQL) is used to manage databases. This course instructs database programmers on how to use SQL to create, modify, and search stored data. Students create complex queries to retrieve specific data from a database. SQL command statements, both static and dynamic, are demonstrated. In some cases, this course is taught using an Oracle database; in others, it's taught using Microsoft- or open-source database technologies. This course can be taken after completing a course in relational databases.
Developing Web Databases
Internet retailers collect an incredible amount of data in order to complete a sale, including customer names, addresses, and credit card numbers. The data is inputted by the buyer and stored in a relational database for retrieval by the seller.
This course teaches skills for developing Web applications. Students learn current technologies for developing Web databases, including client interface programs such as ColdFusion. SQL and other database and Web programming languages are reviewed. Other topics include data security and creating basic Web pages. This is an advanced course for students who have some programming experience.