Home
Videos uploaded by user “Jennifer Kreie”
09 of  13 - Oracle APEX 5 - Create a master-detail form (uses 2 tables)
 
09:27
A new series using APEX 18.1 is now available. https://youtu.be/vlPxEuYnt1Q This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create two master-detail tables. First, we look at the data model and see why two tables should be appear together in a form. Then, we create two master-detail forms. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 42590 Jennifer Kreie
3 of 6  SQL Advanced with Oracle - Type II subqueries, a.k.a. a correlated subquery
 
09:08
This video explains how to write a Type II subquery. A Type II subquery is sometimes referred to as a correlated subquery. There is a explanation of the difference between Type I and Type II subqueries and an example of using a Type II subquery to solve a "difference" problem. (3 of 6) There is also an "SQL Fundamentals" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 11882 Jennifer Kreie
04 of 15 SQL Basics with Oracle - Data Model for sample HR database
 
06:01
This video is a short introduction to the human resources (HR) sample database Oracle provides with Oracle XE. This shows how to unlock the HR account, change the password, and create a database connection using SQL Developer. We also see how to use Data Modeler, a component of SQL Developer, to generate a data model from existing tables in a schema. (4 of 15) There is also an "Advanced SQL" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 20128 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (02 of 22) - Overview of APEX
 
04:17
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video shows the components of the APEX development environment: application builder, SQL workshop, team development and administration.
Views: 20539 Jennifer Kreie
Database Fundamentals (9 of 10) - Multivalued Attributes
 
03:18
See how a multivalued attribute in a data model is handled when the tables in the database are actually built.
Views: 11875 Jennifer Kreie
01 of  13 - Oracle APEX 5 - Overview of APEX; create workspace and designer account
 
08:34
A new series using APEX 18.1 is now available. https://youtu.be/LjPuDuoB-R0 This is one video in a tutorial series about APEX 5. In this video we log in as the APEX administrator to create a workspace. There is an overview of the APEX components. A few designer accounts are created to show how a team could work on a development project. These accounts will be used throughout the series to build the application. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 58285 Jennifer Kreie
Database Fundamentals (6 of 10) - How a relationship is built in the database
 
05:20
A relationship between two entities in a data model must eventually become part of a relational database. This video explains how the primary key and foreign keys are handled.
Views: 4870 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (13 of 22) - Create a master-detail form
 
06:57
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video in the APEX tutorial series shows how to create a master-detail form (form that uses one table and a related sub-form that uses another table).
Views: 12058 Jennifer Kreie
Database Fundamentals (5 of 10) - Logical and Physical Data Models
 
06:04
Learn about the differences between a logical data model and a physical data model. Terms presented include: unique identifier and primary key
Views: 27351 Jennifer Kreie
05 of  13 - Oracle APEX 5 - Create an application; create a form with interactive report
 
14:51
A new series using APEX 18.1 is now available. https://youtu.be/8P0OdAHpxFQ This is one video in a series about APEX 5. In this video we generate an application in APEX (a container for the application design elements) and we look at the difference in theme styles for an application. Next, we create a form with report which actually creates two pages--one for the form and one for the report. The report is interactive and has many readily available features for filtering, sorting, grouping, etc. The form allows a new record to be created and updates to an existing record. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 61431 Jennifer Kreie
Database Fundamentals (1 of 10) - Overview
 
06:53
This is the first of ten videos about fundamental concepts of relational databases.
Views: 10125 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (01 of 22) - Getting started with Oracle XE and APEX
 
06:36
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video shows how to begin working with Oracle APEX 4.24. In the video we log into APEX, create a workspace and then log into that workspace to begin application development. This is the first in a series of videos. There are scripts used in this series you can use to work along with the videos. These scripts are available at: http://web.nmsu.edu/~jkreie/oracle/DatabaseTopics.html
Views: 47042 Jennifer Kreie
15 of 15 SQL Basics with Oracle - Traditional set operators: UNION, INTERSECT & MINUS
 
09:56
This video gives examples of three set operators: UNION, INTERSECT, MINUS. The union compatible rule is also explained. Set operators are used when output comes from more than one SQL statement. (15 of 15) There is also an "Advanced SQL" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 12761 Jennifer Kreie
04 of 13 - Oracle APEX 5 - Generate a lookup table; set uniqueness constraint on field
 
