New

Oracle : Oracle Database 11g SQL Fundamentals I

Oracle : Oracle Database 11g SQL Fundamentals I

Learn To:

  • Develop essential SQL skills that enable developers to write queries against single and multiple tables.
  • Manipulate data in tables.
  • Create database objects.
  • Use single row functions to customize output.
  • Work with group functions to report aggregated data.
  • Use conversion functions and conditional expressions.
  • Manipulate queries to return required data.
  • Perform calculations on data.
  • Administer database objects.

Objectives

  • To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting
  • To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return value
  • To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE
  • To recognize the steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries

Topics

  • Oracle Database 11g: Using SQL to Query Your Database
    • Using SQL in Oracle Database 11g
    • Retrieving, Restricting and Sorting Data
    • Using Single-Row Functions
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins
    • Conversion Functions and Conditional Expressions
    • Group Functions and Joins
  • Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
    • Using Subqueries and Set Operators
    • Manipulating Data
  • Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
    • Using DDL Statements to Create and Manage Tables
    • Creating Other Schema Objects

How to Enroll Oracle : Oracle Database 11g SQL Fundamentals I course?

  • To Access "Oracle : Oracle Database 11g SQL Fundamentals I" Click on Enroll Now button at end of the post. It will redirect you to Udemy Course Page and then you can start the enrollment process.
  • If you're New to Udemy? Sign up with your email and create a password. for Existing users, log in with your credentials to access course.
  • How many members can access this course with a coupon?

    Oracle : Oracle Database 11g SQL Fundamentals I Course coupon is limited to the first 1,000 enrollments. Click 'Enroll Now' to secure your spot and dive into this course on Udemy before it reaches its enrollment limits!

    External links may contain affiliate links, meaning we get a commission if you decide to make a purchase
    Deal Score0

    Learn Data Science. Courses starting at $12.99

    New customer offer! Top courses from $14.99 when you first visit Udemy

    eLearn
    Compare items
    • Total (0)
    Compare
    0