1Z0-071 Oracle SQL Developer: Certified Associate (Database)
5.0 /5- Offered byUDEMY
1Z0-071 Oracle SQL Developer: Certified Associate (Database) at UDEMY Overview
Duration | 19 hours |
Total fee | ₹3,499 |
Mode of learning | Online |
Credential | Certificate |
1Z0-071 Oracle SQL Developer: Certified Associate (Database) at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 45 articles + resources
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
1Z0-071 Oracle SQL Developer: Certified Associate (Database) at UDEMY Course details
- This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL
- This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required
- Create tables in a database and ALTER columns in the table
- Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY
- JOIN two or more tables together, finding missing data
- INSERT new data, UPDATE and DELETE existing data, and export data into a new table
- Create constraints, views and sequences, subqueries and CTEs
- Use UNION, CASE, MERGE and error checking
- Apply ranking and analytic functions, grouping
- 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
- We'll install for free Oracle Express Edition and Oracle SQL Developer
- Then we'll start creating tables, but find that we can't get very far without understanding data types
- We'll revisit the SELECT statement and go into more detail. We'll create tables and JOIN them together
1Z0-071 Oracle SQL Developer: Certified Associate (Database) at UDEMY Curriculum
Introduction
Introduction
The Udemy Interface
Curriculum
Install Oracle Express Edition and SQL Developer
Download and Install Oracle Express Edition
Download and Install Oracle SQL Developer
3a. The Select statement - an overview
Connect to Database
Solving "The network adaptor cannot establish the connection" error
8e. The SELECT and FROM clauses
Renaming fields
Using the AS keyword
Semicolons and comments
3b, 13b. The WHERE clause
15b. The GROUP BY clause
15c. The HAVING clause, and information about error messages.
13a, 13c. The ORDER BY clause
Remembering the order of the clauses
Practice Activity Number 1
Practice Activity Number 1 - The Solution
8b. Session 1- Creating tables - first pass
Creating a table using the GUI
Creating our first table using SQL
17a. Inserting values
Deleting the data, then the table
Trying to create an Employee table
Session 1 - The Dual table and Number types
Using the DUAL table
Practice Activity Number 2 - Writing mathematical queries
Practice Activity Number 2 - The Solution
8c. Creating sample table; Run Script v Run Statement
8a. The NUMBER data type
Do you want to use the comma as a decimal point?
8a. FLOATing data types
Practice Activity Number 3
Practice Activity Number 3 - The Solution
Session 1 - Number functions
5b, 14a. Numeric functions Part 1
Rounding functions
Practice Activity Number 4 - The Solution
1Z0-071 Oracle SQL Developer: Certified Associate (Database) at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?