Release Date: November 2014
ISBN: 9781771373159
Video 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.
Introduction
What You Should Expect From This Course
00:03:46
About The Author
00:02:31
How To Access Your Working Files
00:03:22
The Oracle Relational Database
The Relational Database
00:05:51
The Oracle 12C RDBMS
00:06:23
Structured Query Language
00:05:02
Setting Up SQL Developer
00:05:11
Setting Up Oracle APEX
00:05:06
The SQL SELECT Statement
The Syntax Of SQL
00:04:03
Projecting Columns In A SQL Statement
00:04:17
Using DESCRIBE
00:05:33
Using Aliases In SQL
00:03:38
Arithmetic Operators
00:04:38
Displaying Unique Values With DISTINCT
00:04:22
Concatenating Values
00:04:17
Conditionals In SQL Statements
Selectivity And WHERE Clause Syntax
00:03:07
Conditions Of Equality
00:04:23
Conditions Of Non-Equality
00:05:17
Range Conditions With BETWEEN
00:03:34
Set Conditions With IN
00:02:51
Pattern Matching With LIKE
00:05:06
Boolean Conditions
00:05:03
Sorting Data With ORDER BY
00:04:43
Sort Ordering And Secondary Sorts
00:05:03
Ampersand Substitution
00:05:11
Row Level Data Transformation
Understanding Single-Row Functions
00:03:50
Case Conversion Functions
00:03:37
Basic String Manipulation Functions
00:06:23
Advanced String Manipulation Functions
00:07:04
Date Functions
00:04:46
Arithmetic Functions
00:05:04
Conversion Functions And Conditional Expressions
Date To Character Conversion
00:05:06
Character To Date Conversion
00:04:20
Numeric Conversion
00:04:43
Conditional Expression Functions
00:04:50
Aggregate Data Transformation
Group Functions
00:03:45
Grouping Data With GROUP BY
00:04:03
Row Exclusion With HAVING
00:03:22
Using SQL Clauses Together
00:02:55
Combining Data
Explicit Versus Implicit Join Notation
00:04:28
Implicit Cartesian Joins
00:03:13
Implicit Equijoins
00:04:48
Implicit Outer Joins
00:04:46
Explicit Cross Joins
00:03:17
Ambiguous Explicit Joins With NATURAL JOIN
00:04:30
Explicit Column Joins With JOIN USING
00:03:07
Fully Specified Explicit Joins With JOIN ON
00:02:52
Self Joins And Non-Equijoins
00:04:04
Multi-Table Joins
00:05:17
Subqueries And Set Operators
Solving Problems With Subqueries
00:03:10
Basic Scalar Subqueries
00:03:13
Advanced Scalar Subqueries
00:03:59
Multi-Row Subqueries
00:06:16
Correlated Subqueries
00:03:40
Multi-Column Subqueries
00:04:30
Nested Subqueries
00:02:27
Using Set Operators
00:04:41
Data Manipulation And DML
Create Data With INSERT
00:05:02
Modify Data With UPDATE
00:03:58
Remove Data With DELETE And TRUNCATE
00:03:56
Transaction Control
00:05:30
Data Definition Language
The Purpose Of DDL
00:04:16
Oracles Schema Based Approach
00:04:38
Database Objects
00:05:57
Column Datatypes
00:04:36
The CREATE TABLE Statement
00:04:55
Avoiding Datatype Errors
00:06:30
Modifying Tables With ALTER TABLE
00:07:36
The NOT NULL Constraint
00:02:39
PRIMARY KEY Constraint
00:05:08
FOREIGN KEY Constraint
00:04:59
UNIQUE Constraint
00:03:29
CHECK Constraint
00:03:44
Certification Exam Preparation
About The Exam
00:03:51
Hints And Strategies For Preparation
00:04:17
Conclusion
Wrap Up
00:02:12
آیا می خواهید برنامه نویسی موبایل را با بهترین تکنولوژی شروع کنید؟
به کمک این دوره آموزشی که توسط مدیر سایت گیت تدریس می شود به راحتی اپلیکیشن های Android و iOS و Windows Phone بسازید.
تمامی مباحث از مقدماتی تا پیشرفته آموزش داده می شوند و شرکت کنندگان دوره به مدت نامحدود پشتیبانی می شوند.
برای اطلاعات بیشتر و استفاده از دوره روی لینک زیر کلیک نمایید:
آیا می خواهید طراحی وب را به صورت حرفه ای یاد بگیرید؟
در این دوره آموزشی طراحی وب را در قالب بیش از 72 ساعت آموزش تصویری فارسی فرامیگیرید.
در این دوره HTML5 | CSS3 | Javascript | Jquery | Ajax | Bootstrap4 | PHP | MYSQL | SQL Server | Wordpress آموزش داده می شود.
تمامی مباحث از مقدماتی تا پیشرفته آموزش داده می شوند و شرکت کنندگان دوره به مدت نامحدود پشتیبانی می شوند.
برای اطلاعات بیشتر و استفاده از دوره روی لینک زیر کلیک نمایید:
حجم فایل: 848MB
لینک های دانلود: (Download Links)
موضوع: آموزش Oracle آموزش های Infinite Skills پایگاه داده
تگ ها: آموزش Oracle آموزش پایگاه داده Oracle آموزش پایگاه داده اوراکل آموزش گواهینامه Oracle آموزش گواهینامه Oracle Database 12C Certified Professional
ثبت ديدگاه