Create complex SQL statements such as the use of subqueries, complex case statements and analytic functions using an over clause. Create SQL Stored procedures and functions Basic knowledge of ETL processes, including knowledge of changed data capture techniques Basic data modeling skills including an understanding of star schemas/dimensional data modeling SQL tuning experience using multiple type of indexes, analyzing explain plans, creating aggregate tables and materialized views Creation, impl...
