Oracle Cloud: Basic Oracle SQL with hands on Experience
Oracle Cloud: Basic Oracle SQL with hands on Experience, available at $19.99, has an average rating of 4.1, with 76 lectures, based on 61 reviews, and has 10894 subscribers.
You will learn about Who want to start their career as Oracle Database Administrator or Oracle Developer This course is ideal for individuals who are Oracle Developer, Oracle Database Administrator It is particularly useful for Oracle Developer, Oracle Database Administrator.
Enroll now: Oracle Cloud: Basic Oracle SQL with hands on Experience
Summary
Title: Oracle Cloud: Basic Oracle SQL with hands on Experience
Price: $19.99
Average Rating: 4.1
Number of Lectures: 76
Number of Published Lectures: 76
Number of Curriculum Items: 76
Number of Published Curriculum Objects: 76
Original Price: $89.99
Quality Status: approved
Status: Live
What You Will Learn
- Who want to start their career as Oracle Database Administrator or Oracle Developer
Who Should Attend
- Oracle Developer, Oracle Database Administrator
Target Audiences
- Oracle Developer, Oracle Database Administrator
SQL language is an important skill for any Oracle professional and is the first step in suitable a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, I cover the basics required to code with SQL in an Oracle Database 12c environment. Learn how to select and filter data, and manipulate data using functions, including SUBSTR, UPPER, MIN, MAX, AVG, SUM, and more. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions also include such as constraints and subqueries advance concepts. This training course is suitable for beginning database developers with no prior experience with SQL or Oracle.
Following are including:
- Using Oracle SQL*Developer, the free development environment
- Selecting data from tables
- Filtering data
- Using functions to manipulate data
- Joining data from tables
- Creating tables
- Updating values
- Truncating data
- Grouping and ordering result sets
- Working with primary keys
- Checking constraints
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Chapter 2: Introduction to SQL
Lecture 1: What is SQL?
Lecture 2: Database Tables
Lecture 3: Overview of table data types
Lecture 4: SQL query structure
Chapter 3: Setup course environment
Lecture 1: Downloading the course VM
Chapter 4: Using Oracle SQL Developer
Lecture 1: Introduction to Oracle SQL Developer
Lecture 2: Creating a connection to the database
Lecture 3: Managing existing connections
Lecture 4: Exploring database objects
Lecture 5: Filtering specific objects
Lecture 6: Using SQL Developer tabs
Lecture 7: Viewing query output
Lecture 8: Case sensitivity of SQL commands
Lecture 9: Viewing SQL execution history
Lecture 10: Query output as grid or script
Chapter 5: Basic SELECT Queries
Lecture 1: Writing your first SELECT query
Lecture 2: Selecting only specific columns
Lecture 3: Using WHERE to filter specific rows
Lecture 4: Using multiple WHERE conditions
Lecture 5: Using WHERE to filter partial strings
Lecture 6: Using WHERE to filter numeric ranges
Lecture 7: Using WHERE IN and NOT IN for strings
Lecture 8: Using WHERE IN and NOT IN for numbers
Lecture 9: Using WHERE to filter dates
Lecture 10: Using WHERE to filter exact strings
Lecture 11: Using DISTINCT to eliminate duplicates
Lecture 12: Performing basic numeric calculations
Lecture 13: Using column aliases
Lecture 14: Describe the structure of a table
Lecture 15: Using ORDER BY
Chapter 6: String, Number, and Date Functions
Lecture 1: Introduction to functions
Lecture 2: Using SUBSTRING, LENGTH, and CONCAT
Lecture 3: Using LENGTH
Lecture 4: Using CONCAT
Lecture 5: Using LOWER and UPPER
Lecture 6: Using INSTR
Lecture 7: Using RPAD and LPAD
Lecture 8: Using TO_CHAR to convert numbers
Lecture 9: Using TO_CHAR to format DATE values
Lecture 10: Using TO_CHAR to filter DATE values
Lecture 11: The special Oracle DUAL table
Lecture 12: Using ROUND
Lecture 13: Using TRUNC
Lecture 14: Using SYSDATE
Lecture 15: Using SYSTIMESTAMP
Lecture 16: Using MONTHS_BETWEEN
Lecture 17: Using ADD_MONTHS
Chapter 7: Joining Table Data
Lecture 1: Introduction to SQL joins
Lecture 2: Joining data from tables
Lecture 3: INNER JOIN
Lecture 4: LEFT JOIN
Lecture 5: RIGHT JOIN
Lecture 6: FULL OUTER JOIN
Lecture 7: Joins with table aliases
Lecture 8: Oracle join syntax vs. ANSI syntax
Chapter 8: Manipulating Data
Lecture 1: Introduction to DML and DDL commands
Lecture 2: Creating a simple table
Lecture 3: Inserting a new row to a table
Lecture 4: COMMIT and ROLLBACK
Lecture 5: Introduction to transactions
Lecture 6: Deleting rows for a table
Lecture 7: Updating values
Lecture 8: Multiple-statement transactions
Lecture 9: Adding and dropping columns from a table
Lecture 10: Truncating all data from a table
Chapter 9: Grouping Data
Lecture 1: Introduction to aggregate functions
Lecture 2: Using aggregate functions
Lecture 3: Using GROUP BY
Lecture 4: Using GROUP BY with MAX, MIN, and AVG
Lecture 5: Using HAVING
Chapter 10: Advanced Topics
Lecture 1: Primary keys
Lecture 2: NOT NULL constraints
Lecture 3: Check constraints
Lecture 4: Foreign key constraints
Lecture 5: Subqueries
Instructors
-
Zulqarnain Hayat
Senior Database Specialist and Team Lead Middleware,AWS
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 3 votes
- 3 stars: 6 votes
- 4 stars: 19 votes
- 5 stars: 31 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple