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 ...
Learn SQL and Create a Database With Only Your Web Browser
WebSQL is an API built-in to Google's Chrome web browser that allows you to use JavaScript to create and manage SQL databases. It's mind-boggling to me that you can create and manage an SQL database with nothing more than your web browser. 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 ...
What is an Entity Relationship Diagram?
Entity Relationship diagram is simply a graphical concept which shows the flow of information input and output. Entity relationship diagram has three main components, entity, attribute, and relationship. More ...
The Entity-Relationship Model
After you have a data model that meets the organizations business requirements, the easiest way to transform that model into a relational database is to first transform that model into an entity-relationship model. 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 ...
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 ...
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 ...
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 ...
Gettting Started With MySQL Database
MySQL is a powerful relational database management system. The fact that MySQL is used by many major organizations such as Yahoo, NASA and the U.S. Census Bureau proves that it can outperform the big name database management systems. More ...
