Latest Courses
The Theory of Deep Learning - Become a Data ScientistCheck course
Build a Complete Youtube Video App: Swift2.2 & 3 and XcodeCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
Python Programming Skills Test With ExplanationCheck course
Beginners Eclipse Java IDE Training CourseCheck course
Xamarin Android - A Master Guide to App Development in C#Check course
Python for beginnersCheck course
Salesforce Integration With External SystemsCheck course
The Theory of Deep Learning - Become a Data ScientistCheck course
Build a Complete Youtube Video App: Swift2.2 & 3 and XcodeCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
- 85% 1Z0-071 Oracle Database SQL Developer: Certified Associate

1Z0-071 Oracle Database SQL Developer: Certified Associate

$109.99 $15.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.8/10 (Our Score)
Product is rated as #25 in category SQL

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

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server.

Specification: 1Z0-071 Oracle Database SQL Developer: Certified Associate

Duration 19.5 hours
Year 2020
Level Beginner
Certificate Yes
Quizzes No

17 reviews for 1Z0-071 Oracle Database SQL Developer: Certified Associate

4.5 out of 5
11
4
2
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Michael Cochran

    I think is it very good so far, though I thought that it made Foreign Keys mush more difficult than they are

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Dinesh Yamali

    A good course with simple explanation along with good design of curriculum.

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Bryan Binuya

    One of the best teachers. Explain everything in a very detail way 😀

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Torben Jackisch

    Mostly love the practicum at the end of every chapter.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Aurel GUIDI

    Contenu de bonne qualit , je suis pleinement satisfait jusqu’ pr sent !

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Maikel Amkreutz

    A really perfect and amazing course, I highly recommend it for everyone.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Harold Denson

    Although it’s early, things have gone smooth so far.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    Stephen Hall

    Very informative and covers a lot of information with concise examples.

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    Akhilaja Mogilicharla

    I think you did not covered all the concepts like left join, right join and u explained only primary, foreign keys..

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  14. Avatar

    Gabriel Thomas

    A very good course that goes through the materials well. I haven’t taken the exam yet, but it seemed really good.

    Helpful(0) Unhelpful(0)You have already voted this
  15. Avatar

    Thembisile Gwebeda

    The course is good and practical so far I’m enjoying it.

    Helpful(0) Unhelpful(0)You have already voted this
  16. Avatar

    Felix Davelouis

    very good!

    Helpful(0) Unhelpful(0)You have already voted this
  17. Avatar

    Wally Pons

    Very satisfactory experience, well executed by Mr. Burton and eye opening to the Oracle environment.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    1Z0-071 Oracle Database SQL Developer: Certified Associate
    1Z0-071 Oracle Database SQL Developer: Certified Associate

    $109.99 $15.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare