SQL Info

Company Profile: Tata Power Solar with 25 years of deep domain expertise, is one of the pioneering solar manufacturers in the world and India's largest specialized EPC player. Reference link :http://www.tatapower.com/careers/opportunities.aspx Job Role : Graduate Trainee Job Type : Engineering jobs Job Details : At Tata Power we have a vision of where we want to go, and it’s really exciting. Would you like to be part of a company that is making history? Towards this objective, Tata Power participates in campus recruitments and is the company of choice in most major engineering institutes such as National Insitute of Technology, VJTI, Govt. Engineering Colleges, Birla Institute of Technology, NPTI, MS University, Nirma Institute of Technolgy, etc. Apart from college hiring, we also hire experienced professionals from the industry at various mid-level and senior positions. A Structured Induction Programme is carried out for: Graduate Engineer Trainees (GETs) All the GETs und

Company  Name : Capgemini Company Website : www.in.capgemini.com Company Profile: Capgemini is one of the world’s foremost providers of consulting, technology and outsourcing services. Present in 44 countries with more than 130,000 employees, the Capgemini Group helps its clients transform in order to improve their performance and competitive positioning. We offer an array of integrated services that combine top-of-the-range technology with deep sector expertise and a strong command of our four key businesses. Reference Link : http://www.todaywalkins.com/Capgemini-jobs-HROperations.aspx#sthash.MhV4N7Xg.dpuf Job Type : MBA Jobs Job Role : HR Operations Required Qualification :Any Graduate/MA/MBA Required Experience :0 - 6 Months Job Location :Kolkata Job Description : We are looking to hire HR Operations personnel with excellent communication skills.The person would be joining our HRO team in Kolkata. Skills : Proficient in using MS Office including Word, Excel, PowerPoint, e

Website:  https://www.hsbc.co.in/ Company Profile : HSBC Holdings plc is a British multinational banking and financial services company headquartered in London, United Kingdom. It is the world's fourth largest bank by total assets, with total assets of US$2.67 trillion Job Position name : Assistant Manager - Finance Operations : 00006F8J Job Type : Bank jobs Reference link:  https://hsbc.taleo.net/careersection/external/jobdetail.ftl?lang=en_GB&job=355641&src=JB-10502 Job Details : As a part of Global Finance Centre we have a Stress Testing Team which provides “Run The Bank” and “Change The Bank” support for Polaris, MSA and CaRT applications which are used for Model Calibration, Model Execution required for generating the stress test results, consolidating data from all risk types from all business functions around group, and producing output into a form where regulatory reporting can happen.   This is envisioned to be a group wide strategic platform which Leverage

Experience required for the Job:  4 - 6 years Job Location:  Bengaluru/Bangalore We are looking for PHP developers , please find the JD below PHP Developer Job brief We are looking for a PHP developer who is dedicated to his craft, writes code that is proud of and can hit the ground running. We need you to write beautiful, fast PHP code to a high standard, in a timely and scalable way that improves the code-base of our products in meaningful ways. You will be a part of a creative team that is responsible for all aspects of the ongoing software development from the initial specification, through to developing, testing and launching. Responsibilities Write "clean", well designed code Produce detailed specifications Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality Contribute in all phases of the development lifecycle Follow industry best practices Develop and deploy new features to facilitate related procedur

Experience required for the Job:  2 - 5 years Job Location:  Bengaluru/Bangalore Email:   dhatri@veave.in   |   http://www.veavetech.com J.D Job Position: Magento Developer/Sr Developer Education: B.E/B. Tech Experience: 2-5 Yrs Location: White Field, Bangalore Position:3 Skills: * Should have worked on projects with Magento * Will be better if Magento Certified * Should have experience in customization, development of new extension on Magento * Strong PHP 4 & 5, MySQL, AJAX, CSS, Smarty * Strong knowledge of Zend framework, MySQL * Familiarity with the SDLC and Scrum Methodologies * Familiarity with Web 2.0 Commercials: 2-3 Yrs 35K + tax 3-5 Yrs 45K + tax

