Database Search Results

How To: Fix a WordPress database connection error

See how to resolve a WordPress MySQL database connection error with this free video tutorial. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.

How To: Use database functions in Microsoft Excel 1997-2003

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Hack an Oracle database

In this installment from the Unorthodox Hacking series of Internet security tutorials, you'll learn how to get a shell on an Oracle database. To see how to pop a shell from within Oracle or even perform a port scan from the database itself, watch this hacking how-to.

How To: Import Excel to a MySQL database with cPanel

This data management tutorial shows you how to take a Microsoft Excel Spreadsheet and import it into a MySQL Database using CSV files and PHPMyAdmin in cPanel. Being able to move data from Excel to MySQL is an important part of database content management, so if you use cPanel to manage your databases, you'll want to watch and learn how to import Excel spreadsheets into your MysQL databases.

How To: Connect to a MySQL database using DreamCoder

If you're new to DreamCoder for MySQL, one of the first things you may want to know how to accomplish is to connect to a remote MySQL database. Happily, this tutorial will walk you, step by step, through the process. To learn how to establish a connection between a given MySQL database and the DreamCoder for MySQL, take a look!

How To: Password protect databases with Microsoft Access

The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a login form and password protecting your database.

How To: Connect to a MySQL database with PHP

In this clip, you'll learn how to connect to a MySQL database with PHP. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look

How To: Use phpMyAdmin to create a MySQL database for WordPress

In this clip, you'll learn how to use phpMyAdmin to generate a SQL database for a WordPress blog. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a simple relational database with PHP and MySQL

In this clip, you'll learn how to generate a simple relational database with PHP and MySQL. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a MySQL database for Celtx media pre-production application

In this clip, you'll learn how to generate a basic MySQL database for use with Celtx. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Connect to a Celtx storyboard database with simple PHP commands

In this clip, you'll learn how to connect to a Celtx SQL database with PHP. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Create databases from existing files in FileMaker Pro

Want to create a database from an existing file within FileMaker Pro? Whether you're new to FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to quickly generate databases from existing files.

How To: Backup and restore OnTime databases

Did you know that OnTime includes tools to help you backup and restore your OnTime database? This installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite covers the basics of restoring and backing up a database through the OnTime system. Take a look.

How To: Install WAMP and create a MySQL database

This tutorial covers installing the WAMP (that is, Windows-Apache-MySQL-PHP) all-in-one package and creating a MySQL database using the import function of phpMyAdmin. For step-by-step instructions on the WAMP installation process, or to get started installing your own WAMP serve, take a look.

How To: Extract dates and times from a database field in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.

How To: Create a text alert database using Google Forms

This video explains how to create a database text alert using Google Forms. In Google documents click on new, then form. After naming the form and typing in that standard text messaging rates apply, our presenter selects multiple choice yes or no options. Select it to be a required question so that the user can make sure they understand terms. You can choose to select any or all of the questions to be required. You can then type in various questions for the user to answer-our presenter wants ...

How To: Create PDO's (PHP Database Objects) in PHP

Learn to work with PDO in PHP with this informative video tutorial from JREAMdesign. The PDO extension is a consistent interface for accessing several types of databases in PHP and it has a ton of options. This knowledge is also required for Zend Certification.

How To: Create a database and table in phpMyAdmin

In this clip, you'll learn how to go about creating databases and tables from within the phpMyAdmin tool. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look

How To: Query a MySQL database with MYSQLI and SQL queries

In this clip, you'll learn how to use query MySQL databases when coding in PHP. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Access and edit databases in MySQL Query Browser

In this tutorial we show you where to download MySQL Query Browser and how to access and edit your databases. MySQL Query Browser is an easy way to access database information remotely from your desktop without having to log in to your server. Learn where to get MySQL Query Browser, and how to use it to access and edit your databases.

How To: Use Excel databases for home improvement calculations

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 236th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a database for keeping carpentry measurements as well as how to use a COUNTIF function formula for calculating how many lumber pieces you'll need to cut for your home improvement project.

How To: Use the Zoho Creator database application

While all Web 2.0 applications are by no means equal, certain among them can save you time, money, and frustration–one such web app is the Zoho Creator database utility, which is comparable to Access from the Microsoft Office suite. For more information, or to get started using the Zoho Creator online database application for yourself, take a look!

How To: Set up a MySQL database for Moodle in WebMin

Interested in teaching an online course using your own server but can't quite figure out how to install everything you'll need? This video demonstrates how to setup a MySQL database for use with Moodle, the free, open source course management utility, which requires a MySQL database to run. For step-by-step instructions, take a look.

How To: Connect to PostgreSQL database server with DreamCoder

If you're new to DreamCoder for PostgreSQL, one of the first things you may want to know how to accomplish is to connect to a remote PostgreSQL database. Happily, this tutorial will walk you, step by step, through the process. To learn how to establish a connection between a given PostgreSQL database and the DreamCoder for PostgreSQL, take a look!

How To: Connect to a MySQL database using DreamCoder via SSH

If you're new to DreamCoder for MySQL, one of the first things you may want to know how to accomplish is to connect to a remote MySQL database securely via SSH tunneling. Happily, this tutorial will walk you, step by step, through the process. To learn how to establish a secure connection between a given MySQL database and the DreamCoder for MySQL, take a look!