• SQL Advanced

  • Group Training

    You can query data with SQL, but you need more. You also want to be able to build effective queries for larger datasets that quickly give you the desired answer.

    Training code
    CGAADSQLCD
    Spoken Language
    Dutch
    Language Materials
    English
    Dayparts
    2
    Price
    €750,00
    excl. VAT No extra costs.

    Book SQL Advanced now

    In group training, we use several learning methods to help you obtain the knowledge, give you helpful insights and get you inspired. Check the Spoken language and Language materials on the left for language info.

    • 22-5-2023
      Utrecht
      €750,00
      €750,00
    • 27-11-2023
      Utrecht
      €750,00
      €750,00
     

    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.

    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
     
    Incompany

    You can query data with SQL, but you need more. You also want to be able to build effective queries for larger datasets that quickly give you the desired answer.

    Training code
    CGAADSQLCD
    Spoken Language
    Dutch
    Language Materials
    English
    Dayparts
    2
    Price
    €750,00
    excl. VAT No extra costs.

    With an Incompany training you have several advantages:

    - You choose the location
    - You experience the training with your colleagues, so it is always in line with your practice
    - The trainer can tailor explanations, examples and assignments to your organization
    - In consultation exercises can be adapted to organization-specific questions

    Request more information or a quote.

     

    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.

    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
     
  • Related

    Fields of Expertise
    Data Analytics
     
  • e-CF competences with this course

     

    At Capgemini Academy we believe in transparency and clarity in the training landscape. That is why, in the table below, we show you to which e-CF competence this training or certification contributes. For more information about how to use the e-Competence Framework read more here. If you want to know how you can apply the e-CF within your organization, read more on this page.

    e-Competence Level12345
    B.1.Application Development     
    D.10.Information and Knowledge Management