Premium Essay

Satyam

In:

Submitted By EmailId
Words 375
Pages 2
x x x x x

SQL Facts SQL stands for Structured Query Language SQL is pronounced “sequel” SQL is declarative language SQL is used to access & manipulate data in databases Top SQL DBs are MS SQL Server, Oracle, DB2, and MySQL Database Definitions RDBMS (Relational Database Management System) – Software that stores and manipulates data arranged in relational database tables. Table – A set of data arranged in columns and rows. The columns represent characteristics of stored data and the rows represent actual data entries. How to select data from a table

x

x

SQL Commands Categories Data Query Language (DQL) x SELECT - Retrieve data from table(s) Data Manipulation Language (DML) x INSERT - Insert data into db table x UPDATE - Update data in db table x DELETE - Delete data from table Data Definition Language (DDL) x CREATE - Create db object (table, view, etc.) x ALTER - Modify db object (table, view, etc.) x DROP - Delete db object (table, view, etc.) Data Control Language (DCL) x GRANT - Assign privilege x REVOKE - remove privilege How to insert data in a table INSERT INTO () VALUES () Example: INSERT INTO Orders (FirstName, LastName, OrderDate) VALUES ('John', 'Smith', '10/10/2010') How to delete data from a table DELETE FROM WHERE Example: DELETE FROM Orders WHERE OrderDate < '10/10/2010'

SELECT FROM WHERE Example: SELECT FirstName, LastName, OrderDate FROM Orders WHERE OrderDate > '10/10/2010' How to update data in a table UPDATE SET = , = , … WHERE Example: UPDATE Orders SET FirstName = 'John', LastName = 'Who' WHERE LastName='Wo' How to group data and use aggregates SELECT , () FROM WHERE GROUP BY Example: SELECT LastName, SUM(OrderValue) FROM Orders WHERE OrderDate > '10/10/2010' GROUP BY LastName How to select data from more than one table SELECT FROM JOIN ON . = . Example: SELECT Orders.LastName, Countries.CountryName FROM Orders JOIN

Similar Documents

Premium Essay

Satyam Scandal

...Mahindra Satyam, formerly known as Satyam Service Company Limited, is one of the successful global business and information technology services company. This company handles industry and functional expertise relating to technology, and provides clients the best services to improve business processes and their performances. B Rama Raju, and Ramalinga Raju founded Mahindra Satyam in 1987, and is headquartered in Hyderabad, India, for providing software development and Consultancy services to large corporations. (Mahindra Satyam) Mahindra Satyam operates globally including the US, Canada, Brazil, United Kingdom, China, Singapore, Malaysia, and also many Fortune 500 companies. That being said Mahindra Satyam provides services at General Electric, General Motors, Nestle, and the US government. This company serves automotive products, aviation, farm equipment, hospitality, information technology, real estate and the retail industries. Three main segments that the company operates are IT services, Business Process Outsourcing (BPO), and Software Products. (Mahindra Satyam) The IT service provides wide variety of services, including software development, system maintenance, packaged software integration, and engineering design services. Whereas, BPO segment provides services related to Human resource, finance and accounting, and transaction processing. Lastly, Software Products segment provides involves product development, and creation of software. http://www.mahindrasatyam.com/about-mahindra-satyam/ICT-company...

Words: 560 - Pages: 3

Premium Essay

Satyam Fraud

...Satyam Computers Limited-A case of corporate fraud. Overview: Satyam Computer Services (an IT company) is considered India’s Enron. The company CEO Mr. Raju was the main person involved. In the end, he admitted to faking company profit for numerous years and was arrested for 1.47 billion dollars in fraud. Fraudulent acts: Mr. Raju worked with the internal auditors to come up with ways to create non-existent profits and eliminate debt. For instance, he had fake bank accounts on paper in order to report fake interest income. In addition, internal auditors created fake customer identities to increase company revenue. According to Raju, the fraudulent activities started out only creating a marginal gap between actual and book profit. However, things got out of hand quickly. Cover-ups after cover-ups made the gap wider and wider. External parties involved: Satyam’s external auditors, PwC, were also under high scrutiny and criticism after the fall of Satyam. They were Satyam’s auditors for 9 years and signed off on Satyam’s financial statements annually. Under Indian law, if PwC signed off the financial statements, they are responsible for the numbers. Authorities blamed PwC because they failed to notice obvious red flags such as Satyam having a large no-interest bearing account. Reasonable companies would have invested the money in interest bearing accounts or distributed dividends to shareholders. Red flags raised: Merrill Lynch was appointed by Satyam to...

