Database Administration courses Birmingham

...As well as 6 x 20 credit compulsory modules, you will also undertake a 60 credit project. Core modules Programming in Data Science - 20 credits Storing and Managing...

...include roles in data science, data warehousing, consultancy, data security and data administration. The MSc Big Data Analytics course will provide... Learn about: IT Professional, Business Environment, Contemporary Tools...

...to Databases Functions of aDBMS Benefits of aDBMS Relational Database Structure SQLSyntax BasicSQLStatements Joining Tables Aggregate Functions Subquerie...

...This course is suitable for adults who do not currently hold any formal qualifications but have a basic knowledge of ICT. Course review:...

...hints and statistics. The module also covers the use of the Database Engine Tuning Advisor and index-related dynamic management views to assess indexing strategies...

...Program with PL/SQL. Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience...

...Configuring Shared Servers Creating and Managing Database Storage Structures Managing Redo Log Files and Control Files Managing Schema Objects Managing Users...

...(3 topics) Overview of Built In Aggregate Functions The GROUP BY Clause The HAVING Clause Joining Tables (7 topics) Overview of Table Joins Inner Joins... Learn about: Database training, Database Design, Database Administration...

...and Exporting Data Copying or Moving a Database Monitoring SQL Server 2014 Introduction to Monitoring SQL Server Dynamic Management Views and Functions...

...Delegates: This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for anyone intending to...

...Managing Redo Log Files and Control Files Managing Schema Objects Managing Users, Profiles, Privileges and Roles Managing Undo Data and Temporary Segments...

...Oracle Database 12c software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks. Modules... Learn about: Full Time, Database training, Database Design...

...Using the Table dual to try out Functions Numeric Functions Character Functions String Concatenation Date Arithmetic and Date Functions Conversion...

...Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Topics Covered... Learn about: Monitor and support MySQL databases and servers, To provide the skills necessary to administer...

...Delegates will also learn to manage memory effectively, carry out some evaluation and tuning exercises, control database resources using Resource Manager...

...Oracle Database 12c software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks. Modules... Learn about: Database training, Network Training, Database Administration...

...or Associative Arrays PL/SQL Table Built-in Functions Manipulating PL/SQL Tables or Associative Arrays...

...subqueries, grouping and aggregate functions Use SQL expressions and basic functions Insert, update, delete and replace data Create and alter tables... Learn about: Using client programs to access a MySQL database...

...It also describes how to use the xml data type and its methods. RetrievingXMLby UsingFORXML ShreddingXMLby UsingOPENXML Introducing XQuery Using the xml Data Type Lab...

...(4 topics) Overview of Subqueries Basic Subqueries Set Operators The Union,Intersect and Minus Operators... Learn about: Database training, Database Design...