YoVDO

The Complete Oracle SQL Bootcamp (2024)

Offered By: Udemy

Tags

Oracle Courses Database Management Courses Oracle SQL Courses

Course Description

Overview

Become an In-demand SQL Professional! Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!

What you'll learn:
  • Pass Oracle 1Z0-071 SQL Database SQL Certification Exam easily on your first try!
  • Be Able to Answer any SQL Interview Questions Confidently!
  • Become a Job-Ready SQL Developer by Learning All the Skills You will Need!
  • Learn Oracle SQL by Professionally Designed Content Step by Step!
  • Write, Read and Analyze Any SQL Queries Easily and Learn How to Play with Data!
  • Solve any SQL-related Problems by Yourself Creating Analytical Solutions!
  • Test Your SQL Skills with Hundreds of Hands-on Examples, Quizzes, Challenges!
  • Lifetime Support from the Instructors. Get a Well-Organized Recap Document!

Welcome to the MOSTCOMPREHENSIVEOracle SQLBootcamp Course on the planet!

Latest Course Updates:

  • (Aug 2024) : Brand New Content (Managing Oracle Privileges and Roles) was added!

  • (Jun 2024) : Brand New Content (Using Oracle FLASHBACKTechnologies) was added!

  • (Apr 2024) : 3-Real SQL(Over 200+ High-Quality Questions) Certification Exam Samples are added!

  • (Jan 2024) : More Quiz Questions were added!

Important Notice:This course will be continuously getting updated with more lectures, quizzes, and assessments to enhance your knowledge of Oracle SQL.

Are you a student ready to learn SQL for your lessons?

Do you want to get a better job?

Are you bored with watching a lot of stuff, but could not learn anything?

Do you think you know SQL, but you cannot write SQL codes?

Are you looking for a really professional course?

Then this is the course you are looking for.

You are in the right place!

In this course, all the subjects are explained in professional order.

If you are new to SQL, no problem! You can easily learn all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects.

After completing this course, you will learn all that you need to know. If you don't see something in this course, it means you really don't need to know it for now.

Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.

So come on, what are you waiting for?

Get this course, and go get a better job!