Words: 423 - Pages: 2

Free Essay

Corporate Governance Failure at Satyam

...VANITA YADAV C.V. BAXI CORPORATE GOVERNANCE FAILURE AT SATYAM “Why do you want to quit Satyam,”1 the panel member asked the 30-year-old employee being interviewed. Satyam Computer Services Ltd (“Satyam”) was India’s fourth-largest computer services company; however, many employees had left and applied for new jobs after news of a US$1.4 billion corporate fraud at Satyam became public in December 2008. 2 Satyam’s governance failure had severely shaken its stakeholders and the global business community, and the business press worldwide referred to Satyam as “India’s Enron”.3 Satyam was listed on the New York Stock Exchange (“NYSE”) in 2001 and on Euronext Amsterdam in 2008. 4 It boasted a large number of clients, including many Fortune 500 companies.5 The founder of Satyam Computer Services, B. Ramalinga Raju (“Raju”), was a highly regarded entrepreneur and an eminent fixture at prestigious corporate events in India.6 In 2007, he was honoured with the Ernst & Young Entrepreneur of the Year award, yet a mere two years later, on 7 January 2009, Raju made the calamitous confession that he had falsified accounts on a grand scale over a long period of time. His shocking announcement sparked a big debate over whether India possessed adequate guidelines for corporate governance. 7 How did Raju commit a fraud of such magnitude? How could a successful company, twice awarded the Golden Peacock award for corporate governance excellence collapse in such a manner? 8 Where did the internal...

Words: 8868 - Pages: 36

Premium Essay

Satyam

...dysfunctional behaviors of corporate mangers. The purpose of this report is to address these three elements to Satyam Computer Services Ltd., and provide recommendations on how to prevent future fiascos. Company Background Satyam Computer Services Ltd. (Satyam) is an IT services provider based out of India, founded by Ramalinga Raju in 1987 (Ians, 2009). In 1991, Satyam was listed on the Bombay Stock Exchange with an Initial Public Offering that was oversubscribed 17 times. Satyam was a successful organization having achieved revenues over $1 billion in 2006, and in 2008 they achieved revenues over $2 billion. Satyam was also the recipient of the Ernst and Young Entrepreneur of the Year in 2007 (Ians, 2009). Corporate Scandal In 2009, Raju wrote a letter to the board of directors indicating that he had been cooking the company’s accounting records for years. He took responsibilities for the accounting improprieties that overstated the company’s profits and reported cash holding of approximately $1.04 billion that did not exist (Balachandran, 2009). As Raju stated in his letter to the board, his motive for his actions was that he was concerned that the poor performance would result in a take-over. Raju also expressed his actions as “It was like riding a tiger, not knowing how to get off without being eaten” (Raju’s Statement, 2009). Unethical Practices Based on the Satyam scandal case, it is evident that Raju’s actions were unethical practices. His desires to make the...

Words: 505 - Pages: 3

Free Essay

Satyam

...Trends of IT Industry in Indian Economy – An Analysis N.Swapna1 & N.Sujatha2 1 Dept. of Economics, Telangana University, NZB & Dept.of Economics, Osmania University, Hyderabad, India 2 Dept.of Economics, Osmania University, Hyderabad, India E-mail : Swapanjali111@gmail.com1 Abstract - The Indian Information Technology and Information Technology Enabled Services (IT-ITES) industry has been contributing its role in the economic development of India since post liberalization era. The pace growth of this industry is considered as a growth driver for the economy. India has become as “IT Super Power”. The performance of IT industry can be revealed with the evidence of its contribution to the GDP (Gross Domestic Product) of the country, provision of employment opportunities all over the country, IT services and software exports and revenue to the country. This paper examines how does the IT industry is playing its predominant role in Indian economy with its various trends in the contribution to the GDP of India , IT exports, IT revenue trends and employment opportunities. Keywords - IT-ITES, Contribution to GDP, Employment, Exports and Revenue. I. utilities and services for globally oriented businesses. The SEZ Act 2005 envisages key role for the State Governments in Export Promotion and creation of related infrastructure. A few salient features of SEZ scheme are as under: INTRODUCTION The Government of India has identified IT industry as one of the...

Words: 2019 - Pages: 9

Free Essay

Satyam Scandal

