Search results
02/26/2013
Online Course
T-SQL Step by Step Course
Welcome everyone to the T-SQL course. Here you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2012 (which is a free download).
09/14/2012
Article
Architecture of a DBMS
See in this article some concepts related to data modeling, with emphasis on a DBMS architectures.
07/20/2012
Article
Advanced operations on MySQL database.
This article will explain you some advanced operations on MySQL like views, triggers, index and stored procedures. It is really important article for those aiming to build a website.
07/17/2012
Article
Simple MySQL database functions and operations
This article will tell you how you can work with MySQL database. It is meant for all beginners that want to know how we can create a new database, create a new table, make a inseret, delete or update a value in a table, alter or drop a table, use a select query and functions like sum, count, avg which makes the work easy.
06/05/2012
Article
SSMS Tools Pack in SQL Server
In this article, we are continuing our discussion of applications and add-ons that make developing applications simpler. Today’s discussion is about SSMS Tool Pack.
05/23/2012
Article
Working with indexes in databases for beginners
In this article you will see how constructing or creating an index may help retrieving the data at a much faster pace but it should be used very carefully and only at places where it is really required for.
05/04/2012
Article
SQL Search and XML Notepad
This article is a part of a series of articles that discuss tools and applications that are helpful to application developers. In this article we will talk about SQL Search and XML Notepad.
02/24/2012
Article
Modeling Social Networks – Part 1
In the first part of this article we will see a simple network of relationships and a model that stores a generic social network.
02/16/2012
Article
Building a Tag Cloud
The article describes what the tag clouds are, how they are used and also how to implement a tag cloud from information stored in a SQL Server table
01/29/2012
Article
Storing the Backup on Tape – Part 1
In this article we will discuss the requirements, technologies, strategies and recommendations for the recording of a database backup on a tape.