Database Administrator Specialist Training Pack with Microsoft, CompTIA & Cisco)

Database Administrator Specialist Training Pack with Microsoft, CompTIA & Cisco)
£775
Finance

When it comes to a business’ success in engaging with customers, data is everything. Consequently, competent data administrators who are responsible for the performance, security and integrity of a company’s database are much in demand. This great-value online package is designed to make you that expert.

What Does the Package Involve?

You’ll start with CompTIA Security+ before gaining the skillset to be a Microsoft SQL Server 2012 database administrator. Then you’ll move on to creating and deploying database solutions and business intelligence solutions for an enterprise-class environment. Finally, you’ll work on the routing and switching skills needed to pass the Cisco 100-101 ICDN1 exam.

How Do I Learn?

Advancing your technical skills isn’t the big time or money commitment you think it might be when you choose to study online. Getting a year’s access to the practical, easy-to-engage-with course content means you can easily fit your study around your existing commitments.

KEY LEARNING POINTS

Progress through the modules to gain your database administrator expertise.

  • Begin with CompTIA Security by learning about networking and security terminology, locking down network, wireless, policies and standards, physical security, risk analysis, disaster recovery, business continuity and business impact analysis, computer forensics, types of attacks, system security threats, security assessments, monitoring and auditing, authentication, access control, mitigating security threats, cryptography and public key infrastructure.
  • Get to grips with SQL Server 2012 including T-SQL, SELECT queries, SQL data types, sorting and filtering data, querying data from multiple tables, modifying data, SQL server built-in functions, programming in T-SQL, implementing stored procedures, subqueries and table expressions, set operators, conditional operators, window functions, PIVOT, UNPIVOT, grouping sets, error handling, transactions, querying SQL server system and optimising query performance.
  • Learn about the SQL server platform, deploying and configuring SQL server, databases and server security, advanced security settings, encryption and compression, indexes, log files, back-up and restore, implementing high availability, optimising server performance, troubleshooting, recovering databases and performing advanced database management tasks.
  • Get confident with creating dimensions, changing granularity of dimensions, fact tables and Columnstore indexes, implementing a data warehouse in SQL Server 2012, integration services, control flow, dynamic variables, data flow, SSIS package execution, debugging and troubleshooting, deploying packages, securing packages and databases and working with MDS and Windows.
  • Learn about SQL 2012 and the 464 test, data types, tables, data constraints, planning and indexing, table structures, improving performance with Nonclustered indexes, indexes and execution plans, working with views, designing and implementing stored procedures, merging data and passing tables, designing and implementing user functions, creating highly concurrent SQL server applications, handling errors in TSQL, triggers, implementing managed code, storing XML in SQL, querying XML, spatial data and FullText indexes and queries.
  • Get to grips with designing a database server infrastructure, logical database scheme and physical database implementation.
  • Learn about incorporating data files into the database, tuning database performance, designing database security, policy-based management, monitoring server health, database backup solution, automating multi-server maintenance, managing SQL server with Windows PowerShell, replicating data, planning high availability, reviewing SQL statements and the eleven rules of database design.
  • Move on to business intelligence and data modelling, implementing reports with the SQL server reporting services, supporting self-service reporting, managing report execution and delivery, creating multidimensional databases, cubes and dimensions, measures and measure groups, MDX, cube functionality, tabular data models, DAX, implementing an analysis services tabular data model, SQL analysis services, creating data visualisations with power view, supporting self-service reporting, predictive analysis with data mining and predictive analytics.
  • Tackle database essentials, business intelligence development and results, advanced reporting and development, SSIS and SQL Server 2014 new features, before reviewing learning and preparing for the exam.
  • Get confident with network review, terminology and fundamentals, PKI, cryptography, AAA, secure access, VPNs, secure routing and switching, firewalls, IS and content and endpoint security.

ADVANTAGES OF THIS COURSE

  • Tailor the course content to your own pace by using the easy-to-use navigations and controls to pause, rewind and fast-forward.
  • Technical support is available, should you require it.
  • Access the course content for a year after signing up.
  • Use the Live Labs content to practise your new skillset in real-life scenarios.
  • Your expert instructor puts their 15 years+ of professional experience into practice by providing real-world scenarios for you to learn from.
  • Multimedia presentations, visual demonstrations, flash cards and educational games make learning fun and easy to engage with for all learning styles.
  • Advancing your database specialist skillset is an investment in your career that will get you noticed by potential employers.

