[Lynda] Oracle Database 12c: Basic SQL | Lynda Free Courses Online Download Torrent Video Tutorial

[Lynda] Oracle Database 12c: Basic SQL | Lynda Free Courses Online Download Torrent

are you looking for [Lynda] Oracle Database 12c: Basic SQL | Lynda Free Courses Online Download Torrent Free Download. if yes, then you can download [Lynda] Oracle Database 12c: Basic SQL | Lynda Free Courses Online Download Torrent Video Tutorial right away.

[Lynda] Oracle Database 12c: Basic SQL | Lynda Free Courses Online Download Torrent Free Download is available. so get [Lynda] Oracle Database 12c: Basic SQL | Lynda Free Courses Online Download Torrent Free Download

Author

image of author David YahalomDavid Yahalom

Released

1/17/2018

Mastering the SQL language is an essential skill for any Oracle professional and is the first step in becoming a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, Oracle instructor and consultant David Yahalom covers the basics required to code with SQL in an Oracle Database 12c environment. Learn how to select and filter data, and manipulate data using functions, including SUBSTR, UPPER, MIN, MAX, AVG, SUM, and more. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions. David also provides an overview of advanced concepts, such as constraints and subqueries.

Note: This training course is appropriate for beginning database developers with no prior experience with SQL or Oracle.

Topics include:

  • 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

Size: 404.36M


       


 

[Lynda] Oracle Database 12c: Basic SQL | Lynda Free Courses Online Download Torrent

Free Download [Lynda] Oracle Database 12c: Basic SQL | Lynda Free Courses Online Download Torrent Video Tutorial Course

Leave a Comment