Additional information
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. 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.