08:26
A new series using APEX 18.1 is now available. https://youtu.be/lONi8Ig1sLg This is one video in a series about APEX 5. In this video we use the APEX wizard for generating a lookup table from data in a column in an existing table. Next, we set a uniqueness constraint on a column. Finally, we update the status of to-do tasks in the Team Development component of APEX. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 26118 Jennifer Kreie
03 of  13 - Oracle APEX 5 - Create a table; set a uniqueness constraint on a field; import data
 
10:37
A new series using APEX 18.1 is now available. https://youtu.be/acnRWpRSrbI This is one in a series of videos for an APEX 5 tutorial. In this video we see how to create a database table using APEX. Then we set a uniquenss constraint for a field in an existing table. Finally, we import data from a CSV file into a table. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 35359 Jennifer Kreie
00 of  13 - Oracle APEX 5 - Getting started with Oracle XE and APEX upgrade
 
13:12
A new series using APEX 18.1 is available. https://youtu.be/65LExgaQMHI This is the first of a video series that uses APEX 5 to create a Web app based on an Oracle XE database. This video started with installing Oracle XE and goes through upgrading APEX to 5.0. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 95056 Jennifer Kreie
02 of  13 - Oracle APEX 5 - Run SQL scripts to create tables, sequences, triggers and insert data
 
09:07
A new series using APEX 18.1 is now available. https://youtu.be/acnRWpRSrbI This video in the APEX 5 tutorial series shows how to use SQL Scripts (part of SQL Workshop) to run scripts that create tables, sequences (to generate unique values for primary keys), triggers and insert data (INSERT INTO statements). SQL scripts for this series are available to download at: http://db.kreie.net
Views: 51804 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (14 of 22) - Add a region and add a button to a page
 
05:13
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video shows how to add a region to an APEX application page and how to add a button to that region. This button will open a form or report.
Views: 11068 Jennifer Kreie
08 of  13 - Oracle APEX 5 - List of values (LOV) for a field in a form; display a hidden column
 
13:22
A new series using APEX 18.1 is now available. https://youtu.be/vgrkiIpJEiQ This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create two lists of values (LOVs) in the Shared Components section of our application. We use each LOV in place of a field in a form. We see how APEX will help us write the SQL for a LOV. The difference between a "display value"and a "return value"is discussed. Finally, we display the primary key field in a form, which APEX hides by default. See the primary key field in a form can be helpful during application development. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 39871 Jennifer Kreie
APEX14.18.2:  Master-detail forms are greatly improved. See how easy it is with APEX 18.2
 
10:15
This video uses APEX 18.2 and shows the differences between version 18.1 and 18.2 when creating master-detail forms. A search feature for the primary key value is added and the primary key value is displayed, not hidden. Correction: At 8:24 in this video I say "semi-colon" when I should have said "colon." SQL code for the WHERE clause: where (:P12_SEARCH is null or upper(x."LNAME") like '%'||upper(:P12_SEARCH)||'%' or upper(x."FNAME") like '%'||upper(:P12_SEARCH)||'%' or upper(x."PERS_ID") =:P12_SEARCH ) order by "LNAME"
Views: 2316 Jennifer Kreie
APEX00 of 30: Install Oracle XE. Upgrade Application Express (APEX) to version 18.1
 
14:06
APEX 18.1 video 0 of 30: This is the first in a series of videos about Oracle XE, APEX 18.1, relational databases, and SQL. This video shows the steps to install Oracle XE and upgrade APEX to version 18.1. Scripts for the videos are at: http://db.kreie.net
Views: 6024 Jennifer Kreie
Database Fundamentals (4 of 10) - More About Defining Relationships
 
04:48
The terms one-to-one, one-to-many, and many-to-many are explained Unary and binary relationships are also explained.
Views: 4427 Jennifer Kreie
02 of 15 SQL Basics with Oracle - Create a user account in Oracle XE
 
04:35
This video shows how to connect to Oracle XE using SQL Developer and how to create an account for future use in building a relational database used in this video series. (2 of 15) There is also an "Advanced SQL" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 6106 Jennifer Kreie
06 of  13 - Oracle APEX 5 - Define UI (user interface) defaults; modify a navigation menu item
 
12:04
A new series using APEX 18.1 is now available. https://youtu.be/9_2Hxi7rANw This is one in a series of videos about creating an application using Oracle APEX 5. In this video we look at the user interface (UI) defaults for columns in tables and how to change these. Changing UI defaults to user-friendly text will help make APEX-generated reports and forms easier to read and use. We also look at how to change a navigation menu item so that it opens a different report page. This edit is done in the Shared Components section of APEX. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 45157 Jennifer Kreie
APEX26.18.2:  It is easy to make a master-detail form with two detail regions with APEX 18.2 vs 18.1
 