...The Satyam Scandal Jessica English February 9, 2015 Professor Nauri Ahmed ACC 556 The Satyam Computer Service started in 1987 by Byrraju RamalingaRaju in India. The Satyam became the fourth largest Indian IT firm in 2009, but January 7 2009, RamalingaRaju confessed to the very large revenue that was misstated of the company (Pallimanideep, 2015). Raju wrote a letter to the Satyam board confessing to the fraud and to reinsure no board members had no knowledge of the fraud. The letter written by RamalingaRaju states: “It is with deep regret and tremendous burden that I am carrying on my conscience, that I would like to ring the following facts to your notice: “The balance Sheet carries as of September 30,2008 (a) Inflated (non-existent) cash and bank balances of Rs 5,040 crore (as against Rs 5,361 crore reflected in the books); (b) An accured inters of Rs 376, which is non-existent (c) An understand liability of Rs 1,230 crore on account of funds arranged by me; (d) An overstated debtors’ position of Rs 490 crore (as against Rs 2,651 reflected in the books); For the September quarter we reported a revenue of Rs 2,700 crore and an operating margin of Rs 649 crore (24 cent of revenue) as against the actual revenues of Rs 2,112 crore and an actual operating margin of Rs 61 crore (3 per cent of revenues). This has resulted in artificial cash and bank balances going up by Rs 588 crore in quarter 2 alone ("Satyam fraud: Full text of Raju's letter to board"...

Words: 793 - Pages: 4

Free Essay

Project O Supply Chain

...The below are the requirements for term paper. 1)Title 2)Object 3)Review(2 articles) 4)Analysis 5)conclusion 6)Source(References) http://www.businessweek.com/blogs/globespotting/archives/2009/01/satyam_scandal.html The terror attacks on Mumbai were just a tremor for the country’s tech industry compared to the shocks coming from the Satyam scandal. Earlier today, Ramalinga Raju, Satyam’s founder and longtime chairman, admitted in a letter to the board that he had been cooking the books for years to make up for revenue and profit shortfalls. Read the details in this report by my BW colleague, Manjeet Kripalani. In his letter, Raju wrote that the cover-up finally got the best of him: “It was like riding a tiger, not knowing how to get off without being eaten.” This admission will have a crippling impact on Satyam. Its chances of getting new business are nil. Don’t expect its current customers to abandon the company overnight. That’s not easy in a tech services business where the operations of the client and service provider are so interwoven. On the other hand, it’s possible that the company may collapse financially, in which case clients will have no choice but to flee. Which brings us to a bigger shock: This betrayal of trust could have a major impact on the entire Indian tech services industry. The industry has spent 20 years building up credibility with Western clients, but this disaster will make many US and European clients rethink their reliance on Indian outsourcing...

Words: 4268 - Pages: 18

Free Essay

Essay Plan

...paper is to do a case analysis of Satyam computer Services present the key facts of the paper, identify the main issue that management had and theorize a solution to the main issue. Key Facts Satyam Computer Services Limited was an indispensable part of Indian IT Industry. The company was the fourth biggest software company in India, which was founded by Mr. B. Ramalinga Raju. Raju started his career as an entrepreneur after obtain degrees in commerce and a Master of Business Administration in Ohio University America and he later became the Founder-Chairman of Satyam Computer Services. Listed on both the Indian stock exchange and the New York Stock Exchange. The company had major global US and Australia companies as clients. Over 20 years, Satyam was stating employing 53,000 people with operations in 66 locations world wide. Satyam Computers lost its brand image on January 8, 2009 when Mr Raju who had resigned earlier as CEO announced to the Indian stock exchange that financial fraud had been committed to the tune of over US$1 billion dollars over a number of years. He said that he was trying to cover up losses that the company had. In latter court proceedings prosecutors alleged that Satyam had 13,000 fictionist employees and these salaries were being siphoned off to front companies and two family owned companies to fund land purchases. Mr Raju brother was a managing director. Management Problem. Corporate geed was at the heart of Satyams’ problem led by Mr Raju whose unethical...

Words: 1071 - Pages: 5

Premium Essay

Satyam Scam

