Oracle SQL: An Introduction to the most popular database
Oracle SQL: An Introduction to the most popular database, available at Free, has an average rating of 4.5, with 22 lectures, based on 508 reviews, and has 17742 subscribers.
You will learn about Either Download and Install Oracle Express Edition and Oracle SQL Developer on your computer – for free Write your own SELECT statements. Learn the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses. Get an easy way to remember the order of these clauses. Find out what more you need to know, and resources in how to learn it. This course is ideal for individuals who are This beginner's course is for you if you want to learn about Oracle SQL and the six principal clauses of the SELECT statement. or If you have already heard about Oracle SQL, and wish to learn more about SQL code, then please have a look at my courses. It is particularly useful for This beginner's course is for you if you want to learn about Oracle SQL and the six principal clauses of the SELECT statement. or If you have already heard about Oracle SQL, and wish to learn more about SQL code, then please have a look at my courses.
Enroll now: Oracle SQL: An Introduction to the most popular database
Summary
Title: Oracle SQL: An Introduction to the most popular database
Price: Free
Average Rating: 4.5
Number of Lectures: 22
Number of Published Lectures: 22
Number of Curriculum Items: 22
Number of Published Curriculum Objects: 22
Original Price: Free
Quality Status: approved
Status: Live
What You Will Learn
- Either Download and Install Oracle Express Edition and Oracle SQL Developer on your computer – for free
- Write your own SELECT statements.
- Learn the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses.
- Get an easy way to remember the order of these clauses.
- Find out what more you need to know, and resources in how to learn it.
Who Should Attend
- This beginner's course is for you if you want to learn about Oracle SQL and the six principal clauses of the SELECT statement.
- If you have already heard about Oracle SQL, and wish to learn more about SQL code, then please have a look at my courses.
Target Audiences
- This beginner's course is for you if you want to learn about Oracle SQL and the six principal clauses of the SELECT statement.
- If you have already heard about Oracle SQL, and wish to learn more about SQL code, then please have a look at my courses.
This course is a brief presentation of Oracle SQL.
We will install a version of Oracle Express Edition and Oracle SQL Developer for free.
-
The Oracle Express Edition is the back engine, which does all of the work.
-
Oracle SQL Developer is the front engine, which allows you to send queries and see the results.
We’ll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).
-
The SELECT clause says what fields you want to retrieve.
-
The FROM clause shows the data source.
-
The WHERE clause filters it down, based on criteria you choose.
-
The GROUP BY clause aggregates (sums, count, min, max) it together, creating a summary.
-
The HAVING clause can summarise it further.
-
The ORDER BY clause then orders the results.
As part of this, we’ll be looking at how you can rename fields in a query, how you can use the AS keyword, and semicolons and comments.
Following this, we’ll look at what else you need to know, and resources (which range from FREE to very expensive) which will help you to learn it.
No prior knowledge is required – just a willingness to learn.
See you on the course.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: Welcome to Udemy
Lecture 3: Do you want auto-translated subtitles in more languages?
Chapter 2: Install Oracle Express Edition and SQL Developer
Lecture 1: Download Oracle Express Edition
Lecture 2: Install Oracle Express Edition
Lecture 3: Download and Install Oracle SQL Developer
Chapter 3: Opening Oracle SQL Developer
Lecture 1: Connect to Database
Lecture 2: Solving the "The network adaptor cannot establish the connection" error
Chapter 4: The SELECT, FROM and WHERE clauses
Lecture 1: The SELECT and FROM clauses
Lecture 2: Renaming fields
Lecture 3: Using the AS keyword
Lecture 4: Semicolons and comments
Lecture 5: The WHERE clause
Chapter 5: The GROUP BY, HAVING and ORDER BY clauses
Lecture 1: The GROUP BY clause
Lecture 2: The HAVING clause, and information about error messages.
Lecture 3: The ORDER BY clause
Lecture 4: Remembering the order of the clauses
Lecture 5: Practice Activity Number 1
Lecture 6: Practice Activity Number 1 – The Solution
Chapter 6: What's Next?
Lecture 1: What should you learn, and resources for you
Lecture 2: Thank you for watching
Lecture 3: Bonus Lecture SQL
Instructors
-
Phillip Burton
Best Selling Instructor – over 800,000 students so far
Rating Distribution
- 1 stars: 3 votes
- 2 stars: 7 votes
- 3 stars: 58 votes
- 4 stars: 203 votes
- 5 stars: 237 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
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024