http://local.developer.com/Database-s1177.html 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. 120 en-us Articles@DirectoryM.com Articles@DirectoryM.com http://local.developer.com/Database-s1177.html 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. http://local.developer.com/App_Themes/templateDarkBlueWAdSense_en-US/Images/logo.gif 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? http://local.developer.com/The_Elements_of_a_Database_-a1161959.html http://local.developer.com/The_Elements_of_a_Database_-a1161959.html There is a lot more to being a DBA than just being responsible for the data! http://local.developer.com/What_Is_a_Database_Administrator-a1161958.html http://local.developer.com/What_Is_a_Database_Administrator-a1161958.html 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. http://local.developer.com/Day_1_Learning_the_Basics_of_PLSQL-a1161804.html http://local.developer.com/Day_1_Learning_the_Basics_of_PLSQL-a1161804.html 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. http://local.developer.com/Replication_and_Microsoft_SQL_Server_2000-a1161776.html http://local.developer.com/Replication_and_Microsoft_SQL_Server_2000-a1161776.html 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. http://local.developer.com/Microsoft_SQL_Server_2000_Error_Messages-a1161746.html http://local.developer.com/Microsoft_SQL_Server_2000_Error_Messages-a1161746.html This article discusses some of the opportunities for data transformation provided by Data Transformation Services for Microsoft SQL Server 2000. http://local.developer.com/Practical_Uses_for_DTS-a1161500.html http://local.developer.com/Practical_Uses_for_DTS-a1161500.html 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. http://local.developer.com/A_Quick_Look_at_DTS_in_SQL_Server_2000-a1161494.html http://local.developer.com/A_Quick_Look_at_DTS_in_SQL_Server_2000-a1161494.html 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. http://local.developer.com/An_Overview_of_Java_Database_Connectivity-a1161076.html http://local.developer.com/An_Overview_of_Java_Database_Connectivity-a1161076.html 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. http://local.developer.com/User_Code_EJB_with_Composite_Primary_Key_in_ODBMS-a1161044.html http://local.developer.com/User_Code_EJB_with_Composite_Primary_Key_in_ODBMS-a1161044.html 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. http://local.developer.com/Updating_a_Database_from_WinForms_Controls-a1118629.html http://local.developer.com/Updating_a_Database_from_WinForms_Controls-a1118629.html 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. http://local.developer.com/Cross_Apply_and_Outer_Apply_Operators-a1118616.html http://local.developer.com/Cross_Apply_and_Outer_Apply_Operators-a1118616.html 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. http://local.developer.com/Building_Microsoft_Oslo_Models-a1118596.html http://local.developer.com/Building_Microsoft_Oslo_Models-a1118596.html 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. http://local.developer.com/Exploring_the_Oslo_Repository-a1118588.html http://local.developer.com/Exploring_the_Oslo_Repository-a1118588.html 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. http://local.developer.com/Using_More_Advanced_JDBC_Features-a1094731.html http://local.developer.com/Using_More_Advanced_JDBC_Features-a1094731.html