Latest Courses
Angular 2 Master Class with Alejandro RangelCheck course
The Comple JavaScript From Beginner To AdvancedCheck course
The Complete Android Oreo and Nougat App TutorialsCheck course
C Programming Skills Test With ExplanationCheck course
Modern .NET Ecosystem and .NET CoreCheck course
Python Programming Bible: Hands-On Python 3 with 10 ProjectsCheck course
Introduction to Cloud Computing on Amazon AWS for BeginnersCheck course
Learn basics of Redux in React Native in 2 hours!Check course
Learn Python Django From ScratchCheck course
The Complete PHP Bootcamp Course With Video Sharing ProjectCheck course
Angular 2 Master Class with Alejandro RangelCheck course
The Comple JavaScript From Beginner To AdvancedCheck course
The Complete Android Oreo and Nougat App TutorialsCheck course
C Programming Skills Test With ExplanationCheck course
Modern .NET Ecosystem and .NET CoreCheck 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

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

4.6 out of 5
7
3
1
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

    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