SQL

View:  
Sorted by:  

Knowing Just Enough about Relational Databases

Building a system in Oracle or some other relational database product does not automatically make it a relational database. Similarly, you can design a perfectly good relational database and implement [more…]

Setting Up an Oracle Environment

If you want to set up a typical PL/SQL environment, you need the following components: [more…]

The Scoop on SQL and PL/SQL

As a database application developer, you interact with the Oracle DBMS by using the programming languages Structured Query Language (SQL, pronounced sequel [more…]

Where Does SQL Server Express 2005 Work Best?

SQL Server 2005 Express brings a lot to the table, but when does it make sense to choose it as your data storage platform? Some insight follows. . . . [more…]

More SQL Server 2005 Express Troubleshooting Tips

Predicaments are possible with SQL Server 2005. Here's a smattering of those that you're likely to encounter. [more…]

A Few SQL Server 2005 Express Troubleshooting Tips

As an entry-level database server that is built on the same platform as the entire SQL Server product family, SQL Server 2005 Express combines simplicity with great power and a massive set of features. [more…]

What Is PL/SQL Good For?

PL/SQL is the language to use when writing code that resides in the database. In the following article, you'll see different situations in which you'll find PL/SQL useful. [more…]

Working with Code after Installing an Oracle PL/SQL Database

After you have the database installed, the next question is, "Where will you run all these PL/SQL programs?" The answer isn't as simple as you might think. The ultimate goal is productivity, and you can [more…]

Getting Down to Business with SQL Server 2005 Express

If you're wondering how you can get started using the product, that's what this article is all about. [more…]

MySQL Queries

If you're going to develop Web pages with PHP and MySQL, you're going to have to write MySQL queries. The following list shows the MySQL query names to help make your web development easier than you thought [more…]

WHERE Clause Format for PHP and MySQL Web Development

You’re developing Web pages using PHP & MySQL, and because you’re developing Web pages and/or databases, you need to write WHERE clauses so that you can sort through data. The following list shows the [more…]

Changes for the ALTER Query in PHP and MySQL Web Development

Using PHP and MySQL in developing your Web site and/or database means you often get do things the easy way, and the following list shows you just how easily you can change things [more…]

PHP and MySQL Functions

Doing Web development with PHP and MySQL, you need to use MySQL functions to run your subroutines, whether you’re writing a connect routine or a query. The following list shows the format for these functions [more…]

PHP Statements to Use for Web Development with PHP and MySQL

You'll use PHP statements when developing Web sites and databases with PHP and MySQL. The following list lays out the key PHP statements and the necessary format: [more…]

Special Characters Used in Patterns in PHP and MySQL Web Development

To search for patterns in Web sites and databases developed using PHP & MySQL, you use a list of special characters. You don’t have to channel Daffy Duck [more…]

PHP & MySQL Web Development AIO For Dummies Cheat Sheet

Using PHP and MySQL to develop your Web site and/or database gives you lots of tools and lots of options, but you have to become familiar with how each program operates so that you can properly format [more…]

SQL For Dummies Cheat Sheet

This Cheat Sheet consists of several helpful tables and lists, containing information that comes up repeatedly when working with SQL. In one place, you can get a quick answer to a number of different questions [more…]

Phases of SQL System Development

In developing any system, you start at the beginning and go through to the end, and it's no different with SQL. The following list shows you what to consider at each phase of the SQL development lifecycle [more…]

SQL Criteria for Normal Forms

In SQL, normal forms are defining characteristics of relational databases. SQL forms get classified according to the types of modification anomalies they're subject to. First, second, and third normal [more…]

SQL Data Types

Depending on their histories, different SQL implementations support a variety of data types. The SQL specification recognizes nine predefined general types, shown in the lists below [more…]

SQL Value Functions

You use SQL value expressions to combine two or more values. Several kinds of SQL value expressions exist, corresponding to the different data types; the following tables list string, numeric, and datetime [more…]

SQL Set Functions

Sometimes, the information that you want to extract from an SQL table doesn't relate to individual rows but rather to sets of rows. SQL provides five set [more…]

SQL WHERE Clause Predicates

The WHERE clause is an SQL filter that passes rows that meet the search condition and rejects rows that don't meet the condition. By including WHERE clauses in your SQL SELECT statements, you can restrict [more…]

SQL All-in-One For Dummies Cheat Sheet

SQL is a popular and useful programming language. You can make SQL even more useful if you know the phases of SQL development, the criteria for normal forms, the data types used by SQL, a little bit about [more…]

Oracle PL/SQL For Dummies Cheat Sheet

Need to get up to speed on PL/SQL programming? To effectively use the PL/SQL programming language in the Oracle database environment, take a look at some PL/SQL models for using fundamental syntax and [more…]

Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com