[
{"label":"Introduction","menu":[
{"label":"Introduction","page":"introduction"}
]},
{"label":"SQL","menu":[
{"label":"Introducing SQL","page":"lesson-introduction","format":"markdown"},
{"label":"Understanding SQL","page":"lesson-1","format":"markdown"},
{"label":"Retrieving Data","page":"lesson-2","format":"markdown"},
{"label":"Sorting Retrieved Data","page":"lesson-3","format":"markdown"},
{"label":"Filtering Records","page":"lesson-4","format":"markdown"},
{"label":"Advanced Data Filtering","page":"lesson-5","format":"markdown"},
{"label":"Using Wildcard Filtering","page":"lesson-6","format":"markdown"},
{"label":"Creating Calculated Fields","page":"lesson-7","format":"markdown"},
{"label":"Using Data Manipulation Functions","page":"lesson-8","format":"markdown"},
{"label":"Summarizing Data","page":"lesson-9","format":"markdown"},
{"label":"Grouping Data","page":"lesson-10","format":"markdown"},
{"label":"Working with Subqueries","page":"lesson-11","format":"markdown"},
{"label":"Joining Tables","page":"lesson-12","format":"markdown"},
{"label":"Creating Advanced Joins","page":"lesson-13","format":"markdown"},
{"label":"Combining Queries","page":"lesson-14","format":"markdown"},
{"label":"Inserting Data","page":"lesson-15","format":"markdown"},
{"label":"Updating and Deleting Data","page":"lesson-16","format":"markdown"},
{"label":"Creating and Manipulating Tables","page":"lesson-17","format":"markdown"},
{"label":"Using Views","page":"lesson-18","format":"markdown"},
{"label":"Working with Stored Procedures","page":"lesson-19","format":"markdown"},
{"label":"Managing Transaction Processing","page":"lesson-20","format":"markdown"},
{"label":"Using Cursors","page":"lesson-21","format":"markdown"},
{"label":"Understanding Advanced SQL Features","page":"lesson-22","format":"markdown"}
]},
{"label":"Practice","menu":[
{"label":"Select Statements","page":"assignment-2","format":"json", "type":"assessment"},
{"label":"Sorting Retrieved Data","page":"assignment-3","format":"json", "type":"assessment"},
{"label":"Filtering Data","page":"assignment-4","format":"json", "type":"assessment"},
{"label":"Advanced Data Filtering","page":"assignment-5","format":"json", "type":"assessment"},
{"label":"Advanced Joining","page":"assignment-6","format":"json", "type":"assessment"},
{"label":"Using Data Manipulating Functions","page":"assignment-7","format":"json", "type":"assessment"},
{"label":"Summarizing Data","page":"assignment-8","format":"json", "type":"assessment"},
{"label":"Grouping Data","page":"assignment-9","format":"json", "type":"assessment"},
{"label":"Combining Queries","page":"assignment-10","format":"json", "type":"assessment"},
{"label":"Basic Select","page":"select-intro-assessment","format":"json", "type":"assessment"},
{"label":"Restricting Records","page":"select-where-assessment","format":"json", "type":"assessment"}
]},
{"label":"Code","menu":[
{"label":"Google Apps Script","page":"no-page"},
{"label":"VBA","page":"no-page"},
{"label":"Python","page":"no-page"},
{"label":"Node JS","page":"large-text"}
]},
{"label":"Tools","menu":[
{"label":"Query Editor","type":"javascript","page":"query_editor"},
{"label":"Tutorials","type":"javascript","page":"tutorials"},
{"label":"Grade Query Tester","page":"test-grader"}
]},
{"label":"System","hidden":true,"menu":[
{"label":"User Login","page":"login-user","hidden":false},
{"label":"Subscriptions","page":"subscriptions","hidden":false},
{"label":"Profile","page":"user-profile", "pane":"tool","hidden":false}
]}
]