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
Oracle and SQL Server Database Development CBT
- Brand: Weblearning Publishing
- Product Code: Oracle and SQL Server Database Development CBT
- Reward Points: 100
- Availability: In Stock
- £94.99
-
£79.99
- Price in reward points: 1200
Related Products
Oracle Database SQL Workshop
Oracle Database SQL Workshop This course is a combination of Oracle Database: SQL Workshop ..
£72.99 £89.99
Oracle Database Design and Programming with SQL CBT
Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..
£59.99 £79.99
Oracle Database Design and Programming with SQL eLearning
Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..
£59.99 £79.99
Oracle Database Design and Programming with SQL Training Guide
Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..
£23.99 £29.99
Oracle Database 12c Performance Management and Tuning
Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..
£79.99 £99.99
Oracle Database 12/19c Essentials Certified Implementation
Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..
£169.99 £329.99
SQL Server Database Design and Development
SQL Server Database Design and Development The SQL Server Database Design and Development course ..
£64.99 £94.99
Database Administration Unlimited
Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..
£320.00 £355.00
Oracle Database 23ai Data Warehousing Fundamentals
Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..
£110.99 £129.99
Oracle Database 23ai SQL Workshop
Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..
£84.99 £99.99
Oracle Database 19c Data Warehousing Fundamentals CBT
Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..
£79.99 £99.99
Oracle Database 19c Data Warehousing Fundamentals eLearning
Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..
£79.99 £99.99
Data Science Unlimited
Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..
£310.00 £348.00
AI & Machine Learning Unlimited
AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..
£310.00 £348.00
Big Data Unlimited
Big Data Unlimited Cloud Learning SubscriptionThe Big Data Unlimited Cloud Learning Subsc..
£365.00 £399.00
Big Data & Data Science VM Training Appliance
Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..
£249.00 £279.00
Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171
Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..
£124.00 £149.99
Tags: Database Management, Oracle Database, DB2, SQL, DBA