Courses

This course introduces the most common data types that are available in Oracle. Selecting the correct data type is very important in creating a database design, so it is important to know what data types are available and their capabilities. This is intended to be an introductory level course that will make sure you understand how to choose the data type that best fits your needs.

This course introduces the most fundamental of data structures in an Oracle database: the table. Learn how to define tables, declare columns, define constraints on tables, important storage options you need to know about, and global temporary tables and external tables. You'll also learn about privileges and roles in Oracle, which are essential for granting appropriate permissions in your database. This course will also teach you best practices for building tables in your database, and how to create and use indexes for efficient data access.

Oracle offers a variety of objects that can be used to complement the tables in your database. Views allow you to store a SQL query that defines a logical representation of data in one or more tables, allowing you to create a type of virtual table over your physical tables. Synonyms allow you to define an alternate name for almost any object in Oracle. Sequences help create unique integer values in a thread-safe manner. Triggers allow you to define a behavior when a DML statement is executed against one of your tables. Combined with the tables and indexes in your database, you will be well equipped to handle almost any situation that occurs in your database design.

At the core of developing a high quality, bug free application lies our skills and knowledge to test our applications thoroughly and effectively. In this course, Oracle PL/SQL Unit Testing with Oracle SQL Developer, you'll learn how to test your PL/SQL code using the Oracle SQL Developer Unit Testing Framework. It is a robust and feature rich framework which allows you to easily create test cases for your PL/SQL program units, organize them in test suites, reuse your work with libraries and share your tests in a team development environment. First, you'll discover that it allows you to analyze your code coverage and view previous runs and results with several built-in reports. Next, you'll explore how it lets you synchronize your tests when the name or definition of the underlying program units change. Finally, you'll learn how it gives you the ability to automate your tests using the SQL Developer command line interface, which is extremely useful in implementing your continuous testing strategy. When you're finished with this course, you'll have a foundational understanding of Oracle SQL Developer PL/SQL Unit Testing feature, which will help you immensely when implementing extensive test cases for your PL/SQL program units and achieving test automation.

By the end of this course, learners will be able to apply advanced SQL operators, design efficient queries using views and indexes, and implement analytic and conditional functions to solve real-world business problems. Participants will learn how to restructure and aggregate data with CUBE, ROLLUP, and GROUPING SETS, as well as handle NULL values using NVL, NVL2, and COALESCE. This course goes beyond theory by offering case-study-driven practice in Oracle SQL Developer, ensuring learners gain hands-on experience with query optimization and advanced reporting. Learners will not only understand how to write SQL code but also evaluate performance impacts, analyze multidimensional data, and design logic-driven queries for decision-making. What makes this course unique is its practical approach, combining foundational SQL structures with advanced business-ready techniques such as DECODE, CASE, and ranking functions like ROW_NUMBER, RANK, and DENSE_RANK. By completing this course, learners will confidently create optimized, flexible, and insightful SQL queries that are essential for careers in data analytics, business intelligence, and database management.

