One more reason to connect with Raj Raj

Hi koreinfotech.blog

Since you were first invited to join Raj Raj on WAYN, much has changed!

The website has just been redesigned to be much more user friendly; and we have some great new tools to enable you and your friends to keep in touch and share experiences.

You can publish your "plans" on the WAYN homepage and let your friends know what you're up to, and see if any of your friends are interested in joining you.

Whether it be a weekend break away, a night out with the lads/ladies, or a simple gathering at your local pub WAYN makes it easy to share your plans with your friends.

To connect with Raj Raj – click here

Hope to see you online & planning soon!

Regards,

The WAYN Team
 

This is a reminder service from WAYN – if you do not want to receive any further emails from this service, please click here

Unix Shell Scripting

Come and learn Unix Shell Scripting in a power packed 3 day course and empower yourself to automate Unix Tasks on a day to day basis.

Unix Shell scripting holds the power to automate the most challenging tasks and today organizations are depending on running their operations based on shell scripts.

We cover this in 3 days, 4 hrs per day on a weekend. We make it a short consice exersice based on real-world scenarios geared towards applying the skills learnt immediately on the job.

We also price this course moderately to make it affordable to the masses. You pay only $150 for the entire 3 day programme.

Course Contents

• INTRODUCTION TO SHELL PROGRAMMING
• THE BASIC SHELLS
• SIMPLE, COMPLEX AND SPECIAL COMMANDS (INCLUDING LOOP AND CONDITION STRUCTURES)
• COMMAND SUBSTITUTION
• START UP FILES AND ENVIRONMENT
• PIPES, LISTS AND REDIRECTION
• INPUT AND OUTPUT
• WORKING WITH FILES
• SPECIAL FUNCTIONS (Date and Time / File Set-up / String Functions / Menu Functions / Utility Functions)
• DEBUGGING SCRIPTS

Please write to us at shellscript@koreinfotech.com or raj@koreinfotech.com to book your seats. We need a minimum of 3 participants to start a batch.

Kore Infotech Pte Ltd.
www.koreinfotech.com

A workshop on Oracle Database PL/SQL , SQL

This course assumes no prior knowledge of Oracle or SQL.


Details: 
This course is designed to use real-word examples to
communicate with a database.Its is designed to understand
the communicarion language of databases (SQL) and the
programming language of Oracle (PL/SQL). Instruction
focuses on core language topics, emphasizing cursor usage.
It takes an extended look at programmer-defined stored
packages, inline functions and transaction processing
concepts. Students will learn techniques for utilizing
many of the advanced features of the latest database
version of PL/SQL.

The course provides students with all of the essentials
to develop intermediate PL/SQL programming skills.


The series of classroom labs, which run in a real-world
UNIX / Windows environment, are structured to allow
you to learn by doing.

The hands-on labs progressively build your UNIX knowledge
and command skills in a clear and concise manner.

Working in a controlled classroom environment with an expert
instructor, you will learn concepts, commands, terminology
and database concepts.
You will receive professional tips and techniques that will
help you build your confidence and skills.

Course Contents

* What is database
* Need for a relational database
* Understanding the basic Oracle Architecture
* Understanding the different data types in Oracle
* Understanding the different statement types in Oracle
* Creating, Altering and Dropping Tables
* What is a constraint and different types of constraints
* Creating, altering and dropping constraints
* Retreiving data from tables using SELECT
* The WHERE clause
* Conditional Comparisons
* The ORDER BY clause
* understanding joins (Natural or Inner, Outer, Self, Equi)
and using them in SELECT

* Working with Subquery
* Working with Oracle provided string, number, date and special
functions like decode

* The DUAL table
* Working with NULL data
* Working with INSERT
* Working with UPDATE
* Working with DELETE
* Working with TRUNCATE
* What is PL/SQL
* What is an anonymous PL/SQL block
* Variables and Types in PL/SQL
* Writing, compiling and executing Procedures in PL/SQL
* Writing, compiling and executing Functions in PL/SQL
* Writing, compiling and executing Packages in PL/SQL
* Writing, compiling and executing Triggers in PL/SQL
* Working with explicit and implicit cursors in PL/SQL
* Indexes in Oracle
* Views in Oracle
* Synonyms in Oracle
* Sequences in Oracle
* COMMIT vs ROLLBACK vs SAVEPOINT
* What is performance optimization
* Ways of Optimizing a Query
* Creating a Normalizated relational database

Course Fees:
Fees for this course will be S$ 400 per participant.
Early registrations shall receive a $50 discount!!

So quickly get in touch with us for your registrations.

Participants per batch - 4.

Unix Interview Questions

Unix Interview questions:

1. How to find out how much CPU, RAM the m/c has.?

2. How to find out the network port is running at what speed?

3. What is setuid and setgid ?

4. What is the difference between UDP and TCP?

5. What is subnetting, netmask?

6. How can you lock the remote login of root, which means don’t allow root to login from anywhere except console?

7. How to change the no of times ‘retry’ is allowed for login (when u login with wrong passwd, by default allows for 5 times, for example)?

8. What is rarp and how do u check the arp cache?

9. How do you create a swapfile?

10. How to check at what speed is the network card running in solaris, linux?

