programmingsite : code , tutorials and scripts
Navigation

home


ASP
ASP.net
C
C++
C#
PHP
Java
JavaScript
Powershell
VB.net

Visual Basic

Resources
code
tutorials
training

Ads
Products

 

 





MySQL

Getting Started

Welcome
What You Will Need

Database Basics

What Is A Database?
RDBMSs
Tables and Data Pt 1
Tables and Data Pt 2

SQL Basics

Finding Your Way About
Creating a Database
Creating a Table
Column Types-String Pt 1
Column Types-String Pt 2
Column Types-Numeric Pt 1
Column Types-Numeric Pt 2
Retrieving Data With Search Criteria
Changing Existing Data
Altering A Table
Keys And Indexes
Basics Syntax Recap

Operators in MySQL

Arithmetic Operators
Numeric Comparison Operators
String Comparison Operators
Logical Operators
Bitwise Operators
Regular Expressions 1
Regular Expressions 2 Pt 1
Regular Expressions 2 Pt 2
Operators Syntax Recap

Querying Your Data

Sorting Retrieved Data
Specifying Numbers of Results
Joining Tables Pt 1
Joining Tables Pt 2
More On Joining Tables
Data Aggregation
Queries Syntax Recap

More Complex SQL

Using Default Data
Date And Time 1 Pt 1
Date And Time 1 Pt 2
Date And Time 2
ENUM column type
SET column type Pt 1
SET column type Pt 2
Using Variables
Conditional: IF()
Complex Syntax Recap

Good Practices

Using SQL batch files Pt 1
Using SQL batch files Pt 2
Data Modeling Pt 1
Data Modeling Pt 2
Normalization Pt 1
Normalization Pt 2
Optimizations

Security

Users And Privileges
More About Users And Privileges
The mysql Database Pt 1
The mysql Database Pt 2
Encryption
Security Syntax Recap

Building A Database Application

Planning The Structure
Designing The Database Pt 1
Designing The Database Pt 2
Creating The Database Pt 1
Creating The Database Pt 2
Logging In And Out
Checking Videos In And Out Pt 1
Checking Videos In And Out Pt 2
Searching For A Video
Adding A New Title
Signing Up A New Customer
Hiring And Firing Employees Pt 1
Hiring And Firing Employees Pt 2
Listing Debtors






Products
500 Java Tips E-book
PHP editor
PERL editor
Beginning Java
Beginning Visual Basic
Learn VB.net
Learn VB 6
VB and databases
ASP image library
C++ builder programming
C++ fundamentals
Asp Studio 2005
Xtra PHP
Online PHP Script Encoder
Comparison

Links
Make money selling software
Uk shopping
UK price comparison
US price comparison
free articles
free stuff
Gambling resources
Software directory
XBox cheats and more
Sexy free wallpapers
Hosting resources
Nintendo Wii info
Beginners PHP
Health and fitness
Domain names
Dating site
Nintendo DS resources
Dropshippers
Maxi directory
Perfume and fragrances
PC shopping, tips and info
Magazine superstore

Ads