From the course: Oracle Database 12c: Basic SQL
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Next steps - Oracle Database Tutorial
From the course: Oracle Database 12c: Basic SQL
Next steps
- [David] Congratulations on finishing the Oracle 12c: Basic SQL course. Now that you have successfully completed the course, I am sure you feel more confident in your proficiency of the SQL language and you're in a very good place to continue your learning path of the Oracle database. Continue practicing the SQL language in your own Oracle environments. Write SQL queries, use SQL functions, create tables, add columns, and insert and modify data. The more you practice, the better you will get in writing SQL. Remember, there is also a ton of Oracle SQL tutorials available online, which can help you master the more complex aspects of the SQL language in the Oracle database. In case you have any questions about any of the SQL commands or syntax we learned in our course and would like to get some assistance from fellow Oracle users, my personal favorite website is Oracle's own online community. Simply go to community.oracle.com to gain access to the largest group or Oracle professionals…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
Introduction to Oracle SQL Developer1m 45s
-
(Locked)
Creating a connection to the database4m 53s
-
(Locked)
Managing existing connections50s
-
(Locked)
Exploring database objects1m 29s
-
(Locked)
Filtering specific objects1m 25s
-
(Locked)
Using SQL Developer tabs2m 18s
-
(Locked)
Viewing query output1m 18s
-
(Locked)
Case sensitivity of SQL commands1m 24s
-
(Locked)
Viewing SQL execution history55s
-
(Locked)
Query output as grid or script46s
-
-
-
Writing your first SELECT query1m 56s
-
(Locked)
Selecting only specific columns2m 22s
-
(Locked)
Using WHERE to filter specific rows1m 55s
-
(Locked)
Using multiple WHERE conditions3m 55s
-
(Locked)
Using WHERE to filter partial strings3m 12s
-
(Locked)
Using WHERE to filter numeric ranges1m 17s
-
(Locked)
Using WHERE IN and NOT IN for strings1m 54s
-
(Locked)
Using WHERE IN and NOT IN for numbers1m 35s
-
(Locked)
Using WHERE to filter dates2m 42s
-
(Locked)
Using WHERE to filter exact strings1m 55s
-
(Locked)
Using DISTINCT to eliminate duplicates4m
-
(Locked)
Performing basic numeric calculations2m 23s
-
(Locked)
Using column aliases2m 18s
-
(Locked)
Describe the structure of a table3m 16s
-
(Locked)
Using ORDER BY3m 29s
-
-
-
Introduction to functions1m 39s
-
(Locked)
Using SUBSTRING, LENGTH, and CONCAT2m 50s
-
(Locked)
Using LENGTH1m 4s
-
(Locked)
Using CONCAT4m 48s
-
(Locked)
Using LOWER and UPPER2m 44s
-
(Locked)
Using INSTR4m 32s
-
(Locked)
Using RPAD and LPAD3m 31s
-
(Locked)
Using TO_CHAR to convert numbers1m 34s
-
(Locked)
Using TO_CHAR to format DATE values2m 59s
-
(Locked)
Using TO_CHAR to filter DATE values1m 57s
-
(Locked)
The special Oracle DUAL table1m 18s
-
(Locked)
Using ROUND1m 15s
-
(Locked)
Using TRUNC1m 36s
-
(Locked)
Using SYSDATE1m 59s
-
(Locked)
Using SYSTIMESTAMP1m 37s
-
(Locked)
Using MONTHS_BETWEEN3m 2s
-
(Locked)
Using ADD_MONTHS1m 17s
-
-
-
Introduction to DML and DDL commands2m 7s
-
(Locked)
Creating a simple table2m 1s
-
(Locked)
Inserting a new row to a table3m 15s
-
(Locked)
COMMIT and ROLLBACK2m 23s
-
(Locked)
Introduction to transactions3m 43s
-
(Locked)
Deleting rows for a table3m 23s
-
(Locked)
Updating values2m 40s
-
(Locked)
Multiple-statement transactions2m 41s
-
(Locked)
Truncating all data from a table2m 29s
-
(Locked)
Adding and dropping columns from a table3m 4s
-