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