Databases--tutorial.jcwcn.com

this：1/4 25records total:97 start Previous Next Last goto:

Application Privacy Monitoring for JDBC: ON: 2009-03-16 09:34:26; Privacy policies allow organizations to control the use of personally identifiable information according to individual choices. The Application Privacy Monitoring for JDBC is a technology preview providing a Java library for adding privacy policy enforcement to existing Web applications that use JDBC/SQL; 8 times | category: [Miscellaneous]

SQL Database for Suggestions as You Type in C#: ON: 2009-03-16 09:33:46; This tutorial will show you how to use an AJAX Extender to provide suggestions as you type in a textbox, similar to the Google feature. C# version.; 214 times | category: [Miscellaneous]

Calendar Control and SQL to Create an Organizer in C#: ON: 2009-03-16 09:32:57; This tutorial will show you how to use a SQL database, a SQL database, and the Calendar and FormView Controls to create an organizer to keep track of events of different days. C# version.; 217 times | category: [Miscellaneous]

MySQL max_allowed_packet & MySQL gone away problem: ON: 2009-03-16 09:15:36; This tutorial is regarding the MySQL gone away problem & the solution max_allowed_packet settings.; 36 times | category: [Miscellaneous]

MySQL backup tutorial: ON: 2009-03-16 09:14:00; In this tutorial I will show you a short and simple way how to create a backup copy of your MySQL database using the mysqldump utility.; 31 times | category: [Miscellaneous]

Reset MySQL root password: ON: 2009-03-16 09:11:37; This tutorial is teach the database administrator on how to reset the root password if he/she forget the root password.; 17 times | category: [Miscellaneous]

Security Issues : Cleaning up User Data in MySQL: ON: 2009-03-16 09:05:52; One of the things you’re going to encounter when using MySQL with PHP sooner, rather than later, is the issues that arise when you start accepting user input in the form of comments or blog posts. Up until now in this tutorial, we’ve just been using datcasa that we’ve defined ourselves. We’ve been able to control what goes into our database tables.; 45 times | category: [Miscellaneous]

Creating a Simple Comments and Login System using MySQL and PHP: ON: 2009-03-16 09:01:46; In this tutorial we'll build ourselves a very simple PHP application to accept user data and save it into our database. This information will then be displayed to anyone visiting the site. We’ll also take a quick look at how we can generate a script to authenticate administrative users based on a username and password combination and allow those admin users to delete unwanted comments from the database.; 329 times | category: [Miscellaneous]

Generating Reports using MySQL’s Aggregate Functions: ON: 2009-03-16 08:57:31; MySQL contains a range of functions which are useful for generating aggregate data about multiple records including averages, minimum/maximum values and sum/totals; 76 times | category: [Miscellaneous]

Using Multiple MySQL Tables with Unique IDs, Joins and Normalization: ON: 2009-03-16 08:55:03; In this tutorial we’re going to look at an example where it becomes useful to use more than one table at a time while still using the powerful features of MySQL to query this data in a simple, straightforward manner using JOIN methods; 150 times | category: [Miscellaneous]

Column and Data Types in MySQL: ON: 2009-03-16 08:53:42; In this tutorial we won’t be doing anything too technical. Instead, we’ll be focusing on learning about how MySQL represents the data you give it to store, and the limitations and potential benefits each storage type brings.; 101 times | category: [Miscellaneous]

Using PHPMyAdmin to manage your MySQL data: ON: 2009-03-16 08:48:32; PhpMyAdmin is a popular open-source application used to remotely manage and modify MySQL databases and is particularly useful for use on websites as it can be placed within a secure directory on a remote web server and accessed via a specific URL. This allows you to easily and quickly access your data to make changes, to download backups or perform a range of other useful operations; 65 times | category: [Miscellaneous]

Using Stored procedure with mySQL and PHP: ON: 2009-03-16 08:36:44; Writing external scripts to perform complex data handling is a tedious affair. The best way to automate tasks straightaway into the server is by using Stored Procedures. It is very useful to make them as flexible as possible, as it facilitates easy identification of any errors and can be used for executing a variety of tasks as well.; 99 times | category: [Miscellaneous]

SQL Server FAQs - Transact-SQL Understanding Stored Procedures: ON: 2009-03-16 08:32:29; A collection of 19 FAQs on SQL Server Transact-SQL stored procedures. Clear answers are provided with tutorial exercises on creating and dropping stored procedures; retrieving and modifying stored procedures; ending stored procedures properly; defining and passing values through input and output parameters; temporary and permanent stored procedures.; 642 times | category: [Miscellaneous]

Working with alias data types in SQL Server 2005 using T-SQL: ON: 2009-03-16 08:31:48; In this tutorial you will see how you can add, use and delete alias data types in Microsoft SQL Server 2005 using T-SQL; 110 times | category: [Miscellaneous]

Use the Zoom Box in Access 2007: ON: 2009-03-16 08:25:45; The Access 2007 zoom box allows you to view field data in a separate box where you can view the text more closely and perform some other options to the data.; 19 times | category: [Miscellaneous]

Entering, Manipulating Data and Table Relationships in Microsoft Access: ON: 2009-03-13 17:23:02; This short tutorial explains how enter, manipulate data and also about table relationships in MS Access. Follow the below link for more details.; 50 times | category: [Miscellaneous]

Introduction to database design: ON: 2009-03-13 17:14:53; This article/tutorial will teach the basis of relational database design and explains how to make a good database design.; 124 times | category: [Miscellaneous]

Sybase Overview: ON: 2008-09-12 10:51:36; An overview of what Sybase is, and what it does.; 445 times | category: [Miscellaneous]

Sybase 101 - DBA Tasks Unix Scripts: ON: 2008-09-12 10:50:33; Sybase 101 - DBA Tasks Unix Scripts; 268 times | category: [Miscellaneous]

Sybase 101 - DDL Overview: ON: 2008-09-12 10:48:35; Sybase 101, DDL Overview - Transact-SQL Primer.; 240 times | category: [Miscellaneous]

SQL Injection - The common security breach in websites.: ON: 2008-09-12 10:45:41; SQL injection is most common methodology employed by a hacker to exploit vulnerabilities in software applications. Vulnerabilities are basically weak links in the software that exposes unauthorized data/information to a user. SQL injection occurs when the user input is incorrectly filtered for embedded SQL statements.
The technique is powerful enough not only to expose the information to the user but also modify and delete the content which could prove disastrous to the company.; 8 times | category: [Miscellaneous]

How to Use sql Aggregate Functions: ON: 2008-09-12 10:44:51; Want to find out the minimum or average on a given data? Learn to use SQL's aggregate function for this.; 11 times | category: [Miscellaneous]

How to Concantenate Strings: ON: 2008-09-12 10:43:50; Often times you have to combine output data in SQL, concatenation can be used for this.; 10 times | category: [Miscellaneous]

How to Update, Change, and Delete in SQL: ON: 2008-09-12 10:43:01; Managing database requires three major things-update, change , and delete. Learn the steps to do this in SQL.; 9 times | category: [Miscellaneous]