End of month is approaching and you want to find the total sales per month; a simple SELECT statement might get you the data that you need, but sometimes more than that is required. What if you need to add a 5% bonus to the salesperson who sold most Piña Colada during the sizzling summer months of 2017?
We offer advanced SQL query training that allows for data to be retrieved from complex database structures, generating summaries and statistics, or even working with different file formats.
In certain situations, some logic might benefit from being stored on the DBMS rather than being coded in an external application. This will ensure consistency when multiple applications are developed and ensures data correctness.
While we will typically work with you to tailor the training to your needs, some key topics may include:
- Basic database concepts – Understanding the basic terminology. Installing a DBMS and setting up a database.
- Database planning – Understanding a database design based on an ERD.
- Retrieving data – Use of SELECT, filtering, sorting and set operations.
- Retrieving data from multiple tables – Different type of join operations that can be used to retrieve data from multiple tables.
- Inbuilt functions – The use of existing functions found in the DBMS.
- Database creation and manipulation – Using SQL to create a database based on an existing design. Using SQL to modify an existing database structure.
- Data manipulation – Inserting, updating and deleting data.
- Advanced Querying – Subqueries and table-expressions.
- Working with non-relational data – Processing data in XML or JSON format.
- Error Handling – Implementation of error handling using Try Catch, throwing errors and handling NULL values.
- Procedures and functions – Designing procedure and functions in SQL
- Triggers – Implementing triggers