Diploma in Business and Oracle Programming via Online Distance Learning

Enrolment date: 27 October 2017

Benefiting from over 30 years’ experience, Fitzwilliam Institute’s Online Diploma in Business with Oracle Programming course features:

  • Comprehensive modules covering all aspects of business and oracle programming: Introduction to Business, Strategic Management, Operations Management, Marketing, Financial Accounting, Macroeconomics, Leadership and Communication in the Workplace, Effective Performance in the Workplace, Employee Relations and the Law, Business Ethics, Basic SQL Select Statements, Restricting and Sorting Data, Inserting, Updating and Deleting Data, Creating Database Tables with DDL, Controlling Access, and many more.
  • Interactive course expert support, advice and guidance from leading industry professionals. Always ready to help and answer any questions you might have throughout the course, all of our business course experts are top industry professionals with many years of successful business experience across a broad range of industries. This course contains the core and vital industry key skillset and, on completion, all of our students are industry-ready.
  • Real life business and oracle programming briefs. Fitzwilliam Institute’s Diploma in Business with Oracle Programming offers practical and specific skills that can be applied in real world situations. You will gain exposure to invaluable toolkits and prepare real life business and oracle programming briefs, which will enable you to develop your work portfolio.
  • Flexible online learning. Fitzwilliam Institute’s Diploma in Business with Oracle Programming course can be completed in your own time, from the comfort of your own home, to suit your lifestyle. You will have full access to online resources and subject expert support for one calendar year. However, you can complete the course in as little as 4-6 months, by dedicating 6-8 hours of study per week.
  • Jobs, Networking and Volunteer Opportunities. Benefiting from over 30 years of industry experience, Fitzwilliam Institute are extremely well placed within the industry. Employers are always looking for Fitzwilliam Institute’s students and alumni. Fitzwilliam Institute’s website features a comprehensive jobs and volunteer opportunities section.

Introduction to Business Management

The nature of business, business plans and start-ups, legalities – sole traders and partnerships, limited companies, non-profit organisations, public sector organisations.

Strategic Management

Vision and mission, objectives, planning and strategy, contingency planning, implementation, change control.

Operations Management

Production methods, cost, revenue and break-even analysis, quality assurance, production planning, project management.

Marketing

Marketing concepts, market research, market segmentation, positioning and targeting, new product development and the product life cycle, brand awareness, the marketing mix (product, price, place, promotion), competitor analysis, marketing strategies, e-commerce.

Mathematics and Statistics for Business

Financial Mathematics, Calculus and Profit Maximisation, Descriptive Statistics, Measure of Association, Probability, Statistical Inference.

Financial Accounting I and II

Introduction to financial accounting, users of financial information, key accounting models, terminology, need for financial statements, the balance sheet, balance sheet layouts, ratio and the balance sheet.Income statement and layout, ratios, revenues and trade receivables, owners equity, cash flow measurement and documentation, inventories and cost of sales, tangible and intangible assets, liabilities, financial statements and recording transactions, preparing financial statements, analyzing and interpreting financial statements, analysis tools, auditing.

Macroeconomics

Introduction to macroeconomics, understanding macroeconomics, principles of economics, how the market works, gross domestic product, international trade, open economy, Labour market, income, expenditure and the circular flow, the consumer price index, cost of taxation, employment, cost of living, the Philips Curve, national income, supply and demand for goods and services, money and inflation, the quantity theory of money, interest rates, social costs of inflation, hyperinflation, exchange rates.Economic fluctuations, economic growth, economy in the long run, accumulation of Capital, population growth, policies to promote growth, the Solow Model, the business cycle, aggregate demand and supply, the IS-LM Model, the money market, how fiscal and monetary policies shift the LM Curve, floating and fixed exchange rates, the Mundell-Fleming Model, policy debates, investment, government policies.

Microeconomics

Introduction to microeconomics, trade, trade-offs and government policy, production and supply, elasticities, individual choice in supply and demand, production and cost analysis, competitive markets, oligopoly and monopolistic competition and strategic pricing, uncertainty.

Leadership and Communication in the Workplace

Effective communication skills, leadership styles, information gathering and interpretation, problem solving, decision making, workforce planning, conflict resolution, time management, delegation.

Effective Performance in the Workplace

Company organisational culture and structures, building an effective workforce – recruitment, team selection, appointment and termination, training and appraisal, motivational strategies, competition in the workplace. Wage and salary administration, job restructuring.

