Semos Education Training & Certification Programs
Bul. Kuzman Josifovski Pitu br. 19 lok.6, 1000 Skopje, Macedonia phone: +389 (0)2 31 30 900 | e-mail: kursevi@semos.com.mk www.semosedu.com.mk www.facebook.com/semos.edu
Semos Education
Semos Education is the first and the biggest computer education center in Macedonia with 16 educational programs, over 173 diverse courses, 50 certified trainers and over 45.000 satisfied customers. For over 18 years, we share IT knowledge and experience and believe that the learning process is experience which can cause powerful transformation in the individual as well as the companies. We organize a wide range of trainings, designed for various end users with a different level of computer technology knowledge: IT Professionals (Microsoft: Web programmers, Database administrators, Server administrators; Cisco: Network Associates, Network Professionals; Oracle and Java: Associates and Professionals; EC-Council: Ethical Hackers, Forensic Investigators, Security Analysts, Penetration Testers; Vmware Certified Professionals) Official Autodesk Training
Customized Training (MS Office, Adobe, Graphisoft, ITIL, Project Management, Programming, iOS and Android Applications) Children Computer Training in 20 levels (age 8-16)
How to contact us? Semos Education Bul. Kuzman Josifovski Pitu br. 19 lok.6 1000 Skopje, Macedonia phone:
+389 (0)2 31 30 900
e-mail: kursevi@semos.com.mk www.semosedu.com.mk www.facebook.com/semos.edu
College for Graphic and Web Design – one year student programs
www.semosedu.com.mk
1
Oracle Career Certifications Oracle Approved Training Center
What does OAEC represents
Since 2010 Semos Computers Education Center received title OAEC – Oracle Approved Education Center, becoming the first and only regional training center for the Oracle official courses.
OAEC partners are the unique authorized training centers, whose task and purpose is to implement certified and official training, according to strict standards of Oracle. OAEC program is designed in order to enable maximum support to training partners. The training course includes:
Oracle Authorized Training Partners have been carefully chosen by Oracle University to ensure that attendees will receive the highest quality training possible. Semos Education also possesses Oracle Gold Certificate and Oracle Certified Reseller.
Expert instruction and certification preparation Training materials developed at Oracle Instructors certified and approved by Oracle University
Benefits of certification See below how thousands of members have testified to the value of the Oracle Certification Program. 97% said they have benefited from certification.
96% would recommend the program to a professional colleague. 89% said they gained more confidence in their Oracle expertise after becoming certified.
Learn more at: www.semosedu.com.mk
www.semosedu.com.mk
69
Oracle Career Certifications
Benefits to the IT Employer
A Solid Return On Investment
The Oracle Certification Program is valuable to hiring managers who want to distinguish among candidates for critical IT positions.
In a recent salary report of certified professionals by Certification Magazine, Oracle Certified Professionals were found to earn the highest average salaries as compared to any other DBA or Developer professionals. The survey involved members of the top certification programs in the IT industry. Net gains due to obtaining a certification were also researched, and both Oracle and Compaq Certified Professionals were, again, at the top of the list for increased salary due to certification.
For companies that send employees through annual IT training, certification ensures a return on the training investment by validating the knowledge and understanding gained in training sessions. Companies can also combine certification with an employee development program to enhance employee loyalty and performance on the job. Hiring certified professionals has a direct impact on a company’s bottom line, as these conclusions from a research study by International Data Corporation suggest: Certified professionals handled 40% more support calls per person, per day, than uncertified staff. Companies that advocated certification reported 49% less downtime than those that did not. For the majority of companies surveyed, the savings from increased effectiveness paid the costs of certification in fewer than nine months. Learn more at: www.semoskoc.com.mk
70
www.semosedu.com.mk
Therefore, it is easy to realize the very positive return on investment that Oracle Certification can bring to your bottom line. Most certified OCPs have found that their financial investment in training and certification is paid off by gains in salary, job opportunities, or expanded roles over a short nine month period. It is unlikely that you will find a better opportunity to grow your career and the value you bring to the job.
Oracle Certified Associate (OCA) Associate Level An Oracle Certified Associate (OCA) demonstrates a solid understanding of the foundation skills of a given job role, which can be applied at an apprentice or entry level. By earning an OCA certification,
students can have increased entry-level job opportunities. It is the stepping-stone to starting a successful career as an Oracle professional.
#
Exam
Recommended Training
Classes
1
1Z0-007
Oracle Database: Introduction to SQL
40
1000
2
1Z0-001
Oracle Database: Program with PL/SQL
40
1000
3
1Z0-052
Oracle Database 11g: Administration Workshop I DBA
40
1000
Total:
Price (EUR)
3000
Total with discount:
www.semosedu.com.mk
71
Course Outline Oracle Database: Introduction to SQL
Oracle Database: Program with PL/ SQL 40 classes
Introduction to Oracle Database Retrieve Data Using the SQL SELECT Statement Learn to Restrict and Sort Data Usage of Single-Row Functions to Customize Output Invoke Conversion Functions and Conditional Expressions Aggregate Data Using the Group Functions Display Data From Multiple Tables Using Joins Use Sub-queries to Solve Queries The SET Operators Data Manipulation Statements Use of DDL Statements to Create and Manage Tables Other Schema Objects Control User Access Management of Schema Objects Manage Objects with Data Dictionary Views Manipulate Large Data Sets Data Management in Different Time Zones Retrieve Data Using Sub-queries Regular Expression Support
72
www.semosedu.com.mk
Oracle Database 11g: Administration Workshop I 40 classes
Introduction Introduction to PL/SQL Declare PL/SQL Identifiers Write Executable Statements Interaction with the Oracle Server Control Structures Composite Data Types Explicit Cursors Exception Handling Stored Procedures Stored Functions and Debugging Subprograms Packages Deploying Packages Implement Oracle-Supplied Packages in Application Development Dynamic SQL Design Considerations for PL/SQL Code Triggers Creating Compound, DDL, and Event Database Triggers PL/SQL Compiler Manage PL/SQL Code Manage Dependencies
40 classes Exploring the Oracle Database Architecture Installing your Oracle Software Creating an Oracle Database Managing the Oracle Database Instance Manage the ASM Instance Configuring the Oracle Network Environment Managing Database Storage Structures Administering User Security Managing Data Concurrency Managing Undo Data Implementing Oracle Database Auditing Database Maintenance Performance Management Backup and Recovery Concepts Performing Database Backups Performing Database Recovery Moving Data Working with Support
Oracle Certified Professional (OCP) Professional Level An Oracle Certified Professional (OCP) is in high demand in today’s marketplace. There a many ways to gain OCP. The level of demand continues to grow with each new installation of Oracle technologies around the world. An OCP Certification raises student’s visibility and increases student’s access to the industry’s most challenging opportunities. The demand for professionals in the information technology (IT) industry is high, and the competition for jobs is intense. Individuals, experienced or new to the profession, need to know what skills make them attractive to employers. Employers look for ways to select prospective employees who have the solid foundation of
skills needed for effective performance. The Oracle Certification Program helps the IT industry establish a standard of competence in key entrylevel and professional job roles. The Oracle Certification Program can give you a distinct advantage. OCPs have testified to the value of Oracle Certification2: An Oracle Certification is a valuable, industry-recognized credential that signifies a proven level of knowledge and ability. Each higher level of Oracle certification brings a higher standard of benchmarked skill and ability, which leads to greater opportunities and higher pay.
#
Exam
Recommended Training
Classes
1
1Z0-007
Oracle Database: Introduction to SQL
40
1000
2
1Z0-052
Oracle Database 11g: Administration Workshop I DBA
40
1000
3
1Z0-053
Oracle Database 11g: Administration Workshop II DBA
40
1000
Total:
Price (EUR)
3000
Total with discount:
www.semosedu.com.mk
73
Course Outline Oracle Database: Introduction to SQL
Oracle Database 11g: Administration Workshop I 40 classes
Introduction to Oracle Database Retrieve Data Using the SQL SELECT Statement Learn to Restrict and Sort Data Usage of Single-Row Functions to Customize Output Invoke Conversion Functions and Conditional Expressions Aggregate Data Using the Group Functions Display Data From Multiple Tables Using Joins Use Sub-queries to Solve Queries The SET Operators Data Manipulation Statements Use of DDL Statements to Create and Manage Tables Other Schema Objects Control User Access Management of Schema Objects Manage Objects with Data Dictionary Views Manipulate Large Data Sets Data Management in Different Time Zones Retrieve Data Using Sub-queries Regular Expression Support
74
www.semosedu.com.mk
Oracle Database 11g: Administration Workshop II 40 classes
Exploring the Oracle Database Architecture Installing your Oracle Software Creating an Oracle Database Managing the Oracle Database Instance Manage the ASM Instance Configuring the Oracle Network Environment Managing Database Storage Structures Administering User Security Managing Data Concurrency Managing Undo Data Implementing Oracle Database Auditing Database Maintenance Performance Management Backup and Recovery Concepts Performing Database Backups Performing Database Recovery Moving Data Working with Support
40 classes Core Concepts and Tools of the Oracle Database Configuring for Recoverability Using the RMAN Recovery Catalog Configuring Backup Settings Creating Backups with RMAN Restore and Recovery Task Using RMAN to Perform Recovery Monitoring and Tuning RMAN Diagnosing the Database Using Flashback Technology I Using Flashback Technology II Performing Flashback Database Managing Memory Managing Database Performance Managing Performance by SQL Tuning Managing Resources Automating Tasks with the Scheduler Managing Space in Blocks Managing Space in Segments Managing Space for the Database Duplicating a Database
Oracle OCP – SQL Developer Courses Professional Level Introduction to SQL and PL/SQL is an intensive course that is designed to give the student maximum exposure to Oracle SQL. The student learns by doing, and this class has dozens of in-class exercises and the student will be guided from very simple SQL commands to increasingly complex PL/SQL coding techniques.
The topics start with the basics of SQL and progress into increasingly complex queries, including table joins, sub-queries and creating Oracle views. The PL/SQL section begins with simple concepts and the student gradually masters PL/SQL through increasingly challenging classroom exercises.
#
Exam
Recommended Training
Classes
1
1Z0-007
Oracle Database: Introduction to SQL
40
1000
2
1Z0-001
Oracle Database: Program with PL/SQL
40
1000
3
1Z0-146
Oracle Database 11g: Advance PL/SQL
40
1000
Total:
Price (EUR)
3000
Total with discount:
www.semosedu.com.mk
75
Course Outline Oracle Database: Introduction to SQL
Oracle Database: Program with PL/ SQL 40 classes
Introduction to Oracle Database Retrieve Data Using the SQL SELECT Statement Learn to Restrict and Sort Data Usage of Single-Row Functions to Customize Output Invoke Conversion Functions and Conditional Expressions Aggregate Data Using the Group Functions Display Data From Multiple Tables Using Joins Use Sub-queries to Solve Queries The SET Operators Data Manipulation Statements Use of DDL Statements to Create and Manage Tables Other Schema Objects Control User Access Management of Schema Objects Manage Objects with Data Dictionary Views Manipulate Large Data Sets Data Management in Different Time Zones Retrieve Data Using Sub-queries Regular Expression Support
76
www.semosedu.com.mk
Oracle Database: Advance PL/ SQL 40 classes
Introduction Introduction to PL/SQL Declare PL/SQL Identifiers Write Executable Statements Interaction with the Oracle Server Control Structures Composite Data Types Explicit Cursors Exception Handling Stored Procedures Stored Functions and Debugging Subprograms Packages Deploying Packages Implement Oracle-Supplied Packages in Application Development Dynamic SQL Design Considerations for PL/SQL Code Triggers Creating Compound, DDL, and Event Database Triggers PL/SQL Compiler Manage PL/SQL Code Manage Dependencies
40 classes Introduction PL/SQL Programming Concepts Review Designing PL/SQL Code Using Collections Manipulating Large Objects Using Advanced Interface Methods Performance and Tuning Improving Performance with Caching Analyzing PL/SQL Code Profiling and Tracing PL/SQL Code Implementing VPD with Fine-Grained Access Control Safeguarding Your Code Against SQL Injection Attacks
Oracle OCP Developer with Forms and Reports Oracle Tools Professional Level Oracle Forms, a component of Oracle Fusion Middleware, is Oracle’s long-established technology to design and build enterprise applications quickly and efficiently. Oracle remains committed to the development of this technology, and to the ongoing release as a component of the Oracle platform. This continuing commitment to Forms technology enables you to leverage your existing investment by easily upgrading and integrating existing Oracle Forms applications to take advantage of web technologies and service oriented architectures (SOA). Oracle Reports, a component of Oracle Fusion Middleware is Oracle’s
award-winning, high-fidelity enterprise reporting tool. It enables businesses to provide instant access to information to all levels within and outside of the organization in a scalable and secure environment. Oracle Reports consists of Oracle Reports Developer - a powerful, declarative WYSIWYG reports design tool and a J2EE 5.0 based Oracle Reports Server with multi-tier architecture to access any data sources, generate reports in any popular format for web and paper, and to burst and distribute reports to any destination. Oracle remains committed to the development of this technology, and to the ongoing release as a component of the Oracle Fusion Middleware platform.
#
Exam
Recommended Training
Classes
1
1Z0-007
Oracle Database: Introduction to SQL
40
1000
2
1Z0-001
Oracle Database: Program with PL/SQL
40
1000
3
1Z0-151
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
40
1000
4
1Z0-123
Oracle Reports Developer 10g: Build Reports
40
1000
Total:
Price (EUR)
4000
Total with discount:
www.semosedu.com.mk
77
Course Outline Oracle Database: Introduction to SQL
Oracle Database: Program with PL/ SQL 40 classes
Introduction to Oracle Database Retrieve Data Using the SQL SELECT Statement Learn to Restrict and Sort Data Usage of Single-Row Functions to Customize Output Invoke Conversion Functions and Conditional Expressions Aggregate Data Using the Group Functions Display Data From Multiple Tables Using Joins Use Sub-queries to Solve Queries The SET Operators Data Manipulation Statements Use of DDL Statements to Create and Manage Tables Other Schema Objects Control User Access Management of Schema Objects Manage Objects with Data Dictionary Views Manipulate Large Data Sets Data Management in Different Time Zones Retrieve Data Using Sub-queries Regular Expression Support
78
www.semosedu.com.mk
40 classes Introduction Introduction to PL/SQL Declare PL/SQL Identifiers Write Executable Statements Interaction with the Oracle Server Control Structures Composite Data Types Explicit Cursors Exception Handling Stored Procedures Stored Functions and Debugging Subprograms Packages Deploying Packages Implement Oracle-Supplied Packages in Application Development Dynamic SQL Design Considerations for PL/SQL Code Triggers Creating Compound, DDL, and Event Database Triggers PL/SQL Compiler Manage PL/SQL Code Manage Dependencies
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms 40 classes
Oracle Reports Developer 10g: Build Reports 40 classes
Running a Forms Application Working in the Forms Builder Environment Creating a Basic Form Module Creating a Master-Detail Form Working Data Blocks and Frames Working with Text Items Creating LOVs and Editors Creating Additional Input Items Creating Noninput Items Creating Windows and Content Canvases Working with Other Canvas Types Producing and Debugging Triggers Adding Functionality to Items Displaying Run-Time Messages and Alerts Using Query Triggers Validating User Input Controlling Navigation Overriding or Supplementing Transaction Processing Writing Flexible Code Sharing Objects and Code Using WebUtil to Interact with the Client Introducing Multiple Form Applications
Introduction to Oracle Reports Developer Designing and Running Reports Exploring Oracle Reports Developer Creating a Paper Report Enhancing a Basic Paper Report Managing Report Templates Creating a Web Report Enhancing Reports Using the Data Model: Queries and Groups Enhancing Reports Using the Data Model: Data Sources Enhancing Reports Using the Data Model: Creating Columns Enhancing Reports Using the Paper Layout Controlling the Paper Layout: Common Properties Controlling the Paper Layout: Specific Properties Web Reporting Extending Functionality Using XML Creating and Using Report Parameters Embedding a Graph in a Report Enhancing Matrix Reports Coding PL/SQL Triggers Extending Functionality Using the SRW Package Maximizing Performance Using OracleAS Reports Services Building Reports: Efficiency Guidelines
www.semosedu.com.mk
79