Computer Science

SQL Advanced level for Analysts

SQL Advanced level for Analysts

  • Editor
  • ISBN
  • Price
  • Publication Year
  • Publisher
  • Binding
  • Description
  • About the Editor
    • Covers complex query techniques: window functions, common table expressions, and advanced subquery patterns.
    • Teaches performance tuning strategies-index design, execution plan analysis, and query optimization.
    • Demonstrates data modelling for analytics, including star and snowflake schemas, and advanced ETL transformations.

Lucy Laurent is a data analyst and SQL specialist who trains analysts in advanced querying techniques for business intelligence. With a Master's in Data Science, she has developed complex SQL stored procedures and window-function solutions for retail and e-commerce analytics. Lucy's blog posts on query optimization and performance tuning are widely referenced in the analytics community. She teaches corporate training sessions on data modeling, CTEs, and dynamic SQL generation. Her current research examines integrating SQL with in-database machine-learning routines to streamline predictive workflows.