Topics covered in the Complete Oracle SQLBootcamp 2023 Course:

  • Database Concepts & Terminologies

    • What is a Database?

    • What is the Oracle Database?

    • What is a pluggable database?

    • What is SQL?

    • What is a database table?

    • What is Relational-Database Management System (RDBMS)?

    • What is the Entity-relationship model inSQL?

    • What is a database schema?

    • Installing Oracle Sample Schemas (HR, SH, OE,IX, etc.)

    • Introduction to Database Objects

  • Downloading and Installing the Oracle Database (Version 12c, 18c, 19c, 21c, etc.)

    • Downloading the Oracle Database Installation File

    • Installing Oracle Database into Your Local Computer

  • Working with a Database via a Virtual Machine

    • Downloading and Installing a Virtualization Software (VirtualBox, VMWare)

    • Downloading Pre-built Virtual Machine Image

    • Importing Virtual Machine into Virtualization Software

    • Configuring, Using, and Working with Virtual Machines through Virtualization Software

  • Downloading, Installing,Configuring, and Using the Oracle SQLDeveloper Software

  • Connecting to the Oracle Database Using SQL Developer and SQL Plus

    • Configuring SQLDeveloper for the first use

    • Configuring Network Connections to work with Oracle Sample Schemas

  • Working with Oracle Live SQL

    • Introduction to Oracle Live SQLPlatform

    • How to use Oracle Live SQL

  • Retrieving Data from the Database Using SELECTStatements

    • What is NULL?

    • SELECTStatements

    • Using Column Aliases in SQL

    • DISTINCTand UNIQUEOperators in SQL

    • Concatenation Operators in SQL

    • The Quote (q) Operator in SQL

  • Filtering & Restricting Data returned by SQLQueries using the WHEREClause

    • Using the WHEREClause in SQL

    • Using Oracle Comparison Operators in SQL

    • BETWEENANDOperator inSQL

    • INOperator in SQL

    • LIKEOperator in SQL

    • ISNULLOperator in SQL

    • Logical Operators in SQL:

      • ANDLogical Operator

      • ORLogical Operator

      • NOTLogical Operator

    • Oracle Rules of Precedence in SQL

  • Sorting Data using the ORDERBYClause

    • Using the ORDERBYClause

    • Using the ASC and DESCOperators

    • Using the NULLSFIRSTand NULLSLASTOperators

    • Using the FETCHClause

  • Using Oracle Substitution Variables

    • What are Substitution Variables?

    • Double Ampersand (&&) and DEFINE & UNDEFINE Commands

    • ACCEPT and PROMPTCommands

    • SETVERIFYON / SETVERIFYOFFCommands

  • Using Oracle Single-Row Functions to Customize the Query Outputs

    • Introduction to Oracle Single-Row Functions

    • Character Functions

      • Case Conversion Functions

        • UPPERFunction

        • LOWERFunction

        • INITCAP Function

      • Character Manipulation Functions

        • SUBSTRFunction in SQL

        • LENGTHFunction in SQL

        • CONCATFunction in SQL

        • INSTRFunction in SQL

        • TRIMFunction in SQL

        • LTRIMand RTRIMFunctions in SQL

        • REPLACEFunction in SQL

        • LPADand RPADFunctions in SQL

      • Numeric Functions

        • ROUNDFunction in SQL

        • TRUNCFunction in SQL

        • CEILFunction in SQL

        • FLOORFunction in SQL

        • MODFunction in SQL

      • Nested SQLGroup Functions

      • DateData Types and SQLDate Functions

        • Date Data Types

          • DATEData Type in SQL

          • TIMESTAMPData Type in SQL

          • TIMESTAMPWITHTIMEZONEData Type in SQL

          • TIMESTAMPWITHLOCALTIMEZONEData Type in SQL

        • Oracle Date Functions

          • SYSDATEFunction inSQL

          • CURRENT_DATE Function in SQL

          • SESSIONTIMEZONE Function inSQL

          • SYSTIMESTAMPFunction in SQL

          • CURRENT_TIMESTAMP Function in SQL

        • Date Manipulation Functions

          • ADD_MONTHSFunction

          • MONTHS_BETWEENFunction

          • ROUNDFunction

          • TRUNCFunction

          • EXTRACTFunction

          • NEXT_DAY Function

          • LAST_DAYFunction

  • Oracle Conversion Functions

    • TO_CHARFunction in SQL

    • TO_NUMBERFunction in SQL

    • TO_DATEFunction inSQL

    • Null Related Functions in SQL

      • NVLFunction

      • NVL2Function

      • NULLIFFunction

      • COALESCEFunction

  • Conditional Expressions inSQL

    • CASEExpressions in SQL

    • DECODEFunction in SQL

  • Reporting Aggregated Data Using the Group Functions

    • Introduction to Oracle Group Functions

    • AVGFunction inSQL

    • COUNTFunction in SQL

    • MAXFunction in SQL

    • MINFunction in SQL

    • LISTAGGFunction in SQL

    • Overview of Group Functions in SQL

  • Displaying Data from Multiple Tables Using Joins

    • What is a SQLJoin?

    • Join Types in Oracle SQL

    • How to Create a Join in SQL

    • Natural Join

    • Join with the USINGClause

    • Handling Ambiguous Column Names While Joining Multiple Tables

    • Inner Join (Join with the ONClause)

    • Multiple Join Operations

    • Restricting Joins

    • Self-Join

    • Non-Equijoins (Joining Unequal Tables)

    • Outer Joins in SQL

      • LEFT OUTER JOIN (LEFT JOIN)

      • RIGHT OUTER JOIN (RIGHT JOIN)

      • FULL OUTER JOIN (FULL JOIN)

    • Cross Join (Cartesian Product or Cross Product)

    • Oracle's Old Style Join Syntax (Comparison of ANSI vs. Non-ANSISQLJoin Syntaxes)

  • Using &Building & Analyzing Subqueries

    • What is a Subquery in SQL?

    • How to Use Subqueries in SQL?

    • Subquery Types in SQL:

      • Single-Row Subqueries in SQL

      • Multiple-Row Subqueries in SQL

      • Multiple-Column Subqueries in SQL

      • SCALARSubqueries in SQL

      • Correlated Subqueries in SQL

    • Using Subqueries as a Table

    • Using the EXISTSOperator (Semijoins in SQL)

    • Using the NOTEXISTSOperator

  • Working with Oracle SETOperators

    • What are SETOperators and Why are They Used?

    • UNION Operator

    • UNIONALL Operator

    • MINUS Operator

    • INTERSECT Operator

    • Combining Multiple Queries Using Multiple SETOperators inComplex SQLQueries

  • Using Data Manipulation Language (DML) Statements

    • INSERTStatement

    • UPDATEStatement

    • DELETEStatement

    • MERGEStatement

    • Multiple INSERTStatements

    • Unconditional INSERT(INSERTALL) Statements

    • Conditional INSERTALLStatements

    • Conditional INSERTFIRSTStatements

    • Pivot Insert inSQL

  • Using Transaction Control Language (TCL) Statements

    • What is a transaction in SQL?

    • TCLCommands

    • COMMITand ROLLBACKStatements in SQL

    • Row Locking Mechanism in SQL

    • SAVEPOINTStatement in SQL

    • FORUPDATEStatement in SQL

  • Using Data Definition Language (DDL) Statements

    • What are Data Definition Language Statements

    • Naming Rules &Naming Conventions in Oracle

    • Creating Tables using the CREATETABLEstatements

    • CREATE TABLE AS SELECT (CTAS) Statement in Oracle

    • ALTER TABLE Statement

    • Marking Columns Unused (Using The SET UNUSED Clause)

    • READ-ONLY Tables in SQL

    • DROP TABLE Statement

    • TRUNCATE TABLE Statement

    • COMMENT Statement

    • RENAME Statement

  • Creating, Using, Working, and Managing Constraints

    • What is aConstraint in SQL?

    • Oracle Constraint Types

    • NOTNULLConstraint

    • UNIQUEConstraint

    • PRIMARYKEYConstraint

    • FOREIGN KEY Constraint

    • The ON DELETE CASCADE Clause

    • The ON DELETE SET NULL Clause

    • CHECK Constraint

    • Adding Constraints via ALTER TABLE Statements

    • Dropping (Removing) Constraints

    • Cascading Constraints in Oracle

    • Renaming Constraints

    • Enabling / Disabling Constraints

    • Status of Constraints

    • Deferring (Deferrable) Constraints

  • Creating, Using, and Managing Database Views in Details

    • What is a Database View and What is it Used for?

    • View Types in Oracle

    • Creating Simple Views

    • Creating Complex Views

    • Modifying Views

    • Performing DML Operations with Views

    • Using the WITH CHECK OPTION Clause in SQL

    • Using the WITH READ ONLY Clause on Views

  • Managing Objects Using Oracle Data Dictionary Views

    • What are Data Dictionary views in Oracle?

    • The DICTIONARYView (The MainDictionary)

    • USER, ALL, DBA, and V$ Prefixes in Data Dictionary Views

    • USER_OBJECTS, ALL_OBJECTS, and DBA_OBJECTS Views

    • USER_TABLES, ALL_TABLES, and DBA_TABLES Data Dictionary Views

    • USER_TAB_COLUMNS Data Dictionary View

    • USER_CONSTRAINTS Data Dictionary View

    • USER_CONS_COLUMNS Data Dictionary View

    • USER_VIEWS Data Dictionary View

    • USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views

  • Creating and Using, Working with Sequences in SQL

    • What is a Sequence?

    • Creating Sequences

    • Modifying Sequences

    • Using Sequences

    • Using Sequences as Default Values

    • Sequence Caching

    • The USER_SEQUENCESView

    • Using the IDENTITYColumn in Oracle

  • Creating and Using Synonyms

  • Working with Indexes

  • Managing Schema Objects

  • Retrieving Data By Using Subqueries

  • Manipulating Data By Using Subqueries

  • Controlling User Access in Details

  • Managing Data in Different Time Zones