Oracle Data Integrator (ODI) 12c Developer Course What you'll learn: From basic concepts to advanced level ODI hands-on projects.ODI Development Lifecycle from real life OID implementation projects.ODI Architecture. Role of different ODI Components like Repository, Fusion Middleware, Agents. Data, Integration, Information and Intelligence derivation.ODI 12c Virtual Machine installation.ODI Studio and it's components: Security, Topology, Designer, Operator.Implement practice projects.Projects covering the ODI Lifecycle components.Integration between Complex file (with XML Schema) and RDBMS.Customization of built-in knowledge module and development of new knowledge modules.Real time integration through Changed Data Capture (CDC) and Journalizing (JKM)JDK, Repository, ODI Domain, Weblogic Server, Node Manager, Standalone Colocated Agent, and JEE Agent on you own machine.Execute project on ODI installed on your own machine.Topology for a File System and Oracle Database connection, Reverse engineering the Models, Mapping to transfer data from files to Oracle database tables.ODI integration with Big DataODI components migration through Smart Export and Smart Import Join the most comprehensive and popular Oracle Data Integrator (ODI) 12cDeveloper Courseon Udemy, because now is the time to get started! From basic concepts about Data Integration, Intelligence,Architecture,ODI Components, Project Developmentto Migrationand Support,this course covers it all you need to know to become a successfulODI Developer!But that's not all! Along with covering all the steps ofODI developerfunctions,this coursealso hasquizzesand projects, which allowyou to practice the things learned throughout the course! You'llnot only learn about the concepts but alsopractice each ofthose concepts through Projects. And if you do get stuck, youbenefit from extremely fast and friendly support- both via direct messaging or discussion. You have my word!Withmore than two decades of ITexperience, I have designed this course for students and professionals who wish to masterhow to develop and support industry-standard batch integration inOracle Data Integrator.This course will be kept up-to-date to ensure you don't miss out on any changes once ODI 12c is required in your project!Why ODI?Oracle Data Integrator (ODI) is the integration tool every enterprise need. The key technical capabilities likeExtract-Load-Transform (ELT) approach,Near real-time data integration capability through Change Data Capture(CDC),Declarative design with fully modifiable Knowledge Modules,SOA capable through web-servicesIntegration of structured as well as unstructured dataexists only in ODI. It'sOracle's flagship, High-performance bulk data movementand transformation tool. Oracle is investing a lot in this tool.ODI is a built-in batch integration tool for Oracle BI Apps 11g onwards. The current Oracle BI Apps customers will have to replace their existing ETL tools with ODI.The Extract-load-transform(ELT) approach of ODI with a knowledge module based modular approach makes it the most complete andscalablebatch integration tool.If you are looking for athriving careerindata integration and analytics,this is theright time to learn ODI.Get a very deep understanding of ODI Developer activitiesEvery new ODI version is coming with added features.The successof ODI implementation and its performance depends on the ODI developer.Pay once, benefit a lifetime! This is an evolving course! ODI12c development andlater future versions will be covered in this course. You won’t lose out on anything! Don’t lose any time, gain an edge, and start now!

By completing this course, learners will design relational databases, construct tables with constraints, implement joins, and analyze business data using advanced SQL queries. They will also apply aggregate functions, manage NULL values, pivot datasets, and create subqueries to extract actionable insights. This case study–driven course is designed for learners who want hands-on experience in SQL with Oracle SQL Developer. Beginning with database and table creation, participants progress through increasingly complex scenarios such as finding the nth highest salary, department-level analysis, hierarchical queries, and advanced filtering with GROUP BY and HAVING. Learners will gain practical problem-solving skills by working through real-world style challenges instead of abstract examples. What makes this course unique is its structured approach: each module builds on the last, moving from foundational database creation to advanced business applications. Instead of focusing solely on syntax, the course emphasizes how to think in SQL — transforming raw data into meaningful business insights. By the end, learners will have the confidence to tackle real database challenges, making them more effective in roles across data analysis, business intelligence, and application development.

Use Oracle SQL Developer like a Pro: Learn the features & tricks that will help you be the most admired SQL developer What you'll learn: You will take advantage of many useful features that will make you more effective and efficient at workYou will learn a lot of tricks and enjoy being seen as an SQL Developer expertYou will learn how to create and share beautiful and interactive reportsYou will learn how to Install and customize SQL Developer in a way that works and feels best for youYou will learn how to take full advantage of all the basic features of the tool Oracle SQL Developer is currently the most popular tool among database developers and Oracle SQL learners, however, since it makes it so easy to start firing commands and querying a database, many people don't feel the need to investigate its features, and end up using only what is obvious, visible, and enabled by default.If you are one of them, this course will help you get out of that group and start using Oracle SQL Developer more smartly.Even if you have some time using the tool and are currently using some of its features, there's most likely something in this course that you don't know and can be helpful to you.Learn the features that can help you work with your Oracle database better and faster: Install and customize SQL Developer in a way that works and feels best for you.Take full advantage of the most useful features of the tool.Create and share beautiful and interactive reports.Take advantage of features that will make you more effective and efficient at work.Learn a lot of tricks and enjoy being seen as an SQL Developer expert. All Oracle SQL Developer features are free. Take advantage of them:This course was created because there appears to be a pattern among Oracle SQL courses and the database community in general: “If you are able to install it and connect to a database, you are good to go".What's more: Experience shows that even developers who are already working with Oracle databases as part of their job, tend to not look for ways to work faster inSQL Developer, and usually only investigate features they don't currently use when it is strictly necessary for their jobs.The goal of this course is to fill the gap most SQL courses leave about this great tool so that it can serve as a foundation if you are planning to learn Oracle SQL, and also to help you take advantage of the tool's features if you are already working with Oracle databases as part of your job, so that you can be more efficient and productive, and thus, stand out. Content and Overview:The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer.There is usually one lecture per feature, so, if for any reason you are not interested in any of the included tips, you can simply skip it, and go directly to the one you want to learn about.The course content will continue to be updated over time, to make sure you always know about the most important features available to you, as new versions of Oracle SQL Developer are released.Learn these tips and apply them to your work, and you will not only be well prepared to work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.

