Benefiting from over 30 years’ practical skills training experience, Fitzwilliam Institute’s Online Diploma in Business with Oracle Programming course features:
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;
Vision and mission; Objectives; Planning and strategy; Contingency planning; implementation; change control;
Production methods; cost; revenue and break-even analysis; Quality assurance; Production planning; Project management;
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;
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; Analysing and interpreting financial statements; Analysis tools; Auditing;
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;
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 and the environment; Corporate social responsibility; Commercial Law; Company Law; Contract Law; Employment Law; Law of Tort;
Innovation; research and new product development;
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;
Setting Up & Marketing Your Own Consultancy
The Business Plan; Legalities; Setting Up; The Marketing Strategy; Knowing Your Competitors; Promotional Tools;
Preparation and Research; Speech Content; Subject Matter and Objectives; Speech Delivery and Variety; Body Language; Eye Contact; Presentation Aids; Management of locations and audiences; Presentation structure;
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;
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;
Using SQL SELECT statements with Single Row Functions
Multiple Tables and Aggregate Functions; 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
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;
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;
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
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 by leading industries, bodies and professions.
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: 995.00 EUR
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
Ireland and international companies. See where our most recent students come from and find out what they have to say.