Job At NCSCM Chennai

National Centre for Sustainable Coastal Management (NCSCM)
(An Autonomous body of the Ministry of Environment  and Forests, Govt. of India)
Koodal Building, Anna University Campus, Chennai - 600025
Published by http://www.SarkariNaukriBlog.com

National Centre for Sustainable Coastal Management (NCSCM) is an autonomous centre of the Ministry of Environment and Forests, Government of India :

1. Scientist ‘F’ [Project Lead] : 05 posts, Pay Scale : Rs. 37400-67000 Grade Pay Rs. 8900/-
2. Scientist ‘E’ [Senior Scientist] : 04 posts, Pay Scale : Rs. 37400-67000 Grade Pay Rs. 8700/-
3. Scientist 'D' : 04 posts, Pay Scale : Rs.15600-39100  Grade Pay Rs.7600/-
4. Scientist 'C' : 03 posts, Pay Scale : Rs.15600-39100  Grade Pay Rs.6600/-
5. Scientist 'B' : 04 posts, Pay Scale : Rs.15600-39100  Grade Pay Rs.5400/-
6. Software Engineer : 01 post, Pay Scale : Rs.15600-39100  Grade Pay Rs. 6600/-
7. Junior Application Engineer : 01 post, Pay Scale : Rs.15600-39100  Grade Pay Rs. 5400/-
8. Junior Technical Assistant : 02 posts, Pay Scale : Rs. 9300-34800  Grade Pay Rs. 4800/-
9. Technical Assistant : 02 posts, Pay Scale : Rs. 9300-34800  Grade Pay Rs. 4800/-
10. Data Entry Operator : 02 posts, Pay Scale : Rs. 5200-20200 Grade Pay Rs. 1900/-
11. Senior Laboratory Assistant : 02 posts, Pay Scale : Rs.5200-20200 Grade Pay Rs. 1900/- 
12. Field Assistant : 01 post, Pay Scale : Rs. 4440 -7440  Grade Pay Rs.1650/-
13. Head of Administrative and Human Resources Unit : 01 post, Pay scale : Rs.37400 - 67000 Grade Pay Rs. 10000/-
14. Head, Finance and Procurement Unit : 01 post, Pay scale : Rs.37400 - 67000 Grade Pay Rs. 10000/-
15. Manager (Procurement) : 01 post, Pay Scale : Rs.15600 - 39100 Grade Pay Rs.6600/-
16. Protocol Officer : 01 post, Pay Scale : Rs.15600 - 39100 Grade Pay Rs.6600/-
17. Librarian : 01 post, Pay Scale : Rs.15600 - 39100 Grade Pay Rs.6600/-
18. Accounts Officer (Internal Control Officer): 01 post, Pay Scale : Rs. 9300-34800 Grade Pay Rs. 4800/-
19. Accountant : 02 posts, Pay Scale : Rs. 9300-34800 Grade Pay Rs.4200/-
20. PS to Director : 01 post, Pay Scale : Rs. 9300-34800 Grade Pay Rs. 4200/-
21. Stenographer : 01 post, Pay Scale : Rs. 5200-20200 Grade Pay Rs. 1900/-
22. Office Assistant cum Driver : 01 post, Pay Scale : Rs.4440 - 7440 Grade Pay Rs.1650/-

How to Apply : Apply online at NCSCM website and hard copy of the system generated application is 30/04/2014 (last date is 15/05/2014 for the candidates from far-flung areas.

Details and online application format http://www.ncscm.org/careers

Read More

Hindustan Sambhar Salts Limited-General Manager-Job

Applications are invited from Indian Nationals for following posts :

1. General Manager (Works) : 01 post
2. Dy. General Manager (Finance & Accounts) : 01 post
3. Dy. General Manager (Tech.) : 01 post
4. Chief  Manager (PSP Plant) : 01 post
5. Chief Medical & Health Officer : 01 post
6. Chief Manger (Bromine Plant) : 01 post
7. Sr. Manager (Finance & Accounts) : 01 post
8. Sr. Manager (IT) : 01 post
9. Sr. Manager (Civil) : 01 post
10. Sr. Manager (Salt Washery) : 01 post
11. Sr. Manager (Administration & Logistics) : 01 post
12. Sr. Manager (Coml) Inputs & Logistics : 01 post
13. Manager (Finance & Accounts) : 01 post
14. Manager (Mines Operations) : 01 post
15. Manager (P&A) : 01 post
16. Medical Officer : 01 post
17. Manager (R&D) and Quality Control) : 01 post
18. Jr. Manager (Survey) : 01 post

