Udemy - Oracle SQL From Beginning to Advance Level (2025)

[Courses2024 0]

Free Download Udemy - Oracle SQL From Beginning to Advance Level (2025)
Published 4/2025
Created by Rajeev Agarwal
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 32 Lectures ( 23h 35m ) | Size: 17.8 GB

Oracle SQL Step-By-Step from Database 21C From Beginning to Advance Level
What you'll learn
Install and learn about Oracle database 21C
Oracle SQL Step by Step from beginning to advanced level by an experienced IT professional, certified in Oracle-SQL, PL/SQL, Oracle Forms and OBIEE
Will cover Data Types, DQL, DDL, DML, TCL, DCL, SQL Operators, Joins and Functions (String, Numeric, Date, Conversion, Aggregate and Analytical)
Will cover Sub-Queries, Set Operators, Data Dictionary, Index, Sequence, Views, Materialized Views, Synonyms, Constraints, Pivot and Hierarchical queries
Students will be able to write own Oracle SQL queries and understand others SQL queries on projects
Provided several queries on every topic.
Will provide lifetime support of my videos and always available to support via email
Will be able to confidently face the interviews on Oracle SQL queries
Will appear well-versed on the Oracle SQL (1Z0-071) certification exam.
Requirements
We will learn Oracle database 21C SQL Queries. No prior knowledge on Oracle OR programming knowledge is required. Your computer should have at least 2GB RAM and 10GB of space on the hard drive.
Description
Introduction of Oracle DatabaseWhat is a DatabaseIntroduction Oracle DatabaseHistory of Oracle DatabaseInstallation of Oracle DatabaseDownloading and Installation of and 21C Oracle DatabaseDownloading and setup of SQL Developer-23Logging on to the Oracle Database using SQL*Plus and introduction of SQL Developer (tool to develop of SQL statements)Setup the Test / work environmentIntroduction of SQL and Creating Tables in Oracle DatabaseIntroduction to SQLTypes the types of SQL statements - DQL, DML, DDL, DCL and TCLData types in Oracle databaseRetrieving data using SELECT statement i.e. displaying data from a table for all Columns and Specific ColumnsIntroduction of dummy tableTypes of Operators in Oracle database - Arithmetic, Relational, Logical, Special OperatorsDDL commandsIntroduction to DDL commands in Oracle databaseCreating Tables in Oracle Database using CREATE statementDisplaying the table structure (DESCRIBE) in command SQL*Plus and in SQL DeveloperAltering / modifying table i.e. adding a new column in the tableModifying the column data type in the tableRenaming and deleting the column of the tableRenaming the tableDropping the table using DROP commandRecyclebin and Flashback to recover dropped tableDML statements (Data retrieving)Introduction to DML statements in Oracle databaseInserting data in the tableUpdating the data using UPDATE in the table - updating records in certain criteria or updating the whole tableDeleting the data using DELETE in the table - single record or deleting whole table dataMerge commandDifference in Delete and truncate statementsSQL OperatorsWhat is Dual table?What is SQL Operator?Arithmetic OperatorsComparison Operators / Relational OperatorsLogical Operator - AND, OR etc.What is NULL?Special Operator - IN / NOT IN, BETWEEN / NOT BETWEEN, IS NULL / IS NOT NULL, LIKE / NOT LIKE, ANY / ALLIntroduction of Joins i.e. retrieving data from multiple tablesTable alias and column aliasIntroduction of joinsOracle 8i joins - Equi or Inner, Non-Equi, Self, Outer JoinsOracle 9i / ANSI joinso Inner joino Left Outer joino Right Outer joino Full outer joino Natural joino Cross joinIntroduction of Built-in FunctionsIntroduction of FunctionsTypes of single row functionso String functionso Numeric functionso Date functionsConversion functionso Convert date type string to Date valueo Convert number type to character / string typeo Convert date type to character / string typeAggregate Functions (Multiple Rows Functions) in SQLDISTINCT keyword in SELECT statementIntroduction of Aggregate FunctionsTypes of Aggregate Functionso Count()o Maximum - MAX()o Minimum - MIN()o Average - AVG()o Sum()Introduction of Group By clauseIntroduction of Having clauseRollup, Cube and ListAgg FunctionsSub-QueriesROWNUMROWIDTypes of Sub-QueriesExists and Not Exists OperatorAnalytical FunctionsTypes of Analytical Functionso Rank(), Dense_Rank() and Row_number()o Lag() and Lead()o First_Value() and Last_Value()o Grouping() and Grouping_id()Set OperatorsTypes of Set operators - UNION, UNION ALL, INTERSECT, MINUSOracle Data Dictionary and other topicsIntroduction of Oracle Data DictionaryIntroduction of Index in Oracle DatabaseIntroduction of Sequence in Oracle DatabaseIntroduction of View in Oracle DatabaseIntroduction of Materialized View in Oracle DatabaseIntroduction of Synonym in Oracle DatabaseDecode and Case statementMerge statementVirtual ColumnPivotingHierarchical QuerySet System Variableso LINESIZEo NUMWIDTHo NUMFORMATo PAGESIZEo ECHO ON/OFFo FEEDBACK ON/OFFo HEADING ON/OFFo PAUSE ON / OFFo VERIFY ON / OFFo Date FormatConstraintsIntroduction of Constraints in Oracle Databaseo NOT NULLo DEFAULTo UNIQUEo CHECKo PRIMARY KEYo FOREIGN KEY (Referential Integrity)
Who this course is for
Anyone who is willing to get and work on Oracle SQL queries.
Homepage

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.

No Password - Links are Interchangeable