Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай The Complete Oracle SQL Certification Course, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:19:44
    Oracle Database Introduction & Basics of Tables
  • Урок 2. 00:06:34
    Creating the Workspace in Oracle
  • Урок 3. 00:03:43
    IMPORTANT: Prepare the Sample Data
  • Урок 4. 00:01:40
    Dedicated TA Support
  • Урок 5. 00:02:19
    How to Proceed in This Course
  • Урок 6. 00:14:43
    Retrieving Data Using the SELECT Clause
  • Урок 7. 00:19:38
    Using the WHERE Clause in a Query
  • Урок 8. 00:03:36
    Important Information from Instructor
  • Урок 9. 00:19:48
    Using Operators in the WHERE Clause
  • Урок 10. 00:02:34
    Some Inspiration
  • Урок 11. 00:19:17
    Combining WHERE, AND & OR with Operators
  • Урок 12. 00:20:03
    Query Filtering Continued BETWEEN, IN and NULL
  • Урок 13. 00:03:11
    What Will Make you Grow as a Software Developer
  • Урок 14. 00:19:57
    Query Filtering Conditions & Operator Precedence
  • Урок 15. 00:20:01
    Ordering, Concatenating & Aliasing Query Results
  • Урок 16. 00:19:38
    Single Row Functions (SRF) & Using The Dual Table
  • Урок 17. 00:20:01
    Using Functions in WHERE And Character Based SRFs
  • Урок 18. 00:19:54
    Numeric and Date Data type SRFs
  • Урок 19. 00:19:40
    Conversion SRFs and Date Formatting
  • Урок 20. 00:16:19
    Concluding SRFs & NULL / NULLIF Functions
  • Урок 21. 00:19:43
    Grouping Functions MIN, MAX, AVG, COUNT etc.
  • Урок 22. 00:20:00
    GROUP BY Clause & HAVING Clause
  • Урок 23. 00:12:13
    More Practice With The GROUP BY Clause
  • Урок 24. 00:23:59
    SELECT within SELECT (Subqueries)
  • Урок 25. 00:19:22
    Relating Tables Together Using JOINs
  • Урок 26. 00:21:31
    Joins Continued INNER & OUTER Joins
  • Урок 27. 00:01:29
    Career Advice
  • Урок 28. 00:21:15
    Correlated Subqueries with EXISTS & NOT EXIST operators
  • Урок 29. 00:11:11
    SELF JOIN
  • Урок 30. 00:08:44
    CROSS JOIN, NATURAL JOIN and the USING CLAUSE
  • Урок 31. 00:09:39
    EQUIJOIN and NON-EQUIJOINs
  • Урок 32. 00:08:41
    CASE Statements
  • Урок 33. 00:18:32
    OVER Clause with PARTITION BY
  • Урок 34. 00:18:48
    Compute Running Totals with Ordering and Partitioning
  • Урок 35. 00:08:43
    Unbounded Preceding Order in Over Clause
  • Урок 36. 00:06:00
    Slicing Windows and Filtering with Analytic Functions
  • Урок 37. 00:15:06
    Rank, Dense_rank, Lead, and Lag Functions
  • Урок 38. 00:21:02
    Creating Your Own Tables & Design Considerations
  • Урок 39. 00:19:42
    Inserting Data Into Our Table
  • Урок 40. 00:21:36
    Create Table With a Primary Key Constraint
  • Урок 41. 00:11:25
    INSERT ALL for Multi-table & Conditional Inserts
  • Урок 42. 00:16:35
    Using ALTER to modify the table structure
  • Урок 43. 00:19:57
    Create Table with SELECT + UPDATE Data
  • Урок 44. 00:16:58
    MERGE Statement in Oracle
  • Урок 45. 00:12:29
    Sequence Statements
  • Урок 46. 00:18:51
    DELETE, TRUNCATE, and DROP Commands
  • Урок 47. 00:14:22
    Working With Database Indexes
  • Урок 48. 00:24:07
    System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)
  • Урок 49. 00:23:34
    Views and Other Objects and Commands (Newly Added)
  • Урок 50. 00:15:09
    Granting and Revoking Privileges
  • Урок 51. 00:09:56
    OFFSET and FETCH
  • Урок 52. 00:18:35
    ERD Diagrams
  • Урок 53. 00:14:38
    Commit, Rollback, and Savepoint
  • Урок 54. 00:17:34
    Large Objects and Interval Data Types
  • Урок 55. 00:17:57
    Using Cascade Constraints and On Delete Cascade
  • Урок 56. 00:07:38
    UNUSED Columns
  • Урок 57. 00:15:01
    External Tables
  • Урок 58. 00:32:43
    SQL Plus and Substitution Variables
  • Урок 59. 00:24:20
    QA 1- DML, DDL, and Transaction Control
  • Урок 60. 00:25:14
    QA 2- Fetch and Substitution Variables
  • Урок 61. 00:28:51
    QA 3 - Conversion Functions, TO_CHAR, NVL, and TO_DATE
  • Урок 62. 00:09:37
    Install Oracle Database 19c in Windows
  • Урок 63. 00:13:28
    Install Oracle SQL Developer in Windows