Oracle: The Complete SQL Guide + Cert. (Dumps: 1Z0-061/ 071)
1.262 estudiantes inscritos
Oracle: The Complete SQL Guide + Cert. (Dumps: 1Z0-061/ 071)
Master Oracle SQL: from Beginner to an "Oracle Certified SQL Developer" Ninja for a great and exciting Career ahead..
1.262 estudiantes inscritos
Precio actual: 135,99 €
Precio original: 194,99 €
Descuento:
30 % de descuento
¡Esta oferta termina en 5 horas!
Garantía de reembolso de 30 días
Este curso incluye
- 8,5 horas de vídeo bajo demanda
- 19 artículos
- 3 recursos descargables
- Acceso de por vida completo
- Acceso en dispositivos móviles y TV
- Certificado de finalización
Training 5 or more people?
Dale a tu equipo acceso a más de 4.000 de los mejores cursos de Udemy en cualquier momento y lugar.
Prueba Udemy for Business
Lo que aprenderás
- Be a SQL Ninja by understanding how the Oracle Database works through the usage of 100+ Lectures with 10+ Hours Content.
- Develop the understanding of relational Database terminology.
- Learn and master the concepts of SQL (Structured Query Language), Table creation, Data Retrieval Language (DQL/ DRL) which includes real time scenarios based on the usage of operators, functions, clauses and many more...
- Gaining the deep understanding of Integrity Constraints, Pseudo columns, Joins and Queries to quickly become a Database developer.
- Controlling user access and Database security using requisite SQL commands.
- Dealing with other database objects (VIEWS, INDEXES, SEQUENCES, SYNONYMS) using the SQL commands.
- Understanding the OLAP features and achieving a high degree of data concurrency through LOCKS.
- Understanding the Data Manipulation Language, Transaction Control Language and Data Definition Language.
- Project has been created to pursue a test driven approach by make use of Oracle Database Integration with Spring and Hibernate frameworks.
- Pass the Oracle SQL Certification Examination through deep dive of the above discussed concepts.
Contenido del curso
Ampliar todo
111 clases
10:53:49
+
–
Getting Started
2 clases
14:07
What is Oracle?
06:21
+
–
Oracle Database – The Basics
6 clases
26:50
Relational Database Terminology
07:44
Database Objects
02:15
Table in Oracle
01:27
Data Types in Oracle
06:11
+
–
Table Creation and Insertion of Data
9 clases
31:31
Table Creation
08:30
Inserting Data in Table
04:17
Inserting Data in required Columns
02:23
Inserting NULL values into Table
02:17
Multiple Inserts
03:22
Inserting special values into Table
02:31
Conditional Inserts
04:52
Table: Demonstrated SQL Statements_1
01:16
Table: Demonstrated SQL Statements_2
02:03
+
–
Data Retrieval Languages (DQL/ DRL)
16 clases
01:29:49
Select Statement
04:53
Comments within SQL
01:45
Arithmetic Operators
04:11
Defining a Column/ Table Alias
05:59
Concatenation Operator
02:32
Literals in Oracle
01:59
Eliminate Duplicate Rows
03:00
FROM Clause
04:35
WHERE Clause - Filter of Records
04:00
Order By Clause
05:09
PIVOT Clause
05:51
Relational or Comparison Operators
03:33
Operators: IN(), BETWEEN, IS NULL, IS NOT NULL
14:31
Operators: LIKE, REGEXP_LIKE(), EXISTS
13:50
Logical Operators: AND, OR, NOT
10:21
DQL/ DRL: Demonstrated SQL Statements
03:40
+
–
Query Types (In Progress...)
3 clases
12:03
Types of Query
04:48
Correlated Sub Query
05:30
Query Types: Demonstrated SQL Statements
01:45
+
–
Single Row Function
7 clases
01:16:05
Single Row Functions
01:47
Character Functions
15:13
Number Functions
10:22
Date Functions
12:21
Conversion Functions
11:46
General Functions
21:28
Single Row Function: Demonstrated SQL Statements
03:08
+
–
Multiple Rows Function
8 clases
37:06
Aggregating or Group Functions
01:25
AVG(), SUM(), MIN(), MAX() Functions
06:40
STDDEV(), VARIANCE(),COUNT() Functions
05:16
Group By Clause
05:12
Having Clause
06:28
GREATEST(), LEAST(), USER, UID Functions
05:19
USERENV(), VSIZE(), SOUNDEX() Functions
05:19
Multiple Rows Function: Demonstrated SQL Statements
01:27
+
–
Analytic Functions
2 clases
15:45
CORR(), COVAR_POP(), COVAR_SAMP(), CUME_DIST()
13:33
Analytic Functions: Demonstrated SQL Statements
02:12
+
–
Integrity Constraints
13 clases
01:10:32
Level of Constraints
01:09
NOT NULL Constraint
04:10
UNIQUE Constraint
09:22
PRIMARY KEY Constraint
10:19
FOREIGN KEY or REFERENTIAL INTEGRITY Constraint
08:45
CHECK Constraint
08:16
DEFAULT Option
02:36
Adding Constraint to a Table
08:29
DROPPING Constraints
05:05
DISABLING Constraint
03:02
ENABLE Constraint
03:05
VIEWING Constraints
03:36
Constraints: Demonstrated SQL Statements
02:38
Requisitos
- No earlier programming experience is required to master the discussed content.
- Person with basic computer knowledge is good enough to understand.
- Use Chrome/ Oracle XE/ SQL Developer for practice.
Descripción
Welcome to my new course, 'Oracle: The Complete SQL Guide (Certification: 1Z0-061/ 071)'.
This course starts from scratch, you neither need to know any pre-requisite database knowledge nor any programming expertise.
From the environment Setup to Development, this course covers almost each and every concept required to become an expert SQL certified developer.
Having a deep-dive of the concepts in this course, you'll learn all about:
- Setup Development Environment Setup
- Relational database fundamentals
- Fundamentals of Database
- Table creation and insertion of data
- Data Retrieval Languages (DQL/ DRL)
- Single Rows Function
- Multiple Rows Function
- Integrity Constraints
- Pseudo Columns
- Displaying Data from Multiple Tables i.e. JOINS
- Query types
- SET Operators usage
- Controlling User Access and Database Security
- Oracle Database Administration
- Database objects (Views, Indexes, Sequence, Synonyms)
- OLAP Features in Oracle
- Table Locks
- Data Manipulation Language (DML)
- Transaction Control Language (TCL)
- Data Definition Language (DDL)
- Test driven approach by Integrating Oracle Database with Spring and Hibernate
- Course Roundup and many more...
This course will assist:
- in becoming an proficient 'Oracle SQL Developer' and
- to pass 'Oracle SQL Certification' examination.
Why SQL?
SQL the language is a structured query language designed for managing data in relational database management systems (RDBMS). Relational database management systems are often called SQL databases since they use the SQL language. SQL features provided are:
- Rely on relational tables
- Utilize defined data schema
- Reduce redundancy through normalization
- Support JOIN functionality
- Engineered for data integrity
- Traditionally scale up, not out
- Rely on a simple, standardized query language
- Near universal in adoption
Why Oracle?
Oracle database (Oracle DB) is a relational database management system (RDBMS) from the Oracle Corporation.The system is built around a relational database framework in which data objects may be directly accessed by users (or an application front end) through structured query language (SQL). Database features provided by Oracle are:
- Scalability and Performance Features
- Manageability Features
- Database Backup and Recovery Features
- High Availability Features
- Business Intelligence Features
- Content Management Features
- Security Features
- Data Integrity and Triggers
- Information Integration Features
¿Para quién es este curso?
- Newcomer as well as experienced who would like to become SQL developer or interested in learning SQL for getting proficiency in relational database operations.
- Practicing professional or simple an inspired individual interacting with the Oracle Database operations.
- Course covers most of the topics required for the Oracle SQL Certification exam.