|
/1 - Oracle Database 12c: SQL Fundamentals (1Z0-071)/
|
|
1 - Relational DBs, Oracle, and SQL: What is a Relational Database?.mp4
|
28.4 MB
|
|
10 - Data Definition Language (DDL): Oracle Database Structure and Schema.mp4
|
19.4 MB
|
|
11 - Data Definition Language (DDL): Unique Names and Namespaces.mp4
|
18.3 MB
|
|
12 - Data Definition Language (DDL): Creating a Table with DDL.mp4
|
28.7 MB
|
|
13 - Data Definition Language (DDL): Data Types for Fields.mp4
|
30.2 MB
|
|
14 - Data Definition Language (DDL): Creating a Constraint on a Table.mp4
|
21.1 MB
|
|
15 - Data Definition Language (DDL): Types of Constraints.mp4
|
29.6 MB
|
|
16 - Data Definition Language (DDL): Dropping Columns.mp4
|
24.4 MB
|
|
17 - Data Definition Language (DDL): External Tables.mp4
|
25.8 MB
|
|
18 - Data Definition Language (DDL): Lab.mp4
|
61.0 MB
|
|
19 - Data Manipulation Language (DML): Inserting Data into a Table.mp4
|
23.5 MB
|
|
2 - Relational DBs, Oracle, and SQL: Tables, Views, and Queries.mp4
|
19.5 MB
|
|
20 - Data Manipulation Language (DML): Updating Data in a Table.mp4
|
18.9 MB
|
|
21 - Data Manipulation Language (DML): Selecting Data From a Table.mp4
|
21.8 MB
|
|
22 - Data Manipulation Language (DML): Deleting Data From a Table.mp4
|
15.9 MB
|
|
23 - Data Manipulation Language (DML): Truncating Data From a Table.mp4
|
18.4 MB
|
|
24 - Data Manipulation Language (DML): Managing Transactions with TCL.mp4
|
26.2 MB
|
|
25 - Data Manipulation Language (DML): Lab.mp4
|
53.3 MB
|
|
26 - Restricting and Sorting Query Results: Using the ORDER BY Clause.mp4
|
21.3 MB
|
|
27 - Restricting and Sorting Query Results: Sorting on Expressions and Aliases.mp4
|
23.1 MB
|
|
28 - Restricting and Sorting Query Results: Filtering with WHERE.mp4
|
25.0 MB
|
|
29 - Restricting and Sorting Query Results: Wildcard Comparisons Using LIKE.mp4
|
14.3 MB
|
|
3 - Relational DBs, Oracle, and SQL: Modeling Data With Entity Relationship Diagrams (ERD).mp4
|
23.5 MB
|
|
30 - Restricting and Sorting Query Results: Boolean Logic in the WHERE Clause.mp4
|
24.7 MB
|
|
31 - Restricting and Sorting Query Results: IN, BETWEEN, and IS.mp4
|
22.7 MB
|
|
32 - Restricting and Sorting Query Results: Limiting Results with FETCH.mp4
|
22.3 MB
|
|
33 - Restricting and Sorting Query Results: Ampersand Substitution.mp4
|
26.0 MB
|
|
34 - Restricting and Sorting Query Results: Prompt, Accept, and Define.mp4
|
21.7 MB
|
|
35 - Restricting and Sorting Query Results: Lab.mp4
|
44.9 MB
|
|
36 - Single-Row and Conversion Functions: Single-Row Functions.mp4
|
23.4 MB
|
|
37 - Single-Row and Conversion Functions: Character Functions.mp4
|
27.5 MB
|
|
38 - Single-Row and Conversion Functions: Numeric Functions.mp4
|
17.2 MB
|
|
39 - Single-Row and Conversion Functions: Date Functions.mp4
|
17.6 MB
|
|
4 - Relational DBs, Oracle, and SQL: Normalizing Databases (3NF).mp4
|
27.6 MB
|
|
40 - Single-Row and Conversion Functions: Analytical Functions.mp4
|
22.7 MB
|
|
41 - Single-Row and Conversion Functions: Partition, Lag, and Lead.mp4
|
16.3 MB
|
|
42 - Single-Row and Conversion Functions: Conversion Functions.mp4
|
27.0 MB
|
|
43 - Single-Row and Conversion Functions: General Functions.mp4
|
21.2 MB
|
|
44 - Single-Row and Conversion Functions: Lab.mp4
|
51.6 MB
|
|
45 - Retrieving Data from Multiple Tables: Types of Joins.mp4
|
22.6 MB
|
|
46 - Retrieving Data from Multiple Tables: Inner Joins.mp4
|
24.6 MB
|
|
47 - Retrieving Data from Multiple Tables: Outer Joins.mp4
|
27.5 MB
|
|
48 - Retrieving Data from Multiple Tables: Alternative Join Types.mp4
|
21.5 MB
|
|
49 - Subqueries: Introduction.mp4
|
21.0 MB
|
|
5 - Relational DBs, Oracle, and SQL: What is Structured Query Language (SQL)?.mp4
|
24.2 MB
|
|
50 - Subqueries : Correlated Subqueries.mp4
|
19.5 MB
|
|
51 - Subqueries: EXISTS, NOT EXISTS, and WITH.mp4
|
14.2 MB
|
|
52 - Subqueries: Single-Row and Multi-Row Subqueries.mp4
|
24.2 MB
|
|
53 - Subqueries: Lab.mp4
|
53.3 MB
|
|
54 - Aggregating Data: Aggregate Functions.mp4
|
18.7 MB
|
|
55 - Aggregating Data: Grouping with GROUP BY.mp4
|
21.1 MB
|
|
56 - Aggregating Data: HAVING.mp4
|
16.1 MB
|
|
57 - Aggregating Data: Set Operators.mp4
|
21.1 MB
|
|
58 - Aggregating Data: Set Output Order.mp4
|
15.0 MB
|
|
59 - Aggregating Data: Lab.mp4
|
39.6 MB
|
|
6 - Relational DBs, Oracle, and SQL: ANSI SQL, Oracle SQL, and SQL*Plus.mp4
|
21.7 MB
|
|
60 - Advanced Schema Operations: Objects.mp4
|
27.2 MB
|
|
61 - Advanced Schema Operations: Creating Views.mp4
|
18.5 MB
|
|
62 - Advanced Schema Operations: Creating and Using Sequences.mp4
|
19.3 MB
|
|
63 - Advanced Schema Operations: Creating and Maintaining Indexes.mp4
|
23.3 MB
|
|
7 - Relational DBs, Oracle, and SQL: DDL, DML, and TCL.mp4
|
17.7 MB
|
|
8 - Relational DBs, Oracle, and SQL: Installing Oracle Database 12c.mp4
|
24.9 MB
|
|
9 - Relational DBs, Oracle, and SQL: Your First SQL Statement.mp4
|
25.5 MB
|
|
/10 - Moving Data/
|
|
1 - Oracle Data Pump and SQL*Loader.mp4
|
22.1 MB
|
|
2 - Oracle Data Pump.mp4
|
28.3 MB
|
|
3 - Exporting and Importing with Data Pump.mp4
|
23.4 MB
|
|
4 - Oracle SQL*Loader.mp4
|
25.4 MB
|
|
5 - Demonstrating SQL*Loader.mp4
|
28.7 MB
|
|
6 - External Tables.mp4
|
25.0 MB
|
|
7 - Moving Data Lab.mp4
|
7.6 MB
|
|
/11 - Monitoring and Tuning Database Performance/
|
|
1 - Performance Monitoring.mp4
|
25.8 MB
|
|
2 - Maintenance Windows.mp4
|
27.8 MB
|
|
3 - Maintenance Tasks.mp4
|
18.3 MB
|
|
4 - Memory Management.mp4
|
27.3 MB
|
|
5 - SQL Tuning Process.mp4
|
31.2 MB
|
|
6 - Upgrading your Database with DBUA.mp4
|
25.1 MB
|
|
7 - Upgrading your Database Manually.mp4
|
23.0 MB
|
|
/12 - Using Oracle Database Cloud Service/
|
|
1 - Oracle Database Cloud Service (DBCS) Offerings.mp4
|
18.8 MB
|
|
2 - DBCS Architecture.mp4
|
24.4 MB
|
|
3 - DBCS Deployment.mp4
|
19.9 MB
|
|
4 - Network Access to DBCS.mp4
|
25.7 MB
|
|
5 - Connecting to DBCS.mp4
|
24.5 MB
|
|
/2 - Oracle Database Architecture/
|
|
1 - Installing Oracle Server.mp4
|
34.5 MB
|
|
2 - Oracle SQL and PL_SQL.mp4
|
19.4 MB
|
|
3 - Oracle Database Tools.mp4
|
32.1 MB
|
|
4 - Oracle Supplied User Accounts.mp4
|
27.8 MB
|
|
5 - Connecting to an Oracle Database.mp4
|
22.6 MB
|
|
6 - Querying the Data Dictionary.mp4
|
22.9 MB
|
|
7 - Relational Database Models.mp4
|
30.5 MB
|
|
8 - Installing Oracle Database Lab.mp4
|
12.3 MB
|
|
/3 - Oracle Network Environment Configuration/
|
|
1 - Oracle Net Services.mp4
|
20.7 MB
|
|
2 - Configuring Oracle Net Listener.mp4
|
33.2 MB
|
|
3 - Configuring Dynamic Registration.mp4
|
31.9 MB
|
|
4 - Configuring Local Naming.mp4
|
32.3 MB
|
|
5 - Testing Connectivity.mp4
|
18.0 MB
|
|
6 - Oracle Net Services Lab.mp4
|
13.9 MB
|
|
/4 - Creating and Managing Tablespaces/
|
|
1 - Understanding Oracle Tablespaces.mp4
|
25.7 MB
|
|
2 - Creating Tablespaces.mp4
|
21.3 MB
|
|
3 - Altering Tablespaces.mp4
|
29.5 MB
|
|
4 - Viewing Tablespace Information.mp4
|
21.0 MB
|
|
5 - Implementing Oracle Managed Files.mp4
|
26.9 MB
|
|
6 - Moving Online Data Files.mp4
|
16.5 MB
|
|
7 - Creating and Managing Tablespaces Lab.mp4
|
7.7 MB
|
|
/5 - Managing UNDO Data/
|
|
1 - Oracle Undo Data.mp4
|
19.0 MB
|
|
2 - Configuring Undo Retention.mp4
|
18.8 MB
|
|
3 - Undo Retention Guarantee.mp4
|
17.8 MB
|
|
4 - Viewing Undo Information.mp4
|
19.6 MB
|
|
5 - Managing Undo Data Lab.mp4
|
5.9 MB
|
|
/6 - Backup and Recovery Concepts/
|
|
1 - Categories of Failure.mp4
|
22.1 MB
|
|
2 - Backup and Recovery Strategies and Tools.mp4
|
27.8 MB
|
|
3 - Complete and Incomplete Recovery.mp4
|
37.7 MB
|
|
4 - Oracle Flashback Technology.mp4
|
34.1 MB
|
|
5 - Backup and Recovery on DBCS.mp4
|
23.1 MB
|
|
6 - Backup and Recovery Concepts Lab.mp4
|
7.2 MB
|
|
/7 - Managing Database Instances/
|
|
1 - Initialization Parameters.mp4
|
22.5 MB
|
|
2 - Shutting Down and Starting Up Instances.mp4
|
21.7 MB
|
|
3 - Dynamic Performance Views.mp4
|
16.3 MB
|
|
4 - Database Configuration Assistant (DBCA).mp4
|
13.8 MB
|
|
5 - DBCA Templates.mp4
|
20.8 MB
|
|
6 - Managing Database Instances Lab.mp4
|
6.1 MB
|
|
/8 - Administering User Security/
|
|
1 - Creating Users.mp4
|
16.9 MB
|
|
2 - Granting Privileges.mp4
|
23.0 MB
|
|
3 - Creating and Granting Roles.mp4
|
30.5 MB
|
|
4 - Password Profiles.mp4
|
23.3 MB
|
|
5 - Authenticating Users.mp4
|
18.5 MB
|
|
6 - Default Tablespaces and Quotas.mp4
|
25.0 MB
|
|
7 - Administering User Security Lab.mp4
|
7.0 MB
|
|
/9 - Manage Storage Space with Oracle/
|
|
1 - Segments and Extents.mp4
|
35.7 MB
|
|
2 - Deferred Segment Creation.mp4
|
15.0 MB
|
|
3 - Monitoring Space Usage.mp4
|
24.4 MB
|
|
Total files 130
|
