Day 19. Using Advanced SQL Techniques
In Day 4, "Building a Database and Organizing Data," you learned how to create simple SQL statements that enable you to SELECT certain records from a table in a datasource. In today's lesson, you'll learn more about SQL and its advanced arsenal of selection techniques. You'll learn how to use SQL statements to work with databases that use unconventional table or field names, how to create queries within queries, and how to use SQL's special aggregate functions to find out more about the data you've selected. Users of server-based database applications such as Microsoft SQL Server, Oracle, and Sybase will also learn how to save commonly used SQL statements as stored procedures.
Today's lesson covers:
Column ...
Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