...Satyam Likely To Exist Post Scam : Gartner Study 3,300 views Although several companies are trying to have a bite into Satyam Computers, according to Gartner study, the company is likely to exist in its current form. It is expected to discontinue some of its businesses, service lines or cease to exist in certain geographies by 2010. The study indicated that even the name Satyam may not be around by that time, as the company is expected to undergo a complete change, in ownership and organizationally. Satyam’s ability to sign on new clients during 2009 has significantly diminished, says the study. ‘‘In addition, it will be challenged to invest in client engagements, staff developments or R&D, all critical elements for IT services,’’ said Gartner’s V-P for research, Frances Karamouzis. Read more Posted by Satyam Fraud News Reporter on Sunday, February 1, 2009 at 7:46 am Filed under Impact Of Satyam Scam On Indian Economy Ex-Satyam Director Resigns From Sasken Board 1,536 views Serial entrepreneur and NewPath Ventures co-founder Vinod K Dham resigned from the board of Sasken Communications as an independent director, a top official of the communications solutions provider said on Monday. “Yes, Dham has resigned as a director of the company from the board on January 17,” Sasken chairman and managing director Rajiv C. Mody told IANS but declined to elaborate. “We will inform you later, as we are busy with investors and analysts in a conference call on our third quarter...

Words: 1924 - Pages: 8

Free Essay

Satyam Scam

...https://www.youtube.com/watch?v=bauzUSu2v5k http://www.thehindu.com/specials/timelines/satyam-scandal-who-what-and-when/article7084878.ece http://cbi.nic.in/fromarchives/satyam/satyam.php http://www.dnaindia.com/money/report-all-that-you-need-to-know-about-the-satyam-scam-2067138 https://en.wikipedia.org/wiki/Satyam_scandal http://www.hindustantimes.com/business/satyam-scam-all-you-need-to-know-about-india-s-biggest-accounting-fraud/story-YTfHTZy9K6NvsW8PxIEEYL.html http://www.business-standard.com/article/economy-policy/in-case-of-satyam-issue-is-not-just-about-money-but-biz-ethics-109051100040_1.html http://rammallar.blogspot.in/2013/04/satyam-scam-is-it-failure-of-business.html http://www.termpaperwarehouse.com/essay-on/Satyam-Scam-And-Ethics/198522 http://www.researchgate.net/publication/271133751_CORPORATE_ACCOUNTING_SCANDAL_AT_SATYAM_A_CASE_STUDY_OF_INDIA'S_ENRON (point 5) http://www.scirp.org/journal/PaperDownload.aspx?paperID=30220 https://www.scribd.com/doc/73590653/Satyam-Fraud-Ethical-Corporate-Governance (page 9 onwards imp) http://knowledge.wharton.upenn.edu/article/scandal-at-satyam-truth-lies-and-corporate-governance/ The Satyam Computer Services scandal is a corporate scandal that worked in India in 2009 where chairman Ramalinga Raju confessed that the company's accounts had been falsified. The Global corporate community was shocked and scandalised when the chairman of Satyam, Ramalinga Raju resigned on 7 January 2009 and confessed that he had manipulated the accounts...

Words: 1639 - Pages: 7

Premium Essay

Satyam Accounting Scandal

...History Satyam Computer services Limited an Information Technology Company was founded in 1987 by Ramalinga Raju. The company is based in Hyderabad, India and was the fourth largest software exporter in India until January 2009. As one of the largest software company, Satyam traded in the Bombay Stock Exchange, the national Stock Exchange and New York Exchange. Satyam grew rapidly with customers stretching over 66 countries and was ranked at 185th on the Fortune 500 companies list. In 2008, Satyam received the the Global Peacock Award for global excellence in corporate accountability. Satyam continued to grow even when stock markets around the world were collapsing. In December 2008, Mr. Raju wanted to merge Matyas a real-estate company with Satyam. Matyas a company owned by his family was a complete diversity from the software company. Raju and his family owned a lot more shares in Matyas than they did in Satyam. The merge caused investors to question Mr. Raju’s intentions. The stockholders objected to the merge and the idea was aborted. However, the damage had already been done. The investors had lost faith and Satyam’s stocks plunged to an unbelievable low. Ironically, the word Satyam means Truth in Sanskrit and as the world watched the truth about Raju started to unravel. Fraud is Uncovered In October of 2008, World Bank fired Satyam and restrictions were put in place against the company from bidding for eight years. World Bank alleged that that Satyam had placed spy...

Words: 4845 - Pages: 20

Premium Essay

Satyam Scam

