Learn Oracle SQL in this course: manage data, write queries, and master complex SQL techniques with practical examples and quizzes.
This course is your friendly intro to using SQL with Oracle Database. You’ll learn everything from the basics, like how to run queries and manage data, to more complex topics. It's like a fun little journey into the world of databases—perfect for getting ready for the job market!
Learn how to query and manage data in the Oracle Database Using SQL. Practical, concept-building examples and quizzes.
Course Summary
This introductory course teaches you how to work with data in your Oracle Database using Oracle's proprietary SQL language. It starts with the basic overview of what SQL is all about and then covers basic queries and common things you might be expected to do on a job. We then proceed to learn complex queries and data management such as inserting/updating/deleting data.
All the SQL examples and the power point slides are available for download and there are a few exercises/queries at the end of each chapter for you to test your understanding. I'll try and add more each week. At the end of the course, we also discuss some of the frequently asked questions in Oracle SQL to assess our understanding of the course and various topics and to understand some of the frequently asked interview questions.
The course should take about 2 weeks to complete, with 2-3 hours dedicated each day to go through the examples and work them out yourself.
Understand the different components of an Oracle Database and how it works
Connect to an Oracle Database and run queries from different tools or from a file
Write basic queries involving Select, where, group by and other constructs
1 Lectures
4 Lectures
3 Lectures
5 Lectures
7 Lectures
8 Lectures
4 Lectures
6 Lectures
1 Lectures
About the company : A Data Guru (http://adata.guru) is an attempt at creating a learning community around all things data. To be job ready, learning one particular language or one skill usually is not sufficient and the same is true about data. On a usual day, most analysts, databsae developers/engineers and data scientists work on SQL, work with BI tools,...
Easy to follow examples and slides without having to need 20+ hours of SQL book knowledge.
Can't get to the environment... Sent note regarding and have not received any response... Not being able to submit the queries, defeats the purpose...
Thank you for elaborating on every step, very helpful lectures to understand basic diagrams on Oracle SQL.
More exercises between lessons would help reinforce what was just learned.
Links are not updated and cannot complete the course
I was unable to load the needed software.
I am a beginer of SQL and going through the videos is helping me to understand the commands requires to generate retrieve data for analytic purposes.
It was a nice revision about SQL and very clearly explained.
Thank you.
Everything is important because I am a beginner.
Your email address will not be published. Required fields are marked *
Ednay
Very good