Oracle Database SQL Certified Associate (1Z0-071) Online Training

Focused View

Ben Finkel

6:04:57

45 View

01 - Relational DBs, Oracle, and SQL What is a Relational Database.mp4

06:36

02 - Relational DBs, Oracle, and SQL Tables, Views, and Queries.mp4

04:33

03 - Relational DBs, Oracle, and SQL Modeling Data With Entity Relationship Diagrams (ERD).mp4

05:28

04 - Relational DBs, Oracle, and SQL Normalizing Databases (3NF).mp4

06:25

05 - Relational DBs, Oracle, and SQL What is Structured Query Language (SQL).mp4

05:39

06 - Relational DBs, Oracle, and SQL ANSI SQL, Oracle SQL, and SQL Plus.mp4

05:02

07 - Relational DBs, Oracle, and SQL DDL, DML, and TCL.mp4

04:07

08 - Relational DBs, Oracle, and SQL Installing Oracle Database 12c.mp4

05:49

09 - Relational DBs, Oracle, and SQL Your First SQL Statement.mp4

05:57

10 - Data Definition Language (DDL) Oracle Database Structure and Schema.mp4

04:31

11 - Data Definition Language (DDL) Unique Names and Namespaces.mp4

04:16

12 - Data Definition Language (DDL) Creating a Table with DDL.mp4

06:41

13 - Data Definition Language (DDL) Data Types for Fields.mp4

07:03

14 - Data Definition Language (DDL) Creating a Constraint on a Table.mp4

04:54

15 - Data Definition Language (DDL) Types of Constraints.mp4

06:55

16 - Data Definition Language (DDL) Dropping Columns.mp4

05:40

17 - Data Definition Language (DDL) External Tables.mp4

06:01

18 - Data Definition Language (DDL) Lab.mp4

14:13

19 - Data Manipulation Language (DML) Inserting Data into a Table.mp4

05:28

20 - Data Manipulation Language (DML) Updating Data in a Table.mp4

04:24

21 - Data Manipulation Language (DML) Selecting Data From a Table.mp4

05:04

22 - Data Manipulation Language (DML) Deleting Data From a Table.mp4

03:42

23 - Data Manipulation Language (DML) Truncating Data From a Table.mp4

04:16

24 - Data Manipulation Language (DML) Managing Transactions with TCL.mp4

06:06

25 - Data Manipulation Language (DML) Lab.mp4

12:25

26 - Restricting and Sorting Query Results Using the ORDER BY Clause.mp4

04:56

27 - Restricting and Sorting Query Results Sorting on Expressions and Aliases.mp4

05:23

28 - Restricting and Sorting Query Results Filtering with WHERE.mp4

05:48

29 - Restricting and Sorting Query Results Wildcard Comparisons Using LIKE.mp4

03:19

30 - Restricting and Sorting Query Results Boolean Logic in the WHERE Clause.mp4

05:46

31 - Restricting and Sorting Query Results IN, BETWEEN, and IS.mp4

05:17

32 - Restricting and Sorting Query Results Limiting Results with FETCH.mp4

05:12

33 - Restricting and Sorting Query Results Ampersand Substitution.mp4

06:02

34 - Restricting and Sorting Query Results Prompt, Accept, and Define.mp4

05:02

35 - Restricting and Sorting Query Results Lab.mp4

10:26

36 - Single-Row and Conversion Functions Single-Row Functions.mp4

05:26

37 - Single-Row and Conversion Functions Character Functions.mp4

06:26

38 - Single-Row and Conversion Functions Numeric Functions.mp4

04:00

39 - Single-Row and Conversion Functions Date Functions.mp4

04:06

40 - Single-Row and Conversion Functions Analytical Functions.mp4

05:16

41 - Single-Row and Conversion Functions Partition, Lag, and Lead.mp4

03:48

42 - Single-Row and Conversion Functions Conversion Functions.mp4

06:16

43 - Single-Row and Conversion Functions General Functions.mp4

04:56

44 - Single-Row and Conversion Functions Lab.mp4

12:01

45 - Retrieving Data from Multiple Tables Types of Joins.mp4

05:16

46 - Retrieving Data from Multiple Tables Inner Joins.mp4

05:43

47 - Retrieving Data from Multiple Tables Outer Joins.mp4

06:24

48 - Retrieving Data from Multiple Tables Alternative Join Types.mp4

05:00

49 - Subqueries Introduction.mp4

04:53

50 - Subqueries Correlated Subqueries.mp4

04:31

51 - Subqueries EXISTS, NOT EXISTS, and WITH.mp4

03:17

52 - Subqueries Single-Row and Multi-Row Subqueries.mp4

05:37

53 - Subqueries Lab.mp4

12:24

54 - Aggregating Data Aggregate Functions.mp4

