Subcategories
DB2 (2)
MS Access (2)
MS SQL (3)
MySQL (28)
Oracle (4)
Others (2)
SQLite (0)
Sybase (0)
Databases tutorialsShowing tutorials 0 to 20 out of 41 Databases tutorials. | |||
|---|---|---|---|
|
ADVERTISMENT |
ADVERTISMENT |
 How To: Install mtop on CentOS Learn how to install mtop on CentOS Linux - MySQL performance Not yet rated with 156 hits Added on: Jun 29, 2010 |
 How To: Reset a WordPress user Password using phpMyAdmin or MySQL Console Reset a users password on Wordpress using database tools Not yet rated with 110 hits Added on: Apr 30, 2010 |
 Learn to Use Indexes to Optimize your MySQL servers Performance MySQL users will be able to create, drop, and modify indexes in order to efficiently hone their server's performance. They will learn how to add index and fulltext indexes to tables along with comparing clustered and non-clustered indexes. Administrators will also be shown how to identify duplicate indexes, which can hinder their servers' performance and also learn how to speed up searches for sub domains. Not yet rated with 134 hits Added on: Mar 25, 2010 |
 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 198 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 368 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 318 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 314 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 264 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 317 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 477 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 293 hits Added on: Jul 25, 2009 |
basics of oracle sql in oracle 10g express edition. Not yet rated with 347 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 405 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 439 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 566 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 541 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 417 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 502 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: |
||
» 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: |