... Introduction: 2 Ethical Issues Involved 2 1. Not Following Corporate Governance Norms 2 2. Tampering the financial data - 2 3. Misleading the Shareholders Fund- 3 4. Insider trading at Satyam- 4 Ethical Dilemma faced by Ramalinga Raju 4 Theories and Approaches that may be used to resolve dilemma 5 Hosmer’s Six Step Process: 5 Kohlberg Model: 6 Recommendations for Resolving the dilemma 8 Conclusion 9 References 9 Introduction: The Satyam Computer Services’ scandal brought to light the importance of ethics and its relevance to corporate culture. The fraud committed by the founders of satyam is a testament to the fact that “the science of conduct” is swayed in large by human greed, ambition, and hunger for power, money, fame and glory. Scandals to the recent financial crisis have time and again proven that there is a need for good conduct based on strong ethics. we examine the gross negligence of stakeholder concerns and over indulgence of key management on a personal and organizational level in immortal practices for personal benefit. We also assess the implications of ethics in the business environment. We then delve into the ethical dilemmas faced by the executives at Satyam, apply Hosmer’s framework to moral decision-making and suggest alternatives to handle such moral uncertainties. Finally, we conclude by providing recommendations for ethical code of conduct in organizat...

Words: 2208 - Pages: 9

Free Essay

Riding a Tiger

...strongly believes that ordinary people are capable of extraordinary things and that the key to this is creating highly charged teams. He takes a personal interest in developing teams and leaders and invests significant time as a faculty in Wipro’s leadership development programs. Premji is firmly committed to the belief that business organizations have deep social responsibility, and such responsibility shall be discharged by conducting ethical and fair business, by involvement with community issues and by building an ecologically sustainable business. It’s that kind of integrity that has catapulted Premji and Wipro to unprecedented heights. On the other hand the problems that cropped in another IT services provider in global level is the Satyam Computer Services Ltd. It is stamped as Indian Enron because of the new scam that surfaced in the recent past. The investors shocked at the news that is published in the print media and also broadcasted in the electronic media and it is a big blow on the spirits of the investors...

Words: 2215 - Pages: 9

Free Essay

Accounting

...background Satyam Computers Services Limited (SCSL) was incorporated in the year 1987 as a private limited company at Andra Pradesh. Later at 1991 Satyam recognized as a public limited company. SCSL is fourth largest provider of Information Technology services in India. In the year 1995 company awarded ISO 9001 certification. Twenty years ago, Satyam has consistently innovated across various aspects of the enterprise-processes, technology, business and engagement models, and service offerings. Satyam offers a range of expertise that includes: Software Development Services, Embedded Systems, Engineering Services (CAD/CAM/CAE), Systems Integration, Enterprise Resource Planning Solutions, Enterprise Application Integration, Customer Relationship Management, Supply Chain Management, Product Development, Electronic Commerce, and Consulting. As IT services became more and more technology-centric and generic, hence now Satyam offers services to enhance the customers business needs. Satyam starting with deeper focus on customized IT solution on insurance, financial services, telecom, manufacturing, transportation, health care, Bioinformatics and Retail sectors. 2 Satyam Computer Services – a company based in India (now known as Mahindra Satyam). This is the most recent scandal (declared only in 2009) among those on this list. The accounting fraud in this case involves overstating cash ($1.5 billion) and receivables by $100 million and understating liabilities by $250 million. Taken...

Words: 351 - Pages: 2

Free Essay

Sathyam Computers

...Fraud –Sathyam computers SUBMITTED BY: Abhijith Rajan AUD 2351 MBA (GENERAL) ABSTRACT From Satyam, we can see that corporate book keeping misrepresentation is a noteworthy issue that is raising both in its recurrence and seriousness. Exploration confirmation has demonstrated that these developing number of fakes have made undermined the trustworthiness of monetary reports, added to generous financial misfortunes, and disintegrated speculators' certainty with respect to the handiness and dependability of money related articulations. The expanding rate of these sort of law violations need to get hardened punishments, excellent disciplines, and powerful requirement of law with the right soul. An endeavor is made to inspect and investigate inside and out the Satyam Computer's "inventive bookkeeping" embarrassment, which conveyed to spotlight the significance of "morals and corporate administration" (CG). The extortion submitted by the authors of Satyam in 2009, is a demonstration of the way that "the art of behavior is influenced in huge by human eagerness, aspiration, and crave influence, cash, acclaim and wonderfulness". Dissimilar to Enron, which sank because of "organization" issue, Satyam was conveyed to its knee because of "burrowing" impact. The Satyam embarrassment highlights the significance of securities laws and CG in "developing" markets. Without a doubt, Satyam misrepresentation "prodded the administration of India to fix the CG standards to anticipate repeat...

Words: 3054 - Pages: 13