Classroom
2 days1100,-
excl. VAT
- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
With SQL you can retrieve information from an Oracle database at high speed. You learn how to query, filter, combine and edit data, and how to derive well-founded insights from it.
Description
Companies are collecting more and more data, but without the right query language that data remains unused. Oracle is one of the most widely used database systems in the world, and SQL is the language you use to extract information from it. During this course you will learn how to combine the two.
You start with the basic principles: data types, keys and simple SELECT queries in Oracle SQL Developer. You then build on this with filters, sorting, calculations and functions. On day two you get to work with joins, subqueries and modifying data and tables.
The trainer alternates theory with demonstrations and plenty of practical exercises. You work at your own pace and can raise questions from your own practice. That way you leave with a working toolkit.
Topics
Day 1: Introduction to SQL and simple queries
- Basic principles of SQL: data types, primary key and foreign key
- Working with Oracle SQL Developer
- Retrieving data with SELECT FROM, TOP and DISTINCT
- Sorting with ORDER BY
- Filtering with WHERE, comparison operators and BETWEEN
- Advanced filtering with AND, OR, IN and NOT
- Filtering with wildcards (LIKE)
- Calculations and concatenation
Day 2: Advanced queries in Oracle
- Using functions: ROUND, LTRIM, RTRIM, DATEPART
- Summarising with COUNT, SUM, AVG, MAX and MIN
- Grouping with GROUP BY and HAVING
- Subqueries with IN
- Combining tables with INNER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN
- Table aliases and advanced joins
- Combining queries with UNION
- Adding, modifying and deleting data (INSERT, UPDATE, DELETE)
- Creating and managing tables (CREATE, ALTER, DROP)
Result
After this course you will understand how an Oracle database is structured and you will be able to write queries independently to retrieve, filter, combine and edit data. You will know how to merge data from several tables using joins, how to apply subqueries and how to modify tables with INSERT, UPDATE and DELETE. This allows you to turn data into usable information more quickly in your work as an application manager, data analyst, developer or DBA.
Target audience
This course is intended for anyone starting out with Oracle databases who wants to learn to write queries themselves. Think of application managers, novice Oracle SQL developers, database administrators, BI professionals, data analysts and software developers who want to support their work with SQL.
Teaching method
You work in a small group under the guidance of an experienced database trainer. Theory alternates with demonstrations and plenty of practical exercises in a real Oracle environment. Beforehand you receive a workbook with practice cases, which you can then use as a reference work. The course materials and the software are in English.
Prior knowledge
No prior knowledge of SQL or Oracle is required. Basic computer experience and logical thinking are enough to follow the course successfully.
Comments
Would you prefer a platform-independent SQL basics course? Then take our SQL basics. Are you looking for a basic SQL course aimed specifically at Microsoft SQL Server? Then register for our course Transact-SQL Basics - MS SQL Server.
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.
Language
The training is given in Dutch as standard. The trainer has a good command of English. English-language course material can be used. With a minimum enrolment of 3 participants, the training can also be given entirely in English.