How to Apply :  Apply online at Hindustan Sambhar Salts Limited website from 16/04/2014 to 15/05/2014.

details and online application form. http://www.indiansalt.com/careers.htm

Read More

Union Bank of India -jobs

Union Bank of India, a Leading Listed Public Sector Bank with Head Office in Mumbai and all India representation, invites Online Applications, from qualified candidates for the following posts :

1. Economist : 02 posts (UR-1, ST-1) in Scale-II
2. Security Officer : 40 posts ((UR-20, OBC-11, SC-6, ST-3) in Scale-I

How to Apply: Apply Online at Union Bank of India website between 21/04/2014 and 05/05/2014. 

http://www.unionbankofindia.co.in/abt_recruitmentaspx.aspx for online submission of application from 21st April 2014 onwards.

Read More

Assistant Professor and Contract posts-NIT Tiruchirappalli

National Institute of Technology
 Tanjore Road, Tiruchirappalli - 620015, Tamil Nadu, India

Applications are invited from Indian Nationals for the post of Assistant Professors in various Departments of National Institute of Technology (NIT), Tiruchirappalli.

• Assistant Professor :  40 posts in various disciplines (UR-22, OBC-10, SC-5, ST-3), Pay Scale : Rs. 15600-39100 grade pay Rs. 6000 on contract basis

How to Apply : Filled up applications along with enclosures should be sent to The Register, National Institute of Technology, Tiruchirappalli – 620015. The last date for submission of completed applications is 15/05/2014.

http://www.nitt.edu/home/other/jobs/faculty-advt-6000AGP.pdf

Read More

Sprint Android 4.4.3 for the Nexus 5

Android 4.4.3 KitKat update is out today for and the Nexus 5 users on Sprint
are the first to get it. Carrying a version number KTU48F the update enables
 the device to work on Sprint's LTE network on bands 26 and 41.

 The new Android version is strictly fixing existing bugs and doesn't bring new feature or UI tweaks, as previously rumored. Google has fixed mostly bugs regarding Bluetooth and
Wi-Fi connectivity, but known problems with data connection loss, random reboots,
missed calls and various camera bugs have also been fixed. The update hasn't appeared
 on the list of factory images for Nexus devices just yet, but Sprint is currently seeding it to its customers with Nexus 5 phones.

Read More

Samsung Galaxy S5 costs

Analytics company IHS has released its teardown report of the Samsung Galaxy S5,
 which also reveals an estimate of the phone's bill of materials how much its parts cost.

 The Galaxy S5 costs Samsung about $256 to build, which is just slightly more than what the Galaxy S4 cost back in 2013 - $244. The most expensive component in the Galaxy S5 is its 5.1" full HD

 Super AMOLED display. It costs $63, which is $12 cheaper than the 5" one of the Galaxy S4.

 It appears that Samsung has managed to streamline its display production to achieve the lower price. The DRAM and flash memory of the Galaxy S5 cost $33 combined. Interestingly, according to IHS the fingerprint sensor in the Galaxy S5 costs just $4, which is significantly less expensive than the one found in the iPhone 5s. Apple spends $15 for each one they place in their current flagship phone,
 which carries a $199 bill of materials. Lastly, Galaxy S5's heart rate biosensor is made by
 chipmaker Maxim and adds $1.45 to the cost of the device.

IHS estimates the cost of assembly is $5 per device. Be wary that while this component price estimation gives a neat overview of the phone's cost, it doesn't include R&D, software, distribution and marketing costs.

Read More

Japanese market-LG G3

The Japanese market version of LG's yet to be revealed G3 flagship might have leaked

 on Twitter. A duo of press shots showing a mysterious high-end LG handset made the
rounds on the social network, courtesy of @evleaks.

LG isai for KDDI click to enlarge The leaked press photos reveal the front and the back of the yet to be announced device in blue and white color scheme. Dubbed LG isai, the smartphone is headed to KDDI in Japan. There is no word on the specs of the upcoming handset just yet.
 

However, LG isai impresses with ultra-slim bezels possibly to accommodate that rumored 5.5"
QHD display in a more manageable footprint). The volume rocker on the back of the leaked handset on the other hand is standard high-end LG smartphone affair.


