KiA(Know it All) ChatBot

Learning English with intermediate KiA program.

Note: The program is running as trial. I will keep it up-to-date.

SQL Optimization: Transaction - Part 1

The optimization is an integral part of software development. There are a lot of things which we need to optimize as coding, speed, SQL statement, etc.. for example. Hence, this entry will provide some information about how to optimize SQL Transaction Statement that I got from the internet.

• Try to restricts the queries result set by using WHERE clause: the SQL server will return to client only particular columns, not all table's column. It means reducing SQL network traffic
• Try to avoid using the COUNT(*) clause:  you should use alternative way to count
• Try to use constraints instead of triggers, whenever possible
• Use table variables instead of temporary variables
• Try to avoid the HAVING, DISTINCT clause, whenever possible
• Try to use UNION ALL statement instead of UNION: because of UNION ALL does not look for duplicate rows, UNION does look for duplicate rows.

Speaking Technically - Part 1

What's the communication? It's easy to answer this question, because what's the best answer? There is a big problem to anyone. Don't worry about how to find exact answer for the question. We just know that one person can understand what others say, and responding own think, there is called communication.

However, everyone also find out how to communication better? This is a big inquiry. Therefore, the entry I write which will teach you about Speaking Technically and find out the way to master the problem. I have ever read some books writing about Speaking. First of all, you are more likely to speak effectively if you follow the one key rule:

Think what your listeners need to know, not what you want to say.

Get that right by thinking about the interests and needs of  your listeners, you will feel less nervous. Once you feel more confident, you can present better. However, you shouldn't ignore non-verbal language(also called body language), you don't stand at one place to talk and talk. To make more persuasive, using non-verbal language is very good in presentation as well as communication.

That's the first thing I would like to share with everyone. When I have spare-time, I will share more and more to you to find-out  tips and warning in speaking.

TimeTable for fifth Semester Examination

Programming Languages

1. Java:
 - Java is the powerful OOP(Object-Oriented Programming)and easy to learn for intermediate programmer as well.Java can program for Mobile apps(such as: Android), JSP(JavaServer Pages)
 - if you go to program Web with java, you just do not ignore some strong framework: Spring(greater than any else), truts, click...I think Java is good programming languages

2. PHP:
 - PHP is a dynamical language for web programming. With the language, there are a lot of frame work:

1. CodeIgniter
2. Zend frame work
3. CakePHP
4. Symfony
5. etc...

 - PHP is compared with Ruby on Rails(it's also a language for web programming)
3. C/C++(Visual Studio):
 - C/C++ is a complex language that most programmer who feel headache when work with its. However, It is also really strong to program system programming and game with high graphics.
 - If you like these languages, I think you should program in Linux OS(without using Visual Studio:D)
 4. Flash+ActionScript(AS):
 - Oh, Flash +AS is new technology in the world. It's great for 2D graphics(also have 3D graphics, but I don't like 3D in FLash because of it's not nice:D). If you want 3D, I think you should learn OpenGL(it's a OpenSource Library for C/C++)