TNCS COMPUTER EDUCATION Pvt. Ltd.,

BASIC INFORMATION

Course Fees : 4500.00 4500.00/-
Course Duration : 3
Minimum Amount To Pay : Rs.1500.00

Admission Now

Course content

Topics covered in the Complete Oracle SQL Certification Course:

Database Basics

· Oracle Database Introduction & Basics of Tables

· Creating the Workspace in Oracle

· Prepare the Sample Data

Single Table Queries

· Oracle Exams and Certification Information

· Retrieving Data Using the SELECT Clause

· Using the WHERE Clause in a Query

· Important Information from Instructor

· Using Operators in the WHERE Clause

· Combining WHERE, AND & OR with Operators

· Query Filtering Continued BETWEEN, IN and NULL

· Query Filtering Conditions & Operator Precedence

· Ordering, Concatenating And Aliasing Query Results

· Assignment 1: Practice with Single Table Queries

Single Row Functions

· Single Row Functions (SRF) & Using The Dual Table

· Using Functions in WHERE And Character Based SRFs

· Numeric and Date Data type SRFs

· Conversion SRFs and Date Formatting

· Some More Date Functions

· Concluding SRFs & NULL / NULLIF Functions

· Assignment 2: Practice with Single Row Functions

Grouping Functions

· Grouping Functions MIN, MAX, AVG, COUNT etc.

· GROUP BY Clause & HAVING Clause

· More Practice With The GROUP BY Clause

Multi-Table Queries and Joins

· SELECT within SELECT (Subqueries)

· Relating Tables Together Using JOINs

· Joins Continued INNER & OUTER Joins

· Correlated Subqueries with EXISTS & NOT EXIST operators

· SELF JOIN

· CROSS JOIN, NATURAL JOIN and the USING CLAUSE

· EQUIJOIN and NON-EQUIJOINs

· CASE Statements

Analytical Functions using OVER and PARTITION with ORDER BY

· OVER Clause with PARTITION BY

· Compute Running Totals with Ordering and Partitioning

· Unbounded Preceding Order in Over Clause

· Slicing Windows and Filtering with Analytic Functions

· Rank, Dense_rank, Lead, and Lag Functions

· Assignment: Application of Window Functions and SELF JOIN

Creating, Altering, and Updating Objects Using SQL

· Creating Your Own Tables & Design Considerations

· Inserting Data Into Our Table

· Create Table With a Primary Key Constraint

· INSERT ALL for Multi-table & Conditional Inserts

· Using ALTER to modify the table structure

· Create Table with SELECT + UPDATE Data

· MERGE Statement in Oracle

· Primary and Foreign Keys

· Sequence Statements in Oracle

· DELETE, TRUNCATE, and DROP Commands

· Working With Database Indexes

· System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)

· Views and Other Objects and Commands (Newly Added)

· SQL could be tricky, check this out!

· Granting and Revoking Privileges

ADDITIONAL TOPICS + REVIEW for EXAM 170-071

· OFFSET and FETCH

· ERD Diagrams

· Commit, Rollback, and Savepoint

· Large Objects and Interval Data Types

· Using Cascade Constraints and On Delete Cascade

· UNUSED Columns

· External Tables

· SQL Plus and Substitution Variables

Exam Question Walkthrough Videos + 2 Exams

· QA 1- DML, DDL, and Transaction Control

· QA 2- Fetch and Substitution Variables

· QA 3 - Conversion Functions, TO_CHAR, NVL, and TO_DATE

· Practice Test 1 - 20 questions

· Practice Test 2 - 25 questions

APPENDIX - Installing Oracle on Windows2 lectures • 23min

· Install Oracle Database 19c in Windows

· Install Oracle SQL Developer in Windows

Inspiration

· What Will Make you Grow as a Software Developer

· Student Success Stories

· Career Advice

12th

OTHER COURSES

CERTIFICATE IN COMPUTER APPLICATION ( C0641 )

Course Fees : 3600.00/- 4000.00/-
Minimum Amount To Pay : Rs.1000.00

Course Code : C0641

CERTIFICATE IN OFFICE AUTOMATION ( C0642 )

Course Fees : 3750.00/- 5000.00/-
Minimum Amount To Pay : Rs.1000.00

Course Code : C0642

DIPLOMA IN OFFICE AUTOMATION ( D0665 )

Course Fees : 5850.00/- 6500.00/-
Minimum Amount To Pay : Rs.1500.00

Course Code : D0665

DIPLOMA IN FINANCIAL ACCOUNTING ( D0250 )

Course Fees : 8100.00/- 9000.00/-
Minimum Amount To Pay : Rs.1500.00

Course Code : D0250

DIPLOMA IN COMPUTER APPLICATION ( D0690 )

Course Fees : 5400.00/- 6000.00/-
Minimum Amount To Pay : Rs.1500.00

Course Code : D0690

DIPLOMA IN COMPUTER APPLICATION ( D0663 )

Course Fees : 7200.00/- 8000.00/-
Minimum Amount To Pay : Rs.2500.00

Course Code : D0663

DIPLOMA IN COMPUTER APPLICATION ( D0662 )

Course Fees : 5400.00/- 6000.00/-
Minimum Amount To Pay : Rs.1500.00

Course Code : D0662

DIPLOMA IN DESKTOP PUBLICATION ( D0351 )

Course Fees : 5850.00/- 6500.00/-
Minimum Amount To Pay : Rs.1500.00

Course Code : D0351

DIPLOMA IN COMPUTER PROGRAMMING ( D0550 )

Course Fees : 10800.00/- 12000.00/-
Minimum Amount To Pay : Rs.2500.00

Course Code : D0550

DIPLOMA IN COMPUTER AIDED DESIGNING ( D0751 )

Course Fees : 6300.00/- 7000.00/-
Minimum Amount To Pay : Rs.1500.00

Course Code : D0751

ADVANCED DIPLOMA IN FINANCIAL ACCOUNTING ( D0260 )

Course Fees : 10800.00/- 12000.00/-
Minimum Amount To Pay : Rs.2500.00

Course Code : D0260

P.G DIPLOMA IN COMPUTER APPLICATION ( D0650 )

Course Fees : 12600.00/- 14000.00/-
Minimum Amount To Pay : Rs.2500.00

Course Code : D0650

DIPLOMA IN COMPUTER TEACHER TRAINNING ( D0655 )

Course Fees : 12600.00/- 14000.00/-
Minimum Amount To Pay : Rs.2500.00

Course Code : D0655

DIPLOMA IN COMPUTER CODEING ( D0561 )

Course Fees : 14400.00/- 16000.00/-
Minimum Amount To Pay : Rs.2500.00

Course Code : D0561