Experience required for the Job:  2 - 5 years Job Location:  Bengaluru/Bangalore   Greetings from Veave Technologies!!! Our Client is looking for exceptionally talented Professionals with the following Technologies: I came across your resume on Job Portal and find that your skills match with a position we have for the Job   Job Description : Job Position: Magento Developer/Sr Developer Education: B.E/B. Tech Experience: 2-5 Yrs Location: White Field, Bangalore Position:3 Skills: * Should have worked on projects with Magento * Will be better if Magento Certified * Should have experience in customization, development of new extension on Magento * Strong PHP 4 & 5, MySQL, AJAX, CSS, Smarty * Strong knowledge of Zend framework, MySQL * Familiarity with the SDLC and Scrum Methodologies * Familiarity with Web 2.0 If you really interested in this position, please share your updated resume to   ashvini@veave.in

The PHP development team is proud to announce the immediateavailability of PHP 5.5.0. This release includes a large number of new features and bug fixes. The key features of PHP 5.5.0 include: Added   generators   and coroutines. Added the   finally   keyword. Added a   simplified password hashing API . Added   support for constant array/string dereferencing . Added scalar class name resolution via   ::class . Added   support for using empty() on the result of function calls and other expressions . Added   support for non-scalar Iterator keys in foreach . Added   support for list() constructs in foreach statements . Added the   Zend OPcache   extension for opcode caching. The GD library has been upgraded to version 2.1 adding new functions and improving existing functionality. A lot more improvements and fixes.

One of the main advantages of OO programming is its ease of modification. Objects can easily be modified and added to a system there by reducing maintenance costs. OO programming is also considered to be better at modeling the real world than is procedural programming. It allows for more complicated and flexible interactions. OO systems are also easier for non-technical personnel to understand and easier for them to participate in the maintenance and enhancement of a system because it appeals to natural human cognition patterns. For some systems, an OO approach can speed development time since many objects are standard across systems and can be reused. Components that manage dates, shipping, shopping carts, etc. can be purchased and easily modified for a specific system.

The fine manual has this to say about the NOW function: mysql > SELECT NOW (); -> '2007-12-15 23:50:26'   If you want just the date, then use CURDATE . The fine manual has this to say about the CURDATE function: mysql > SELECT CURDATE (); -> '2008-06-13'

Truncate and delete in SQL are two commands which is used to remove or delete data from table. Though quite basic in nature both sql commands can create lot of trouble until you are familiar with details before using it. Difference between Truncate and delete are not just important to understand perspective but also a very popular SQL interview topic which in my opinion a definite worthy topic. What makes them tricky is amount of data. Since most of Electronic trading system stores large amount of transactional data and some even maintain historical data, good understanding of delete and truncate command is required to effectively work on those environment.I have still seen people firing delete command just to empty a table with millions of records which eventually lock the whole table for doing anything and take ages to complete or Simply blew log segment or hang the machine. Most of enterprise stock trading system maintains two kind of database one transactional and other static. T

Website : www.genpact.com Company Profile : Genpact Limited is a multinational business process outsourcing and information technology services company, domiciled in Bermuda with executive headquarters in New York. Job Details Genpact Hiring for Finance Collections on past due, Dispute management. Eligible Required Skills - Communication skills( verbal and written) Result Orientation Problem solving Decision Making Collection Strategy Desired Skills MS Excel - Basic Typing speed 30 wpm Collections background Job Responsibility : Invoice Processing in SAP PO/ Non PO Processing Critical Vendor, Vendor reconciliations Resolution of invoices on Hold Monthly closing, Generating Payment Run Preferred skills : P2P, AP knowledge of AP process. Inquisitive & Energetic Should be comfortable with night shifts. Required Experience : Freshers an also apply...with good communication skills... Shift: Shift- 24*7 Work Place- Gurgaon & Noida Procedu

