MSSQL Training Courses
Microsoft SQL (MSSQL) Server is a leading relational database management system.
NobleProg onsite live MSSQL training courses demonstrate through hands-on practice the fundamentals of MSSQL.
MSSQL training is available in various formats, including onsite live training and live instructor-led training using an interactive, remote desktop setup. Local MSSQL training can be carried out live on customer premises or in NobleProg local training centers.
I appreciated Fulvio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael Keymer - Markit Valuations Limited
Sebastian Huerta Martinez - Sartorius Corporate Administration GmbH
MSSQL Course Outlines
|ddavsvbsqls||Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012||21 hours||This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises. VB.NET Language in Visual Studio 2012 VB.NET Object Orientation VB.NET and Sql Server 2012|
|3092||SQL language in MSSQL||14 hours||The course answers questions How to build a query? What opportunities have SQL? What is a relational database? What is the structure and SQL commands?|
|66437||Microsoft SQL Server 2008/2012 (MSSQL)||14 hours||This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables.|
|67592||SQL Server 2008 Administration||28 hours||This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing of database requests Create and use full-text indexes Secure SQL Server and implement policy-based management Recover data Automate administrative tasks with the SQL Server Agent Use Dynamic Management Views to monitor the database and troubleshoot problems Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication|
|3033||Administering in Microsoft SQL Server||21 hours||The course is designed for administrators, developers and database developers. The objectives of the training: acquire and strengthen the skills to create and manage databases knowledge of the syntax and use SQL to retrieve and modify data apply safety rules in the database the use of advanced elements (replication, automation, BI) the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers|
|3119||Business Intelligence in MS SQL Server 2008||14 hours||Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS. The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line. The participant will acquire knowledge of scripting XML / A and MDX.|
|mssql2016||MS SQL Server 2016||14 hours||As a core of the Microsoft data platform, SQL Server is a leading operational database management system.|
|SQL100||T-SQL Fundamentals with SQL Server Training Course||16 hours||This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn: How to work with SQL Server and SQL Server Management Studio. Meaning of Databases, SQL and RDBMS etc. How to create tables, use DDL, DML and DAL. Which are the various RDBMS Packages in the market and how they compare with each other. An Introduction to NoSQL and how they are organizations are changing into hybrid databases.|
|Course||Course Date||Course Price [Remote / Classroom]|
|Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 - Cardiff||Wed, 2018-04-04 09:30||£3300 / £4200|
|T-SQL Fundamentals with SQL Server Training Course - Bristol, Temple Gate||Wed, 2018-04-04 09:30||£3300 / £3800|
|Microsoft SQL Server 2008/2012 (MSSQL) - Oxford||Thu, 2018-04-05 09:30||£2200 / £2750|
|SQL Server 2008 Administration - Plymouth Drake Circus||Mon, 2018-04-09 09:30||£4400 / £5000|