Complete your career-boosting admin by signing up to Database Administrator Specialist Training Pack (with Microsoft, CompTIA & Cisco) today.

CompTIA SY0-501: Security+
  • Introduction
  • Managing Risk
  • Monitoring and Diagnosing Networks
  • Understanding Devices and Infrastructure
  • Identity and Access Management
  • Wireless Network Threats
  • Securing the Cloud
  • Host, Data, and Application Security
  • Cryptography
  • Threats, Attacks, and Vulnerabilities
  • Social Engineering and Other Foes
  • Security Administration
  • Disaster Recovery and Incident Response
  • Appendix A
  • Appendix B
Microsoft 70-461: Querying SQL Server 2012
  • Getting Started with SQL Server 2012
  • Working with T-SQL
  • Writing SELECT Queries
  • Working with SQL Data Types
  • Sorting and Filtering Data
  • Querying Data from Multiple Tables
  • Modifying Data
  • Working with SQL Server Built-in Functions
  • Programming in T-SQL
  • Implementing Stored Procedures
  • Working with Subqueries and Table Expressions
  • Working with Set Operators, Conditional Operators, and Window Functions
  • Working with PIVOT, UNPIVOT, and Grouping Sets
  • Managing Error Handling and Transactions
  • Querying SQL Server System
  • Optimizing Query Performance
Microsoft 70-462: Administering SQL Server 2012 Databases
  • Identifying the SQL Server Platform
  • Deploying SQL Server
  • Configuring SQL Server
  • Managing Databases in SQL Server 2012
  • Managing SQL Server Security
  • Implementing Advanced Security Settings
  • Applying Encryption and Compression
  • Working with Indexes and Log Files
  • Working with Backup and Restore
  • Implementing High Availability
  • Optimizing Server Performance
  • Troubleshooting Issues and Recovering Databases
  • Performing Advanced Database Management Tasks
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
  • Introduction to Data Warehouse
  • Creating Dimensions and Changing Granularity of Dimensions
  • Creating Fact Tables and ColumnStore Indexes
  • Implementing Data Warehouse in SQL Server 2012
  • Working with Integration Services
  • Managing Control Flow
  • Working with Dynamic Variables
  • Implementing Data Flow
  • Managing Data Flow
  • Managing SSIS Package Execution
  • Debugging and Troubleshooting
  • Deploying Packages
  • Securing Packages and Databases
  • Working with MDS and Windows
Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases
SQL 2012 And The 464 Test
  • Introduction to SQL Server 2012
  • Intro To SQL Server 2012 Part1
  • Intro To SQL Server 2012 Part2
  • Management Studio Demo Part1
  • Management Studio Demo Part2
  •  Management Studio Demo Part3
  • Other SQL Server Tools
Working with Data Types
  • Working with Data Types Part1
  • Working with Data Types Part2
  • Working with Data Types Part3
  • Other Data Types
Tables
  • Tables
  • Creating Tables
Data Constraints
  • Data Constraints Part1
  • Data Constraints Part2
Planning In Indexing
  • Planning In Indexing Part1
  • Planning In Indexing Part2
  • Planning In Indexing Part3
  • Planning In Indexing Part4
Table Structures
  • Table Structures
  • Working With Clustered Indexes
  • Clustered Indexes
  • Designing Effective Clustered Indexes
Improving Performance with NonClustered Indexes
  • Improving Performance with NonClustered Indexes Part1
  • Improving Performance with NonClustered Indexes Part2
  • Improving Performance with NonClustered Indexes Part3
Using Indexes And Execution Plans
  • Using Indexes
  • Execution Plans Part1
  • Execution Plans Demo
  • Execution Plans Part2
Working with Views
  • Working with Views Part1
  • Working with Views Part2
Designing and Implementing Stored Procedures
  • Designing and Implementing Stored Procedures Part1
  • Designing and Implementing Stored Procedures Part2
  • Designing and Implementing Stored Procedures Part3
Merging Data and Passing Tables
  • Merging Data and Passing Tables Part1
  • Merging Data and Passing Tables Part2
  • Merging Data and Passing Tables Part3
Designing and Implementing User Functions
  • DesigningAndImplementingUserFunctions
Creating Highly Concurrent SQL Server Applications
  • Creating Highly Concurrent SQL Server Applications Part1
  • Creating Highly Concurrent SQL Server Applications Part2
  • Creating Highly Concurrent SQL Server Applications Part3
Handling Errors in TSQL
  • Handling Errors in TSQL Part1
  • Handling Errors in TSQL Part2
