Hawaiʻi's Technology Community

DB Admins & Developers

Information

A group for database administrators and developers.

Location: Hawaii
Members: 47
Latest Activity: Dec 17, 2011

Discussion Forum

Hawaii Tech Employment Web Sites 3 Replies

Started by Nelson Nomura. Last reply by Francis A. Covington Apr 14, 2010.

Database Objects and Source Control 4 Replies

Started by Stephen McMahon. Last reply by Stephen McMahon Dec 28, 2008.

View All

Database News

In relational databases, the SQL ORDER BY statement is a powerful tool for sorting data in a table. The statement is used to arrange queried data into rows in a specific order, based upon one or more columns. In this database programming tutorial, we will learn how to use the SQL ORDER BY statement to […]

The post SQL SORT BY Statement appeared first on Database Journal.

Working with NULL Values in SQL

In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell. Understanding how to handle NULL values is important for database developers who want […]

The post Working with NULL Values in SQL appeared first on Database Journal.

Working with SQL AND, OR, and NOT Operators

In a previous tutorial, we learned how to work with the WHERE clause in SQL, which database developers can use when they wish to retrieve a group of records that meet a certain criteria or condition. For instance, a database administrator may wish to find every instance in a database where a user’s name is […]

The post Working with SQL AND, OR, and NOT Operators appeared first on Database Journal.

How to Use Databases With Python

Python allows developers to interact with various relational databases (such as Oracle, SQLite, and MySQL) and relational database systems (RDBMS) through several different libraries, which must conform to standards defined in PEP 249. In this database programming tutorial, we will discuss how to connect to a MySQL database using Python and make database queries. You […]

The post How to Use Databases With Python appeared first on Database Journal.

SQL Data Types

In SQL, data types help to define the type of value that can be stored in a database cell, or, more specifically, in a column. There are many kinds of data types in SQL and in this database programming and administration tutorial, we will look at each one and learn their syntax, how to use […]

The post SQL Data Types appeared first on Database Journal.