dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Database Development

Database Development

Active Server Pages
Data Access
Database Administration
Database Apis
  ADO   ADOX   JDBC   ODBC   OLE DB   SQL-DMO
Database Tuning
DB2
Informix
MySQL
Oracle
Relational Databases
SQL
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
1-20 of 236     Previous     Next
Using ENUM to Pre-define Column Values in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how the values for a particular column can be pre-defined during the table definition. These values will be validated when the records are inserted or updated in the table.
Creating an SQL Query that Generates Dynamic LIKE Statements
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See how to construct a query that can generate dynamic LIKE statements in SQL.
Converting UNIX_TIMESTAMP to Readable Format in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about a quick and neat way of converting the current time from Unix format to Readable format.
3 Hints for Achieving Faster SQL Queries
by Hannes du Preez
Language: SQL, Expertise: Beginner - Follow these three tips to help increase the performance of your SQL queries.
Understanding TOP WITH TIES in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See what the Top with Ties clause actually does in SQL>
Difference Between RANK, DENSE_RANK and ROW_NUMBER SQL Statements
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn more about how to use three very different SQL statements.
Three Levels of Data Abstraction in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about the levels of data abstraction employed in SQL to hide irrelevant details from users.
Delete Data Safely with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Explore to how to safely delete data in SQL.
Name All of the Normalization Forms in SQL
by Hannes du Preez
Language: Java, Expertise: Beginner - Explore a list of the names of all normalization forms in SQL.
Discovering the Reason for Poor Query Performance
by Hannes du Preez
Language: SQL, Expertise: Beginner - Explore some of the reasons why your query performance might not by up to expected speeds.
Types of Indexes that Exist in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Get an overview of the index types available in SQL.
Getting the Last ID in MySQL
by M S Sridhar
Language: SQL Expertise: Intermediate - Explore how MySQL supports AUTO_INCREMENT column types when many instances require the last value that was inserted to be used in reporting.
Understand the AES Encryption Method
by M S Sridhar
Learn how to understand the AES ENCRYPTION method that is supported by MySQL.
Using the WEEKOFYEAR Function in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to use calendar functionality in MySQL to figure out in which week a given date belongs.
T-SQL Performance Tip: Stored Procedure Names
by Hannes du Preez
Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.
T-SQL Performance Tip: NOT IN vs NOT EXISTS
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn the difference between using not in and not exists in T-SQL.
Use MySQL for Calculations
by Sridhar MS
Language: SQL, Expertise: Intermediate - See a few different ways to use MySQL to compute the result of a mathematical formula.
User Creation and Scenarios
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about the importance of providing a password during the user creation process itself.
T-SQL Performance Tip: The * Operator
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about why you should use explicit column names in T-SQL.
Understanding NULL in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate - See how to work with NULL in MySQL. Examine a few examples in which you might be confused with the output unless you are very comfortable using NULL.
1-20 of 236     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date