Developer.com offers daily news, articles, and tutorials for professional involved in the development of applications and other technical solutions. Daily coverage includes articles, tutorials, news and other resources related to all facets of development.
Please wait...
There are a number of key terms and concepts that you must be aware of in order to understand and work with databases. Do you know the key terms?
There is a lot more to being a DBA than just being responsible for the data!
PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database. Here's how to get started using it.
Data Replication is a powerful feature of SQL Server. SQL Server 7.0 provided many improvements from previous versions, and SQL Server 2000 builds on those features and adds more to increase the reliability, ease of use, and management of replication.
SQL Server alerts you to possible problems with databases, objects, or the server, but how do you in determine and fix the problem. The first step to troubleshooting problems is to understand how to read and where to find SQL Server error messages.
This article provides an introduction to Data Transformation Services for Microsoft SQL Server 2000. If you have already used DTS in SQL Server 7.0, the first part of this article will be familiar to you.
We examine the basic steps required to handle JDBC using javax.swing for creating user interfaces. If you're new to object-oriented programming to databases in Java, this will set you off on the right path.
As you may have observed, half of the value in modeling is that it creates a new level of abstraction. Higher levels of abstraction mean less code does more. Using the HTML example, HTML user interface functionality requires less code than equivalent functionality implemented in assembly language.
Elevate your SQL game (a little bit) with Cross Apply and Outer Apply. SQL Server 2005 came out with the Cross Apply and Outer Apply operators.
PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database. Here's how to get started using it.
Walk through examples and see how existing Repository models are constructed using the M language, how the models are stored in a SQL database, and how to query the SQL database for model information.
SQL Server alerts you to possible problems with databases, objects, or the server, but how do you in determine and fix the problem. The first step to troubleshooting problems is to understand how to read and where to find SQL Server error messages.
This article discusses some of the opportunities for data transformation provided by Data Transformation Services for Microsoft SQL Server 2000.
Data Replication is a powerful feature of SQL Server. SQL Server 7.0 provided many improvements from previous versions, and SQL Server 2000 builds on those features and adds more to increase the reliability, ease of use, and management of replication.
There are a number of key terms and concepts that you must be aware of in order to understand and work with databases. Do you know the key terms?
Old school programming, whereby the programmer reads control values and writes inline SQL, still works, but it's so 90s. If you are new to WinForms or Web programming but experienced, peruse the article and then master LINQ.
This Java user offers us the source code for implementing the Composite Primary Key of an Entity Bean, along with with the object in the database.
Expand your basic knowledge of connecting to a database from a Java application using JDBC. Discover how to use just about any database application you may want. In this example its a Microsoft Access database.
There is a lot more to being a DBA than just being responsible for the data!