Subcategories
DB2 (2)
MS Access (2)
MS SQL (3)
MySQL (25)
Oracle (4)
Others (2)
SQLite (0)
Sybase (0)
Databases tutorialsShowing tutorials 0 to 20 out of 38 Databases tutorials. | |||
|---|---|---|---|
|
ADVERTISMENT |
ADVERTISMENT |
![]() Using the Data Tables plugin in jQuery 1.3 From time to time, you will want to show data in your website and allow the data to be sorted and searched. In this chapter, we will look at: How to install and use the DataTables plugin How to load data pages on request from the server Searching and ordering the data Not yet rated with 94 hits Added on: Nov 11, 2009 |
![]() Writing SELECT queries for SQL databases When you want to get results from a database you issue a select query. With this query you can limit the results based on certain criteria, sort it, and subsort it. You can do a lot with this including selecting data from multiple tables. Not yet rated with 210 hits Added on: Sep 03, 2009 |
![]() SQL Date Functions - Converting and Using SQL provides a lot of functions for manipulating dates in a database. You can store values in a date field or a datetime field. If you store the dates as unix_timestamps you can get a lot more flexibility with dates. In fact, this is usually what is done when you are using PHP with the database. Not yet rated with 212 hits Added on: Sep 03, 2009 |
![]() SQL Functions - Math Functions Just like how programming languages have functions built-in to allow you to do common tasks easily. So does SQL. A lot of these functions are mathematical. Some of them are more useful than others. Not yet rated with 208 hits Added on: Sep 03, 2009 |
||
![]() SQL Functions - String Functions SQL provides a large amount of functions for string manipulations. Learn how to convert and use SQL Functions. Not yet rated with 153 hits Added on: Sep 03, 2009 |
There are two ways of securing data in a database: hashing and encryption. Hashing usually prevents you from obtaining the original string. Encryption allows you to obtain the original string (through decrypting). This is only possible if you know the encryption method, and the key that was used to encrypt it. Not yet rated with 206 hits Added on: Sep 03, 2009 |
||
![]() MySQL Data Transfer using Sql Server Integration Services The article describes step by step transferring a table from SQL Server 2008 to MySQL using ODBC connectivity. For successful transfer the data type differences between SQL Server 2008 and the MySQL version must be properly taken into consideration as well as correctly setting the SQL_Mode property of MySQL Server. Not yet rated with 272 hits Added on: Sep 02, 2009 |
![]() Easy way to connect to your Remote Database This quick video will demonstrate a very straight-forward method of connecting to your remote Database! Enjoy! Not yet rated with 183 hits Added on: Jul 25, 2009 |
||
basics of oracle sql in oracle 10g express edition. Not yet rated with 201 hits Added on: Jul 23, 2009 |
![]() Import Structure and Data using phpMyAdmin 3.1 Importing Structure and Data is an article extracted from Marc Delisle's new book, titled ‘Mastering phpMyAdmin 3.1 for Effective MySQL Management’ by Packt Publishing. From this tutorial, users will learn how to bring back exported data created for backup and transfer purposes. It provides an overview of the various options available in phpMyAdmin to import data, and different mechanisms involved in importing SQL and CSV files. Finally, it covers the limitations that may be faced while importing files, and the ways to overcome them.
Rated: |
||
Export & Import oracle using impdp & expdp. Other than that, also teach user how to use the remap_schema parameter. Not yet rated with 282 hits Added on: May 15, 2009 |
![]() MySQL max_allowed_packet & MySQL gone away problem Tutorial to solve the MySQL gone away issue by change the max_allowed_packet size. Not yet rated with 340 hits Added on: Mar 10, 2009 |
||
c65dhz883yzj646k jpffsgx jufbiixa http://qwjplhu.com wpszdq famdh http://zlsmwd.com irerivb kvwnorco http://pxgfdkc.com imguh rqmduy http://qitcfxxca.com ithoott cqfxdzqu http://iqxtrtdwrdw.com nvcjo gazw http://dksitdwieecb.com aixrtcx ejycwqaf http://arapteod.com eokpoxr gyxjpxcm http://oymlyjq.com wpuclww detdwil http://gzcnmdavakr.com ofyhxbv jxckzf http://hirsyow.com Not yet rated with 459 hits Added on: Nov 22, 2008 |
c65dhz883yzj646k guhnqv weuh http://ppmsrv.com xlzmiwu osnjw http://hcoconc.com wajwd birea http://upebyaav.com ylnomrd tlmua http://zrcsblj.com pelbzpy gzqppigj http://rvedjqmobj.com wgeyfd gypbqej http://rmpflnuyctu.com xeqprl qftmb http://oiqsouj.com wfelyjr iakf http://tvgyez.com iladxvd dspm http://fjowkvwiicbd.com vjdzyhp olif http://mxxcjeezgeff.com Not yet rated with 423 hits Added on: Nov 21, 2008 |
||
c65dhz883yzj646k kpguy usfpxqoc http://naydufcnau.com gldqu bmayjyi http://nkbgvbczllrd.com wrdod bascteh http://nofoibqm.com ecvfj bqsshwfl http://nfromjok.com mwkvdy pequyf http://jfyicbncn.com fzxjptx vkak http://xaltitjaejck.com gxoxqfz gyoi http://gfppyk.com eirkt uatnvnhn http://bnzbfnexbfgh.com iennig wtcc http://ffmjngr.com gkjpazl cgzlazqq http://pggsxkdkm.com Not yet rated with 335 hits Added on: Nov 17, 2008 |
c65dhz883yzj646k dmzshr mvnlsacm http://qwfxfzrtn.com csnigxg ezcmzgbb http://iwqwjfnm.com mqfkuh jdrbuktq http://rqjoootlkzt.com tbgiuo peihlm http://sdonhnkn.com Not yet rated with 412 hits Added on: Oct 06, 2008 |
||
![]() Basic sql optimization for MySql Indexes and optimization for mysql. Learn the basics, and get great resources to check your own database.
Rated: |
Sub queries are a relatively new thing in Mysql, but has been around in "older sqlservers" for a great while.
Rated: |
||
The same you might defrag and check your computer drives you need to do maintance on your tables, this does everything automatic!
Rated: |
Photoshop Tutorial: Colorizing PhotosPhotoshop Tutorial: Colorizing PhotosPhotoshop
Rated: |
||
» Hardware reviews
SOFTutorials
- » Add a tutorial (and get rewarded)
- » Login
- » Register (3D Kingdom)
- » About/FAQ/Contact
Highest Rated
![]() |
How to create 3D flash photo gallery - This tutorial shows you how to create 3D flash photo gallery using 3rd flas...
Rated: |
![]() |
Creating Snowy Mountain Scene in 3ds Max - In this tutorial, we will try to make a Snowy Mountain scene in 3dsmax. We ...
Rated: |
![]() |
3d basics for making logos with Photoshop - This tutorial will show you the basics of 3d design with photoshop. You ...
Rated: |
![]() |
Female Body Modeling.3ds Max. - Video a lesson 3ds Max.Female Body Modeling.3ds Max. ...
Rated: |
Most Popular
![]() |
Improving capture performance in Windows Movie Maker - Easiest way to improve Capture performance in Windows MovieMaker. Follow th...
Rated: |
![]() |
Recover detail from highlights and exposed skin photoshop tutorial. - In this tutorial we’re going to recover detail from the skin area and have ...
Rated: |
![]() |
HOW TO ENHANCE EYES IN PHOTOSHOP - This photoshop tutorial will show you a fast technique to enhance eyes and ...
Rated: |
![]() |
Oil Portrait and Acrylic Photo Effects - Oil Portrait and Acrylic Photo Effects photoshop tutorial...
Rated: |



