BENEFITS OF TAKING THIS SQL COURSE:

Knowing SQL can get you a better job or improve the one you have and it can earn you 150k+ (USD) per/year in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, this is why it's so popular and backed by Oracle.

This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts of how to write SQL codes easily and think analytically against the problem in your company.


STUDENT REVIEWS PROVE THIS COURSE'S WORTH:

Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.

Many students had also taken other SQLcourses in the past, only to find that this SQLcourse was their favorite. They enjoyed the structure of the content and the high-quality audio/video.

Check out all of the great reviews in the review section ... a lot of happy students :-)


IMPORTANT NOTE:

Knowing SQL is "mandatory" for any IT Professional and having good SQLknowledge will be a "GREATPLUS" for you!

If you want to Become a Job-Ready SQL Professional who can pass any Oracle SQL Exam confidently, this course will be the next step for you!

So let’s do this! I'll see you in the first lecture!


Taught by

Oracle Master Training • 150,000+ Students Worldwide and Code Star Academy

Related Courses

Break Free of Legacy Databases (French)
Amazon Web Services via AWS Skill Builder Break Free of Legacy Databases (Italian)
Amazon Web Services via AWS Skill Builder Break Free of Legacy Databases (Portuguese)
Amazon Web Services via AWS Skill Builder Enterprise Database Migration
Google Cloud via Coursera Database and Multi-Cloud Assessment with StratoZone
Google Cloud via Coursera