SQL developer

You will master the SQL query language and its procedural extension PL/SQL. Learn how to collect, process and present data for analysis, be able to visualize information and understand how to use and configure your databases for various tasks.

Who is this course suitable for?

• Beginners in programming
• Get familiar with the SQL language and understand how databases work. Learn to manage data and work with SQL analytical functions. Develop your first corporate service and prepare for the start of a successful programming career.
• 
  
• 
  
• < strong>Technical support specialists
• Learn to optimize SQL queries and automate routine tasks using PL/SQL. With the help of new skills, you can apply for a higher salary or move to the position of a database developer.
• 
  
• Junior developers
• The skill of working with SQL is one of the key skills for any programmer. You will become familiar with the PL/SQL dialect, learn how to write complex queries and design reliable databases. Expand your range of skills and be able to take on more expensive projects.

What you will learn

• Write queries to databases: Get acquainted with the basic capabilities of SQL, learn how to build complex analytical reports and what are the recipes for preparing data.
• Create interfaces in Oracle Apex: Learn to visualize data and learn how to create a web application and set up a workbench in the Oracle Apex environment.
• Work with data: Learn how to make multi-table selections , create and link tables, group, filter, analyze and aggregate data using the functions sum, avg, count, having and others.
• Create your own databases: You will understand database objects, learn to write programs to process them and learn how to design your own databases for different purposes