Mark Simon has been involved in training and education since the beginning of his career. He started as a teacher of mathematics but soon moved into IT consultancy and training because computers are much easier to work with than high school students! He has worked with and trained in several programming and coding languages, and currently focuses on web development and database languages. When not involved in work, you will generally find Mark listening to or playing music, reading, or just wandering about.

Focuses on modern SQL techniques, including inner/outer joins, common table expressions, and creating and using views

Includes weaknesses and edge cases to highlight areas where you need to be cautious

Helps you link your SQL skills to database design principles, and shows how design affects your approach to SQL

Chapter 1: SQL Sampler.- Chapter 2: Database.- Chapter 3: Filtering Data.- Chapter 4: Ordering Results.- Chapter 5: Calculating Column Values.- Chapter 6: Selecting from Multiple Tables.- Chapter 7: Aggregating Data.- Chapter 8: Working with Tables.- Chapter 9: SQL Techniques.- Appendix 1: Differences Between SQL Dialects.- Appendix 2: Working with Tables.- Appendix 3: A Crash Course in PDO.