Tag Archives: SQL

MySql XML Import Primer Tutorial

MySql is a brilliant database especially when it teams up with its partner in Web excitement … PHP. It also is very friendly with the XML protocol, and, like a lot of other database engines integrates XML into its language. … Continue reading

Posted in Data Integration, Database, eLearning, Tutorials | Tagged , , , , , , | Leave a comment

MySql Join versus Subquery and Having Primer Tutorial

Below we have some MySql (but it is very generic in its ideas … particularly if you get rid of the `s), using phpMyAdmin, showing a table Join versus the same functionality using a Subquery approach, then each of these … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , | 26 Comments

MySql Database Copy Tutorial

Do you own a sizable website that uses data? A lot of people reading will be nodding. What do you figure differentiates your website and its presence? . . . . . . The Data! Quite so … lots of … Continue reading

Posted in Data Integration, Database, eLearning, Tutorials | Tagged , , , , , , | Leave a comment

Advantage Database Server Primer Tutorial

Welcome to the Advantage (Database Server) Primer Tutorial … or APT for short, because it is apt, and not because I cut and paste a lot. Advantage Database Server is a relational database management system (RDBMS) for small to medium … Continue reading

Posted in Database, eLearning, Tutorials, Visual Studio | Tagged , , , , , | 2 Comments

Oracle and Unix Korn Shell Primer Tutorial

Oracle databases are great in design and in their range of software tools. The SQL is great and their command line tool SQL*Plus makes the creation of procedures around a job, especially reporting type jobs, very easy. You can do … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , | Leave a comment

SQL Server Primer Tutorial

Welcome to the SQL Server Primer Tutorial … or SSPT for short (although by the time you explain it, it is not so short anymore). Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, … Continue reading

Posted in Database, eLearning, Tutorials, Visual Studio | Tagged , , , , , , | Leave a comment

SQL in MySql Primer Tutorial

Transcript: SQL is a language designed to find and create and update and delete information from a database. Each of the database products such as MySql, SQL Server, Oracle, Access, Advantage and DB2 have their own form of SQL. In … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , | 1 Comment