05:14
This video shows how APEX 18.2 makes it easy to create two detail regions related to a master region, such as a record in the “master” ANIMALS and two related “detail” tables — TRANSACTIONS and ACTIVITIES.
Views: 1484 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (07 of 22) - Create an application using Application Builder
 
06:47
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI In this video we create a new application using APEX's Application Builder. An application is a container for a set of web pages and other items. For the application template, we select a "responsive" design template that enables the application to adjust the display of a web page based on the dimensions of the device viewing the page, i.e. computer, phone, or tablet.
Views: 18290 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (15 of 22) - Using LOVs (list of values) in a form or report
 
11:27
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI A list of values (LOV) is a user-friendly way to display information in a report or to provide a drop-down list of choices in a form. This video shows how to create an LOV in the Shared Components section of APEX and then use it in forms and reports. Examples of how to combine more than one column in the display list are shown.
Views: 9569 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (05 of 22) - Create a table using Object Browser and define a constraint
 
04:57
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI See how to use Object Browser in APEX's SQL Workshop to create a table. How to add a constraint to field in a table is also shown. In this example a uniqueness constraints is added to a field.
Views: 20055 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial  (03 of 22) - Use SQL Workshop to create tables from SQL scripts.
 
03:34
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video shows how to use SQL Workshop to upload SQL scripts and run them. In the examples shown there is a script to create tables. The data model for these tables is also explained. The script is available to use if you want to work along with the videos. The URL for the scripts in this video series is given at the beginning of the video.
Views: 20476 Jennifer Kreie
12 of  13 - Oracle APEX 5 - Master-detail-detail form; add hyperlink to open another form
 
21:34
A new series for APEX 18.1 is available. https://youtu.be/vlPxEuYnt1Q This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create a master-detail form with two detail sections. We add a hyperlink to each detail section and these open other forms in the application. Finally, we add a button to the master form and configure it to open another form to a specific record. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 35340 Jennifer Kreie
APEX05 of 30: Create an application with Application Builder.  Create a simple form. Add a logo.
 
10:48
APEX 18.1 video 5 of 30: In this video we create a new application with APEX’s Application Builder. We add a logo to the application title bar and then we create a simple form with an interactive report. An APEX interactive report automatically provides many filtering and grouping options.
Views: 1225 Jennifer Kreie
11 of  13 - Oracle APEX 5 - Create simple and complex views; compare classic and interactive reports
 
16:52
A new series for APEX 18.1 is available. https://youtu.be/jYaOyiUWnk0 This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create some simple views that combine information from two tables. We create a more complex view that uses other views and tables. We use these views to create a classic APEX report and then an interactive APEX report. A few options from the interactive report are demonstrated. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 17373 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (20 of 22) - Add a hyperlink to a master-detail report
 
08:11
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI The previous video show how to create a master-detail form with two detail sections. This videos adds some useful features such as hyperlinks to switch from the master-detail form to a related record in another form. Another column is also added to the display in one of the detail sections by editing the underlying query definition.
Views: 10246 Jennifer Kreie
10 of  13 - Oracle APEX 5 - Use LOVs in form and report pages; concatenate columns into one
 
18:01
A new series using APEX 18.1 is now available. https://youtu.be/_GJVTIBYME8 This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create more LOVs (list of values) in the Shared Components section of APEX. We see how to combine (concatenate) 2 or more columns into one display column in an LOV. We use LOVs in forms and then add them to report pages. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 19037 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (06 of 22) - Use SQL Workshop utilities to import data from a CSV file
 
06:17
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video show how to import data from a comma-separated format (CSV) and insert the data into a table in the database. We also see how to use a feature called "create lookup table" to create a reference table based on existing data in a column of a table.
Views: 15825 Jennifer Kreie
4 of 6  SQL Advanced with Oracle  - Inline subquery and rownum
 
04:53
This video gives an example of an inline subquery, a query in the FROM clause of another query. We also see how we might use the rownum option to limit how many rows of output we get. (4 of 6) There is also an "SQL Fundamentals" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 10827 Jennifer Kreie
Database Fundamentals (7 of 10) - Foreign keys in unary and one-to-one relationships
 
06:48
This video gives examples of how to create the foreign key in a unary relationship (a table related to itself) and in a binary relationship where two tables that are related in a one-to-one relationship.
Views: 6217 Jennifer Kreie
Oracle APEX Tutorial (22) - See a schematic diagram of the application's database
 