Preparation for Oracle Certification (Java Certification) Java SE 21 1Z0-830 with examples, quizes and home tasks What you'll learn: Master handling primitives, wrapper classes, and type conversions in JavaEvaluate and apply arithmetic and boolean expressions with precedence rulesEffectively manipulate text using String, StringBuilder, and text blocksWork with Java Date-Time API to handle date, time, period, and timezone objectsCreate and manage control flow constructs like if/else, switch, and loopsImplement advanced object-oriented concepts, including encapsulation and inheritanceCreate classes, records, and instantiate fields, methods, and constructorsApply polymorphism, method overriding, and the instanceof operator with pattern matchingWork with Java interfaces, functional methods, and enums effectivelyHandle exceptions using try/catch/finally, try-with-resources, and multi-catch blocksCreate and manipulate arrays and Java Collections like List, Set, Map, and DequeProcess data using Streams and lambda expressions for filtering, transforming, and sortingPerform advanced operations on Streams like decomposition, reduction, and groupingUnderstand modular Java, compile code, and create modular/non-modular JARsManage concurrent code execution with threads, ExecutorService, and parallel streamsDevelop thread-safe code with locking mechanisms and concurrent APIsUse Java I/O API for reading/writing files and serializing/deserializing objectsImplement localization using resource bundles and locale-specific parsing/formattingUnderstand additional Java features, including annotations and the Java Logging API What Is Oracle 1Z0-830 Certification?The Oracle 1Z0-830 certification, also known as the Java SE 21 Developer Certification, is an advanced credential that validates your expertise in modern Java development. This certification is specifically designed for professionals who want to showcase their skills in Java SE 21 features, covering a wide range of programming concepts, from object-oriented principles to modular applications.Benefits of Earning This CertificationCareer Growth: Elevate your profile with a globally recognized certification.Updated Knowledge: Stay ahead with expertise in Java SE 21, the latest long-term support version.Credibility: Demonstrates a deep understanding of core and advanced Java programming concepts.Real-World Applications: Gain skills that are highly relevant to modern enterprise applications.How This Course Prepares YouThis course is crafted to help you master every topic required for the Oracle 1Z0-830 certification. It includes lessons to build your understanding and quizzes to test your knowledge. By the end of the course, you’ll be well-prepared to tackle the certification exam with confidence. Topics Covered in This CourseThe Oracle 1Z0-830 certification requires proficiency across various domains of Java development. Below is a breakdown of the topics:1. Handling Date, Time, Text, Numeric, and Boolean ValuesUse primitives and wrapper classes, evaluate arithmetic and boolean expressions, and apply precedence rules, type conversions, and casting.Manipulate text using String, StringBuilder, and text blocks.Work with date, time, duration, period, and time-zone objects, including daylight saving time, using the Date-Time API.2. Controlling Program FlowCreate and manage control flow constructs such as if/else, switch statements and expressions, loops, and break/continue statements.3. Using Object-Oriented Concepts in JavaDeclare and instantiate objects, including nested classes, and explain object lifecycles.Create classes, records, and define/instantiate instance and static fields, methods, constructors, and initializers.Implement method overloading, including var-arg methods.Understand variable scopes, apply encapsulation, and create immutable objects.Use local variable type inference.Implement inheritance, including abstract and sealed types, record classes, and overriding methods, including those of the Object class.Use polymorphism, casting, and the instanceof operator with pattern matching and switch constructs.Create and use interfaces with functional methods, and private, static, and default methods.Work with enums including fields, methods, and constructors.4. Handling ExceptionsHandle exceptions with try/catch/finally, try-with-resources, and multi-catch blocks.Create and use custom exceptions.5. Working with Arrays and CollectionsCreate and manipulate arrays, List, Set, Map, and Deque collections, including adding, removing, updating, retrieving, and sorting elements.6. Working with Streams and Lambda ExpressionsUse Java Streams, including lambda expressions implementing functional interfaces, to filter, transform, process, and sort data.Perform decomposition, concatenation, reduction, grouping, and partitioning on sequential and parallel streams.7. Packaging and Deploying Java CodeDefine and expose module content, including by reflection, and declare module dependencies.Compile Java code, create modular/non-modular JARs, runtime images, and implement migration to modules using unnamed/automatic modules.8. Managing Concurrent Code ExecutionCreate platform and virtual threads using Runnable and Callable objects.Manage thread lifecycles and use different ExecutorService implementations and concurrent APIs.Develop thread-safe code with locking mechanisms and process Java collections concurrently with parallel streams.9. Using Java I/O APIRead/write console and file data using I/O Streams.Serialize and deserialize Java objects.Work with Path objects and their properties using the java.nio.file API.10. Implementing LocalizationImplement localization using locales and resource bundles.Parse and format messages, dates, times, and numbers, including currency and percentage values.11. Additional Java FeaturesUnderstand the basics of the Java Logging API.Use annotations like @Override, @FunctionalInterface, @Deprecated, @SuppressWarnings, and @SafeVarargs.Comprehensive Scope of CertificationBy completing this course, you will develop proficiency in:Handling Date, Time, Text, Numeric, and Boolean ValuesControlling Program FlowObject-Oriented Concepts in JavaHandling ExceptionsArrays and CollectionsStreams and Lambda ExpressionsPackaging and Deploying Java CodeManaging Concurrent Code ExecutionJava I/O APILocalizationAdditional Java FeaturesThis comprehensive preparation ensures you are fully equipped to pass the Oracle 1Z0-830 certification and advance your career in Java development. Let’s begin!

