Menu
SQL (Structured Query Language)

Language Integrated Queries (LINQ) and Visual Basic
LINQ is a better version of SQL - it is a part of ADO.NET and is integrated with VB.NET. LINQ now has the long missing option of using Visual Basic functionality in the data selection process. More ...

Introduction to SQL (Structured Query Language)
IBM developed its relational database management system by creating a language initially named SEQUEL (Structured English Query Language). However IBM's legal department found a possible copyright issue with the name SEQUEL. So they decided to drop the vowels and call the language SQL. More ...

SQL 2012 Data Tools
Data Tools (SSDT) is a tool set designed for use by Microsoft with SQL Server and SQL Azure to facilitate database design. Features include business intelligence (BI) tools, rapid data discovery, and data warehousing, among others. More ...

Program a Visual Basic MySQL Database
In my previous article we used MySQLGUI for executing SQL queries on our example database. In this article I show you how to program a simple MySQL database browser using Visual Basic. I assume that you already know how to program a simple Visual Basic .EXE project. More ...

Introduction to SQL Database Design
A Database is the storage of data in what are called tables. Without knowing what kind of data you are planning on storing, you will not know how to create the tables. More ...

Conversion of Access Database Systems to Visual Basic Dot NET and SQL Server
Microsoft will continue supporting VBA for many years to come, but the programming emphasis is rapidly changing in favour of Visual Basic.Net and SQL Server. More ...

Entity-Relationship Diagrams
An entity-relationship (ER) model represents the structure of a database, where data equates to entities (or objects) that are linked by relationships expressing dependencies and requirements. More ...

Database Administration
This is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field?s latest realities and challenges. More ...