About the Course

This is a extensive class on learning Oracle 11g SQL. I have 15+ years of experience in the IT industry and have been teaching SQL in Engineering colleges.

My students have cleared the SQL exam as part of Oracle OCA and are very confident in writing SQL.

You will be learning from the basics and get the confidence of writing own SQL commands. SQL being mandatory for students and beginners in the IT industry, it is not only needed for developers, but also a must for testers, analysts etc.

I will also discuss /share some oracle dump questions

Topics Covered

Retrieving Data Using the SQL SELECT Statement List the capabilities of SQL SELECT statements Execute a basic SELECT statement Limit the rows that are retrieved by a query Sort the rows that are retrieved by a query

Using Single-Row Functions to Customize Output

Describe various types of functions available in SQL Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

Describe various types of conversion functions that are available in SQL Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Reporting Aggregated Data Using the Group Functions

Identify the available group functions Describe the use of group functions Group data by using the GROUP BY clause Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables

Write SELECT statements to access data from more than one table using equijoins and nonequijoins Join a table to itself by using a self-join View data that generally does not meet a join condition by using outer joins Generate a Cartesian product of all rows from two or more tables

Describe set operators Use a set operator to combine multiple queries into a single query Control the order of rows returned Manipulating Data

Describe each data manipulation language (DML) statement Insert rows into a table Update rows in a table Delete rows from a table Control transactions Using DDL Statements to Create and Manage Tables

Categorize the main database objects Review the table structure List the data types that are available for columns Create a simple table Explain how constraints are created at the time of table creation

About the Trainer

I have 15+ years experience and currently teaching school/college students on various subjects

Some school students feel mathematics as one of the dreaded subjects. I am teaching concepts of mathematics to create an interest on the subject. I teach and explain maths through fun ways and games. This not only creates interest, but also helps them build a stronger base on the subject.

I teach "Learning Tables the fun way" for kids in Class 1. This program has sparked a good interest among parents as tables is base foundation for maths

I am teaching Vedic mathematics for the past 7 years and trained more than 400 students. Currently I am conducting classes at home and in schools.

The courses I take are For School students Vedic maths training Concepts of Mathematics Concepts of Algebra Learning Tables the fun way

For College Students

SQL training for beginners in the software industry SQL/PL SQL classes for College students BE tution for Compiler Design Data Structures Database Management system

For Parents/Trainer Remove the fear of Maths in your Child Vedic maths trainer program

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you.Read more