Working with:
Installing and Configuring SQL Server
Databases and Storage
Planning and Implementing a Backup Strategy
Importing and Exporting Data Whit Sql Server Integration Server SSIS
Monitoring SQL Server with Notifications and Alerts
Performing Database Maintenance, Automating SQL Server Management
Managing SQL Server Security
T-SQL Querying, Writing Queries,Querying Multiple Tables,Sorting and Filtering Data
DML to Modify Data and Built-In Functions
Grouping and Aggregating Data, Subqueries,Table Expressions
Window Ranking, Offset, and Aggregate Functions
Designing, Implementing and Executing Stored Procedures, Views, User-Defined Functions, Tiggers
Implementing Error Handling, Transactions
Pivoting and Grouping Sets
Designing and Implementing Databases and Advanced Table Designs (Partitioning and Compressing)
Ensuring Data Integrity Through Constraints, Indexes and Optimized Index Strategies.
SSRS Implementing and Configuartion. Managing SSRS Security
Design, Programing and Maintenance a wide variety of custom SSRS reports .
Implementing data warehouses, and BI tools such as Microsoft SQL Server Reporting Services (2005 or higher)