Oracle Database Introduction to SQL Training

Posted by czcoder on January 2, 2012 No comments
The SQL introduction training is a first level training course that aims to teach basic sql syntax and styles. The user of to course learns sql statements, sql tools and write sql code on an application. Usually these types of courses assumes that the ser knows database objects like tables, queries. In these type of courses the concept are like that: Basic tools to connect to Oracle such as Toad. Basic SQL syntax and styles Basic PLSQL coding style The first step is how to connect Oracle? Read More [...]
Oracle, SQL, Training

Oracle Database 11g Performance Tuning Training

Posted by czcoder on January 2, 2012 No comments
Performance tuning is an important factor for Oracle databases.  The speed is a key factor for a database if the database must respond to the clients in a short time. There are a lot of factor which affects the performance of a database. If the administrator of the database increase performance of one side the other factors can be worse. So, the administrator should look for the cache buffer tuning, network tuning and plsql tuning.  Cache and buffer tuning is the first factor to cover in a Oracle Read More [...]
Oracle, Training,

Oracle 11g System Administrator Training

Posted by czcoder on January 1, 2012 No comments
The system administration for a database system requires a detailed training. Oracle system administration is somewhat harder then the other database systems. Oracle is usualy used for online systems. So, the system have curical real time informations. Most of the Oracle systems requires quick back ups. The last version 11g has a fast backup system. The administrator will be responsible for the entire system.The safety of the tables in the system, the maintenance of the database and the protection Read More [...]
Oracle, Training, , ,

Migration problems during Oracle 10g to 11g

Posted by czcoder on December 31, 2011 No comments
Oracle created the new database system 11g. The new system is a powerfull sytem for OLTP servers. Most of the users of Oracle use Orace 10g or the older versions of Oracle databases. The migration from Oracle 10g ( or the older versions of Oracle) to Oracle 11g is not so simple. The systax of Oracle 8g is some what different. For example for left join and right join, Oracle 8g uses + "plus" sign. If the one sight of the join has plus sign then the compiler recognizes this is a left or right join. Read More [...]
Oracle,

Online Sytems Usage For Sybase IQ

Posted by czcoder on December 31, 2011 No comments
Sybase IQ is a database system that is mostly used for data warehouse purposes. The database is good enougn for summery tables and queries. The use of aggrigate functions lie sum, max, min responds very quickly. On the other hand, the insert and update operations are very slow. The bulk insert operation is good but, the insertion of one row is moderate. Since the system is designed for data mining and data warehouse, the Sybase systems can not respond for online operations. OLTP response is very Read More [...]
Sybase,

Java Application Servers Review

Posted by czcoder on December 27, 2011 No comments
There are a lot of application servers in which java codes can run. These servers executes the code and runs it. In the server, you can run both java beans and any type of java web modules. To run a code on the application server, first you should develop your code. And then you should deploy the code on the server. If you use an application server on your local computer, you will deploy the code on the localhost. Otherwise, you will use a ftp program to trasfer the code to the server. The deployment Read More [...]
java

Oracle and Sybase Load data from file

Posted by czcoder on December 26, 2011 No comments
Both database system Oracle and Sybase need external files to be loaded into the system. The data from environment comes as a text file and must be loaded into a table in the database. The files must be ordered column type files so that the user can load it. To load the file in both system, first of all the file must be copied to the server where the database is running. To do that, you can use any FTP program to transfer the file into the server. (Filezilla is a free open source FTP program) After Read More [...]
Oracle, Sybase, , ,

Creating Temporary Tables Sybase

Posted by czcoder on December 26, 2011 No comments
Sybase is a powerfull column based database. The database is used for especially data wharehouse  and datamining. Creating reports, creating summary tables and using aggregate function is very easy in Sybase. There are two types of tables in Sybase IQ. The first one, is the real types that is stored on disk. The data is on disk so, when the database restarts or the user signs off the tables will not be erased. This type of tables are common in all database systems. Data resides on disk and safely Read More [...]
Sybase,

Java Environment Eclipse or Netbeans

Posted by czcoder on December 21, 2011 No comments
When I started to write code on java, I was using a standart notepad editor. After my code finished, i was using statndart java comands to compile and run the code I wrote. To compile the code, you should open a command prompt program and then go to the directory in which you saved your code. Finally, write javac comand. You had to orginize your class and java files by yourself. Now there are two famious java environment to develop java projects. Namely, Netbeans environment and Eclipse environment. Read More [...]
java,

Comment Importance in coding and Comment Styles

Posted by czcoder on December 18, 2011 No comments
The comment is one of the most important aspects of programming. It is not just for hiding old code from the compiler, but it is also usefull for keeping information about what the code item is. After a moment you will have difficulty about remembering the code you wrote. To remember what was going on, commenting on the code is very important. You can write some words on the code, to tell the next programmer what is this code. Moreover, if you depart from the project the new programmer who is responsible Read More [...]
java, Oracle, Sybase, ,