Shulou(Shulou.com)06/01 Report--

Found some [SQL Database basic Video course] which is suitable for rookies to learn (there is a free way to get it at the end of the article). Taking Oracle as an example, this paper explains the syntax of basic SQL and the use of functions, multi-table join query, sub-query, as well as some SQL applications of management objects and some regular expressions. The SQL language of all relational databases is the same, and it is easy to get started only by learning the SQL of other relational databases.

Duration: 109 videos in 18 chapters

Video link: https://www.modb.pro/course/3?yll

Learning content (109 videos) Chapter 1 retrieves data using select statements (4 lectures)

Through this section, you can master the most basic syntax of sql statements and use select to query data.

1.1 select basic syntax "4:52"

1.2 null value calculation and operation expression "12:36"

1.3 aliases, concatenation operators, strings, reference operators "20:22"

1.4 desc and distinct usage "6:37"

Chapter 2 filtering and sorting data (8 lectures)

Learn to filter query results through conditions and sort results through this chapter

2.1 Overview of filtering conditions and syntax using "8:01"

2.2 comparison operator "6:31

2.3Date, string and fuzzy match "7:32"

2.4Null filtering "3:53

2.5 logical operators and priority "14:14"

2.6 the query results in sql are sorted by "9:28"

2.7 apply the alternative variable "12:15" in sql

2.8Appling define and verify "5:44" in sql

Chapter 3 using one-line functions (5 lectures)

Through the study of this course, we can deal with the data through one-line function.

3.1 Overview of one-line functions and examples "5:06"

3.2 character function "4:23"

3. Numeric function "9:09"

3.4Using the date and the date statement "13:36"

3.5 date function "7:39"

Chapter 4 using conversion functions and conditional expressions (7 lectures)

Master the conversion of three data types and commonly used expressions through the study of this course.

4.1Overview and classification of conversion functions "7:07"

4.2 to_char, to_number and to_date "27:01"

4.3Functions dealing with null values "10:47"

4.4 concat and substr, length "7:54"

4.5 lpad,rpad,trim,instr "8:13"

4.6 nested function "7:52"

4.7 case and decode "15:24"

Chapter 5 using grouping functions (lecture 5)

Master the detailed usage of grouping function through the study of this course

5.1Overview of grouping functions and syntax "4:36"

5.2 avg,count,sum,min,max "15:10"

5.3 group by "12:32"

5.4 use having to filter "8:08"

5.5 nested function "4:58"

Chapter 6 Multi-table query (lecture 6)

Master several ways of multi-table connection through the study of this course

6.1 several types of join queries and their syntax "6:35"

