Comprehensive Video Tutorials

Oracle Database 12c Certified Professional - SQL Foundations Training Video

CareerVision Training
Online

£ 72 - (85 )
zzgl. MwSt.

Wichtige informationen

  • Kurs
  • Online
  • Dauer:
    Flexible
  • Wann:
    Freie Auswahl
  • Online Campus
Beschreibung

The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
Freie Auswahl
Online

Was lernen Sie in diesem Kurs?

IT
Database
SQL
Database training

Themenkreis

A Practical Oracle 12c Training Course That Teaches Real World Skills

In this project-based Oracle Database 12c Certified Professional - SQL Foundations video tutorial series, you'll quickly have relevant skills for real-world applications.

Follow along with our expert instructor in this training course to get:

  • Concise, informative and broadcast-quality Oracle Database 12c Certified Professional - SQL Foundations training videos delivered to your desktop
  • The ability to learn at your own pace with our intuitive, easy-to-use interface
  • A quick grasp of even the most complex Oracle Database 12c Certified Professional - SQL Foundations subjects because they're broken into simple, easy to follow tutorial videos

Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Oracle Database 12c Certified Professional - SQL Foundations tutorial, online or offline... so you'll know the exact steps for your own projects.

Course Description

In this Oracle Database 12c Certified Professional - SQL Foundations training course, expert author Steve Ries will teach you the fundamentals of the SQL programming language, as well as prepare you for the first test in the Oracle certification track. This course is designed for the absolute beginner, meaning no experience with Oracle 12c is required.

You will start by learning about the Oracle relational database, then jump into learning about the SQL SELECT statement. From there, Steve will teach you about conditionals in SQL, conversion functions, and implicit and explicit joins. This video tutorial also covers subqueries, data manipulation, and data definition language. Finally, you will learn about the exam, and Steve will provide you with hints and strategies to help you prepare.

Once you have completed this computer based training course, you will be fully capable of using the SQL programming language. You will also have gained the knowledge necessary to prepare for the Oracle Database 12c SQL Fundamentals exam. Working files are included, allowing you to follow along with the author throughout the lessons.

Course Outline

01. Introduction What You Should Expect From This Course About The Author 0103 How To Access Your Working Files 02. The Oracle Relational Database The Relational Database The Oracle 12C RDBMS Structured Query Language Setting Up SQL Developer Setting Up Oracle APEX 03. The SQL SELECT Statement The Syntax Of SQL Projecting Columns In A SQL Statement Using DESCRIBE Using Aliases In SQL Arithmetic Operators Displaying Unique Values With DISTINCT Concatenating Values 04. Conditionals In SQL Statements 0401 Selectivity And WHERE Clause Syntax 0402 Conditions Of Equality 0403 Conditions Of Non-Equality 0404 Range Conditions With BETWEEN 0405 Set Conditions With IN 0406 Pattern Matching With LIKE 0407 Boolean Conditions 0408 Sorting Data With ORDER BY 0409 Sort Ordering And Secondary Sorts 0410 Ampersand Substitution 05. Row Level Data Transformation 0501 Understanding Single-Row Functions 0502 Case Conversion Functions 0503 Basic String Manipulation Functions 0504 Advanced String Manipulation Functions 0505 Date Functions 0506 Arithmetic Functions 06. Conversion Functions And Conditional Expressions 0601 Date To Character Conversion 0602 Character To Date Conversion 0603 Numeric Conversion 0604 Conditional Expression Functions 07. Aggregate Data Transformation 0701 Group Functions 0702 Grouping Data With GROUP BY 0703 Row Exclusion With HAVING 0704 Using SQL Clauses Together 08. Combining Data 0801 Explicit Versus Implicit Join Notation 0802 Implicit Cartesian Joins 0803 Implicit Equijoins 0804 Implicit Outer Joins 0805 Explicit Cross Joins 0806 Ambiguous Explicit Joins With NATURAL JOIN 0807 Explicit Column Joins With JOIN USING 0808 Fully Specified Explicit Joins With JOIN ON 0809 Self Joins And Non-Equijoins 0810 Multi-Table Joins 09. Subqueries And Set Operators 0901 Solving Problems With Subqueries 0902 Basic Scalar Subqueries 0903 Advanced Scalar Subqueries 0904 Multi-Row Subqueries 0905 Correlated Subqueries 0906 Multi-Column Subqueries 0907 Nested Subqueries 0908 Using Set Operators 10. Data Manipulation And DML 1001 Create Data With INSERT 1002 Modify Data With UPDATE 1003 Remove Data With DELETE And TRUNCATE 1004 Transaction Control 11. Data Definition Language 1101 The Purpose Of DDL 1102 Oracles Schema Based Approach 1103 Database Objects 1104 Column Datatypes 1105 The CREATE TABLE Statement 1106 Avoiding Datatype Errors 1107 Modifying Tables With ALTER TABLE 1108 The NOT NULL Constraint 1109 PRIMARY KEY Constraint 1110 FOREIGN KEY Constraint 1111 UNIQUE Constraint 1112 CHECK Constraint 12. Certification Exam Preparation 1201 About The Exam 1202 Hints And Strategies For Preparation 13. Conclusion 1301 Wrap Up