The SELECT statement, functions and more. Oracle Database 11g, 12c, 19c, 21c using Oracle SQL Developer. 1Z0-071 exam. What you'll learn: Create tables in a database and ALTER columns in the table.Know what data type to use in various situations, and use functions to manipulate date, number and string data values.Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.JOIN two or more tables together, finding missing data.INSERT new data, UPDATE and DELETE existing data, and export data into a new table.Create constraints, views and sequences, subqueries and CTEsUse UNION, CASE, MERGE and error checkingApply ranking and analytic functions, groupingLearn about transactions, indexes, users, privileges, roles and more This course is the foundation for the Oracle Database SQL1Z0-071 certification. It covers the SELECTstatement in detail, with additional requirements for controlling user access. It is divided into 6 sessions, each of which should take a morning or afternoon to complete.Please note:This course is not affiliated with, endorsed by, or sponsored by Oracle. What do people like you say about this course?Prashant says: "Course has been designed in way that a person with no knowledge of Oracle can understand it. Good learning and thanks a lot for making such nice course."Shubho says:"Awesome course. The instructor explains the concepts very thorougly and in a easy-to-grasp way. Also, the practice exercises are super helpful. If you want to master Oracle SQL, this is the course for you."Henry says:"I want to thank Phillip for this formidable course. This course along with other materials helped me to pass the 1Z0-071 Exam last Saturday." Session 1We'll install for free Oracle Express Edition and Oracle SQLDeveloper. Then we'll take a look at the 6 principal clauses of the SELECTstatement:SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.Then we'll start creating tables, but find that we can't get very far without understanding data types. We'll then look at string, date and number types and functions, together with looking at functions converting between them.Session 2We'll revisit the SELECT statement and go into more detail. We'll create tables and JOIN them together. Once you have finished this session, you should be secure in your knowledge of the 6 principal clauses of the SELECT statement, the most important part of Oracle SQL.Session 3In session 3, we'll looking for missing data, and find out how to delete and update data. We'll look at the difference between implicit and explicit transactions, and various constraints, including primary and foreign keys.Session 4We'll start off by saving our queries in views. Then we'll combine tables, not by adding additional columns using JOINS, but adding additional rows such Oracle SQLset operators such as UNION, INTERSECT and MERGE. Then we'll look at analytical functions using the OVERclause.Session 5Session 5 starts off by adding totals to our SELECT queries. We'll then look at subqueries, and how you can add them into the FROM, SELECT and WHEREclauses, and also into the WITH clause. Finally, we'll look at Oracle SQLself-joins, which are useful when you have hierarchies.Session 6Session 6 starts off with two additional data types, TIMEZONE and INTERVAL data types and functions. We'll then have a look at SEQUENCEs and INDEXes, together with how these are shown in the Data Dictionary. We'll then create new users, and assign privileges and roles to them, and we'll finish with the last few requirements for the exam.No prior knowledge is required - we'll even install Oracle Database and Oracle SQL Developer on your computer for free!Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in Oracle SQL.

