This tutorial covers installing WAMP and creating a MySQL data base using the import function of phpMyAdmin.
This tutorial was created by Mike Lively of Northern Kentucky University.
Duration : 0:9:58
Installing WAMP and Creating a MySQL Database
How To Put Game Saves, Custom Themes and Other Crap Onto Your PS3
Its very easy once you know how.
Memory Stick PS3 THEME / SAVEDATA
Game Saves
1 Find the Game Save you want
2 Wack in a USB stick into your PC.
3 In the USB stick, create a folder called PS3, and within that folder create another folder called SAVEDATA (CAPITALS)
4 Copy the Game Save into that folder.
5 Once copied shove it in your PS3.
6 Go to ‘Game’ on the XMB, select ‘Saved Data Utility’ and then select ‘USB Device’.
7 Press Triangle on the save file and select the ‘Copy’ option.
Themes
1 Find the Theme you want
2 Wack in a USB stick into your PC.
3 In the USB stick, create a folder called PS3, and within that folder create another folder called THEME (CAPITALS)
4 Copy the Theme into that folder.
5 Once copied shove it in your PS3.
6 Go to ‘Settings’ on the XMB, select ‘Theme Settings’ and then select ‘USB Device’.
7 Then install
8. Then apply it.
Duration : 0:3:29
Using an HTML Form to insert data into mysql database
This tutorial umes that you know how to set up your mysql database. If you do not know how to do that then you can download a full set of tutorials on the basics of this at http://www.kperspectives.com/Dreamweaver/free_tutorials.php. With this tutorial you will learn the basics of setting up a data insert form in Dreamweaver CS3.
Duration : 0:4:50
Using Google Spreadsheets as a Database in the Cloud
Watch Jeffrey Scudder demonstrate his GData Python Client Library extension that makes it easy to use Google Spreadsheets as a database in the cloud.
http://code.google.com/apis/spreadsheets
Duration : 0:6:2
Excel Magic Trick #94: VLOOKUP Into Web Query
See how to use a currency web query, and then link it to a data validation cell drop down list and a VLOOKUP formula that transforms a Balance Sheet from One Currency To Another.
VLOOKUP and Web Query and Data Validation
Formula and functions
Duration : 0:5:18
SQL Joins (Lab3.1 Using an Inner Join in your query.)
www.Joes2Pros.com… Learn how to use basic inner joins to see two tables in one results set..
Duration : 0:8:37
Database – Alexander Perls
All song info is located in the “Statistics and Data” tab next to the “Commentary” tab.
Duration : 0:3:14
SQL Server 2008 and using Transact SQL (TSQL)
http://www.learningsqlserver2008.com/
If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with a little background and the database we will use AdventureWorks2008. We start off with the SELECT statement which is used to return data. The basic syntax is discuss with an e.g. from Person and SalesOrderHeader table. We move onto the INSERT statement using the Person table in the database. The next two statements are UPDATE and DELETE which are very powerful. Using a where clause is extremely important here. We show you how to change data in Person table. (Running time is 32 mins)
Duration : 0:9:17