What is SQL Advanced
Now that you have mastered the basics of SQL and know how to query a database in all kinds of ways, we will look at more advanced concepts in this training. How do you ensure that your database remains fast even when it contains a lot of data? How do you ensure that no small errors creep into your queries because you repeat them more often? Who can do what in a database? All these topics and more will be covered.
You will be introduced to terms such as
- Dialects
- Constraints
- Views
- Features
- Stored Procedures
- Permissions
- Grants
- Explain
- Profiling
During the training, the application of what you learn is central and you are challenged to get started with the theory in practical cases. The training is given by people who work with SQL in practice and know what it is about. They want to pass on that practical knowledge.
Who should attend SQL Advanced
The SQL Advanced training is suitable for:
- People who have been working in a data role for a while
- Data Analysts
- Information Analysts
- Data Engineers
Prerequisites
Basic SQL skills and general knowledge of SQL. The ‘Introduction to SQL’ course addresses these topics and is ideally suited for pre-training. The basic SQL statements should be grounded. Some time hands-on experience with SQL is therefore strongly recommended.
During this training you need a laptop on which you can install software: MySql Community Server or PostgreSql.
Objectives
At the end of this training, the participant will be able to use SQL to:
- Efficiently query large amounts of data
- Compose complex queries that are reusable
- Making data available to a limited group of users
Classroom, online, blended and in-company
At Capgemini Academy you learn in the way that suits you. Do you prefer classroom training, online or a combination of the two (blended)? You can follow most training courses in-company: within your own organization. We use a variety of tools to make learning even more fun and effective. Consider videos, games, quizzes, webinars and case studies, for example. And you can always contact your trainer with any questions.
In-company training courses
With an in-company training you have several advantages:
- You choose the location.
- You train with your colleagues, ensuring it aligns with your practice.
- The trainer tailors explanations, examples and assignments to your organization.
- In consultation, exercises can be adapted to organization-specific questions.
Request more information or a quote.