Company Website : www.cgi.com/ Company Profile: CGI Group Inc., more commonly known as CGI, is a global information technology consulting, systems integration, outsourcing, and solutions company headquartered in Montreal, Quebec. Reference Link :www.cgi.com/en/india/careers Job Role : Various Positions Job Type  : IT/software Job Educational qualification : Any graduates Working experience : Freshers Shift : Any shift Salary : 3.0 lac per annum+ Required documents : Updated Resume Work place : Across India Job Timing : Full timing Job kind  : Regular Selection process : Interview Apply mode : Online

Yes, there are some. Looking for a PHP version? I was looking for a PHP 5.1 codepad (run PHP code online for test purposes), but was not able to. I remember there was one, but I have not found it. Here is the list I came up so far before you need to click through hundreds of search results : Codepad PHP Version(s) Note writecodeonline.com PHP 4.4.9 Legacy needs? codepad.org PHP 5.2.5 Many languages, good history ideone.com PHP 5.2.12 (pl0-gentoo) Many langauges, good history freephptest.com PHP 5.2.17 Not very accessible coderun.com (ide) PHP 5.3.1 Not suitable for quick testing phpcodepad.com PHP 5.3.2 Not very accessible codepad.viper-7.com PHP 5.2, PHP 5.3, PHP 5.4 + trunk A PHP coders paradise

Internally in PHP a connection status is maintained. There are 3 possible states: 0 - NORMAL 1 - ABORTED 2 - TIMEOUT When a PHP script is running normally the NORMAL state, is active. If the remote client disconnects the ABORTED state flag is turned on. A remote client disconnect is usually caused by the user hitting his STOP button . If the PHP-imposed time limit (see  set_time_limit() ) is hit, the TIMEOUT state flag is turned on. You can decide whether or not you want a client disconnect to cause your script to be aborted. Sometimes it is handy to always have your scripts run to completion even if there is no remote browser receiving the output. The default behaviour is however for your script to be aborted when the remote client disconnects. This behaviour can be set via the ignore_user_abort  php.ini  directive as well as through the corresponding  php_value ignore_user_abort  Apache  httpd .conf  directive or with the  ignore_user_abort()  function

Friend function is best shared among a number of different classes. Such functions can be declared either as member functions of one class or as global functions. In either case they can be set to be friends of other classes, by using a friend specifier in the class that is admitting them. Such functions can use all attributes of the class which names them as a friend, as if they were themselves members of that class. A friend declaration is essentially a prototype for a member function, but instead of requiring an implementation with the name of that class attached by the double colon syntax, a global function or member function of another class provides the match. For this PHP 5.3+ implementation you will need a base class. A class that should be extended by the classes that need to have friends. This base class provides the friend-architecture, so that it will need to be coded only once.

PHP is an "HTML-embedded scripting language " primarily used for dynamic Web applications . The first part of this definition means that PHP code can be interspersed with HTML, making it simple to generate dynamic pieces of Web pages on the fly. As a scripting language, PHP code requires the presence of the PHP processor . PHP code is normally run in plain-text scripts that will only run on PHP-enabled computers (conversely programming languages can create standalone binary executable files, a.k.a. programs). PHP takes most of its syntax from C, Java, and Perl. It is an open source technology and runs on most operating systems and with most Web servers .               PHP was written in the C programming language by Rasmus Lerdorf in 1994 for use in monitoring his online resume and related personal information. For this reason, PHP originally stood for "Personal Home Page". Lerdorf combined PHP with his own Form Interpreter, releas

Company Website : www.cognizant.com Company Profile :Cognizant Technology Solutions is an American multinational corporation that provides custom information technology, consulting, and business process outsourcing services. It is headquartered in Teaneck, New Jersey, United States. Headquartered in Teaneck, New Jersey (U.S.), Cognizant combines a passion for client satisfaction, technology innovation, deep industry and business process expertise and a global, collaborative workforce that embodies the future of work. With over 50 delivery centers worldwide and approximately 211,500 employees as of December 31, 2014, Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 2000 and the Fortune 500 and is ranked among the top performing and fastest growing companies in the world. Job details : Cognizant Technology Solutions Hiring Freshers for Insurance roles, Walk-in- 17th, 18th, 19th, 20th August, 2015. Check more details below Job Position name   : Pro