09:17
The database built for this tutorial was based on a data model shown in earlier videos. In this video we see how to use SQL Developer to create a schematic diagram of the database as it was actually built. This helps us confirm correct construction of the database and provide a diagram that can be saved as a PDF file for documentation of the database and application.
Views: 13508 Jennifer Kreie
1 of 6 SQL Advanced with Oracle - Equi-joins, one-sided outer joins, plus notation
 
08:37
This video shows examples of equi-joins (the default when you use two tables in a query), one-sided outer joins using the JOIN operator in the FROM clause, and the use of the "plus notation" in Oracle in the WHERE clause (another way to do a one-sided outer join). There is also an example of using a one-sided outer join with the "is null" criterion in the WHERE clause. (1 of 6) There is also an "SQL Fundamentals" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 40724 Jennifer Kreie
07 of  13 - Oracle APEX 5 - Use data model to plan forms and reports; test forms
 
12:29
A new series using APEX 18.1 is now available. https://youtu.be/vlPxEuYnt1Q This is one in a series of videos about creating an application using Oracle APEX 5. In this video we look at the data model for the database we are building an application for. Based on the model we can plan some of the forms and reports to build. We do some testing to make sure the application is working properly. We also edit the text in the navigtation menu and update the to-do list in Team Development. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 21492 Jennifer Kreie
APEX01 of 30: Create a schema in Oracle XE and create a workspace in APEX
 
07:21
APEX 18.1 video 1 of 30: This video shows the commands used to create a schema (account) in Oracle XE and how to create a workspace in APEX that uses that schema. Scripts for the videos are at: http://db.kreie.net
Views: 1945 Jennifer Kreie
Database Fundamentals (8 of 10) - Many-to-many Relationships in a Data Model
 
03:19
A logical data model may show many-to-many relationships but these cannot be built in the relational database. The physical data model decomposes the many-to-many relationship into at least two one-to-many relationships. This video gives examples of this.
Views: 4669 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (16 of 22) - Create views in APEX
 
10:45
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video shows how to use APEX to create a view (a stored SQL query). Views are usually used to gather information from more than one table into a single display (i.e., view). Using the Object Browser and Query Builder, three views are created in this video. The first two views are simple but third view is more complicated. It uses two sub-views and two tables.
Views: 8584 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (04 of 22) - Create triggers and insert data into tables
 
03:41
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video show how to upload SQL scripts in SQL Workshop, a tool without APEX, and run these scripts to create triggers and insert data in tables. (The tables were created in the previous video.) This video also show an example of updating a to-do item in the Team Development tool in APEX.
Views: 19405 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (10 of 22) - Forms and reports on a table
 
06:21
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This series of videos uses a scenario in which several forms with reports need to be created. This video explain how a review of the data model helped the designers decides which forms and reports to create.
Views: 12577 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (11 of 22) - Create a list of values (LOV) and use it in a form
 
09:01
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI See how to create a list of values (LOV) in the Shared Components section of an application and then use that LOV in one or more forms.
Views: 12877 Jennifer Kreie
12 of 15 SQL Basics with Oracle - Aggregate (grouping) functions and the GROUP BY clause
 
09:33
This video explains the GROUP BY clause and some of the aggregate functions: sum, count, average, maximum, minimum, count(distinct ...), etc. An example of using an aggregate function would be to group students by major and only show the number of students in each major, not individual student information. (12 of 15) There is also an "Advanced SQL" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 5639 Jennifer Kreie
5 of 6  SQL Advanced with Oracle - A query with nested aggregate functions
 
03:16
This video gives an example of nested aggregate functions. A subquery with aggregate functions is placed in the WHERE clause of the outer query, which also contains aggregate functions. (5 of 6) There is also an "SQL Fundamentals" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 9356 Jennifer Kreie
Database Fundamentals (10 of 10) - Test Your Understanding
 
04:17
This video presents questions about terms, concepts and implementation that were presented in the previous nine videos in this series. See if you can answer these questions.
Views: 3442 Jennifer Kreie
Oracle APEX 4.2.4 Tutorial (17 of 22) - Create a classic report in APEX
 
05:04
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI This video shows the classic report format available in APEX. The default setting includes a link to download the report data into a CSV (comma separated value) file. At the end of the video you can see how to switch a classic report format to the interactive report form. An interactive report offers several features that help users organize the report data in several ways.
Views: 7329 Jennifer Kreie