Employee Relations and the Law

Human resources management, employee representation, industrial democracy including bargaining, consultation and participation, industrial relations - action and disputes. Government policy (including EU and other industrial blocs), consumer protection, workforce protection, equal opportunities legislation, pressure groups. Taxation.

Business Ethics

Business ethics, business and the environment, corporate social responsibility. Commercial Law, Company Law, Contract Law, Employment Law, Law of Tort.

Entrepreneurial Skills

Innovation, research and new product development.

Spreadsheets (Calc)

Introduction to spreadsheets, step by step instructions on using the features, functions and applications for spreadsheets, customizing the spreadsheet software, installing the spreadsheet software, security, platforms, operating system compatibility.

Case studies

Three business management case studies.

ORACLE PROGRAMMING

ORACLE: Writing Basic SQL SELECT Statements

Capabilities of SQL SELECT Statements, Basic SELECT Statement, Selecting All Columns, Selecting Specific Columns, Writing SQL Statements, Column Heading Defaults, Arithmetic Expressions, Using Arithmetic Operators, Operator Precedence, Using Parentheses, Defining a Null Value, Null Values in Arithmetic Expressions, Defining a Column Alias, Using Column Aliases, Concatenation Operator, Using the Concatenation Operator, Literal Character Strings, Using Literal Character Strings, Duplicate Rows, Eliminating Duplicate Rows

ORACLE: Restricting and Sorting Data

Limiting Rows Using a Selection, Limiting the Rows Selected, Using the WHERE Clause, Character Strings and Dates, Comparison Conditions, Using Comparison Conditions, Other Comparison Conditions, Using the BETWEEN Condition, Using the IN Condition, Using the LIKE Condition, Using the NULL Conditions, Logical Conditions, Using the AND Operator, Using the OR Operator, Using the NOT Operator, Rules of Precedence, ORDER BY Clause, Sorting in Descending Order, Sorting by Column Alias, Sorting by Multiple Columns

ORACLE: Using SQL SELECT statements with Single Row Functions, Multiple Tables and Aggregate Funuctions

Obtaining Data from Multiple Tables, Cartesian Products, Generating a Cartesian Product, Types of Joins, Joining Tables Using Oracle Syntax, What Is an Equijoin?, Retrieving Records with Equijoins, Additional Search Conditions Using the AND Operator, Qualifying Ambiguous Column Names, Using Table Aliases, Joining More than Two Tables, Nonequijoins, Retrieving Records with Nonequijoins, Outer Joins, Outer Joins Syntax, Using Outer Joins, Self Joins, Joining a Table to Itself, Joining Tables Using SQL: 1999 Syntax, Creating Cross Joins, Creating Natural Joins, Retrieving Records with Natural Joins, Creating Joins with the USING Clause, Retrieving Records with the USING Clause.

Creating Joins with the ON Clause, Retrieving Records with the ON Clause, Creating Three-Way Joins with the ON Clause, INNER versus OUTER Joins, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN,What Are Group Functions?, Types of Group Functions, Group Functions Syntax, Using the AVG and SUM Functions, Using the MIN and MAX Functions, Using the COUNT Function, Using the DISTINCT Keyword, Group Functions and Null Values, Using the NVL Function with Group Functions, Creating Groups of Data, Creating Groups of Data: GROUP BY Clause Syntax, Using the GROUP BY Clause, Grouping by More Than One Column, Using the GROUP BY Clause on Multiple Columns, Illegal Queries Using Group Functions, Excluding Group Results, Excluding Group Results: The HAVING Clause, Using the HAVING Clause, Nesting Group Functions

ORACLE: Inserting, Updating and Deleting Data with DML (Data Manipulation Language)

Data Manipulation Language, Adding a New Row to a Table, The INSERT Statement Syntax, Inserting New Rows, Inserting Rows with Null Values, Inserting Special Values, Inserting Specific Date Values, Creating a Script, Copying Rows from Another Table, Changing Data in a Table, The UPDATE Statement Syntax, Updating Rows in a Table, Updating Two Columns with a Subquery, Updating Rows Based on Another Table, Updating Rows: Integrity Constraint Error, Removing a Row from a Table, The DELETE Statement, Deleting Rows from a Table, Deleting Rows Based on Another Table, Deleting Rows: Integrity Constraint Error, Using a Subquery in an INSERT Statement, Using the WITH CHECK OPTION Keyword on DML Statements.

