Latest Courses
Statistical Decision Making in Data Science with Case StudyCheck course
SQLite Studio Tutorial for beginnersCheck course
Editor X Masterclass - Build Amazing Websites | No CodingCheck course
C++ Intermediate to Advanced Course with ProjectCheck course
Algorithms in Python : Design Techniques And ApproachCheck course
Learn Advanced AI for Games with Behaviour TreesCheck course
Bootstrap Bootcamp (featuring Bootstrap 5)Check course
SQL Essentials - A Whole New Way of Learning SQL for Anyone!Check course
Unreal Engine 5: Blueprints for BeginnersCheck course
Azure Functions MasterclassCheck course
Statistical Decision Making in Data Science with Case StudyCheck course
SQLite Studio Tutorial for beginnersCheck course
Editor X Masterclass - Build Amazing Websites | No CodingCheck course
C++ Intermediate to Advanced Course with ProjectCheck course
Algorithms in Python : Design Techniques And ApproachCheck course
- 85% 1Z0-071 Learn Oracle SQL: prepare for Certified Associate

1Z0-071 Oracle Database SQL Developer: Certified Associate

$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 #27 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. 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. Dinesh Yamali

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

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

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

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

    Mostly love the practicum at the end of every chapter.

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

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

    Helpful(0) Unhelpful(0)You have already voted this
  6. 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. 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. Maikel Amkreutz

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

    Helpful(0) Unhelpful(0)You have already voted this
  9. 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. Harold Denson

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

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

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

    Helpful(0) Unhelpful(0)You have already voted this
  12. 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. 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. 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. Thembisile Gwebeda

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

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

    very good!

    Helpful(0) Unhelpful(0)You have already voted this
  17. 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

    $15.99

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare