Data Analytics Bootcamp

• Learn how to use functions to speed up your workflow
• Add formatting and other visual effects
• Turn data into visual charts, including line, column, and pie charts
• Learn tips and tricks for easy workbook management

• Learn to split and join text, add data validation, and named ranges
• Use database functions and logical statements
• Create Pivot Tables to quickly summarize large databases
• Create advanced combo charts from multiple charts

• Cell management including cell locking, auditing, and hot keys
• Special formatting for calculating dates
• Use advanced functions and advanced analytical tools 
• Record macros and relative reference macros for ad hoc reporting

This Level I course covers SQL fundamentals including relational database management systems (RDBMSs), Microsoft SQL Server, and the SQL programming language. Through this course, you'll gain an understanding of how data is stored and you'll learn how to write queries to make sense of complex data.

Build upon SQL basics to achieve easier and more targeted data analytics. You'll learn how to use views, subqueries, math functions, and logic statements to find data that meet specific search criteria. You'll also learn how to increase report readability by using data conversion functions to format data.

This Level I course covers SQL fundamentals including relational database management systems (RDBMSs), Microsoft SQL Server, and the SQL programming language. Through this course, you'll gain an understanding of how data is stored and you'll learn how to write queries to make sense of complex data.

SQL III students learn how to build and maintain a highly efficient database that incorporates best practices in database management, including exporting external data, creating temporary tables, protecting data integrity, and maximizing procedural efficacy.