Triggers
  • Triggers
Implementing Managed Code
  • Implementing Managed Code Part1
  • Implementing Managed Code Part2
  • Implementing Managed Code Part3
Storing XML in SQL
  • Storing XML in SQL Part1
  • Storing XML in SQL Part2
  • Storing XML in SQL Part3
Querying XML
  • Querying XML Part1
  • Querying XML Part2
  • Querying XML Part3
Working with the Spatial Data
  • Working with the Spatial Data Part1
  • Working with the Spatial Data Part2
  • Working with the Spatial Data Part3
Working With FullText Indexes and Queries
  • Working With FullText Indexes and Queries Part1
  • Working With FullText Indexes and Queries Part2
  • Working With FullText Indexes and Queries Part3
  • Outro
Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012
Designing A Database Server Infrastructure
  • Introduction
  • Designing A Database Server Infrastructure Part1
  • Designing A Database Server Infrastructure Part2
  • Designing A Database Server Infrastructure Part3
  • Designing A Database Server Infrastructure Part4
  • Considerations For Database Server Consolidation
  • Managing Server Resources
Designing A Logical Database Scheme
  • Designing A Logical Database Scheme Part1
  • Designing A Logical Database Scheme Part2
  • Designing A Logical Database Scheme Part3
  • Designing A Logical Database Scheme Part4
  • Designing A Logical Database Scheme Part5
Designing A Physical Database Implementation
  • Designing A Physical Database Implementation Part1
  • Designing A Physical Database Implementation Part2
  • Designing A Physical Database Implementation part3
Incorporating Data Files Into the Database
  • Incorporating Data Files Into the Database Part1
  • Incorporating Data Files Into the Database Part2
  • Incorporating Data Files Into the Database Part3
  • Incorporating Data Files Into the Database Demo
  • Searching Data Files
  • Searching Data Files Demo
Tuning Database Performance
  • Tuning Database Performance Part1
  • Tuning Database Performance Part2
  • Tuning Database Performance Part3
  • Working with Query Plans Part1
  • Working with Query Plans Part2
  • Working with Query Plans Part3
  • Working with Query Plans Part4
Desigining Database Security
  • Desigining Database Security Part1
  • Desigining Database Security Part2
  • Contained Databases
  • Protecting Data with Encryption
Policy Based Management
  • Policy Based Management
  • Policy Based Management Demo
Monitoring Server Health
  • Monitoring Server Health
  • Monitoring Server Health Demo
Designing Database Backup Solution
  • Designing Database Backup Solution Part1
  • Designing Database Backup Solution Part2
  • Designing Database Backup Solution Part3
  • Designing Database Backup Solution Part4
  • Disaster Recovery Plan Part1
  • Disaster Recovery Plan Part2
Automating Multi Server Maintenance
  • Automating Multi Server Maintenance
  • Managing Multiple Servers
Managing SQL Server With Windows Powershell
  • Managing SQL Server With Windows Powershell
  • Windows Powershell Lab
Replicating Data
  • Replicating Data Part1
  • Replicating Data Part2
  • Replicating Data Part3
Planning High Availability
  • Planning High Availability Part1
  • Planning High Availability Part2
Review of SQL Statements
  • Review of SQL Statements Part1
  • Review of SQL Statements Part2
  • Review of SQL Statements Part3
Eleven Rules Of Database Design
  • Eleven Rules Of Database Design
  • Conclusion
Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012
Introduction To Business Intelligence And Data Modeling
  • Introduction To Business Intelligence and Data Modeling Part1
  • Introduction To Business Intelligence and Data Modeling Part2
  • The Microsoft Business intelligence Platform Part1
  • The Microsoft Business intelligence Platform Part2
  • The Microsoft Business intelligence Platform Part3
  • The Microsoft Business intelligence Platform Part4
Implementing Reports The SQL Server Reporting Services
  • Implementing Reports the SQL Server Reporting Services Part1
  • Implementing Reports the SQL Server Reporting Services Part3
  • Implementing Reports the SQL Server Reporting Services Part2
  • Implementing Reports the SQL Server Reporting Services Part4
  • Implementing Reports the SQL Server Reporting Services Part5
  • Implementing Reports the SQL Server Reporting Services Part6
  • Implementing Reports the SQL Server Reporting Services Part7
  • Implementing Reports the SQL Server Reporting Services Part8
Supporting Self Service Reporting
  • Supporting Self Service Reporting Part1
  • Supporting Self Service Reporting Part2
