IT, Computing, Telecommunications courses Birmingham

...knowledge of the Red Hat Linux operating system to the level covered in the Administering Red Hat Linux - Part I & Part II courses.On completion of... Learn about: Securing and scripting on a Red Hat Linux system...

...to information technology in general would be useful. Course Objectives To provide the knowledge and skills needed to retrieve and update data held in a relational database... Learn about: Creating SQL statements to query a database table...

...update and delete records Manage sequences and synonymns Access the Data Dictionary Describe the Basic Structure of a PL/SQL Block Use PL/SQL IF Statements... Learn about: Using PL/SQL Index-By table built-in functions...

...Oracle Database SQL Expert (IZ0-047) Objectives: By the end of this course, the delegate will be able to: Describe the basic structure of a relational... Learn about: Updating and deleting rows in database tables...

...This Oracle Database 11g Release 2 DBA - Part I course is suitable for users of both Release 1 and Release 2. Skills Gained The delegate will practise... Learn about: Installing and Configuring Oracle, Creating and Managing an Oracle Database...

...They will also learn how to control database resources using the Resource Manager; how to automate administration tasks with the Scheduler and how to carry...

...On completion of the course the delegate will have a good working knowledge of how to manipulate the Shell as an environment interface and how to fully...

...and Pipe Utilities Shell Variables Shell Program Structure and Execution Positional Parameters Conditional Statements Looping Constructs Bash Shell Facilities... Learn about: Moving and deleting files and directories...

...They will have gained practical experience of configuring administrative, networking and security aspects of a Linux Enterprise system to an advanced level...

...MySQL database Use the MySQL Client Program and other interfaces Create a MySQL database Write SQL statements to select data from a MySQL database Use joins... Learn about: Using client programs to access a MySQL database...

...Understand MySQL Client/Server concepts Use advanced features of the MySQL Client Understand various types of Connector Use advanced data types Manage... Learn about: Performing advanced Insert, Replace and Truncate Operations...

...PL/SQL Programs Generating SQL*Plus and SQL Developer Output IF THEN ELSIF ELSE Statements CASE Expressions Basic Loops The WHILE and FOR Loops Nested...

...own login environment Who will the Course Benefit? Anyone who needs to understand and use the HP-UX Operating System. There are no formal pre-requisites... Learn about: Moving and deleting files and directories...

...utilise the Shell programming language. Suitable for: Personnel who need to know the HPUX Posix Shell programming language to be able to carry out their daily... Learn about: Allowing them to administer an HP-UX system...

...Skills Gained The delegates will practice: Creating, copying, renaming, moving and deleting files and directories Using the shell's redirection and... Learn about: Moving and deleting files and directories...

...On completion of the course the delegate will have a good practical knowledge of the LINUX Operating System, the command structures and the editor facilities... Learn about: Moving and deleting files and directories...

...will also gain the key skills required to work towards achieving the Novell Certified Linux Professional (Novell CLP - SLES 10) and the LPIC-1 & LPIC-2 certification status...

...Import and export data Perform complex joins to access multiple tables Perform complex subqueries Manage and use views Use variables and prepared statements... Learn about: Performing complex joins to access multiple tables...

...Understand MySQL Client/Server concepts Use advanced features of the MySQL Client Understand various types of Connector Use advanced data types Manage databases... Learn about: Replace and Truncate Operations, Performing advanced Insert...

...They will gain an understanding of the architecture of a MySQL database. They will be able to ensure the integrity and availability of a company's data within the MySQL environment... Learn about: To provide the skills necessary to administer, Monitor and support MySQL databases and servers...