10/27/12

Data Warehousing Object: Dimension Tables Types

We had our last post on Fact Tables in Data Warehousing. This post is on Dimension Table Types. Along with Fact Tables there are many types of Dimension Tables which are used in Data Warehousing. Dimension Tables are those tables which contain attributes that helps in describing the facts of the...

10/12/12

9/26/12

Data Warehousing Object : Fact Tables

In the previous post on DW we saw different types of Data Warehousing Schemas. So the different types of schemas had one thing in common and that was, they had Fact and Dimension Tables. So these are nothing but Data Warehousing Objects.  Apart from Fact Tables, Dimension Tables there are...

9/22/12

I want my KAJU KATLI. Do you?

An off the topic post on Code 2 Learn, as KAJU KATLI made me go WOW!!.  You all might be thinking why am I referring to KAJU KATLI and why am I saying "I want my KAJU KATLI".  A friend of mine, who is an entrepreneur, a blogger and a creative genius did some research on...

9/16/12

Count the number of lines in a File in UNIX

UNIX doesn't have any real command which helps us to get the number of lines which has records or data in it. But what UNIX offers is to get the number of new lines. The command wc -l <file_name> gives us the number of new line characters and not the no. of lines which has data. For Example,...

9/15/12

Data Warehousing SCHEMAS

A schema is a collection of database objects, including table, views, indexes and synonyms. There are some special architectures which arranges the schema objects in the schemas models. The most common of them are : * Star Schema * Snowflake Schema * Fact constellation Schem...

9/4/12

What is a Data Warehouse?

A very exciting and one of the hottest topic currently in the IT world is DATA WAREHOUSE. The tools which are used for the same are among some of the hot skills example INFORMATICA, TERADATA etc. ...

8/19/12

Iterative Statements in PL/SQL

In the last post on PL/SQL, we had seen Conditional Statements and how they can be used. Today we will be learning about Iterative Statements in PL/SQL. As we all know the types of Iterative statements that are there in a programming language. PL/SQL also has the same iterative statements and...

UNIX and SHELL Scripting : General Purpose Commands

As everyone is aware of UNIX nowadays thanks to UBUNTU, which has made this platform very popular. In this post we won't be learning about UNIX or its architecture but what we will be learning are the General Purpose Commands required for UNIX and SHELL Scripting. UNIX has a lot of commands...

7/25/12

Conditional Statements in PL/SQL

Conditional Statements in PL/SQL are same as conditional statements available in java, c++, c or any other language. PL/SQL allows processing of data using the following conditional statements:     * IF     * CASE ...

7/6/12

GROUP BY vs DISTINCT in SQL

This question has to come my mind many times and also I have been asked the same question many time. That what should be used GROUP BY or DISTINCT, as both perform the same thing. So, after researching and using both statements and checking the performance using some scripts from here and there,...

6/30/12

Variables and Constants in PL/SQL

This is out first of many tutorial in the PL/SQL series. Today we will be discussing about variables and coonstants in PL/SQL. PL/SQL stands for Procedural Language to Structured Query Language. We can use PL/SQL in the Oracle relational databases, in Oracle Server, and in client-side application...

6/26/12

SQL Data Control Language (DCL) Tutorial

After doing tutorials on DML (Data Manipulation Language) and DDL (Data Definition Language), we will be learning about one more language used in SQL called the Data Control Language (DCL). As we saw in our previous tutorials on SQL, that with the help of DDL we can define tables, databases, views...

6/23/12

SQL Data Definition Language (DDL) Tutorial

After writing a post on Data Manipulation Language (DML), here is another tutorial in SQL series on DDL i.e. Data Definition Language. DDL (Data Definition Language) statements are used to build and modify the structure of your tables and other objects in the database. When you execute a DDL...

6/15/12

SQL Tutorial on Data Manipulation Language (DML)

After writing a tutorial on SQL Baiscs, long back, here I am writing again on SQL, but this time on DML i.e. Data Manipulation Language. By the full form of DML we understand that with the help of this we will be able to manipulate data. Now what kind of manipulation can we do might be the...

6/10/12

6/3/12

Creating a Basic JDBC application

Today we will be creating a Basic JDBC application i.e. an application that will be able to retrieve information (student_name, roll_no, class, DOB, etc) from the database. I already gave a tutorial on connecting SQL Server using JDBC-ODBC Bridge. To do the above we will need to make use of the...

5/21/12

5/20/12

Transaction Isolation Levels in JDBC

The transaction isolation levels in JDBC help us to determine whether the concurrently running transactions in a DB can affect each other or not. If there are 2 or more transactions concurrently accessing the same DataBase, then we need to prevent the actions of the transactions from interfering...

5/9/12

PHP Operators

Fighting With PHP operators: In all programming languages, operators play a key role in performing tasks with variables and values. You might have knowledge about "." or assignment operator"=". There are many operators in PHP. Here these are categorized as : Assignment...

5/7/12

5/5/12

Algorithm Tutorials - Part 1 : Ad-Hoc Problems

I will start with the very basic of Algorithms. Before moving on to the different algorithms, let's first see what does an algorithm actually mean? Definition :  A process or set of rules to be followed in calculations or other problem-solving operations, esp. by a computer.   Aho,...

5/2/12

Cloud Computing : The Future of Web

This is not a tutorial with codes, its a tutorial to make people aware about Cloud Computing, later posts will have tutorials with examples of App Engine. Before we move into Cloud Computing and its characteristics. Lets take the word cloud. CLOUD Cloud is a place or an area where we...

4/19/12

4/17/12

Import a CSV file to MySQL via phpMyAdmin

After getting requests for this tutorial from our readers on this topic, we decided to do a post on it. If you also want to request a tutorial then feel free to use the "Request a Tutorial Here" link and send us a request for FREE. According to the request the task was to import a CSV file to...

4/13/12