• Mon - Saturday 08.00 - 20.00
  • 1st Floor North Westgate House, the High, Harlow, ESSEX, CM20 1YS
  • 0330 0240 989
  • [email protected]

Database Administrator Specialist Training Pack (With Microsoft, COMPTIA & CISCO)

Database Administrator Specialist Training Pack (With Microsoft, COMPTIA & CISCO)

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+ 2014 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.

Get Certified with WGS Career Academy today!

It’s simple, effective and affordable.

Units of Study

  • Networking Terminology
  • Locking Down Or Network
  • Wireless
  • Introduction To Security Terminology
  • Policies And Standards
  • Physical Security
  • Risk Analysis
  • Disaster Recovery, Business Continuity, and BIA (Business Impact Analysis)
  • Introduction To Computer Forensics
  • Types Of Attacks
  • System Security Threats
  • Security Assessments
  • Monitoring And Auditing
  • Authentication
  • Access Control
  • Mitigating Security Threats
  • Implementing System Security
  • Cryptography
  • Public Key Infrastructure
  • 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
  • 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
  • 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
  • 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 Part1
  • Working with Data Types Part2
  • Working with Data Types Part3
  • Other Data Types
  • Tables
  • Creating Tables
  • Data Constraints Part1
  • Data Constraints Part2
  • Planning In Indexing Part1
  • Planning In Indexing Part2
  • Planning In Indexing Part3
  • Planning In Indexing Part4
  • Table Structures
  • Working With Clustered Indexes
  • Clustered Indexes
  • Designing Effective Clustered Indexes
  • Improving Performance with NonClustered Indexes Part1
  • Improving Performance with NonClustered Indexes Part2
  • Improving Performance with NonClustered Indexes Part3
  • Using Indexes
  • Execution Plans Part1
  • Execution Plans Demo
  • Execution Plans Part2
  • Working with Views Part1
  • Working with Views Part2
  • Designing and Implementing Stored Procedures Part1
  • Designing and Implementing Stored Procedures Part2
  • Designing and Implementing Stored Procedures Part3
  • Merging Data and Passing Tables Part1
  • Merging Data and Passing Tables Part2
  • Merging Data and Passing Tables Part3
  • DesigningAndImplementingUserFunctions
  • 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 Part1
  • Handling Errors in TSQL Part2
  • Triggers
  • Implementing Managed Code Part1
  • Implementing Managed Code Part2
  • Implementing Managed Code Part3
  • Storing XML in SQL Part1
  • Storing XML in SQL Part2
  • Storing XML in SQL Part3
  • Querying XML Part1
  • Querying XML Part2
  • Querying XML Part3
  • Working with the Spatial Data Part1
  • Working with the Spatial Data Part2
  • Working with the Spatial Data Part3
  • Working With FullText Indexes and Queries Part1
  • Working With FullText Indexes and Queries Part2
  • Working With FullText Indexes and Queries Part3
  • Outro
  • 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 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 Part1
  • Designing A Physical Database Implementation Part2
  • Designing A Physical Database Implementation part3
  • 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 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 Part1
  • Desigining Database Security Part2
  • Contained Databases
  • Protecting Data with Encryption
  • Policy Based Management
  • Policy Based Management Demo
  • Monitoring Server Health
  • Monitoring Server Health Demo
  • 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
  • Managing Multiple Servers
  • Managing SQL Server With Windows Powershell
  • Windows Powershell Lab
  • Replicating Data Part1
  • Replicating Data Part2
  • Replicating Data Part3
  • Planning High Availability Part1
  • Planning High Availability Part2
  • Review of SQL Statements Part1
  • Review of SQL Statements Part2
  • Review of SQL Statements Part3
  • Eleven Rules Of Database Design
  • Conclusion
  • 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 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 Part1
  • Supporting Self Service Reporting Part2
  • Managing Report Execution And Delivery
  • Managing Report Execution
  • Subscriptions And Data Alerts
  • Creating Multidimensional Databases
  • Creating Data Sources And Data Source Views
  • Creating And Browsing a Cube
  • Working with Cubes And Dimensions
  • Sorting And Grouping Attributes
  • Introduction to MDX
  • Adding Calculations To A Cube
  • Customizing Cube Functionality Part1
  • Customizing Cube Functionality Part2
  • Customizing Cube Functionality Part3
  • Implementing A Tabular Data Model Part1
  • Implementing A Tabular Data Model Part2
  • Introduction to DAX
  • Demonstration Making A Tabular Model Part1
  • Demonstration Making A Tabular Model Part2
  • Using DAX
  • Implementing An Analysis Services Tabular Data Model Part1
  • Implementing An Analysis Services Tabular Data Model Part2
  • Deploying A Tabular Data Model
  • SQL Analysis Services Part1
  • SQL Analysis Services Part2
  • Performing Predictive Analysis With Data Mining
  • Using the Data Mining Wizard
  • Predictive Analytics Part1
  • Predictive Analytics Part2
  • 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
  • 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
  • Using SQL Server Data Tools Demo
  • Building An IS Integration Services Package Demo
  • Loading Data From Remote Sources Demo
  • 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
  • Drill Through Reports
  • Data Visualization
  • Creating Store Procedure From Scratch
  • Memory Optimize Table
  • 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
  • Backup Enhancements
  • Index Enhancements
  • Online DB Enhancements
  • Back Up To The Cloud
  • Partition Data
  • BI Review
  • Share Point Overview
  • Share Point Demo
  • Exam Prep
  • Before You Take The Exam
  • Conclusion
  • Networking Fundamentals
  • Basic Ethernet LAN Implementation
  • Designing Ethernet LANS
  • Understanding IPv4
  • Working With Cisco Routers
  • IPv4 Design And Troubleshooting
  • IPv4 Services
  • Implementing IPv6
  • Introducing Cisco Collaboration Architecture
  • Telephony And Call Routing
  • Preparing The Network And Phone Behavior
  • CUCM Administration Interfaces
  • Call Configuration

Curriculum

Curriculum is empty

Review and Rating

0

Average Rating

0 rating
5 stars
0
4 stars
0
3 stars
0
2 stars
0
1 star
0

Course fee

£775£975.00
14-days Money back
  • Lectures 0
  • Quizzes 0
  • Duration 70 hour
  • Skill level All levels
  • Max Students 1000
  • Language English

COURSE CODE

EC112714

TYPE

Online Course

COURSE ACCESS

1 Year

EXAMS INCLUDED

No

CERTIFICATION

    No

SYSTEM REQUIREMENT

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

COMPATIBILITY

Windows, Mac, iPhone, iPad, Android
  • Contact via:

SIGN IN

Forgot Password

Do not have an account? Register Now

X

ENQUIRY FORM

Complete the form below to receive more details about this course.

Yes, I’d like wgscareeracademy.com to contact me via email.

0330 0240 989