Phillip Burton
This course is the foundation for the Oracle Database SQL 1Z0–071 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access. It is divided into 6 sessions, each of which should take a morning or afternoon to complete.
Session 1
We’ll install for free Oracle Express Edition and Oracle SQL Developer. Then we’ll take a look at the 6 principal clauses of the SELECT statement: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
Then we’ll start creating tables, but find that we can’t get very far without understanding data types. We’ll then look at string, date and number types and functions, together with looking at functions converting between them.
Session 2
We’ll revisit the SELECT statement and go into more detail. We’ll create tables and JOIN them together. Once you have finished this session, you should be secure in your knowledge of the 6 principal clauses of the SELECT statement, the most important part of Oracle SQL.
Session 3
In session 3, we’ll looking for missing data, and find out how to delete and update data. We’ll look at the difference between implicit and explicit transactions, and various constraints, including primary and foreign keys.
Session 4
Instructor Details
Courses : 7
Specification: 1Z0-071 Oracle Database SQL Developer: Certified Associate
|
17 reviews for 1Z0-071 Oracle Database SQL Developer: Certified Associate
Add a review
| Price | $15.99 |
|---|---|
| Provider | |
| Duration | 19.5 hours |
| Year | 2020 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$15.99
Michael Cochran –
I think is it very good so far, though I thought that it made Foreign Keys mush more difficult than they are
Dinesh Yamali –
A good course with simple explanation along with good design of curriculum.
Bryan Binuya –
One of the best teachers. Explain everything in a very detail way 😀
Torben Jackisch –
Mostly love the practicum at the end of every chapter.
Aurel GUIDI –
Contenu de bonne qualit , je suis pleinement satisfait jusqu’ pr sent !
Alexandre de Mello Zart –
Great english pronounciation, good start with explanations that usually are not made by the instructors (as the connection problem, for example). I think that this was a good investment.
Steve Letko –
Course intro is long and covering basic OS functions. I have not been shown anything that couldn’t be outlined in course requirements.
Maikel Amkreutz –
A really perfect and amazing course, I highly recommend it for everyone.
Thomas Bohrer –
I bought several courses for passing the 1Z0 071 and this was by far the best, in terms of well everything. For a start it is 19 hours long, the videos are good quality, the instructor is English and hence speaks in clear English. He explains by way of example and this is then reinforced at the end of each session with a practice lesson while at the same time you assimilate how to use Oracle SQL Developer. On finishing, one actually has the feeling that one could with a bit of practice pass the Oracle Certification. Thank you Phillip, great course.
Harold Denson –
Although it’s early, things have gone smooth so far.
Stephen Hall –
Very informative and covers a lot of information with concise examples.
Akhilaja Mogilicharla –
I think you did not covered all the concepts like left join, right join and u explained only primary, foreign keys..
Pramod L –
It’s really a great course…I liked the way the instructor explained the concepts mostly practical but also theoretical as when required.
Gabriel Thomas –
A very good course that goes through the materials well. I haven’t taken the exam yet, but it seemed really good.
Thembisile Gwebeda –
The course is good and practical so far I’m enjoying it.
Felix Davelouis –
very good!
Wally Pons –
Very satisfactory experience, well executed by Mr. Burton and eye opening to the Oracle environment.