Managing Report Execution And Delivery
  • Managing Report Execution And Delivery
  • Managing Report Execution
  • Subscriptions And Data Alerts
Creating Multidimensional Databases
  • Creating Multidimensional Databases
  • Creating Data Sources And Data Source Views
  • Creating And Browsing a Cube
Working With Cubes And Dimensions
  • Working with Cubes And Dimensions
  • Sorting And Grouping Attributes
Working With Measures And Measure Groups
Introduction To MDX
  • Introduction to MDX
  • Adding Calculations To A Cube
Customizing Cube Functionality
  • Customizing Cube Functionality Part1
  • Customizing Cube Functionality Part2
  • Customizing Cube Functionality Part3
Implementing A Tabular Data Model
  • Implementing A Tabular Data Model Part1
  • Implementing A Tabular Data Model Part2
Introduction To DAX
  • Introduction to DAX
  • Demonstration Making A Tabular Model Part1
  • Demonstration Making A Tabular Model Part2
  • Using DAX
Implementing An Analysis Services Tabular Data Model
  • Implementing An Analysis Services Tabular Data Model Part1
  • Implementing An Analysis Services Tabular Data Model Part2
  • Deploying A Tabular Data Model
SQL Analysis Services
  • SQL Analysis Services Part1
  • SQL Analysis Services Part2
Creating Data Visualizations With Power View
Supporting Self Service Reporting
Performing Predictive Analysis With Data Mining
  • Performing Predictive Analysis With Data Mining
  • Using the Data Mining Wizard
Predictive Analytics
  • Predictive Analytics Part1
  • Predictive Analytics Part2
Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012
Intro To Business Intelligence
  • Introduction
  • The Business Intelligence Solution
  • Overview Of Business Intelligence
  • BI And Power Pivot Demo
  • ETL Intro
  • Designing Data Warehouses
  • Design For Speed
  • BI Semantic Model
Database Essentials
  • Basic Database Objects Demo
  • Stored Procedures And Triggers Demo
  • Database Clusters Demo
  • SQL Server Management
  • Table Triggers
  • DB Config Options
  • DB Backup
  • DB Files And Restore
Business Intelligence Development
  • Using SQL Server Data Tools Demo
  • Building An IS Integration Services Package Demo
  • Loading Data From Remote Sources Demo
Business Intelligence Results
  • Processing Data From Web Service Demo
  • Report Building Intro Setup Demo
  • Using Report Builder Demo
  • Reporting From Multiple Tables Demo
  • Report Function And Matrix Demo
  • Interactive Reports Demo
  • Sorting Report Data Demo
Advanced Reporting And Development
  • Drill Through Reports
  • Data Visualization
  • Creating Store Procedure From Scratch
  • Memory Optimize Table
SQL Server Integration Services (SSIS)
  • Building Our First Integration Project
  • Data Transformation
  • Introduction To Big Data
  • Transformation Using Store Procedure
  • Transformation Using SSIS
  • Building Fact Table Using Store Procedure
  • Building Fact Table Using SSIS
SQL Server 2014 New Features
  • Backup Enhancements
  • Index Enhancements
  • Online DB Enhancements
  • Back Up To The Cloud
  • Partition Data
Course Review And Exam Prep
  • BI Review
  • Share Point Overview
  • Share Point Demo
  • Exam Prep
  • Before You Take The Exam
  • Conclusion
Cisco 100-105 ICND1 Interconnecting Cisco Network Devices Part 1
  • Networking Fundamentals
  • Basic Ethernet LAN Implementation
  • Designing Ethernet LANS
  • Understanding IPv4
  • Working With Cisco Routers
  • IPv4 Design And Troubleshooting
  • IPv4 Services
  • Implementing IPv6
Cisco 210-060 CICD: Implementing Cisco Collaboration Devices
  • Introducing Cisco Collaboration Architecture
  • Telephony And Call Routing
  • Preparing The Network And Phone Behavior
  • CUCM Administration Interfaces
  • Call Configuration
Course Code
EC112714
Type
Online Course
Course Access
1 Year
Exams Included
No
Processor
1 gigahertz (GHz)
RAM
1 GB
Operating Systems
Windows 7
Windows 8
Mac OS
iOS
Browsers
Internet Explorer 8 or above
Google Chrome
Safari 6 or above
Mozilla Firefox
Windows, Mac, iPhone, iPad, Android
Football Intermediary Diagnostic Test