...multiplication operator is *, not x, as shown in line 2. The ANNUAL SALARY alias cannot include spaces. The alias should read ANNUAL_SALARY or should be enclosed in double quotation marks. A comma is missing after the LAST_NAME column. Part 2 Note the following location for the lab files: \home\oracle\labs\SQL1\labs If you are asked to save any lab files, save them at this location. To start Oracle SQL Developer, double-click the SQL Developer desktop icon. Before you begin with the practices, you need a database connection to be able to connect to the database and issue SQL queries. Oracle Database 10g: SQL Fundamentals I A - 2 Practice 1: Solutions (continued) 4. To create a new database connection in the Connections Navigator, right-click Connections. Select New Connection from the menu. The New/Select Database Connection dialog box appears. 5. Create a database connection using the following information: a. Connection Name: myconnection b. Username: ora1 c. Password: ora1 d. Hostname: localhost e. Port: 1521 f. SID: ORCL g. Ensure that you select the Save Password check box. Oracle Database 10g: SQL Fundamentals I A - 3 Practice 1: Solutions (continued) You have been hired as a SQL programmer for Acme Corporation. Your first task is to create some reports based on data...
Words: 6452 - Pages: 26
...needs the following reports: 4. Find the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the nearest whole number. Place your SQL statement in a text file named lab_04_04.sql. SELECT ROUND(MAX(salary),0) "Maximum", ROUND(MIN(salary),0) "Minimum", ROUND(SUM(salary),0) "Sum", ROUND(AVG(salary),0) "Average" FROM employees; 5. Modify the query in lab_04_04.sql to display the minimum, maximum, sum, and average salary for each job type. Resave lab_04_04.sql as lab_04_05.sql. Run the statement in lab_04_05.sql. SELECT job_id, ROUND(MAX(salary),0) "Maximum", ROUND(MIN(salary),0) "Minimum", ROUND(SUM(salary),0) "Sum", ROUND(AVG(salary),0) "Average" FROM employees GROUP BY job_id; 6. Write a query to display the number of people with the same job. SELECT job_id, COUNT(*) FROM employees GROUP BY job_id; Generalize the query so that the user in the HR department is prompted for a job title. Save the script to a file named lab_04_06.sql.� SELECT job_id, COUNT(*) FROM employees WHERE job_id = '&job_title' GROUP BY job_id; Oracle Database 10g: SQL Fundamentals I A - 12 Practice 4: Solutions (continued) 7. Determine the number of managers without listing them. Label the column Number of Managers. Hint: Use the MANAGER_ID column to determine the number of managers. SELECT COUNT(DISTINCT manager_id) "Number...
Words: 569 - Pages: 3
...languages. Excellent communication skills, Demonstrated | | |effective project planning skills. Exceptional problem solving skills with a strong sense of customer and management | | |focus and commitment to meeting deadlines. Confident, team focused and an effective relationship builder, indebt | | |knowledge of RDBMS developer tool such as oracle developer tools, SAP R/3. Adequate knowledge of office automation | | |software such as Microsoft office etc. Adequate knowledge of package implementation of integrated system. | |PROFESSIONAL SKILLS |Operating Systems: Windows 95, 98, 2000, NT,XP,2003 | | |TECHNICAL SKILLS: | | |Experience with SQL Server ,MS/SQL Server,...
Words: 443 - Pages: 2
...Oracle® Database Concepts 10g Release 2 (10.2) B14220-02 October 2005 Oracle Database Concepts, 10g Release 2 (10.2) B14220-02 Copyright © 1993, 2005, Oracle. All rights reserved. Primary Author: Michele Cyran Contributing Author: Paul Lane, JP Polk Contributor: Omar Alonso, Penny Avril, Hermann Baer, Sandeepan Banerjee, Mark Bauer, Bill Bridge, Sandra Cheevers, Carol Colrain, Vira Goorah, Mike Hartstein, John Haydu, Wei Hu, Ramkumar Krishnan, Vasudha Krishnaswamy, Bill Lee, Bryn Llewellyn, Rich Long, Diana Lorentz, Paul Manning, Valarie Moore, Mughees Minhas, Gopal Mulagund, Muthu Olagappan, Jennifer Polk, Kathy Rich, John Russell, Viv Schupmann, Bob Thome, Randy Urbano, Michael Verheij, Ron Weiss, Steve Wertheimer The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement...
Words: 199783 - Pages: 800
...Introduction to Oracle9i: SQL Instructor Guide • Volume 1 40049GC11 Production 1.1 October 2001 D33993 Authors Nancy Greenberg Priya Nathan Copyright © Oracle Corporation, 2000, 2001. All rights reserved. This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. If this documentation is delivered to a U.S. Government Agency of the Department of Defense, then it is delivered with Restricted Rights and the following legend is applicable: Restricted Rights Legend Use, duplication or disclosure by the Government is subject to restrictions for commercial computer software and shall be deemed to be Restricted Rights software under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights in Technical Data and Computer Software (October 1988). This material or any portion of it may not be copied in any form or by any means without the express prior written permission of Oracle Corporation. Any other copying is a violation of copyright law and may result in civil and/or criminal penalties. If this documentation is delivered to a U.S. Government Agency not within the Department of Defense, then it is delivered with “Restricted Rights,” as defined in FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987). The information in this document...
Words: 33172 - Pages: 133
...Chapter 3 (Database Design Using Entity-Relationship Diagrams) * Checkpoint 3.1, Problems 1, 3, 5; pp. 78 Chapter 4 (Database Design Using Entity-Relationship Diagrams) * Checkpoint 4.1, Problems 1, 3, 5; pp. 99 * Checkpoint 4.3, Problems 1, 3; pp. 117 Part II. SQL A Guide to SQL (2008) by Philip J. Pratt and Mary Z. Last Use only Oracle for this part. Please show the complete question, query used, and print the query results. Do the exercises from the Henry Books Database. Chapter 1 (A Guide to SQL, Henry Books) * Exercises - odd numbers Chapter 2 (A Guide to SQL, Henry Books) * Exercises - odd numbers Chapter 3 (A Guide to SQL, Henry Books) * Exercises - odd numbers Chapter 4 (A Guide to SQL, Henry Books) * Exercises - odd numbers Part III. Database System Fundamentals Fundamentals of Database Systems (2011) by Ramez Elmasri; Shamkant B. Navathe Sixth Edition Addison-Wesley Chapter 1 (Fundamentals of Database Systems) * Review Questions 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7; pp. 27-28 Chapter 2 (Fundamentals of Database Systems) * Review Questions 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10; pp. 53-54 Chapter 3 (Fundamentals of Database Systems) * Review Questions 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9,...
Words: 352 - Pages: 2
...data for business intelligence. The tools generally read data that have been previously stored, often, though not necessarily, in a data warehouse or data mart. BI Tools Analyzed: When preparing the analysis of the business intelligence tools, I made a personal preference of analyzing the tools leading in the Gartner chart, and that these tools must have efficient service and customer usage. The 5 business intelligence tools which I have selected are as follows: 1. IBM Cognos Link: http://www-01.ibm.com/software/analytics/cognos/ 2. Oracle BI 12c Link: http://www.oracle.com/us/solutions/business-analytics/business-intelligence/foundation-suite/overview/index.html 3. SAS Enterprise Intelligence Platform Link: http://support.sas.com/documentation/onlinedoc/intellplatform/index.html#intell92 4. Microsoft SQL Server + MS SharePoint Server Link: https://technet.microsoft.com/en-us/library/ee210689(v=sql.105).aspx 5. MicroStrategy Link: http://www.microstrategy.com/us Criteria used for Evaluation: I have researched for multiple criteria and then grouped them into 5 main groups based on their functionality or their possible use in the BI system. The main criteria groups are detailed as follows: 1. Infrastructure & Development This group checks if the tool has the necessary development methodology, back-end integrity and so on. I have given this group a weight of 10%. The factors I have grouped into this super group are: * BI...
Words: 1293 - Pages: 6
...® OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) ABOUT THE AUTHORS John Watson (Oxford, UK) works for BPLC Management Consultants, teaching and consulting throughout Europe and Africa. He was with Oracle University for several years in South Africa, and before that worked for a number of companies, government departments, and NGOs in England and Europe. He is OCP qualified in both database and Application Server administration. John is the author of several books and numerous articles on technology and has 25 years of experience in IT. Roopesh Ramklass (South Africa), OCP, is an independent Oracle specialist with over 10 years of experience in a wide variety of IT environments. These include software design and development, systems analysis, courseware development, and lecturing. He has worked for Oracle Support and taught at Oracle University in South Africa for several years. Roopesh is experienced in managing and executing IT development projects, including infrastructure systems provisioning, software development, and systems integration. About the Technical Editor Bruce Swart (South Africa) works for 2Cana Solutions and has over 14 years of experience in IT. Whilst maintaining a keen interest for teaching others, he has performed several roles including developer, analyst, team leader, administrator, project manager, consultant, and lecturer. He is OCP qualified in both database and developer roles. He has taught at Oracle University...
Words: 150089 - Pages: 601
...principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and design techniques and how to transform data models into database designs. Another basic component of this course is the use of SQL – Structured Query Language. Students will also learn how to create databases, modify databases, and develop queries using SQL. In addition, this course also teaches the management of database resources in an organization. Course Learning...
Words: 1374 - Pages: 6
...Introduction to Oracle9i: SQL Instructor Guide • Volume 1 40049GC11 Production 1.1 October 2001 D33993 Authors Copyright © Oracle Corporation, 2000, 2001. All rights reserved. Nancy Greenberg Priya Nathan This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. If this documentation is delivered to a U.S. Government Agency of the Department of Defense, then it is delivered with Restricted Rights and the following legend is applicable: Technical Contributors and Reviewers Josephine Turner Martin Alvarez Anna Atkinson Don Bates Marco Berbeek Andrew Brannigan Restricted Rights Legend Use, duplication or disclosure by the Government is subject to restrictions for commercial computer software and shall be deemed to be Restricted Rights software under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights in Technical Data and Computer Software (October 1988). This material or any portion of it may not be copied in any form or by any means without the express prior written permission of Oracle Corporation. Any other copying is a violation of copyright law and may result in civil and/or criminal penalties. Laszlo Czinkoczki Michael Gerlach Sharon Gray Rosita Hanoman Mozhe Jalali Sarah Jones Charbel Khouri ...
Words: 33197 - Pages: 133
...education, with the opportunity for professional growth based on performance. I feel that my heterogeneous experience has provided me with the ability to perform well under pressure, meeting deadlines and successfully achieving targets while effectively utilizing my management, business and technical skills as part of a team. Work Experience: - Oct 2010 Till Now Cairo University-Banha University Technical Analysis Fundamental Analysis Stock markets Futures & Options Assistant Lecture (Mandatory) Economics Finance Portfolio Management Forex - Sept 2014 ADMIRAL MARKETS INTERNATIONAL BROKERAGE SENIOR TECHNICAL ANALYST & FUTURES TRADER TRAINER - Dec 2012 VENUS INTERNATIONAL SENIOR TECHNICAL ANALYST & FUTURES TRADER (OPTIONS &COMMODITIES) - June 2009 ELHORREYA BROKERAGE SENIOR TECHNICAL ANALYST - Oct 2006 - Oct 2005 - Oct 2004 TECHNICAL ANALYST & OPERATION MANAGER. INTERNATIONAL SHARES & BONDS CENTER (ISBC) U.A.E LUXOR SECURITIES BROKERAGE & BOOK KEEPING EL-REBDI FOR STOCK EXCHANGE INVESTMENTS IN SAUDI ARABIA TECHNICAL ANALYST & FUNDAMENTAL ANALYST. TECHNICAL ANALYST & MONITORING & EXECUTION. Education: - Preparing (PHD) in Economics in Faculty of Commerce Ain-shams University Under Supervision of Dr.Ali Lotfy the previous former prime minister and Dr. Essam Khalifa The President of the National Bank Funds. - Completed Preliminary of Doctoral Degree in Economics in Faculty of Commerce Ain-Shams University with grade (very good) – May 2012. - Master...
Words: 484 - Pages: 2
...A GUIDE TO SQL Eighth Edition This page intentionally left blank A G U I D E TO S Q L Eighth Edition Philip J. Pratt Grand Valley State University Mary Z. Last University of Mary Hardin-Baylor Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States A Guide to SQL, Eighth Edition Philip J. Pratt, Mary Z. Last Vice President, Publisher: Jack Calhoun Editor-in-Chief: Alex von Rosenberg Senior Acquisitions Editor: Charles McCormick, Jr. Product Manager: Kate Hennessy Development Editor: Jessica Evans Editorial Assistant: Bryn Lathrop Marketing Director: Brian Joyner Marketing Manager: Bryant Chrzan Marketing Communications Manager: Libby Shipp Marketing Coordinator: Suellen Ruttkay Content Project Manager: Matt Hutchinson Art Director: Stacy Jenkins Shirley, Marissa Falco Cover Designer: Joseph Sherman Cover Image: Getty Images/Taxi/Chris Bell Manufacturing Coordinator: Denise Powers © 2009 Course Technology, Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright hereon may be reproduced, transmitted, stored, or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the publisher....
Words: 48772 - Pages: 196
...the external/conceptual mapping of the data. (We have seen examples of external/conceptual mapping in the previous lecture) same way when data at the conceptual level is correlated with the same data at the internal level, this is called the conceptual/Internal mapping. When you connect to SQL Server or SQL Azure, you need to specify a target database for migration. If you have multiple Access databases you can map them to multiple SQL Server databases (or schemas) or to multiple schemas under the connected SQL Azure database. A data definition language or data description language (DDL) is syntax similar to a computer programming language for defining data structures especially database schemas. Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle databases store schema objects logically within atablespace of the database. The data of each object is physically contained in one or more of the tablespace's datafiles. For some objects (such as tables, indexes, and clusters) a database administrator can specify how much disk space the Oracle RDBMS allocates for the object within the tablespace's datafiles. When it processes DML requests, Teradata Database accesses the information it needs from data dictionary tables using internal express-request transactions that place READ locks on row hash values. These locks are released when the data is...
Words: 643 - Pages: 3
...2014 Preface Theoretical knowledge, what we learn through our academic activities, is not sufficient to prepare ourselves for the life battle. Academic knowing is needed to be backed up by practical experience. In business studies, besides their usual theoretical course works, students are required to fulfill some practical assignments which are set by the course teachers to examine the depth of knowledge learned by the students. Most of the time, the students are required to study a practical working environment of any organization or industry to critically examine ‘what is actually going on’ in the real world. This document is prepared as a result of an assignment set by the honorable course teacher of the course “Fundamental of MIS”. .My duty was to describe “Information System of My Organization.” and report what I found. This is how this assignment paper titled “Information System of Standard Bank Limited.” was emerged. I believe this paper is a reflection of accumulation of my effort, learning and dedication. Letter of Transmittal November 8, 2014 Dr. Mosharraf Hossain Professor MBA (Evening) Program Department of Management Studies University of Dhaka Subject: Submission of term paper on Information System of Standard Bank Limited. Dear Sir, With due respect, it is my immense pleasure to present the term paper entitled “Information System of Standard Bank Limited.” In the process of preparing...
Words: 1837 - Pages: 8
...been a place where student tend to spend most of their time doing their assignments, completing their homework and also spend time on leisure reading. This well occupied library has been through a renovation lately where there is more reading space and also more books. The college library management has been done manually and not computerised. They have opened suggestions to the student where they can give out suggestion on which hardware and software can be used for our college library. As most of the library in colleges and public library tend to use computerised system for the management purpose has been making things easy and effective for the librarian to do their job. The type of hardware that I would suggest that would be fundamental for a library system would be definitely the system unit, the monitor, the keyboard, the mouse and a printer. A system unit with a business user specification would be prefect for this usage. In detail, Server or PC with i5 Processor, Windows 7, a 500 GB hard drive, 4 GB of fast DDR3 RAM memory, and a LCD display. Hardware which would be even necessary would be like the finger print reader where this can used to scan and read finger print of students who want to borrow books just have to place their finger to be scanned as their details and data would appear in the monitor’s screen of the librarian. This would be necessary as scanning wouldn’t take a very long time and its even precise compared to filing data manually. The only disadvantage...
Words: 888 - Pages: 4