Learn how to query databases using SQL What you'll learn: Choose the right logical operators for your queriesChoose the right logical SET operators for your queriesWrite SQL Queries to extract dataWrite SQL Queries to modify dataWrite SQL Queries to delete dataWrite SQL Queries to create tablesWrite SQL Queries to extract data from multiple tablesWrite Advanced SQL Queries using analytic functionsWrite SQL Queries to generate reports Learning SQL is a very useful skill to have as every business and organisationis so dependent on data. There are not enough skilled SQL professionals hence the demand and pay rate for SQL professionals is quite high. SQL stands for structured query language. It is an international standard language used to query and manipulate databases. There are different types of database vendors like Oracle, Microsoft ,MySQL and so on . They all support SQL and performs certain operations in the same way. Keywords like CREATE,SELECT,UPDATE, DELETE,WHERE and FROM are used the same way with various database vendors. This course will teach you the skills you need to get your foot in the door as an SQL professional. With the skills you learn on this course you can work confidently as a data analyst or even progress to be a database administrator. This course will take from scratch to more advanced SQL using TOAD and SQL Developer TOOL Some of what you will learn on this course includes: Database conceptsSQL SUB Languages -DDL and DMLAggregate FunctionsLogical OperatorsSET OperatorsTable JoinsAnalytic FunctionsSingle Row FunctionsCreating TablesCreating ViewsCreating SequencesCreating IndexesUsing AliasesUsing Sub QueriesNULL ValuesRestricting and Limiting DataBy the end of this course you will confidently be able to write SQL queries to create,read,update and delete data which are the key functions that are performed on a database.

Explore the world of fast and efficient Java microservices using GraalVM in this 35-minute conference talk. Discover how to leverage GraalVM, a high-performance virtual machine, to compile Java applications into native executables optimized for cloud deployments. Learn the basics of getting started, examine compatible frameworks, and gain insights into performance optimization techniques. Join Alina Yurenko, Developer Advocate for GraalVM at Oracle, as she guides you through the process, covering topics such as Micronaut, available resources, the language ecosystem, and practical examples. Conclude with a Q&A session to address any lingering questions about harnessing the power of GraalVM for Java microservices development.

Explore a preview of an upcoming series in Java Magazine focusing on the vibrancy of the Java community in this 24-minute video interview. Listen as Jim Grisanzio converses with Alan Zeichick, editor-in-chief of Oracle's Java Magazine, about the planned profile articles featuring engineers and developers who contribute to Java's dynamic ecosystem. Gain insights into recent Java trends, the anticipated release of Java 15, and the Oracle Developer Live Java event. Discover the importance of peer-reviewed content in Java Magazine and learn about the influx of new developers entering the Java world with a clean slate approach. Hear about Alan's encounter with Venkat Subramaniam and the Oracle Groundbreakers India Yatra event. Enhance your understanding of Java's ongoing evolution and the passionate community driving its growth.

