Oracle SQL E-learning course
In this Oracle SQL e-learning course you learn at your own pace how Oracle works, how to structure tables, write queries and statements, and work with SQL functions, joins and subqueries.
NRTO quality mark
- Entirely at your own pace
- A year's access to all the course material
- Practical SQL skills from the ground up
- Ready for broad deployment as an Oracle developer
- Directly applicable in your day-to-day work
In this e-learning course you learn to work with Oracle SQL at your own pace. You will discover how to structure tables, write queries and execute statements. A full year of access to all videos, exercises and quizzes, so you can go through everything whenever it suits you.
Description
In this Oracle SQL e-learning course you work at your own pace on building a solid foundation in Oracle Database and the SQL programming language. You get around 32 hours of study material and a year's access to all videos, lectures, quizzes and exercises, so you can work through everything whenever it suits you.
You start with how Oracle works and build up your knowledge step by step towards writing queries and statements. You learn to structure tables, store data, run reports and apply SQL functions. In addition, you work with joins, subqueries, SET operators and conditional processing with CASE.
The course is offered in English and is suitable for anyone who wants to get started with Oracle without being tied to classroom timetables.
Topics
- how Oracle Database works
- structuring tables and storing data
- running reports with SQL
- Applying SQL functions
- grouping data for aggregated values
- writing joins and subqueries to retrieve data from multiple tables
- Using SET operators
- conditional processing with CASE
- Writing INSERT, UPDATE and DELETE statements
- creating views
Result
After this e-learning course you can manage Oracle applications and develop them further within your organisation. You understand how Oracle works and translate functional designs into technical solutions. You structure tables, store data and retrieve information using queries, joins and subqueries. You also write INSERT, UPDATE and DELETE statements, use SQL functions and carry out tests and problem analyses. This enables you to support colleagues who work with Oracle and to get started as an Oracle developer in a wide range of fields.
Target audience
This e-learning course is intended for (aspiring) developers, database administrators and IT professionals who want to learn to work with Oracle SQL. It is also a good fit if you are a functional designer and want to broaden your technical knowledge. Basic knowledge of databases and SQL is useful, but not required. The course is offered in English, so a good command of the English language is important.
Teaching method
You take this course entirely online, at your own pace and whenever it suits you. You get a year's access to all videos, lectures, quizzes and exercises, so you can review and repeat material at your leisure. Allow for around 32 hours of study time. The e-learning course is in English and covers Oracle SQL step by step, from the basics through to writing more complex queries and statements.
Prior knowledge
You do not need any specific prior knowledge for this e-learning course. Basic knowledge of working with databases is useful, but not required. You start from the basics and build up your knowledge step by step at your own pace.
Comments
None in particular.
Practical information
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials
- Certificate
- At the end of the course you will receive a certificate of attendance
In-company
Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.
Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.
This course for your team?
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
- Your date and location
- Tailored content
- Multiple groups or an academy are also possible
- More than 25 years' experience
What others say about this course
“You get value for money. And you leave with the knowledge to write your own SQL statements.”
“Practically applicable within my own organisation.”
“Practical course in which a user/information analyst quickly learns how to unlock (relational) databases using the basic principles of SQL.”
“A good balance between listening and practising. After this course you have a solid basis to get started on your own.”
“Good course with an excellent trainer who was able to give a clear answer to all our questions. Not just theoretical knowledge, but plenty of practical assignments.”
“Good course with a good progression from the basics to somewhat more complex content spread over two training days. I found it a very useful course and it is good that we also have reference material in the form of a course book and access to the website with the material from the book and practical exercises including answers.”
“Excellent course with plenty of depth added to the basic material by a professional trainer.”
"Fine, short yet complete basic course."
“The course is highly suitable for people who have never worked with SQL before. It explains clearly what SQL can do. This is a good basic course. If you already use SQL regularly, I would recommend an advanced course.”
“The course material is clear and of a good standard. The exercises are clear with sufficient and progressive depth, and the trainer is calm and competent.”
“Thanks to all the practice and the pleasant teaching style, this course is extremely well suited to picking up basic SQL knowledge quickly.”
“A good, practice-oriented programme, recommended for the increasingly popular field of Big Data.”
“A course in an informal atmosphere, where personal contact comes first. This way everyone can take in the material at their own pace and there is plenty of room to achieve your goals.”
"E. van Herwijnen - "Positive impression. Good location, course, exercise material and applicability in practice." - Rating: 7.2"
“Effective training course from an experienced trainer with more than enough knowledge. The trainer was able to switch quickly between people and also focused on those who needed it without forgetting the others.”
“The trainer is extremely knowledgeable and manages to present the often dry material in an entertaining way as well. Keep it exactly like this! Everything was arranged pleasantly and quickly by Learnit Training!”
“Excellent course if you want to learn SQL thoroughly and in a structured way. With plenty of practical exercises. The content of the course was excellent: clearly organised, good course material including practice assignments, a good balance between theory and practical exercises. The trainer's knowledge is good, as is the way he explains and conveys the material. He places a strong emphasis on building knowledge in a structured and solid way, rather than on quick results. He responded well to questions.”
“I am positive. I now feel less like I am getting lost in queries made by others. Creating queries is not a requirement for my role, but making the occasional small adjustment to generate output is.”
“For me, this course was on the one hand a good repetition of the SQL Basics course I also attended, and on the other hand it covered additional topics I did not yet know. Thanks to the content of the course I now have, as the trainer nicely put it, a number of new tools in my toolbox that I can use if I need them in my work.”
“Excellent SQL Server course with a clear structure.”
“Excellent course. You really come away with the basics! The trainer was very enthusiastic and delivered the course in an enjoyable way.”
“If you have no experience with sql and would like to learn the basics, this course is a good start! Now I know a bit about what sql involves.”
“This is a good course for learning the basics of SQL. It does help your understanding if you already know something about databases/files. In a number of programming languages, knowledge of SQL is already indispensable.”
"Learnit is a professional organisation with a personal approach. The SQL course was well matched to our starting level, and the trainer guided us through the material skilfully and with great enjoyment. Excellent!"
“My main learning objective was to be able to read and understand queries/scripts better. By writing scripts myself and getting to know a number of the possibilities of SQL, I have certainly achieved this objective. Simply practising with a few scripts yourself already gives you some insight and a foundation. You do have to put it into practice and keep practising at work or at home. Then the knack will certainly follow.”
“Valuable course with highly capable trainers, at a pleasant location.”
“The course has given me enough tools to get started with SQL. You gain the experience in practice, but this course gives you enough firm ground under your feet.”
“Enjoyable and instructive course with a good mix of theory and practice. The trainer presented it in a relaxed way and with humour, which made it all the more pleasant. Everything was well organised and I was able to apply what I had learned straight away!”
“This is a good course for learning the basics of SQL. It does help your understanding if you already know something about databases/files. In a number of programming languages, knowledge of SQL is already indispensable.”
“Very good, the trainer had a lot of knowledge. Good examples. Room for questions.”
“I have no experience at all with SQL. But the course was explained at a steady pace, so you could master the material. I would recommend it for beginners.”
“I would recommend this course to people who have never worked with SQL before; it is perfectly suited to that.”
“The course largely matched the impression I had from the brochure. Excellent trainer who was clear and to the point; took account of the different levels within the group and struck a good balance between theory and exercises.”
“Well-structured course. Good course material and reference work. The trainer has a sound knowledge of SQL and conveys it well.”
“A good course for taking the first step towards becoming an SQL expert.”
“A very good course for beginners, but certainly also a refresher for those with a little more experience.”
“It's a good training for filling in the gaps if you have patchy knowledge, due to on the job learning, like I did.”
“A good, practice-oriented programme, recommended for the increasingly popular field of Big Data.”
“The SQL Basics course at Learnit comes highly recommended. Personal attention, the quality of the course material and the training itself are, in a word, excellent. I was able to learn a great deal in 2 days. It provides a great foundation for growing into a professional super user if you want to move up to a higher level.”
“Good balance between presentation and doing exercises yourself. Good variation in the difficulty of the exercises, there were a few nice challenging ones among them. The trainer had a great deal of knowledge and explained clearly how to tackle a problem in a structured way.”
“Enjoyable and highly applicable course; you really get something out of it and you can put it into practice straight away. Highly recommended.”
“Clear explanation of SQL with plenty of usable examples and good exercises. It was all very manageable and after following this basic course I have gained more than enough knowledge to run all the queries we need on our database. And that has produced a lot of useful information. In short: an excellent course!”
“Very practical training course. Clear explanations and plenty of relevant exercises.”
“Good trainer, plenty of course material. I achieved my initial objectives.”
"It was all explained clearly and enthusiastically. The trainer came across as an expert. We received plenty of attention, but then again we were a small group. It met expectations. I achieved my learning objectives. The location was lovely too (Amsterdam, Muziekgebouw aan 't IJ)."
“This training course is ideal for people who are going to work with SQL databases. A lot is explained and the pace is never too slow. All kinds of queries are covered, as well as the combined use of different types. Highly recommended!”
“After this course you have a good picture of how SQL works. You also have good course material to fall back on and to keep practising with to your heart’s content in your own environment. If you want to learn SQL, this is the way to do it in my view.”
"Recommended! An enjoyable, informal way to broaden your knowledge."
“I found the combination of short explanations and exercises very pleasant. The trainer has an agreeable way of conveying knowledge and weaves practical experience into the course material.”
“The SQL Basics course at Learnit comes highly recommended. Personal attention, the quality of the course material and the training itself are, in a word, excellent. I was able to learn a great deal in 2 days. It provides a great foundation for growing into a professional super user if you want to move up to a higher level.”