3-day course
Generating intelligence from raw data is an indispensable skill for every business analyst or Data Warehouse professional. Our 3-day SQL for Business Analysts course represents the finest training opportunity on the market today for any company seeking to leverage their data and derive actionable insights. This program requires a working knowledge of databases and some programming experience.
What You Will Learn:
- Database system concepts and design
- Data modeling, ER diagram, normalization forms
- Concept of tables, views, schemas, and data types
- Data manipulations: inserting, changing, and deleting data
- Using castings, case statements, operators, and predicates in SQL queries
- Enforcing business rules with constraints and triggers
- Basics of set theory, set operators in SQL
- Advanced SQL techniques: joins, common table expressions, sub-queries, functions, recursive queries
- Data Warehousing concepts, terminology, architecture, lifecycle
- OLAP vs. OLTP
- OLAP Functions, Grouping sets, ROLLUP and CUBE queries
- Data Mining concepts
Benefits of Attending:
- Through a series of practical examples and exercises, hands-on SQL skills will be greatly augmented
- Gain sound theoretical background knowledge of all major concepts and tools of SQL and Data Warehousing
- Learn tips and proven techniques of SQL, data queries, and report generation
For more details, e-mail training@adastracorp.com or call 905-881-7946.