SQL for Complete Beginners

£2.99

SQL for Complete Beginners

A friendly, step-by-step course that teaches you to read and write SQL queries using a simple shop database of orders and customers. You will filter, sort, summarise and join tables, with worked examples from small UK businesses, action tasks, workbook pages and a tracker with a query log to build your own library of reports. The lessons - Lesson 1: What SQL Is and Why It Helps - Lesson 2: SELECT and FROM - Lesson 3: Filtering With WHERE - Lesson 4: Sorting and Calculating - Lesson 5: Summaries With GROUP BY - Lesson 6: Joining Tables - Lesson 7: Good Habits and Next Steps Includes - 49 course slides as PowerPoint and PDF, with notes for every slide - 15-page fillable workbook (type into it or print it) - Excel tracker: Query Log, Practice Tracker, Data Dictionary - 30-day plan as a spreadsheet tab and a printable page By the end you will - Explain tables, rows, columns and keys in…

More like this