6.2Natural connections (natural join and using "16:22"

6.3 join... On and left connection and external connection, full external connection "9:21"

6.4 self-connecting "15:55"

6.5 non-equivalent connection "5:51"

6.6 Descartes connects "5:21"

Chapter 7 using subqueries (lecture 4)

Through this course, we learn to master the syntax of subqueries and the difference between single-line and multi-row subqueries.

7.1Syntax "8:07" for subquery

7.2 single-line subquery "7:19"

7.3 subqueries in having and null value problem "11:24"

7.4 Multiline subquery (all,any,in) "10:11"

Chapter 8 using set operators (lecture 3)

Master the operation between sets through the study of this course.

8.1 Overview and categories of collection operators, union "9:01"

8.2 intersec and minus "5:35"

8.3 select query and order by "3:28"

Chapter 9 DML processing data (6 lectures)

Through the study of this course, we will master the classification of SQL sentences and the common use of DML.

9.1 the type of sql statement "7:44"

9.2 insert statement "10:15"

9.3 update "8:09"

9.4 delete and truncate "8:52"

Transaction Control: rollback,commit "21:12"

9.6 for update statement "5:01"

Chapter 10 creation and Management of tables (5 lectures)

Master the creation and management of the table through the study of this course.

10.1 Overview of database objects and syntax for creating common object tables "12:27"

10.2 Overview of data types and constraints 8:55

10.3 definition of constraint "25:53"

10.4 create table "3:05" with subquery

Modify the properties of the table and delete the table "7:02"

Chapter 11 creating other Program objects (6 lectures)

Master the creation and management of views, sequences, indexes and synonyms through the learning of this course.

11.1 Overview of views and simple and complex view creation, modification and data dictionary query "13:49"

11.2 with check option and read only "6:33" on the view

11.3 Overview of sequences and creation of sequences, queries, deletion of "8:28"

11.4 using sequence (nextval,currval), modify sequence "9:18"

Create index, delete index and query index "13:57"

11.6 creation, deletion and query of synonyms "13:45"

Chapter 12 controlling user access (7 lectures)

Master the creation of users and rights management through the study of this course

Overview of permissions "6:15"

12.2 create user "6:25"

12.3 system permissions "9:19"

12.4 object permissions "17:02"

12.5 role permissions "12:39"

12.6 change the user password "5:15"

12.7 revoke the object permission "14:47"

Chapter 13 Managing user objects (lecture 11)

Master the management of tables, indexes and other objects through the learning of this course.

13.1 alter table changes the table structure "6:17"

13.2Adding and removing constraints "9:51"

13.3 delay constraint "4:45"

13.4 enable and disable constraint "10:11"

13.5 column and constraint name of renamed table "5:25"

13.6 Overview of index creation "3:48"

Create the b-tree index by hand and view the index "4:37"

13.8 functional index "5:43"

Delete index "2:27"

13.10 flashback drop "7:06" with flashback table

13.11 temporary watch "4:53"

Chapter 14 Management object and data Dictionary View (8 lectures)

Learn how to manage user objects by using common data dictionary views through this course

Introduction and use of the data dictionary "7:24"

14.2 user_objects and all_objects "5:29"

14.3 the use of commonly used data dictionaries "8:45"

14.4 View the view's information "3:13" from the data dictionary

14.5 View the sequence information "7:01" through the data dictionary

14.6 View the index information "5:50" through the data dictionary

14.7 View the information of the same noun "6:06" in the data word

14.8 add a comment "5:00" to the table

Chapter 15 manipulating large datasets (lecture 7)

Master the processing of a large amount of data through the study of this course

15.1 use subqueries to process data "16:40"

15.2 use the default value "7:24" in insert and Update

Use insert to copy the data "4:57" in another table

Unconditional insert "7:47" for multi-watch insert

Conditional Insert for multi-table insert "4:05"

Conditional insert first for multi-table Insert "8:33"

15.7 rotation of multi-watch Insert Insert "5:22"

Chapter 16 manages data in different time zones (7 lectures)

Master management data in different time zones through the study of this course

16.1 set the time zone "5:24"

Query the time zone and date of the comparison session "6:33"

16.3 timestamp data type "8:47"

16.4 interval data type "6:25"

16.5 the extract and tz_offset functions "4:28"

16.6 the from_z and to_timestamp functions "3:48"

16.7 the to_yminterval and to_dsinterval functions "4:10"

Chapter 17 using subqueries to retrieve data (6 lectures)

Through the study of this course, master the use of sub-query to retrieve data.

17.1 pairwise and unpaired comparison of multi-column subqueries "10:04"

Standard quantum query "9:16"

17.3 related subquery "5:58"

17.4 exists and not exists "4:41"

Related Update and related delete "6:08"

17.6 with clause "6:00"

Chapter 18 regular expressions (4 lectures)

Through the study of this course, I have mastered the use of regular expressions to process data.

18.1 regular expression and metacharacter "3:53"

Regular expression function Grammar and REGEXP_LIKE "3:19"

18.3 REGEXP_REPLACE and REGEXP_INSTR and REGEXP_SUBSTR "10:37"

18.4 REGEXP_COUNT and citation constraint "4:18"

Video link: https://www.modb.pro/course/3?yll

Add me VX (ID:modb666) and send "SQL basic course" to show you how to get the above 109th videos for free.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.