Oracle and SQL Server Database Development

The Weblearning Oracle and SQL Server Database Development course combines Oracle SQL&PL/SQL and SQL Server Database design and T-SQL development foundation courses into a single solution for students wanting to start a highly rewarding career in Database administration and development.

On successful Completion of this course you will be able to:

• Understand Relational Database Concepts
• Understand Oracle and SQL Server Data Tools
• Writing SELECT queries
• Sorting and filtering data
• Using SQL aggregate functions
• Using SET operators
• Writing joins to query multiple tables
• Using built-in functions
• Using Subqueries
• Inserting, updating, deleting and merging rows
• Transaction control
• Creating and using views
• Using table expressions
• Enhanced Grouping and Pivoting data
• Using Windowing ranking, offset and ranking functions
• Creating and using Stored Procedures
• Controlling Program Flow
• Using Dynamic SQL
• Implementing Error Handling
• Improving Query Performance