While we don't see a physical power/lock key on the device, we wouldn't be surprised if that mysterious strip on the left of the volume rocker plays the role it could well be a fingerprint scanner too). LG isai is yet to be annoucned. We'll keep a close eye on any further details on the handset.

Read More

Basic MySQL

Basic MySQL

Create or Drop a Database

Starting with something simple, you can use the CREATE command to create a new database. The syntax is

CREATE DATABASE IF NOT EXISTS [yourDBName];

When you create a database with this command, you're really just creating a directory to hold the files that make up the tables in the database.

To delete an entire database from the system, use the DROP command:

DROP DATABASE IF EXISTS [yourDBName];

Be extremely careful when using the DROP command,
because once you drop the database,


You can also use the CREATE command to create a table within the current database. The syntax is

CREATE TABLE [yourTableName] ([fieldName1] (type], [fieldName2]
[type], ...) [options]

To delete a table from the current database, use the DROP command:

DROP TABLE [yourTableName];

Be extremely careful when using the DROP command, because once you drop the tables,

Altering a Table

To add a column to a table, use this:

ALTER TABLE [yourTableName] ADD [newColumn] [fieldDefinition];

To delete a column from a table, use this:

ALTER TABLE [yourTableName] DROP [columnName];

To change a column from one type to another, use this:

ALTER TABLE [yourTableName] CHANGE [columnName]
[newfieldDefinition];

To make a unique column in your table, use this:

ALTER TABLE [yourTableName] ADD UNIQUE [columnName]
([columnName]);

To index a column in your table, use this:

ALTER TABLE [yourTableName] ADD INDEX [columnName]
([columnName]);

Using the ALTER command alleviates the need to delete an entire
table and re-create it .

Insert, Update, or Replace tables record

The INSERT and REPLACE commands populate your tables one record at a time. The syntax of INSERT is

INSERT INTO [yourTableName] ([fieldName1], [fieldName2], ...)
VALUES ('[value of fieldName1]', '[value of fieldName2]'...);

