Course not currently available
MCSE: SQL Server 2012 Data Platform
-
The trainer was excellent and so professional with deep knowledge of his subject. The environment was so good and nice. The delivery of the course was superb and the staff was so welcoming
← | →
-
I have had the time of my life there. The course was fantastic and the training went really well. The trainer went smoothly throughout the process. The staff and the whole team including trainers were so friendly, polite and supportive. I had the time of my life there
← | →
-
Tutor is very precise and pays attention to details. Very good tutor.
← | →
Course
In City Of London ()
Maximise your chances of becoming more employable in the current competitive IT job market!
-
Type
Course
-
Level
Intermediate
-
Duration
6 Weeks
Be equipped with the skills that would facilitate you to demonstrate the ability to provide innovative solutions across multiple technologies to your clients with this MCSE: SQL Server 2012 Data Platform Course imparted by Training Square.
Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry currently. On achieving SQL Server 2012 certification, you will maximise your chances of becoming more employable and more marketable in the current competitive IT job market.
SQL Server 2012 can perform 1 million commands in just 1 second which makes it the fastest, reliable and robust solution for small to large enterprises. SQL Server 2012 also provides higher productivity for DBAs, System Admins and Application Developers. It is also capable to avoid mission critical outages or data loss and the Excellent BI and reporting tools, large scale data warehousing capabilities, make SQL Server 2012 stands out in the market.
So, if you want more information about this programme contact Training Square through Emagister.co.uk without hesitation. You won’t regret it!
About this course
Novice/Mediocre/Expert.
Computer Illiterate.
Diploma/Corporate Training/Hands-On Practical Training/Exam Preparation.
Expert, Industry Experienced and Certified Trainers.
State of the Art Facilities.
Maximum 5-6 Delegates Per Class. Quality that matters.
100% Practical Hands-on Training, Classroom Based and Instructor Led.
Flexible Starting Dates: Weekdays, Weekends and Evenings
Location: Central London.
Our Course Advicer will contact him/her and explain further about the Course.
Reviews
-
The trainer was excellent and so professional with deep knowledge of his subject. The environment was so good and nice. The delivery of the course was superb and the staff was so welcoming
← | →
-
I have had the time of my life there. The course was fantastic and the training went really well. The trainer went smoothly throughout the process. The staff and the whole team including trainers were so friendly, polite and supportive. I had the time of my life there
← | →
-
Tutor is very precise and pays attention to details. Very good tutor.
← | →
Course rating
Recommended
Centre rating
Alice
Jackson
Zoltan
James
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 10 years
Subjects
- Monitoring
- Access
- Transactions
- Market
- Audit
- XML training
- XML
- Data warehousing
- Database
- SQL
- Design
- Quality
- MCSE training
- Database training
- Warehousing
- Planning
- MCSE
Teachers and trainers (1)
Teaching Staff
Teacher
Course programme
Microsoft SQL Server 2012 and Tools
- Overview Microsoft SQL Server 2012
- MS SQL Server Management Studio
- Creating and Managing T-SQL scripts
- Microsoft SQL Server 2012 architecture
- Overview of SQL Azure
- Features of SQL Azure.
- Provision a SQL Azure server and configure its security.
- T-SQL Scripts, Sets, Predicate Logic
- Logical Order of Operations in SELECT statements
- SELECT Statements, filter data, sort data using ORDER BY
- SELECT statement, focusing on queries against a single table.
- Eliminating Duplicates with DISTINCT
- Using Column and Table Aliases
- CASE Expressions, DISTINCT clause
- Understanding Joins, Inner Joins, Outer Joins, Cross Joins, Self Joins,
- Multiple-Table Inner Join, self-joins and cross joins queries
- Sorting Data, WHERE Clause, TOP and OFFSET-FETCH, ORDER BY
- SQL Server 2012 Data Types, Character Data, Character Functions
- Writing Queries with Built-In Functions, Conversion Functions
- Using Logical Functions, Functions to Work with NULL
- Using Aggregate Functions, GROUP BY Clause,
- Filtering Groups with HAVING
- Correlated Subqueries, Self-Contained Subqueries
- Using Derived Tables, Common Table Expressions
- Using Views, Inline Table-Valued Functions
- Using EXCEPT and INTERSECT, Set Operators
- UNION set operators and UNION ALL multi-set operators
- CROSS APPLY and OUTER APPLY operators
- EXCEPT and INTERSECT operators
- PIVOT and UNPIVOT, GROUPING SETS subclause
- Querying System Catalog Views and Functions
- Executing System Stored Procedures
- Querying Dynamic Management Objects
- Querying System Catalog Views
- Querying System Functions
- Querying System Dynamic Management Views
- Passing Parameters to Stored Procedures, Dynamic SQL
- Pass parameters to stored procedures
- Execute system stored procedures
- Controlling Program Flow and Elements
- Variables and Delimiting Batches, Synonyms, Error Handling, TRY / CATCH Blocks, THROW
- Transactions and the Database Engine, Controlling Transactions, BEGIN, COMMIT, and ROLLBACK
- Adding error handling to a CATCH block
- Factors in Query Performance, Execution Plans, role of indexes
MS SQL Server 2012 and its Toolset
- SQL Server Platform, Server Tools, SQL Service Services, Component Installation
- SQL Server New Instance, Name Pipes Protocol, Aias
- Ensuring SQL Browser is Disabled and Configure a Fixed TCP/IP Port
- SQL Server Architecture, Resource Requirement,
- Test Server, Memory Configuration
- Installing SQL Server, Upgrading and Automating Installation
- Install the SQL Server instance, Configure Server Memory
- MS SQL Server Databases Data Files, Log files
- Working with Files and Filegroups
- Moving Database Files, tempdb configuration, RateTracking datbase
- Adjust tempdb configuration
- Create the RateTracking database
- Attach the OldProspects database
- Add multiple files to tempdb
- Backup Strategies, SQL Server Transaction Logging
- Planning a SQL Server Backup Strategy, Recovery Models
- Plan a backup strategy, Configure Reovery Models
- Critical concepts surrounding backup strategies.
- Transaction logging capabilities within the SQL Server database engine. .
- Backing up Databases and Transaction Logs, Managing Database Backups
- Working with Backup Options, Investigate backup compression
- Differential, Copy-only, Partial backup
- Restoring Databases, Restore Process, Point-in-time recovery
- Restoring System Databases and Individual Files
- Restore strategy, STANDBY mode
- Importing & Exporting Table Data, Inserting Data in Bulk
- Import the Excel spreadsheet, CSV File
- Authenticating Connections to SQL Server
- Authorizing Logins to Access Databases
- Authorization Across Servers, Create and Manage Logins, Database Users vs OS Users
- Server Roles, Fixed Database Roles, User-defined Database Roles, Check Role Assignments
- User Access to Objects, Execute Code, Permission Schema Level
- Auditing Data Access in SQL, SQL Server Audit
- Audit configuration and create audit
- Automating SQL Server Management
- SQL Server Agent, Agent Jobs
- Troubleshoot a Failing Job
- SQL Server Agent Security, Configuring Credentials
- Configuration of Database Mail, SQL Server Errors
- Monitoring SQL Server Errors, Alerts and Notifications
- Configuring Operators, Alerts and Notifications
- Ensuring Database Integrity, Maintaining Indexes
- Check database integrity using DBCC CHECKDB
- Correct index fragmentation
- Create a database maintenance plan
- Investigate table lock performance
- Capturing Activity using SQL Server Profiler
- Improving Performance with the Database Engine Tuning Advisor
- Configure SQL Trace
- Monitoring Activity, Capturing and Managing Performance Data
- Configure Management Data Warehouse
- Configure Instances for Data Collection
- Work with Data Collector Reports
- Working with Multiple Servers, Virtualizing, Data-Tier Applications,
MS SQL 2012 Data Warehousing
- Data Warehousing, Data Warehouse Solution, ETL solution
- Planning and Building a Data Warehouse
- Data Warehouse Reference Architectures and Appliances
- Logical Design for a Data Warehouse, Physical Design for a Data Warehouse
- Implementing a Star Schema, Snowflake Schema and Time Dimension Table
- ETL with SSIS, Source Data, Data, Flow
- Control Flow, Creating Dynamic Packages
- Using Containers, Managing Consistency
- Using Variables and Parameters, Containers, Transactions, Checkpoints
- Debugging an SSIS Package, Logging, Errors, Event Handler
- Incremental ETL, Extracting Modified Data
- Loading Modified Data, Using a DateTime Column to Incrementally Extract Data
- Using a Change Data Capture, Using Change Tracking
- Using a Lookup Transformation to Insert Dimension Data
- Using a MERGE Statement to Load Fact Data
- Cloud Data Sources, SQL Server Database
- The Windows Azure Marketplace, SQL Azure Database
- Data Quality, Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Match Data
- Creating a Matching Policy, DQS Project to Match Data
- Implement a Master Data Services
- Using the Master Data Services Add-in for Excel
- Enforcing Business Rules
- Overview of SSIS Deployment
- Planning SSIS Package Execution, Create a SSIS Catalog
- SSIS Solution
- Scheduling SSIS Packages with SQL Server Agent
- Business Intelligence, Reporting, Data Analysis, PowerPivot
Designing and Implementing Tables
- Designing Tables, Working with Schemas
- Creating and Altering Tables, Table Design
- Improving the Design of Tables
- Core Indexing Concepts
- Data Types and Indexes
- SQL Server Table Structures, Clustered Indexes,
- Comparing the Performance of Clustered Indexes vs. Heaps
- Implementing Nonclustered Indexes, Database Engine Tuning Advisor
- Nonclustered index, SQL Server Profiler and Database Engine Tuning Advisor
- Introduction to Views, Creating and Managing Views
- Performance Considerations for Views
- Introduction to Stored Procedures, Manage and Implement Stored Procedures
- Implementing Parameterized Stored Procedures
- Overview of Functions, Implementing Scalar Functions, Table-Valued Functions
- Introduction to Transactions, Locks, Deadlocks, Isolation Levels
- Implementing DML Triggers
- Designing DML Triggers
- Advanced Trigger Concepts
- Introduction to SQL CLR Integration
- Importing and Configuring Assemblies
- Storing XML Data and Schemas in SQL Server
- Introduction to XML and XML Schemas
- Implementing the XML Data Type
- XML Data Storage in SQL Server, XML Data in Variables
- Using the T-SQL FOR XML Statement
- XQuery, Shredding XML
- Query SQL Server data as XML
- Introduction to Full-Text Indexing, stoplist
Designing a Database Server Infrastructure
- Introduction to Database Server Infrastructure
- Planning a Database Server Infrastructure
- Planning for Consolidation, Single Instance, Single Windows Server, Virtual Servers
- Considerations for BLOB Data, Working with FileStream
- Using Full-text Search, Creating FileTable
- Optimizing Query Performance with Indexes,
- Performance Monitoring and Tuning
- Designing Database-Level Security, Server -Level Security, Transparent Database Encryption
- Security for MIA-SQL Instance and the Human Resources Database
- Implementing Security for SQL Server Agent
- Using the SQL Server Utility
- Creating a Utility Control Point, Configuring Health Policies
- Analyzing Server Health Issues
- Introduction to PowerShell, Backing up a Database Using PowerShell
- SQL Server Replication, Plan and Implementing Replication
Additional information
Discounted Price
£2700.00 (Actual Price £3000.00)
Or Choose from one of the following Finance Options @ 0% interest:
3 months - £300 Upfront and monthly payments of £900.00
6 months - £300 Upfront and monthly payments of £450.00
12 months - £300 Upfront and monthly payments of £225.00
Duration
6 Weeks or Fast Track 6 Days
MCSE: SQL Server 2012 Data Platform