Oracle SQL For Data Analysis : Truly From Basics to Advanced

Oracle SQL For Data Analysis : Truly From Basics to Advanced, available at $54.99, has an average rating of 4.65, with 56 lectures, based on 317 reviews, and has 16800 subscribers.

You will learn about SQL over Oracle 19 C version on Oracle LiveSQL platform A to Z in SQL on Oracle's latest version Go from an absolute beginner to an advanced SQL developer in less than 15 hours RDBMS fundamentals and explanation on various terminologies for interview preparation This is a complete course which does not require the students to have local installation of Oracle yet they we use the latest version of Oracle from web Structure of basic query statement – Projection, Predicate and Verb Use of Logical Operators – AND, OR, IN, BETWEEN, NOT, DISTINCT, LIKE Various important properties of ORDER BY clause with examples Deal with NULL values – IS NULL, NVL, NVL2, COALESCE All forms of Sub-queries / Nested Queries – Multi-valued, Returning NULL, Set Comparison, Correlated, EXISTS operator, ANY & ALL operators All forms of JOIN operations – Inner, Equijoin, Natural, Non-equijoin, Selfjoin, Outer Join operator, OUTER JOIN clause GROUP BY clause concept – Group Functions MAX, MIN, SUM, AVG, COUNT – Group function tricky queries Analytical / Aggregate form of Function – ROLLUP, CUBE, RANK, DENSE_RANK, DECODE vs CASE SQL General Functions – Conversion, Numeric, String, Date functions – Query examples Database Transaction Concepts – DML statements and forms – Rows Locking FOR UPDATE NOWAIT clause – Transaction Consistent Read SET TRANSACTION READ ONLY SQL commands DELETE vs TRUNCATE – Difference and similarities CREATE TABLE from scratch and copy from existing table – ALTER TABLE – Add/drop columns – Change column datatypes/widths and limitations – RENAME columns/Table Constraint Metadata – Enable / Disable Constraint – Data Validation Data Integrity Concepts – Data Integrity Constraints – Column / Table level constraint definitions – Referential Integrity through FOREIGN KEY constraint IMMEDIATE vs DEFERRED constraints – Transaction level constraint validation. This course is ideal for individuals who are Students interested in database back end programming or Programmers in any other front end language like Java or PHP or Python etc, must learn SQL or Engineering students, Computer Science students, Science / Commerce students – All pursuing UG or PG or completed with degree or Management people who are required to draw ad-hoc data as per requirement It is particularly useful for Students interested in database back end programming or Programmers in any other front end language like Java or PHP or Python etc, must learn SQL or Engineering students, Computer Science students, Science / Commerce students – All pursuing UG or PG or completed with degree or Management people who are required to draw ad-hoc data as per requirement.

Enroll now: Oracle SQL For Data Analysis : Truly From Basics to Advanced

Summary

Title: Oracle SQL For Data Analysis : Truly From Basics to Advanced

Price: $54.99

Average Rating: 4.65

Number of Lectures: 56

Number of Published Lectures: 56

Number of Curriculum Items: 57

Number of Published Curriculum Objects: 57

Original Price: ₹7,900

Quality Status: approved

Status: Live

What You Will Learn

• SQL over Oracle 19 C version on Oracle LiveSQL platform
• A to Z in SQL on Oracle's latest version
• Go from an absolute beginner to an advanced SQL developer in less than 15 hours
• RDBMS fundamentals and explanation on various terminologies for interview preparation
• This is a complete course which does not require the students to have local installation of Oracle yet they we use the latest version of Oracle from web
• Structure of basic query statement – Projection, Predicate and Verb
• Use of Logical Operators – AND, OR, IN, BETWEEN, NOT, DISTINCT, LIKE
• Various important properties of ORDER BY clause with examples
• Deal with NULL values – IS NULL, NVL, NVL2, COALESCE
• All forms of Sub-queries / Nested Queries – Multi-valued, Returning NULL, Set Comparison, Correlated, EXISTS operator, ANY & ALL operators
• All forms of JOIN operations – Inner, Equijoin, Natural, Non-equijoin, Selfjoin, Outer Join operator, OUTER JOIN clause
• GROUP BY clause concept – Group Functions MAX, MIN, SUM, AVG, COUNT – Group function tricky queries
• Analytical / Aggregate form of Function – ROLLUP, CUBE, RANK, DENSE_RANK, DECODE vs CASE
• SQL General Functions – Conversion, Numeric, String, Date functions – Query examples
• Database Transaction Concepts – DML statements and forms – Rows Locking FOR UPDATE NOWAIT clause – Transaction Consistent Read SET TRANSACTION READ ONLY
• SQL commands DELETE vs TRUNCATE – Difference and similarities
• CREATE TABLE from scratch and copy from existing table – ALTER TABLE – Add/drop columns – Change column datatypes/widths and limitations – RENAME columns/Table
• Constraint Metadata – Enable / Disable Constraint – Data Validation
• Data Integrity Concepts – Data Integrity Constraints – Column / Table level constraint definitions – Referential Integrity through FOREIGN KEY constraint
• IMMEDIATE vs DEFERRED constraints – Transaction level constraint validation.

Who Should Attend

• Students interested in database back end programming
• Programmers in any other front end language like Java or PHP or Python etc, must learn SQL
• Engineering students, Computer Science students, Science / Commerce students – All pursuing UG or PG or completed with degree
• Management people who are required to draw ad-hoc data as per requirement

Target Audiences

• Students interested in database back end programming
• Programmers in any other front end language like Java or PHP or Python etc, must learn SQL
• Engineering students, Computer Science students, Science / Commerce students – All pursuing UG or PG or completed with degree
• Management people who are required to draw ad-hoc data as per requirement