When inserting records, be sure to separate your strings with single quotes or double quotes. If you use single quotes around your strings and the data you are adding contains apostrophes, avoid errors by escaping the apostrophe (\ ') within the INSERT statement. Similarly, if you use double quotes around your strings and you want to include double quotes as part of the data, escape them (\ ") within your INSERT statement.

The REPLACE command has the same syntax and requirements as the INSERT command. The only difference is that you use REPLACE to overwrite a record in a table, based on a unique value:

REPLACE INTO [yourTableName] ([fieldName1], [fieldName2], ...)
VALUES ('[value of fieldName1]', '[value of fieldName2]'...);

The UPDATE command modifies parts of a record without replacing the entire record. To update an entire column in a table with the same new value, use this:

UPDATE [yourTableName] SET [fieldName] = '[new value]';

If you want to update only specific rows, use a WHERE clause:

UPDATE [yourTableName] SET [fieldName] = '[new value]' WHERE [some
expression];

UPDATE can be a very powerful SQL command.

Deleting from a Table

Like the DROP command, using DELETE without paying attention to what you're doing can have horrible consequences in a production environment. Once you drop a table or delete a record, it's gone forever. Don't be afraid; just be careful. To delete all the contents of a table, use the following:

DELETE FROM [yourTableName];

If you want to delete only specific rows, use a WHERE clause:

DELETE FROM [yourTableName] WHERE [some expression];

If you're going to start deleting records, be sure you have a backup.



Selecting from a Table

When creating database-driven Web sites, the SELECT command will likely be the most often-used command in your arsenal. The SELECT command causes certain records in your table to be chosen, based on criteria that you define. Here is the basic syntax of SELECT:

SELECT [field names] FROM [table name]
WHERE [some expression]
ORDER BY [field names];

To select all the records in a table, use this:

SELECT * FROM [yourTableName];

To select just the entries in a given column of a table, use this:

SELECT [columnName] FROM [yourTableName];

To select all the records in a table and have them returned in a particular order, use an expression for ORDER BY. For example, if you have a date field for record entries and you want to see all the record entries ordered by newest to oldest, use this:

SELECT * FROM [yourTableName] ORDER BY [dateField] DESC;

DESC stands for "descending." To view from oldest to newest, use ASC for "ascending." ASC is the default order.

You can also perform mathematical and string functions within SQL statements,

PHP Functions Php tutorial - imagemagick php.ini Basics PHP Sessions Cookies Versus Sessions PHP Web-Related Variables PHP ERRORS maximum size of a file uploaded Php Image upload php file_get_contents	MySQL Data on the Web What are GET and POST php and pdf $_ENV and $_SERVER PEAR with php SELECTING DATA PHP prevent hijacking with PHP LAMP PHP MySQL Functions PHP Zip File Functions	Substrings PHP PHP Variable names PHP magic methods How to get current session id Add variables into a session $_GET , $_POST,$_COOKIE different tables present in mysql PHP CURL php Sessions page PHP-sorting an array
PHP-count the elements of array Operators for If/Else Statements PHP file uploading code PHP global variables Testing working using phpinfo PHP Code for a Valid Number PHP-Associative Arrays PHP mvc tutorial PHP get_meta_tags-Extracts difference between print and echo	PHP best tutorial-PHP variables Reading DOC file in PHP PHP interview questions convert time PHP PHP implode array elements header function-PHP PHP-Renaming Files Directories PHP Classes in_array function in PHP keep your session secure PHP	Web Application with PHP What is SQL Injection PHP-extract part of a string PHP urlencode PHP- know browser properties PHP- Extracting Substrings Checking Variable Values /Types PHP-best 20 Open Source cms IP AddressPHP PHP-Scope Resolution Operator
how create new instance of object how eliminate an object PHP- ob_start XML file using the DOM API PHP- MVC PHP- CAPTCHA PHP- Position of a Value in an Array PHP-Mail Functions PHP-difference include vs require calculate the sum of values in an array	PHP-total number of rows Show unique records mysql MySQL Triggers MySQL data directory MySQL Subqueries PHP- Networking Functions PHP- Operators Restore database Conditional Functions mysql PHP-function overloading	Friend function mysql_connect /mysql_pconnect PHP-Error Control Operators what is IMAP Apache-Specific Functions Send Email from a PHP Script SQL inherently WAMP, MAMP, LAMP Php tutorial-SYMBOLS Table Types-MySQL
PHP-Encryption data management PHP Array Running MySQL on Windows Maximum Performance MySQL XML-RPC PHP-static variables Advanced Database Techniques FTP Codeigniter Apache Pool Size	Why NoSQL MySQL Server Performance Database software SQL Interview Answers PHP Redirect	PHP Interview Questions with Answers Advanced PHP

Read More

Nokia Lumia 630 - Russia- just €160

Nokia Lumia 630 went official just a few days ago.
It is among the first smartphones to run Windows Phone 8.1 with Lumia Cyan out of the box.
 The smartphone is considered as a successor of the Lumia 620. Nokia has announced the
3G Lumia 630 will launch in various EU and Asian markets this May for €119, 
while its dual-SIM sibling should set you back €129. The smartphone will be also released worldwide with LTE connectivity under the Lumia 635 moniker in July for €139.

 This is at least the official info, but as usual it doesn't include taxes or subsidies. Nokia has begun taking pre-orders for the single and dual-SIM Lumia 630 in Russia via its official Nokia store. The single-SIM Lumia 630 is priced at €163 RUB 7,990, while the dual-SIM version costs €173 RUB 8,490.

Read More

Microsoft to release two GDR updates for WP8.1

Microsoft separates Windows Phone 8 updates into major and minor ones - 

 so far we've seen one major 8.1 and three minor ones GDR 1, 2 and 3.

The company is reportedly planning at least two GDR updates for WP8.1 this year.
That's wholly unconfirmed for now, but a 3D Touch system is a possibility.
We heard the first murmurs about it last year - it's essentially Samsung's Air
Gestures from the Galaxy S and Note devices, at least that's what the first rumor made
 it sound like. Another possibility is evolving Nokia's Refocus app which got many imitators
 in this flagship generation. The rumor mill is talking of a dual-camera setup to create
 Lytro-like refocusable photos with just one shot. HTC tried just that and the results were not perfect. The first of the GDR updates for Windows Phone 8.1

Nokia lumia 630

Read More