SQL Developer is a graphical tool for database development. It mainly allows you to browse objects, run SQL statements and SQL scripts and edit and debug PL/SQL statements.
With this tool, you can also run a number of provided reports or make your own and save them. SQL Developer is compatible with any kind of relational database that supports SQL. It supports Oracle, Microsoft SQL Server, Microsoft Access, flat file databases such as DBF, Paradox tables and any other ODBC-compatible database
A database administrator (DBA) has to focus on keeping the SQL server running and doing it fast. Configuration of the server and the software is the prime responsibility of database administrator An administrator may adopt an approach of setting the server and leaving it like that since SQL server can grow or reduce any database automatically. The role of the SQL administrator towards proper sizing and configuration of the hardware is also required to be determined
CERTIFICATION:
Exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2014
Course Curriculum
| Course 20463D Implementing a Data Warehouse with Microsoft SQL Server 2014 | |||
| Introduction to Data Warehousing | 00:00:00 | ||
| Data Warehouse Hardware Considerations | 00:00:00 | ||
| Designing and Implementing a Data Warehouse | 00:00:00 | ||
| Creating an ETL Solution with SSIS | 00:00:00 | ||
| Implementing Control Flow in an SSIS Package | 00:00:00 | ||
| Debugging and Troubleshooting SSIS Packages | 00:00:00 | ||
| Implementing an Incremental ETL Process | 00:00:00 | ||
| Enforcing Data Quality | 00:00:00 | ||
| Using Master Data Services | 00:00:00 | ||
| Extending SQL Server Integration Services | 00:00:00 | ||
| Deploying and Configuring SSIS Packages | 00:00:00 | ||
| Consuming Data in a Data Warehouse | 00:00:00 | ||
