Save 67%
      WGS Career Academy

      Database Administration

      WGS Career Academy
      Online

      £199
      Prefer to call the centre directly?
      33002... More
      Want to speak to an Advisor about this course?

      Important information

      Typology Course
      Level Intermediate
      Methodology Online
      Class hours 45h
      Duration 1 Year
      Start Different dates available
      Online campus Yes
      Support service Yes
      Virtual classes Yes
      • Course
      • Intermediate
      • Online
      • 45h
      • Duration:
        1 Year
      • Start:
        Different dates available
      • Online campus
      • Support service
      • Virtual classes
      Description

      Master the world’s most popular database systems with this comprehensive course that takes students through the fundamentals of querying and managing SharePoint Server, SQL Server 2012 and Oracle 11g.
      Using a blend of instructor led videos and self-study manuals, the Database Administration course contains everything students need to master SharePoint, SQL Server and Oracle. Delivered online, course contents are available anyplace anytime, to fit in around the student’s existing schedule. Participants can also learn from the experiences of others using the social networking tools built into the course platform. Learning is further reinforced through the use of end of section assessments help participants assess their own readiness for the final MCP/MCSE and OCA/OCP certification exams.

      Facilities (1)
      Where and when
      Starts Location
      Different dates available
      Online
      Starts Different dates available
      Location
      Online

      To take into account

      · What are the objectives of this course?

      Using vendor approved courseware, participants will gain an in-depth understanding of three of the most popular data storage systems in use today. SharePoint Server 2013 which offers superior document management services, the SQL Server 2012 relational database system, and the enterprise-class Oracle 11g database platform. Installing, configuring, managing and maintaining a SharePoint Server 2013. Configuring and managing profiles and permissions to secure data stored in SharePoint 2013. Configuring enterprise search and managing taxonomy to ensure users can find and access the information they need. Create and configure web applications and site collections. Design an information architecture and accompanying logical and physical architectures to build a corporate intranet that expands inline with business needs and priorities.

      · Who is it intended for?

      Database administrators who need to improve or qualify their querying and management skills. Document management specialists who want to better understand SharePoint Server and technologies that underpin it. Developers who need to better understand the working of common database platforms and how they may be leveraged in custom applications. Consultants who want to maximise their skill set to service the largest number of clients. IT professionals and others looking to move into database management roles.

      · Requirements

      Internet Explorer 8 or above Google Chrome Safari 6 or above Mozilla Firefox

      · What marks this course apart?

      Improved database management and querying skills that help them become more effective in their current roles. All the training and resources required to prepare for the MCSA SQL Server 2012, MCSE SharePoint Professional and Oracle OCA and OCP certifications. Real world skills that backup database theory. Increased knowledge and experience that will help improve employment and promotion prospects. A broad set of database-related skills that can be applied across multiple operating environments. The Database Administration course is a cost-effective solution for students who want to enhance their knowledge and experience, making them a valuable member of any database administration team.

      Questions & Answers

      Ask a question and other users will answer you

      What you'll learn on the course

      Transactions
      Database Administration
      Database training
      Server
      Sharepoint
      Database
      SQL
      microsoft
      Installing SharePoint
      Logical & Physical
      Site Collections

      Course programme

      Units of Study

      Learning Microsoft 70-331: SharePoint Server 2013 Core Solutions Course Curriculum
      • Comprehensive Introduction to Sharepoint
      • Installing SharePoint
      • SharePoint Architecture, Logical & Physical
      • Web Applications and Site Collections
      • Configure Service Applications
      • Permissions
      • Search
      • User Profiles
      • Ongoing Support And Maintenance
      Learning Microsoft 70-332: SharePoint Server 2013 Advanced Solutions Course Curriculum
      • Business Continuity
      • Model, Design, and Test
      • Upgrade and Migrate
      • Create and Configure Service Applications
      • SharePoint Management
      Microsoft Exam 70-461: Querying Microsoft SQL Server 2012 Certification Training Course Curriculum:

      Module 1
      • Introduction to SQL Server 2012
      • SQL Instances
      • Editions and Licensing
      • SQL Server Objects
      • System Databases
      • SQL Server Data Tools
      • Object Explorer
      • Object Scripting
      • Template Explorer
      • Query Tabs
      • Projects and Solutions
      • Customizing SSDT
      • Debugging T-SQL
      • SQLCMD
      • Exam Scenarios
      • Module Review
      Module 2
      • T-SQL Overview
      • T-SQL Elements
      • Batch Separators
      • Line Terminator
      • Variables
      • Control Flow
      • Expressions
      • Functions
      • Predicates and Operators
      • SELECT
      • Column Aliasing
      • SELECT Execution
      • Exam Scenarios
      • Module Review
      Module 3
      • SELECT Statements
      • Basic SELECT Statement
      • Specifying Columns
      • Derived Columns
      • Aliasing Columns
      • Calculated Columns
      • Ordering Results
      • Returning Distinct Results
      • Exam Scenarios
      • Module Review
      Module 4
      • Filtering
      • WHERE Syntax
      • BETWEEN
      • WHERE Syntax IN
      • Filtering NULL Values
      • LIKE
      • Data Type Comparison
      • Filtering Data with WHERE
      • TOP
      • OFFSET-FETCH
      • Exam Scenarios
      • Module Review
      Module 5
      • Join and Set Operators
      • Using Joins
      • Categories of Joins
      • INNER JOIN
      • OUTER JOIN
      • JOIN Demo
      • Set Operators
      • Set Operators Demo
      • Exam Scenarios
      • Module Review
      Module 6
      • Subqueries and Table Expressions
      • Subqueries
      • Self Contained Subquery
      • Correlated Subquery
      • Subquery Demo
      • EXISTS
      • Common Table Expressions
      • Temporary Tables
      • Table Variables
      • Table Demo
      • Exam Scenarios
      • Module Review
      Module 7
      • System Functions
      • Scalar Functions
      • ROWSET
      • System Function Demo
      • Aggregate Functions
      • DISTINCT
      • Aggregation Demo
      • GROUP BY
      • HAVING
      • Conversion Functions
      • Exam Scenarios
      • Module Review
      Module 8
      • T-SQL Programming
      • Logical Functions
      • IIF, CHOOSE and CASE
      • Logical Function Demo
      • Using Views
      • Stored Procedures
      • Functions
      • Triggers
      • Views Demo
      • TRY CATCH
      • Exam Scenarios
      • Module Review
      Module 9
      • Transactions
      • Introduction to Transactions
      • INSERT and UPDATE
      • DELETE and TRUNCATE
      • Transactions Demo
      • Managing Transactions
      • XACT_ABORT
      • Managing Transactions Demo
      • Exam Scenarios
      • Module Review
      Module 10
      • Query Performance
      • Indexing
      • Index Strategies
      • Indexes Demo
      • Execution Plans
      • Statistics IO
      • Execution Plans Demo
      • Exam Scenarios
      • Module Review
      • Program Review
      Microsoft Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 Certification Training Course Curriculum:

      Introduction to Data Warehouses
      • Overview of Data Warehouses
      • Examine Data Warehousing Concepts
      • Introduction to Data Analysis and Reporting Concepts
      Creating Dimensions and Changing Granularity of Dimensions
      • Create Dimensions
      • Change Granularity
      Creating Fact Tables and Columnstore Indexes
      • Create Fact Tables
      • Create Columnstore Indexes
      Implementing Data Warehouses in SQL Server 2012
      • Overview of Data Warehouse Components
      • Install Integration Services
      Working with Integration Services
      • Create an SSIS Project
      • Add Packages to an SSIS Project
      Managing Control Flow
      • Deploy a Control Flow
      • Execute Packages from Different Control Flow
      Working with Dynamic Variables
      • Create Expressions with Variables
      • Create Package Templates
      Implementing Data Flow
      • Add Data Flow Components to a Data Flow Task
      • Perform Transformation Tasks
      • Track Changed Data
      Managing Data Flow
      • Add Script Tasks and Script Components to an SSIS Package
      • Profile OLTP Data
      • Cleanse Data Using DQS
      Managing SSIS Package Execution
      • Execute SSIS Packages on the Server
      • Configure the Package Execution Strategy
      Debugging and Troubleshooting Packages
      • Debug Package Execution Components
      • Troubleshoot Package Failures
      Lesson 12: Deploying Packages
      • Deploy SSIS Packages
      • Examine MSI Packages
      Securing Packages and Databases
      • Secure Packages
      • Secure Databases
      Working with MDS and Windows Azure
      • Configure MDS
      • Work with MDS Databases
      • Work with Windows Azure
      Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052
      • Database Administration
      • Oracle Architecture
      • Database Schema
      • Recovery Manager
      • Introduction to SQL
      • Filtering and Sorting Data
      • Function
      • SET Operators and Subqueries
      • Regular Expressions and SQL*Loader
      • Course Review

      Compare to choose better:
      See all