Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
1
•
Activities:
1
•
Resources:
63
- Announcements
- 001 Oracle Database Introduction Basics of Tables mkUP gitir
- 002 Creating the Workspace in Oracle FyeN gitir
- 003 IMPORTANT Prepare the Sample Data oBjD gitir
- 004 Dedicated TA Support vqCD gitir
- 006 How to Proceed in This Course nG45 gitir
- 008 Retrieving Data Using the SELECT Clause NALK gitir
- 009 Using the WHERE Clause in a Query VqN9 gitir
- 010 Important Information from Instructor urBR gitir
- 011 Using Operators in the WHERE Clause ige8 gitir
- 012 Some Inspiration HsBg gitir
- 013 Combining WHERE AND OR with Operators zLgS gitir
- 014 Query Filtering Continued BETWEEN IN and NULL T8k7 gitir
- 015 What Will Make you Grow as a Software Developer D9Rd gitir
- 016 Query Filtering Conditions Operator Precedence xuj9 gitir
- 017 Ordering Concatenating And Aliasing Query Results MmFu gitir
- 019 Single Row Functions SRF Using The Dual Table inSE gitir
- 020 Using Functions in WHERE And Character Based SRFs Xefr gitir
- 021 Numeric and Date Data type SRFs 2wRJ gitir
- 022 Conversion SRFs and Date Formatting xAwj gitir
- 024 Concluding SRFs NULL NULLIF Functions k92i gitir
- 026 Grouping Functions MIN MAX AVG COUNT etc Ptey gitir
- 027 GROUP BY Clause HAVING Clause AgGX gitir
- 028 More Practice With The GROUP BY Clause zqi9 gitir
- 029 SELECT within SELECT Subqueries oRWp gitir
- 030 Relating Tables Together Using JOINs UuTS gitir
- 031 Joins Continued INNER OUTER Joins fN83 gitir
- 032 Career Advice xyTi gitir
- 033 Correlated Subqueries with EXISTS NOT EXIST operators dix3 gitir
- 034 SELF JOIN MsKj gitir
- 035 CROSS JOIN NATURAL JOIN and the USING CLAUSE Pylk gitir
- 036 EQUIJOIN and NON EQUIJOINs BHmm gitir
- 037 CASE Statements VS4w gitir
- 038 OVER Clause with PARTITION BY g9bA gitir
- 039 Compute Running Totals with Ordering and Partitioning UleG gitir
- 040 Unbounded Preceding Order in Over Clause CcgS gitir
- 041 Slicing Windows and Filtering with Analytic Functions 8aDI gitir
- 042 Rank Dense rank Lead and Lag Functions 767b gitir
- 044 Creating Your Own Tables Design Considerations s0Gg gitir
- 045 Inserting Data Into Our Table OQld gitir
- 046 Create Table With a Primary Key Constraint wAn4 gitir
- 047 INSERT ALL for Multi table Conditional Inserts noOR gitir
- 048 Using ALTER to modify the table structure E7U5 gitir
- 049 Create Table with SELECT UPDATE Data lIoQ gitir
- 050 MERGE Statement in Oracle qXCC gitir
- 052 Sequence Statements in Oracle JovI gitir
- 053 DELETE TRUNCATE and DROP Commands 2hIE gitir
- 054 Working With Database Indexes M4Mm gitir
- 055 System Tables Pseudo Columns Deleting Duplicates Newly Added ZARp gitir
- 056 Views and Other Objects and Commands Newly Added Na8q gitir
- 058 Granting and Revoking Privileges nBz7 gitir
- 059 OFFSET and FETCH fhSw gitir
- 060 ERD Diagrams ERQ8 gitir
- 061 Commit Rollback and Savepoint 38Oq gitir
- 062 Large Objects and Interval Data Types T2xc gitir
- 063 Using Cascade Constraints and On Delete Cascade qBQT gitir
- 064 UNUSED Columns pVPZ gitir
- 065 External Tables ybT1 gitir
- 066 SQL Plus and Substitution Variables AF1N gitir
- 067 QA 1 DML DDL and Transaction Control iQ0q gitir
- 068 QA 2 Fetch and Substitution Variables KGX6 gitir
- 069 QA 3 Conversion Functions TO CHAR NVL and TO DATE V2Ud gitir
- 072 Install Oracle Database 19c in Windows E7id gitir
- 073 Install Oracle SQL Developer in Windows cEXL gitir