Database

/Database

Creating open data connection files on Microsoft Excel and using SharePoint

Microsoft Excel is a tool with functionality beyond imagination and ‘data connections’ is one such functionality, which facilitates users with much ease. ‘Data connections’ web part enables storage and maintenance of multiple data connections to rapidly build workbooks. Excel can be effectively used to import data located externally which can be narrowed down using connections [...]

By |2018-04-19T19:55:43-05:00May 17th, 2015|Categories: Database, Microsoft Excel, SharePoint|Comments Off on Creating open data connection files on Microsoft Excel and using SharePoint

How to Use SQL – Structured Query Language

SQL or Structured Query Language is a set of commands that helps interact with RDBMS systems. The syntax of these commands defines how to use SQL commands and how to define the parameters that the commands must use. An RDBMS or relational database management system will contain, in general, more than one database. Any of [...]

By |2018-04-19T19:55:43-05:00October 31st, 2014|Categories: Database, Programming, Windows|Tags: |Comments Off on How to Use SQL – Structured Query Language

Installing Apache, MySQL, and PHP in Windows

Introduction If you want to learn PHP and/or MySQL, there’s no better way to start than by installing a LAMP/WAMP/MAMP stack on your desktop computer. The difference between LAMP, WAMP, and MAMP, as you can easily see, is the first letter which denotes the operating system name: Linux, Windows, and Mac OS X respectively. Installing [...]

By |2018-04-19T19:55:43-05:00October 19th, 2014|Categories: Database, Programming|Tags: , , |Comments Off on Installing Apache, MySQL, and PHP in Windows

SQL Server Developer – A handy edition of SQL Server

Microsoft has several standard editions of the SQL server product. It offers a special SQL developer edition so that development work can be carried out before installation on a production server. This SQL Server edition is also available directly from Microsoft too. If you were to look at the product page (for example, example the [...]

By |2018-04-19T19:55:44-05:00September 7th, 2014|Categories: Database, Programming, Small Business|Tags: , |Comments Off on SQL Server Developer – A handy edition of SQL Server

What is SQL Server ? Compare different SQL Versions

SQL Server is a software product from the Microsoft. It is a relational database or RDBMS product. Microsoft SQL Server is addressed to same users as the other RDMS products from major software product companies such as DB2 from IBM, Oracle from Oracle Corporation and MySQL is an open-source product. Like all of these competitive [...]

By |2018-04-19T19:55:45-05:00March 30th, 2014|Categories: Database, Programming|Tags: |Comments Off on What is SQL Server ? Compare different SQL Versions

SQL Server 2005 – Your database solution

SQL Server code base grew out of the product owned by Sybase. The version for OS/2 release in 1989 was a product owned by Microsoft. By the time SQL Server version was released in 2000 the code base was nearly free of Sybase code. The SQL Server code for version 2005 was entirely of Microsoft. [...]

By |2018-04-19T19:55:47-05:00September 16th, 2013|Categories: Database, Programming|Tags: |Comments Off on SQL Server 2005 – Your database solution

How to create database in MS Access 2010.

In Microsoft Access 2010, the building block of the database is a table. This is where all the information relating to your database will be stored. As you work with a relational database like MS Access, you will have a number of tables, each of which contain info on a particular subject. After a database [...]

By |2018-04-19T19:55:54-05:00January 22nd, 2012|Categories: Database, Microsoft Access, Office 2010|Comments Off on How to create database in MS Access 2010.