Advanced SQL with Backup and Restore

The following are the recipes we will be covering in this chapter:

• Exploring ordered analytic functions
• Using CASE statements
• Working with correlated subqueries
• Experimenting with JSON
• Partitioning tables column wise
• Archiving DD
• Archiving databases
• Archiving PPI tables
• Restoring a table
• Generating a unique row number