Explore the groundbreaking implementation of virtual threads in Helidon 4, the world's first web framework fully based on this game-changing technology. Dive into the story of Helidon WebServer, examining the challenges faced and solutions developed. Learn how virtual threads, introduced in Project Loom and now a production feature in Java 21, significantly enhance JVM resource utilization, enabling performance comparable to reactive engines while maintaining a fully blocking paradigm. Discover the impact of this innovation on microservices frameworks and gain insights from Dmitry Aleksandrov, a Java Champion and Oracle Groundbreaker, as he shares his expertise on this transformative development in the Java ecosystem.

Do you want to develop or migrate your existing web applications to run in the cloud? Perhaps you have an environment with multiple languages and runtimes at the same time? In this course, Oracle Cloud for Developers, you'll learn how to create Java SE and Node.js applications and run them in Oracle Application Container Cloud Service and take advantage of the power of the cloud. You'll learn all about integration with other Oracle Cloud Services such as Database. You'll also learn to deploy, monitor, and scale your applications instantly from the Web UI. By the end of this course, you'll know everything you'll required to create applications and run them in Oracle Application Container Cloud Service. Visit https://www.pluralsight.com/partners/oracle to view additional content Oracle and Pluralsight have arranged to help you skill up on Oracle Cloud.

Oracle is one of the most popular database systems in use today. Yet many developers do not understand how Oracle works or the principles behind developing high performance Oracle applications. This course targets the .NET or Java developer who is writing an application with a backend Oracle database. Topics include: understanding how Oracle is processing your SQL statements through generating and interpreting execution plans, to designing and using indexes to speed up the data access of your application. Also included is how to use Oracle dynamic performance views to view real time information about Oracle performance, including which SQL statements are the most costly to run. The use of bind variables, connection pooling, and some application best practices round out the topics covered in the course.

Every application needs a database to store its data. But setting up and managing a new database has traditionally been a slow and time-consuming process. With Oracle Autonomous Transaction Processing, you can set up a fully managed Oracle database hosted in the cloud in a matter of minutes. In this course, Oracle Autonomous Transaction Processing for Developers, you will learn everything you need to know to start creating applications with Autonomous Transaction Processing. First, you will learn how to create an Autonomous Transaction Processing database in the Oracle Cloud. Next, you will discover how to connect to Autonomous Transaction from various programming languages. Finally, you will explore how to manage your Autonomous Transaction Processing instance. When you are finished with this course, you will have the skills and knowledge to start writing applications against Autonomous Transaction Processing and take advantage of its most important features.

Today, more then ever, data is central to any organization to provide useful insights and competitive advantages. There is also a growing need to move data around, from one database to another or within schemas of the same database, for better analysis, testing, and review. Data warehouses are crucial for predictive analysis, and the need to have efficient tools to extract, transform, and load data in these environments is extremely important. In this course, you will learn how to get data quickly and efficiently in and out of Oracle using popular formats like Excel, XML, JSON, plain insert scripts, and SQL loader format, among others. We will learn about the flexible SQL*Loader tool and its powerful direct path option which can improve load performance by orders of magnitude. We will explore the powerful External table feature, which allows you to query data in external data files using the power of SQL and PL/SQL. After taking this course, as a database developer you should be well equipped with the skills and knowledge to perform data transfer tasks effectively.

Explore a conference talk that delves into the concept of automating developer workflows to eliminate toil and maximize engineering value. Learn about the definition of toil in the context of developer experience and discover how automations can effectively remove it. Examine the key traits of impactful automations, including their ability to drive culture, be low-lift, serve as experiments, and run against a broad palette. Gain insights into how leading teams implement automation today through real-world examples of guardrails, notifications, actions, and workflows. Understand the importance of measuring, experimenting, and iterating in the automation process. Discover the Sleuth automations marketplace and find out where to learn more about implementing these practices in your development workflow.

Explore a 34-minute conference talk featuring Justin Cormack, CTO of Docker, discussing the company's developer-centric approach and successful restructuring. Gain insights into Docker's explosive growth, product development strategies, and the challenges of the "Shift Left" trend in software development. Learn about Docker's efforts to enhance developer productivity, support for AI applications, and the importance of the inner development loop. Discover why developers prefer certain hardware and how to effectively communicate technical needs to business leaders. Understand Docker's vision for the future of software development and containerization in this informative discussion on developer-focused strategies and industry trends.