SQL is the language used to query the Oracle database. It is the API for data retrieval and modification. In this video, explore the SQL language and understand its primary function in an Oracle environment.
- [Narrator] So let's start by talking about what is SQL. So, SQL, which is short for Structured Query Language, although some places call it Server Query Language, is the programing language which you use to access data stored in your Oracle Database. SQL, as a data retrieval language, is an industry standard. And, all relational database products, not only Oracle, implement SQL as the mechanism, the language, the syntax you use to retrieve data from your database server.
In practice, it means that using the SQL language, you write queries, which we'll see a lot of throughout this course, and these queries instruct the Oracle Database what is the data that the user wants to see. The data returns from the Oracle Database, via your SQL query, will be in tabular format. So, essentially, using the SQL language you control what data you want to see from all of the data that is stored in your database.
Using SQL you can choose to see some of the data, maybe select data from specific tables only, maybe add filtering to the data, maybe manipulate the data. You can do all of that using the SQL language. So, think of SQL as the API, or Application Programming Interface, the primary language which you use to interact with your Oracle Database. The SQL language allows you to: One, run queries on your Oracle Database and choose what data you want to see.
Two, modify data that is on your database. Such as, insert new data, update or delete existing data. And, three, the SQL language allows you to modify objects in the database. That is create new tables. Or, modify the structure of existing tables, such as adding columns to tables or deleting columns from tables. You can do all of that using the SQL language and we see all of that in action throughout our course with hands on demos.
Note: This training course is appropriate for beginning database developers with no prior experience with SQL or Oracle.
- Using Oracle SQL*Developer, the free development environment
- Selecting data from tables
- Filtering data
- Using functions to manipulate data
- Joining data from tables
- Creating tables
- Updating values
- Truncating data
- Grouping and ordering result sets
- Working with primary keys
- Checking constraints
Skill Level Beginner
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
1. Introduction to SQL
2. Preparing the Course Environment
Downloading the course VM2m 16s
3. Using Oracle SQL Developer
4. Basic SELECT Queries
5. String, Number, and Date Functions
6. Joining Table Data
7. Manipulating Data
8. Grouping Data
9. Advanced Topics
Next steps1m 33s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.