We use the SQL language to query data from database tables that are used to store our records in a structured way based on rows and columns. In this video, get a brief overview of what database tables are and their structure.
- [Instructor] A table in the Oracle Database…is the most fundamental logical unit of storage.…We create tables to store data in our database.…Each table has a name which is specified…during the creation of the tables.…Such as an employee's table,…a department's table,…a job's table, and so on.…And each table is made up of one or more columns,…which are also specified during table creation.…
So for example,…an employee's table might have three columns.…An ID column,…which will contain the employee ID number.…A name column,…which will contain the employee name.…And the salary column,…which will contain the employee salary.…Of course we can create table with more or less…columns as needed.…In addition to columns, tables contain rows.…Which is the actual data that is inserted into our table.…So our employee's table might…have a single row with a value of 1,000 for ID,…Kirk for name,…and 999,999,999 for the salary.…
So essentially we now have one record or row,…in our employee's table.…And of course the table can contain more than a single row.…
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
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Oracle 12c Database: Administrationwith David Yahalom3h 58m 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.