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
CERTIFICATION:
Exam 70-461 Querying Microsoft SQL Server 2014
Course Curriculum
| Course 20461D Querying Microsoft SQL Server 2014 | |||
| Introduction to Microsoft SQL Server 2014 | 00:00:00 | ||
| Introduction to T-SQL Querying | 00:00:00 | ||
| Writing SELECT Queries | 00:00:00 | ||
| Querying Multiple Tables | 00:00:00 | ||
| Sorting and Filtering Data | 00:00:00 | ||
| Working with SQL Server 2014 Data Types | 00:00:00 | ||
| Using DML to Modify Data | 00:00:00 | ||
| Using Built-In Functions | 00:00:00 | ||
| Grouping and Aggregating Data | 00:00:00 | ||
| Using Subqueries | 00:00:00 | ||
| Using Table Expressions | 00:00:00 | ||
| Using Set Operators | 00:00:00 | ||
| Using Window Ranking, Offset, and Aggregate Functions | 00:00:00 | ||
| Pivoting and Grouping Sets | 00:00:00 | ||
| Querying data with Stored Procedures | 00:00:00 | ||
| Programming with T-SQL | 00:00:00 | ||
| Implementing Error Handling | 00:00:00 | ||
| Implementing Transactions | 00:00:00 | ||
| Appendix 1: Improving Query Performance | 00:00:00 | ||
| Appendix 2: Querying SQL Server Metadata | 00:00:00 | ||
