Skip to content
Latest
Linux To The Rescue
User Detection
JavaScript – An Introduction
The History Object
Understanding Binary Numbers
Monday, Feb 6, 2023

Wiki Web Pedia

Website Programming and Website Development

  • What Is WWP
  • Twitter
  • Facebook
  • Google+
  • What Is WWP
  • Twitter
  • Facebook
  • Google+

Category: Database Programming

  • Home
  • Database Programming

MYSQL Custom Field Sorting Revisited

sql

At times in MYSQL an unnatural sort is required. This article presents an easy to maintain set of tables where sorting a table in any order can be easily defined.

Posted in Database ProgrammingTagged , custom sortingMySQLmysql custom sortingmysql sortingphpsqlSQL orderingsql statementsql tables

Examples of Using the COUNT and MAX Functions in MySQL

sql

Shows how to use the MAX and COUNT functions in MySQL, both separately and in combination, with detailed examples.

Posted in Database ProgrammingTagged , aggregate functionscountexamplesmaxMySQLselect

MYSQL Custom Field Sorting

mysql database

In MYSQL the sorting of recordset data can be easily setup and maintained with a few custom tables and a little thought.

Posted in Database ProgrammingTagged , custom sortingdatabase creationMySQLmysql custom sortingmysql sortingtable creation

Decision Stream Derivation Expression Operators

The Decision Stream or Data Manager ETL tool has many built in capabilities that assist the data warehouse programmer in generating the data needed by the business.

Posted in Database ProgrammingTagged , data managerdata warehousing conceptsdecision streamderivationsetletl developmentetl softwareetl tools

How to Write a SQL Update Statement

mysql database

The SQL update statement provides developers with a way to change data in a table. Learn how to write an update query for your database.

Posted in Database ProgrammingTagged , sqlsql update statementsql update statement syntaxsql update table recordsupdate statementupdate table records

How to Deduplicate Data from Tables in SQL Server

Need to get rid of duplicate records? You can dedupe a table using SQL queries and temporary tables.

Posted in Database ProgrammingTagged , dedupe datadedupe data recordsdedupe querydedupe recordsdelete duplicate table recordsremove duplicate records

How to Design a Database Table for SQL Server

Improve SQL Server performance following these five tips for database table design.

Posted in Database ProgrammingTagged , custom database designdatabase consultingdatabase design stepsdatabase table designsql database developmentsql database programming

How to Optimize SQL Select Statements

Without optimization on SQL select statements, the database server can produce poor performance during queries. Here are two ways to optimize SQL select statements.

Posted in Database ProgrammingTagged , optimize sqlselect statementssql optimizationsql performancesql queriessql select statementsql server

What is a JOIN in Microsoft SQL?

join in sql

Microsoft SQL, as well as other SQL languages, uses JOIN to merge related data from two or more datasets in to one readable result set to perform operations

Posted in Database ProgrammingTagged , microsoft sql serverms sql joinsql inner joinsql joinsql join querysql join statementsql join syntaxsql join typessql joinssql left joinsql outer joinsql server jointransact sql join

Data Dictionary and MetaData

Data about data is called meta data. Meta data is often housed in a data dictionary. The data dictionary is one of the primary needs of a successful BI team.

Posted in Database ProgrammingTagged , business intelligencedata definitionsdata dictionarydata warehousedata warehousing conceptsmetadata

Posts navigation

Older posts

Project Sponsors

  • Web Programming Blog
  • Search Engine Optimisation
  • Moldovan Law Company
  • 3D Printing Files

Recent Posts

  • Linux To The Rescue
  • User Detection
  • JavaScript – An Introduction
  • The History Object
  • Understanding Binary Numbers
  • Computer Programming Fundamentals
  • Good Programming Style
  • Solving Mac OS X Problems

Archives

Categories

  • AJAX (3)
  • Computer Programming (3)
  • Database Programming (12)
  • Delphi Programming (7)
  • HTML Lessons (8)
  • JavaScript (18)
  • Linux Programming (3)
  • MAC (3)
  • Network (5)
  • PHP Programming (6)
  • Top Websites (3)
  • Website Content (8)
  • Website Design (12)
  • Website Development (34)
  • Website Management (4)
  • Website Marketing (2)
  • Website Optimization (7)
  • Website Programming (17)

RSS Gray Matter Blog

  • What is a Trial Balance?
  • Destruction
  • Powermad – The Madness Has Begun
  • Incubus – Cajun Death!
  • What Is SEO?
  • Starting An Online Business
  • Web Consulting
  • Creating Ethical and Binding Website Terms and Conditions

RSS Web Design Art

  • A Printmaker's Guide to Printmaking and Prints
  • Getting an Angle on Perspective
  • Contemporary Australian Artist Maximizes Use of Internet
  • Let's Try Some Drawing!
  • Calligraphy is Art
  • ART BASICS - PAPER
  • Wood Engraving and a Wood Engraver in the 21st Century
  • Fragile, Hostile, Heavy, and Totally Astounding!

Tags

AJAX browser build my own website CMS Content Management System create a website custom sorting database data warehousing concepts delphi get a website google HTML html links image infographic Java Java programming JavaScript JavaScript objects learn Java links macintosh make a website microsoft MySQL mysql custom sorting open source cms php programming programming languages security server sql sql server tthread web development web programming website design website development website terminology website vocabulary what is Java why you need website windows
Copyright © All right reserved. | WWP >> Wiki Web Pedia powered by ✠ #1 SEO Company ✠