This course introduces students to PL/SQL .The Oracle database environment is one of the most popular environments and programs in the world. Although the Oracle database used in large companies, Oracle has introduced new products that can support the use of the Oracle environment in smaller organizations. In this course, you are taught database programming using PLSQL and you will learn how to create Procedures, Packages Functions, use control commands such as if statements and loop use Cursors to access data, check for exception and create Triggers to solve some problem when dealing with tables.
Course Objectives This course teaches developers the programming skills required for developers to create Windows applications using C #, students review the fundamentals of C language, program structure basics, syntax, and implementation details, then integrate their knowledge into creating an application that includes many features of the .NET Framework 4.5
The course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® TransactSQL. " This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.