The school has been structured in such a way as to supplement the basic knowledge acquired independently or through previous participation in the SQL01 training. Its content is not only a collection of good practices, but also advanced queries and original expressions. People who use SQL on a daily basis, work as analysts or use SQL databases and want to learn and expand their skills will find something for themselves here.
- You will learn good practices regarding the use of databases
- You will understand how the different types of table joins work
- You will see how to apply criteria and regular expressions
- You will understand the professional vocabulary that will help you navigate the world of databases
- You will learn how to use text and logical functions and how to perform operations on dates
- You will learn how to use grouping and aggregation
- You will learn good practices regarding the use of databases
- You will become familiar with the ranking functions and the OVER function
- You will understand how stored procedures and views work
- You will see what is the difference between a CTE and a subquery
Basic knowledge of SQL syntax (such as: SEL: ECT, FROM, JOIN, WHERE, GROUP BY, HAVING, or ORDER BY)
English
- The use of scheduling functions
- Window function OVER()
- ROW_NUMBER()
- RANK()
- DENSE_RANK()
- NTILE(n)
- Non-standard data grouping
- ROLLUP
- CUBE
- GROUPING SETS
- Glossaries, sums, differences and set products
- UNION
- UNION ALL
- EXCEPT
- INTERSECT
- Selected functions
- Text
- Date and time
- Mathematical
- Converting
- The use of several sources and data combining
- Subqueries
- CTE (Common Table Expression) queries
- The use of views
- Temporary tables
- Creating parameterised stored procedures
- Downloading, sending data
- data import
- BULK INSERT
- Sending SQL commands from VBA code in Excel (ADO Recordset)
- Performing an operation in a loop
- Navigating through records
- FETCH, OFFSET
- LAG, LEAD
- Data transformation (PIVOT / UNPIVOT)
- Recursive CTE
- Incremental sum