Add Resources      Login      Logout

Results for sql by example

Advertisements
 

Results

A web based tuning tool - works by analyzing SQL_TRACE and Oracle trace files.
Tags: sql trace



Development environment with special emphasis on SQL and PL/SQL performance optimization. By Leccotech.



PL/SQL development environment that includes a debugger. Several editions available; high-end edition includes a code generator. By Mentat Technologies.



PL/SQL editor, debugger, object navigator, command console. By Opensoft, Inc.



"Windows Explorer"-like tool for Oracle application developers. Includes PL/SQL editor. By Redwood Software Inc.
Tags: pl/sql



Oracle to Java edition helps convert Oracle PL/SQL procedures to Java. By Vembu Technologies.



Edit, test, tune, and debug SQL and stored code (works with Oracle, Microsoft and Sybase). By Computer Associates.



Execute, test, and debug SQL and PL/SQL statements. By Core Lab.



Generic tool for logging, benchmarking, and monitoring custom PL/SQL code, inspired by "log4j" [Open source, GPL]



Tune and debug SQL, PL/SQL. By Compuware.



Stored procedure development tool for both PL/SQL and Java stored procedures. By Manton Computer Associates. [Free evaluation]



Oracle SQL processor tool for Windows (98,NT,2000). Piper facilitates monitoring and debugging PL/SQL application development with features such as HTML Output Previewer, Continuous Pipe Read capability, Catalog Browser, and Command History. By DataBeacon



Including browser, PL/SQL editor, and debugger for Linux or Windows. By Underscore AB.
Tags: debugger , linux , windows



PL/SQL editor, debugger, SQL execution plan analyzer. By IDB Consulting.




Book Description
If you want to learn SQL, you’ve picked the right book. Unlike most SQL books, this one starts by showing how to use SQL queries to extract and update the data in a database, because that's what every programmer needs to know. Then, the book shows how to design and implement a database, and how to use the server-side features like views, procedures, and transactions. Because its CD includes everything you need for running SQL on your own PC, this book works great whether you want to learn SQL or the specifics of SQL for Microsoft SQL Server.

From the Publisher
To be an effective database programmer, you need to master SQL for the database you’re going to be using. So this is first a book for programmers who use Microsoft SQL Server. However, but it is also a great book for anyone who wants to learn standard SQL, because its CD includes everything you need for running SQL on your own PC.

In section 1, you’ll learn the concepts and terms you need for working with any database. You’ll also learn how to use the Microsoft SQL Server 2000 Desktop Engine (MSDE) and the client tools for SQL Server 2000 that come on the CD. Then, you’ll be able to run SQL statements on your own PC. At that point, you’ll be prepared for rapid progress as you learn SQL.

In section 2, you’ll learn all the skills for retrieving data from a database and for adding, updating, and deleting that data. These skills move from the simple to the complex so you won’t have any trouble if you’re a SQL novice. And they present skills like using outer joins, summary queries, and subqueries that will raise your SQL expertise if you do have SQL experience.

In section 3, you’ll learn how to design a database and how to implement that design by using either SQL DDL (Data Definition Language) statements or the Enterprise Manager that comes with SQL Server. When you’re done, you’ll be able to design and implement your own databases. But even if you’re never called upon to do that, this section will give you perspective that will make you a better SQL programmer.

To complete your SQL skills, section 4 presents the skills for working with database features like views, stored procedures, functions, triggers, cursors, and transactions. These are the features that give a database management system much of its power. So once you master them, you’ll have a powerful set of SQL skills.




Professional Data Management is developer of the SQL Plugin for FileMaker Pro. Currently in use by more than 20,000 FileMaker Pro users. First released in 1997 interacts with SQL backends from within FileMaker Pro 4, 5, 6 and 7.
Tags: sql backends , sql plugin




Written by Michael Otey, Senior Technical Editor of SQL Server Magazine, this authoritative resource introduces the new features in the Yukon release, providing a jump start for IT professionals transitioning from SQL Server 7 and SQL Server 2000.

From the Back Cover

Take Full Advantage of The Database and Analysis Potential of SQL Server 2005

Get full details on all the innovative features and benefits available in the upcoming release of SQL Server 2005. This authoritative guide explains the new and improved enterprise data management capabilities, developer functions, and business intelligence tools. You’ll see how the new release offers enhanced scalability, availability, and security, as well as ease-of-use. Written by the Senior Technical Editor of SQL Server Magazine, this is an ideal resource for decision-makers, developers, and DBAs preparing for upgrades or migration.

Covers new and improved capabilities including:

* All news tools such as SQL Server Management Studio and Business Intelligence Development Studio
* .NET Common Language Runtime (CLR) integration
* Enhanced availability and recovery features including Database Mirroring and Snapshot Isolation
* T-SQL enhancements and new data types
* Improved XML integration and the new native XML data type
* The new Reporting Services and SQL Server Broker subsystems
* The new Unified Dimensional Model and Data Mining algorithms
* Security enhancements such as secure default settings and Schema ownership
* The enterprise-ready Integration Services
* All new development models: AMO, SMO, ODL, XMLA

About the Author: Michael Otey is Senior Technical Editor of SQL Server Magazine, Technical Director of Windows IT Pro Magazine, and co-author of SQL Server 2000 Developer’s Guide and SQL Server 7 Developer’s Guide, both from McGraw-Hill/Osborne. He is the president of TECA, Inc., a software development and consulting firm.





Learn how to configure WebSphere Information Integrator to read and write to tables and views managed by MySQL, an open source DBMS. Once you've done this, you'll be able to join and union data in your MySQL database with other corporate data accessible to your WebSphere Information Integrator federated database. The WebSphere Information Integrator family supports a wide variety of data sources, including commercial relational DBMSs, non-relational DBMSs, mainframe data, XML files, Web services, message queues and more.



dBforums is a discussion forum and helpdesk for database design, development and administration issues. MySQL is the cross-platform open source database server software most used in web development. It does not have some advanced features present in enterprise systems, but these are offset by ease of use and impressive speed.
Tags: mysql , forums



Graphical user interface for Oracle. DreamCoder empowers developers to be more productive by providing an graphical user interface to Oracle. DreamCoder is a tool that makes PL/SQL development faster and easier. Editors allow users to work on multiple files simultaneously such as SQL, PL/SQL, Java and text. Hot keys, syntax highlighting and other productivity features speed development, while editing and testing are made easier with integrated result sets, EXPLAIN plans, tracing, and DBMS_OUTPUT views.

All content Copyright© 2004-2006. databasecorner.com . All Rights Reserved.

Reproduction in whole or in part in any form or medium without express written permission is prohibited.

Use of this site, content or service of databasecorner.com constitutes acceptance of our Terms of Use and Privacy Policy

All product names and designated trademarks and brands are the property of their respective owners.

databasecorner.com is not affiliated with or endorsed by any company listed at this site.

Sistemax, LLC
1920 South Main Street, Suite 530
McAllen, TX 78503
USA
(210) 787-3505

Page rendered on:3/19/2010 10:31:44 PM