Advanced SQL concepts include joins, grouping, aggregate functions, and Common Table Expressions (CTEs). ER diagrams can be generated using tools like MySQL Workbench and SQL Server Management Studio.