SQL Learning Resources

16. SQL Learning Resources

16.1 BriteCore Support

BriteCore Support can help with:

• View definitions, field semantics, and logical layer troubleshooting.

• Performance guidance and query optimization.

• Feature questions and edge cases.

16.2 Public Resources

• W3Schools SQL - Excellent interactive guide to SQL fundamentals and syntax.

• SQL Tutorial - Covers SELECT, JOIN, GROUP BY, HAVING, and subqueries.

• Mode Analytics SQL Tutorial - Business-focused SQL practice with real datasets.

• MySQL Documentation - Official reference for functions, operators, and syntax (BriteCore uses MySQL).

16.3 In-Tool Learning

• SQL Primer (Section 9) - Quick reference for keys, joins, aggregation, and grouping.

• Left Sidebar View Browser - Click on any view to see its fields, data types, and relationships.

• Stock Reports - Open published reports to study their SQL and patterns.

16.4 Practice Exercises

1. Write a query to count policies by state using m_inforce_policies and v_revisions.

2. Build a report showing claims by status, with count and total loss amount.

3. Modify a stock report by adding a new WHERE condition or output column.