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
Write a query to count policies by state using m_inforce_policies and v_revisions.
Build a report showing claims by status, with count and total loss amount.
Modify a stock report by adding a new WHERE condition or output column.