$ 49.00   USD
  • Course Code:  OS01

  • Term:  Summer 2015

  • Open for Enrollment

  • Self-paced

  • Course Author(s)
    Mr. Dheeraj Vaidya
Original Price:   $ 49.00   USD
Oracle sql

Oracle SQL - Introduction to Oracle SQL

Summer 2015

Development - Programming Language

  • Main file logo new
    edu CBA
    Instructor
  • Edu
    edu CBA
    Instructor

Course Summary

 

Oracle SQL - Introduction to Oracle SQL

 

 

In this course, you will learn how to write SQL queries to access data stored in an Oracle Database schema. This SQL training course teaches you how to use SQL to manage data that is held in databases. This training course is designed for beginners who have no previous experience with SQL of any kind. Learn to manipulate data and use various types of functions for customizing data output. You will learn essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Learn to use single row functions to customize output, use conversion functions and conditional expressions.

 

It uses video lectures, covering database topics such as:

 Basic terminology

 Reading data using a SELECT statement

 What can be done using a SELECT statement

  Functions

  Data types

  Joins, set operators, subqueries

  Inserting, updating and deleting data

  Creating tables

 

You can go from absolute beginner to capable of writing SQL statements in a matter of hours. You will start by learning how to use SQL to select and filter data from a database, including sorting the data, filtering date columns, and working with null or empty values. The course then teaches you about common SQL functions, such as text manipulation, and how to group and summarize. This video tutorial also covers topics such as joining tables, data modification, and creating new tables and views. Finally, you will learn about the powerful subquery, and the main variances in SQL between database types. Once you have completed this computer based training course, you will have a fundamental knowledge of what SQL is and how you can apply it to different database types. Working files are included, allowing you to follow along with the author throughout the lessons. This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. This course will teach you the basics of the SQL language on an Oracle database.

 

 

What are the requirements?

This training course is designed for beginners who have no previous experience with SQL of any kind

 A computer with Internet

 No basic knowledge is required

 

 

What am I going to get from this course?

 In this course, you will learn how to write SQL queries to access data stored in an Oracle Database schema

 Learn to manipulate data and use various types of functions for customizing data output

 Learn to use single row functions to customize output, use conversion functions and conditional expressions.

 You can go from absolute beginner to capable of writing SQL statements in a matter of hours.

 The course then teaches you about common SQL functions, such as text manipulation, and how to group and summarize

 You will learn essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects

 

 

What is the target audience?

 Beginners

 Developers

 Students

 IT Professionals

 Oracle users

 

 

Instructor Biography

 

Instructor Biography

 

Mr. Dheeraj V. (CFA, FRM, IIML, IITD)

Dheeraj, a financial wizard with a relentless pursuit of knowledge and financial acumen, is one of the most sought after individuals in the training circles. He was associated with J.P Morgan Chase Equity Research Group as an analyst and later moved to CLSA India (Asia’s #1 Broking Firm) in the field of Equity Research and Investment Banking domain.

 

His performance and contribution was exemplary and widely appreciated. A financial wizard, a thorough professional to the core,a man filled with entrepreneurial drive and vision. His relentless pursuit of knowledge and financial acumen has made him the most sought after individual not only in the business sphere, but also in the training circles.

 

Dheeraj has done his MBA from IIM Lucknow and B.Tech in Mechanical Engineering from IIT Delhi. Additionally, Dheeraj has cleared CFA Level III. Also, he is a Certified Financial Risk Manager (FRM). His unflinching desire to make a mark in business drove him towards entrepreneurship.

 

Website: - edu CBA

Course Page – accounting training basic

Be a part of the learning community onFacebook orTwitter

You may also find awesome resources at our accounting blog

×
One Last Thing!

Check your email inbox and click on the email verification link we just sent you.

If it doesn’t reach your inbox in a few moments, it might be in your spam folder. Don’t forget to add our email address to your contacts if it did end up in spam! That’ll make sure it doesn’t happen again.

As soon as you’ve verified your email, you’ll be able to continue.


Continue

×

Confirm Payment

Payment Unavailable. Try again later.

Oracle SQL - Introduction to Oracle SQL

49.0 USD


Credit Card
PayPal