Category Archives: Database

A database is an organized collection of data ( Wikipedia )

SQL Server CSV Import Primer Tutorial

Posted on by

Welcome to the SQL Server CSV Import Primer Tutorial. Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested … Continue reading →

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

MySql XML Import Primer Tutorial

Posted on by

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

Access Primer Tutorial

Posted on by

Welcome to the Access (Database Server) Primer Tutorial. Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It … Continue reading →

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

MySql Join versus Subquery and Having Primer Tutorial

Posted on by

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

Toad interface to Oracle Primer Tutorial

Posted on by

Is there anything as good as the way phpMyAdmin interfaces to MySql available in Oracle? What if I told you not to look at this post’s titles and captions, and gave you the hint “Friend of Mole and Ratty and … Continue reading →

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

MySql Database Copy Tutorial

Posted on by

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

Posted on by

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

Posted on by

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