Overview of the Explict Default Feature, Using Explicit Default Values, The MERGE Statement, MERGE Statement Syntax, Merging Rows, Database Transactions, Advantages of COMMIT and ROLLBACK Statements, Controlling Transactions, Rolling Back Changes to a Marker, Implicit Transaction Processing, State of the Data Before COMMIT or ROLLBACK, State of the Data After COMMIT, Committing Data, State of the Data After ROLLBACK, Statement-Level Rollback, Read Consistency, Implementation of Read Consistency, Locking, Implicit Locking.

ORACLE: Creating and Managing Tables

Database Objects, Naming Rules, The CREATE TABLE Statement, Referencing Another Userís Tables, The DEFAULT Option, Creating Tables, Tables in the Oracle Database, Querying the Data Dictionary, Data Types, Datetime Data Types, TIMESTAMP WITH TIME ZONE Data Type, TIMESTAMP WITH LOCAL TIME Data Type, INTERVAL YEAR TO MONTH Data Type, Creating a Table by Using a Subquery Syntax, Creating a Table by Using a Subquery, The ALTER TABLE Statement, Adding a Column, Modifying a Column, Dropping a Column, The SET UNUSED Option, Dropping a Table, Changing the Name of an Object, Truncating a Table, Adding Comments to a Table

ORACLE: Controlling User Access

Controlling User Access; Privileges; System Privileges; Creating Users; User System Privileges; Granting System Privileges; What Is a Role?; Creating and Granting Privileges to a Role; Changing Your Password; Object Privileges; Granting Object Privileges; Using the WITH GRANT OPTION and PUBLIC Keywords; Confirming Privileges Granted; How to Revoke Object Privileges; Revoking Object Privileges; Database Links

Setting Up and Marketing Your Own Consultancy

The Business Plan, Legalities, Setting Up, the Marketing Strategy, Knowing Your Competitors, Promotional Tools.

Presentation Skills

Preparation and Research, Speech Content, Subject Matter and Objectives, Speech Delivery and Variety, Body Language, Eye Contact, etc., Presentation Aids e.g. Visuals, etc., Management of Locations and Audiences, Presentation Structure.

Business Management Briefs

The projects are an important part of the course. Each course participant is given five project briefs. Participants are asked at the end of the course to produce five business management projects. This gives participants the opportunity to use the knowledge they have obtained during the course in a focused way.

ADDITIONAL INFORMATION

Methods of Training

Online Lecture Modules, Subject Expert Feedback Sessions after each Module, Practical Case Studies, End of Module Practical Activities etc.

Subject Experts

Full support is available from our Subject Experts by email at the end of each module and an ongoing basis during the course.

Who Should Apply

Anyone working in the general business sector in a senior or support role which is likely to require Business Management Skills.

Qualifications

Successful candidates are awarded the Diploma in Business and Oracle Programming at Pass, Credit or Distinction level.

Time and Duration

Students have up to 12 months to complete this course.

On successful completion of this course you will receive a Diploma level qualification that is certified and awarded by the ICM (Institute of Commercial Management)

The Institute of Commercial Management was founded in 1979 and is one of the leading Professional Examination and Certification Bodies in the world today. Fitzwilliam Institute have developed and provided practical skills training courses in liaison with the Institute of Commercial Management qualifications and certifications framework for over 25 years. The Institute of Commercial Management certifications and continual professional development training awards are recognised throughout Europe, the USA, Canada, Australia, South Africa and Asia in a total of 140 countries, by leading industries, bodies and professions.

next start date: 27th October 2017

Duration: You will have full access to online resources and subject expert support for one calendar year. However, you can complete the course in as little as 4 - 6 months, by dedicating 6-8 hours of study per week.

Course Fees: 795.00 GPB

To secure your place on the course the full fee is required. All fees must be paid in full before the course begins. Please note, the full course fees are inclusive of all course materials and certification costs.

Enrolment intake is strictly limited on this course. Early application is advised. Places are allocated on a first come first served basis.

Fitzwilliam Institute closes on Bank Holidays and for a number of days at Christmas and New Year. Fitzwilliam Institute reserves the right to postpone, cancel or alter courses without notice or to change any of the details in this brochure. Fees are not refundable unless the course is cancelled by Fitzwilliam Institute. Distance Learning courses are provided by Fitzwilliam Institute BGLS Ltd.

Year on year, we have the pleasure of training students from top UK and international companies. See where our most recent students come from and find out what they have to say.