search
  • Sign In
  • Sign Up
Password reset successful

Follow the proiects vou are interested in andi aet the latestnews about them taster

Home
Course List
Xiao Wenji Oracle video tutorial

Xiao Wenji Oracle video tutorial

Oracle has always been a leader in the database field due to its good data security and stability. "Xiao Wenji Oracle Video Tutorial" is designed for database developers and introduces Oracle from scratch. In addition to basic SQL syntax, it also brings you custom functions and stored procedures that are necessary in the database development process.

83713 person learning
33 class hour
2022-04-18 update time
11 Hours48 minutes14 seconds Total course duration
大家讲道理
Gold lecturer
114 Course
51793 student
5.8 score

光阴似箭催人老,日月如移越少年。

You will learn

1. Master the basics of Oracle’s SQL statements. 2. Be able to master common Oracle functions 3. Be able to skillfully use Oracle functions in queries to facilitate data query statistics.

Xiao Wenji Oracle video tutorial

Section1 Oracle server installation
21 minutes05 seconds
Section2 Oracle remote connection
18 minutes44 seconds
Section3 Oracle architecture
27 minutes56 seconds
Section4 Data dictionary and creating tablespace
24 minutes07 seconds
Section5 User creation and permission granting
25 minutes18 seconds
Section6 Create table
20 minutes03 seconds
Section7 Maintenance table
20 minutes01 seconds
Section8 DML statement
30 minutes41 seconds
Section9 Column-level constraints and table-level constraints
41 minutes46 seconds
Section10 Constraint maintenance
16 minutes24 seconds
Section11 Three paradigms of data modeling
18 minutes34 seconds
Section12 Data modeling entity relationships
25 minutes10 seconds
Section13 Crazy shopping platform modeling
16 minutes46 seconds
Section14 Simple query statement
42 minutes51 seconds
Section15 Commonly used functions
31 minutes43 seconds
Section16 Multiple table join
18 minutes00 seconds
Section17 group function
30 minutes26 seconds
Section18 Collection query
02 minutes57 seconds
Section19 subquery
23 minutes24 seconds
Section20 rownum and rowid
15 minutes25 seconds
Section21 path to maturity
53 minutes10 seconds
Section22 decode function
05 minutes13 seconds
Section23 sequence sequence
12 minutes04 seconds
Section24 synonyms
06 minutes23 seconds
Section25 index
08 minutes19 seconds
Section26 view
05 minutes56 seconds
Section27 Define variables
17 minutes06 seconds
Section28 Operation data
10 minutes01 seconds
Section29 Composite data type
22 minutes08 seconds
Section30 process control
16 minutes53 seconds
Section31 Exception handling
12 minutes51 seconds
Section32 cursor
18 minutes33 seconds
Section33 stored procedure
48 minutes16 seconds
Chapter1 Oracle Video Tutorial

Data Name

The courseware is currently not available for download, and the staff are organizing it. Please pay more attention to this course in the future~