11. What are the 3 fields in top that show system load figures? If you have 4 processors and one process is showing 25% usage in top what does that mean?

12. How will you know which of the resources memory, disk usage or cpu is running low or is the bottleneck? How do you check these params?

13. What is jumpstart/kickstart? What is the need? Can you jumpstart machines across subnets, how?

14. How do you configure system event logging? What is loghost?

15. What is the use of the utility dd? How do you take a dd of an entire hard disk?

16. What is IP multipathing, have you used it before?

17. What is dfstab and vfstab for ?

18. What is automounter? Have you used it before, what is the purpose?

19. What are soft, hard links - do you know of any examples where these are typically used.

20. What is sticky bit, which filesystem has it set by default?

21. What are the different file system types? What is difference between UFS, ext2, ext3?

22. How do u achieve to execute some command before each time a prompt is displayed, before each time you logout?

23. How do you display the directory usage of /home for each user? Or how do you find out which user is consuming the most amount of disk space?

24. How do you cut columns 1 to 5 from a given output?

25. How do you find disk drive statistics or how many disks are connected to your system currently?

26. In shell scripting what does 2>&1 mean?

27.How to change the hostname/ip address on solaris/linux?

28. How do you kill all processes of a given user in a single command?

29. How do you monitor which processes are taking max cpu/mem?

30. What are rlogin, rsh, telnet used for? What are the differences?

31. Have you used scripting – shell / perl?

32. Is there a diff between bourne , korn and c shell scripting?

If you are used to writing k shell scripts and you go to a new environment where they use tcsh by default, what will you do – will you learn how to write c shell scripts or is there a way you can continue using your k shell scripting knowledge and still write scripts?

33. A given server is overloaded by users, you can’t telnet or rsh into that server. What will you do next, is there any other way to access this server and prevent a hard reboot?

34. How do you disable telnet or ftp on a given server? How do you disable these for a specific user and allow a specific group of users to access at the same time on the same server?

35. You try to login to a server (say using telnet) as root and you are not allowed to login and you get a message “not on system console” what does this mean?

36. If you run a GUI based app (eg. Browser) on server A, whereas you are sitting on server B, how do you see the application on server B?

37. What protocol does ping command use?

38. What is tftp, have you used it before. Do you know one application where it is used?

39. What is loopback, why do you need the line localhost in /etc/hosts file?

40. For sun or linux how to you install packages such that you can rollback?

41. What is RAID? How is it useful? What are the different types?

42. How do you see what messages a system printed on the console while it was booting up?

43. If you are given a machine for which you do not know the root password, can you reset it? How?

Vi or Vim

44. In vi how do you remove the ^M from a DOS file?

45. How do you do a global search and replace in vi?

46. How do you copy , paste or delete 10 lines or a paragraph?

47. If you want to see line numbers in vi, how do you turn them on/off?

48. How do you move to end /beginning of a line, or end of a file?

49. How do you save a copy of a file while in vi?

50. How do you execute a unix command while still in vi?

Kore Infotech Pte Ltd,
Singapore.

Unix Training Course

We are running Unix Training as below based on Solaris & Linux:
Level : Basic to Intermediate
Pre-Requisite: No prior knowledge of Unix is required.
Methodology: Hands on on two servers Solaris and Linux.
Course fees is S$ 600 per participant.
Duration: 5 weeks, twice a week. (Tue , Thu - 7-9 pm, Sun 3-6 pm)
Participants per batch: Normally 4, max 6.
Training schedule and timing may change from batch to batch.

Course Contents

* What is Unix?
* Unix Versions
* Understanding Unix – background & workings
* Unix Kernel
* Unix Processes
* Unix Virtual Memory - Memory management in Unix.
* Moving around in Unix
* Basic Unix Commands
* All about Directory's
* Unix Devices
* Unix File Structure
* Unix Permissions - File, directory, User, Group permissions.
* Links - What,they are, how to use them?
* Editing Files - Vi
* RUN Levels - System bootup sequence and how to alter it.
* Rc Scripts
* Setting up your Environment
* Shells
* Basic Network Configuration
* DNS
* Config files /etc
* Processes and Job Control
* Redirection and awk - Power User command line.
* Compression & Archiving
* Disks and Partitions
* File System Types
* Scheduling Jobs - Cron - How to automatically schedule jobs.
* System Logging - syslog basics
* User Management - Create/Add, Remove
* File Sharing using NFS & Mount Points
* Installation - Install Linux on your laptop - dualboot Windows and Linux.
* Shell Script Basics.
* Patching & packaging - Patch management.
* Advanced Commands
* Day to Day Sysadmin Tasks
* Common Unix Interview Questions.
* Exercises - The whole course will be mostly hands-on.

This course is to familarize participants with Unix commands and functioning as a whole. Typically for people who are from windows background and want to use Unix in the workplace or for people who would like to make a start for their career in Unix.

Pls contact us for on unix@koreinfotech.com for any further enquiries or to book your seat.


We have compiled a list of unix interview questions, you should be able to answer atleast 50% of them, if not you should sign up for our course. You will be able to answer all of them and more at the end of the training. Look at our next post for these questions.

We are also going to start advanced unix, networking, database and other trainings.

Let us know if interested?
Sincerely,
Kore Infotech Pte Ltd.
info@koreinfotech.com