04:21

55 - Aggregating Data Grouping with GROUP BY.mp4

04:54

56 - Aggregating Data HAVING.mp4

03:46

57 - Aggregating Data Set Operators.mp4

04:54

58 - Aggregating Data Set Output Order.mp4

03:29

59 - Aggregating Data Lab.mp4

09:14

60 - Advanced Schema Operations Objects.mp4

06:21

61 - Advanced Schema Operations Creating Views.mp4

04:18

62 - Advanced Schema Operations Creating and Using Sequences.mp4

04:29

63 - Advanced Schema Operations Creating and Maintaining Indexes.mp4

05:25

Description

In this entry-level Oracle Database Associate training, Ben Finkel will prepare you to take the 1Z0-071 exam, which is the one required exam to earn the Oracle Database SQL Certified Associate certification.

Don’t let the OCA exam title code fool you. This Oracle training is actually a SQL course that anyone can use to learn the SQL flavor called Oracle SQL. While Oracle SQL isn’t entirely unlike other flavors, there are big differences in transaction control and even database organization that you should know.

More details

If you already know SQL, this training will get you up to speed. If youâ€™re learning SQL for the first time, thatâ€™s even better. Follow along in the Oracle virtual labs to learn Oracleâ€™s flavor of the popular query language SQL.

For anyone who leads a technology team, this Database Associate training can be used for 1Z0-071 exam prep, on-boarding new data professionals, or as a training plan for anyone who needs to learn SQL.

1Z0-071: What You Need to Know

For any data analyst using this training for exam preparation, our Oracle Database SQL Certified Associate course maps to the Oracle 1Z0-071 exams objectives, and covers topics such as:

Learn about Relational Databases
Tables, views, and queries in Relational DBs
Introduction to Structured Query Language (SQL)
Oracle Database Structure and Schema
Aggregating, Manipulating, and Retrieving Data
Restricting and sorting query results

Who Should Take 1Z0-071 Training?

This Database Associate training is considered associate-level Oracle training, which means it was designed for data analysts, database administrators, and anyone who needs to learn the Oracle SQL query language. This 1Z0-071 course is valuable for new IT professionals with at least a year of experience with Oracle database and experienced data professionals looking to validate their Oracle skills.

New or aspiring data professionals. This SQL training is perfect for anyone trying to learn the language. Ben starts with the basics of relational databases, like proper database structure and schema, works his way into inserting and updating data, and then gets into sorting with queries. Even though youâ€™ll be working on an Oracle database in the six virtual labs, youâ€™ll be able to use your new SQL skills across platforms.

Experienced data professionals. Data analysts or database administrators with a few years of experience should be pretty comfortable with the Oracle infrastructure aspects of this Oracle training. However, this is primarily a SQL course â€” and thereâ€™s plenty to learn when it comes to Oracle SQL. Ben covers the full range of DDL, DML, and TCL queries available with Oracle SQL and then gets into data aggregation, views, and maintaining Oracle database indexes. Experienced data professionals can use this SQL training to study for an Oracle exam, or simply as reference material developed by an Oracle expert.

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

Database Programming

Ben Finkel

Instructor's Courses

"The best part about being a trainer is learning all of these great new technologies, and working with a community of people who are all passionate about learning, and just generally being a part of a culture that values learning the way I do. I love sitting down and working through an involved or complex topic so that I can competently speak about it on screen."

Ben Finkel has worked in software development since 1996. Before joining CBT Nuggets, he was a software engineer at M&T Bank in Buffalo, New York. He is a Google Certified Trainer. When he’s not creating CBT Nuggets training videos, Ben enjoys skiing, snowboarding, reading, and home brewing beer and cider. He also considers himself a hobbyist programmer and likes learning new development technologies.

Certifications: Google, Microsoft

Areas of expertise: Google Developer Expert, Google Certified Trainer, Microsoft ASP.NET (WebForms and MVC), Data Analysis and Design, Relational Database Architecture, MS SQL Server, Microsoft C#.NET, Javascript, jQuery, Microsoft Visual Basic .NET & 6.0, .NET Reporting Services, MS Access, Python

CBT Nuggets

View courses CBT Nuggets

CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. We provide a variety of training, primarily in IT, project management, and office productivity topics. Our comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word. Whether you want to pass a certification exam, increase your skills, or simply learn new things, we've got you covered! All of our training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are the rock stars of training, renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts, EVER. Our trainers love to teach, and it shows! CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. He wanted to help provide large organizations, small teams and individuals with comprehensive and budget-conscious training, and he realized it couldn't be done in a classroom. From the CBT Nuggets World Headquarters in Eugene, Oregon, Dan and his team promise each video will be informative, comprehensive, accurate, and fun to watch.