Oracle SQL - A Complete Developer's Guide
4.5 /5- Offered byUDEMY
Oracle SQL - A Complete Developer's Guide at UDEMY Overview
Duration | 11 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
Oracle SQL - A Complete Developer's Guide at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 48 downloadable resource
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Oracle SQL - A Complete Developer's Guide at UDEMY Course details
- For Who wants to start a career as Database Developer
- For Developers preparing for Oracle SQL certification (1Z0-071)
- For ETL developers who wants to improve query writing skills
- Comprehensive course in SQL as per 100% Oracle University syllabus + Bonus 2 topics
- Learn SQL and get a job as Database Developer
- Well structured program to learn quickly learn and apply on projects from day 1
- Instructor is having real time IT experience in SQL 19 Years!!
- Course will help to clear Oracle SQL Certification (1Z0-071)
- 100+ 1Z0-071 certification questions
- Oracle holds 46% share in commercial market space. So learn SQL with the best Database- Oracle !
- Learn SQL using Oracle Platform and can apply on any RDBMS like MySQL, Sybase, MS SQL Server etc
- This course designed to learn Oracle SQL step by step and master it
- You can learn SQL and clear Oracle certification 1Z0-071 (OCA- Oracle Certified Associate), It will give boast to your career as a Pro-SQL Programmer
Oracle SQL - A Complete Developer's Guide at UDEMY Curriculum
Introduction
Introduction to RDBMS
Introduction to SQL
Relationship between a database and SQL
SQL Select Statement to Components of an ERD
Introduction to SQL
Environment Setup
Versions of Oracle, Live Oracle Cloud account creation, demo data setup
Oracle 11g- XE installation
Work is SQL*PLUS and SQL Developer
Basic SQL
Schema, Alias, Prefix, what is '*'
How to restrict data using WHERE clause, Data sorting by ORDER by Clause
Substitution variables - VERIFY, DEFINE , UNDEFINE
Row Limiting Clause for Top-N Queries - 12C
Operators
Unary and Binary Operators
Comparison Operator (=,<>,>,<,<=,>=, BETWEEN, NOT IN, IN ,IS NULL, IS NOT NULL)
Comparison Operator ( Wildcard Search LIKE, NOT LIKE)
Logical operators (NOT, AND , OR)
Arithmetic operators (+ Addition , - Minus , * Multiplication , / Division )
Arithmetic operators Precedence
Character operators (
)
Set operators ( UNION, UNION ALL, INTERSECT, INTERSECT ALL, MINUS )
Operators (1Z0-071)
Oracle Built in single row functions
Numeric Function (ABS, FLOOR, CEIL, MOD, POWER, SIGN, TRUNC_ROUND, WIDTH_BUCKET)
Character Function (CONCAT, REPLACE, SUBSTR, INSTR, UPPER, LOWER, LAPD, RPAD)
Date Functions (SYSDATE, LAST_DAY, ROUND, TRUNC, ADD_MONTHS, MONTHS_BETWEEN)
Conversion Function (TO_DATE, TO_CHAR, TO_TIMESTAMP, TO_NUMBER)
Nesting Functions
NULL Functions (NVL, NVL2, COALESCE, NULLIF)
Oracle Built-in Single row Functions (1Z0-071)
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?