“Any Data, Any Size, Anywhere for Anybody”
This is Microsoft’s slogan for its SQL Server 2012 product!
More than a simple database engine, SQL Server is a complete data management and analysis platform guaranteeing optimal performance, enhanced security and a set of advanced functions (cloud, agility, BI, .. .)
Come and discover this platform and benefit from the experience of our collaborators by following our courses.
SQL Server 2016 : Administer a database infrastructure
Duration : 5 days
Goals :
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
- Protect data with encryption and auditing
- Describe recovery models and backup strategies
- Back up data SQL Server databases
- Restore SQL Server databases
- Automate database management
- Configure security for SQL Server agent
- Manage alerts and notifications
- Manage SQL Server via PowerShell
- Trace access to SQL Server
- Monitor SQL Server infrastructure
- Troubleshoot SQL Server infrastructure
- Import and export dataSQL Server (20761) : Writing Queries with Transact SQL
Duration : 5 days
Goals :
- Describe key features and components of SQL Server
- Describe T-SQL and logical predicates
- Write SELECT queries
- Write queries on multiple tables
- Write SELECT queries to sort and filter data
- Describe usage data types in SQL Server
- Write DML queries
- Write queries that use built-in functions
- Write sub-queries
- Create and implement views and functions of table values
- Use the set of operators to combine query results
- Use classification, shift and aggregation functions
- Transform data using pivot, unpivot, roolup and cube
- Create and execute stored procedures
- Program with T-SQL
- Set up management of error
- Implement transactionsSQL Server 2016 (20761) : Writing Queries with Transact SQL
Duration : 5 days
Goals :
- Describe key features and components of SQL Server
- Describe T-SQL and logical predicates
- Write SELECT queries
- Write queries on multiple tables
- Write SELECT queries to sort and filter data
- Describe usage data types in SQL Server
- Write DML queries
- Write queries that use built-in functions
- Write sub-queries
- Create and implement views and functions of table values
- Use the set of operators to combine query results
- Use classification, shift and aggregation functions
- Transform data using pivot, unpivot, roolup and cube
- Create and execute stored procedures
- Program with T-SQL
- Set up management of error
- Implement transactionsSQL Server 2016 (20762) : Developing databases
Duration : 5 days
Goals :
- Knowing how to create databases and database files
- Knowing how to create stored procedures and functions
- Knowing how to implement managed code in the database
- Knowing how to implement data integrity in Microsoft SQL Server 2016
- Understand how to use indexes to guarantee the performance of the database
- Knowing how to use Transact SQL to handle exceptions, create triggers
- Learn to use SQL Server’s specialized data types to manipulate hierarchical XML data or to manage spatial location dataSQL Server 2016 (20765) : Database Provisioning
Duration : 5 days
Goals :
- Understand how to install or update a SQL Server instance
- Have the necessary skills for database maintenance
- Know how to optimize aspects relating to information storage
- Be able to migrate a local database to SQL AzureSQL Server Initiation
Duration : 4 days
Goals :
- Carry out any schemas and queries for MS-SQL
- Know the main functionalities offered by MS SQL Server
- Install, maintain, administer an MS SQL server
- Create and maintain an MS SQL server optimallySQL Server Advanced
Duration : 2 days
Goals :
- Optimally create and maintain an MS SQL serverTransact SQL (T-SQL)
Duration : 3 days
Goals :
- Mastering Transact SQLSQL Server 2014 : Queries (Course MS20461 – Exam 70-461)
Duration : 5 days
Goals :
- Write SELECT queries
- Write queries on multiple tables
- Sort and filter data
- Modify data with Transact-SQL
- Program with T-SQLSQL Server 2014 : Administer a database (Course MS20462 – Exam 70-462)
Duration : 5 days
Goals :
- Describe the main administration tasks and database tools
- Install and configure SQL Server 2014
- Configure SQL Server databases and storage
- Monitor SQL Server
- Audit data access and encrypt dataSQL Server 2014 : Setting up a Data Warehouse (Course MS20463 – Exam 70-463)
Duration : 5 days
Goals :
- Describe data warehouse concepts and architectural needs
- Select the appropriate hardware platform for a data warehouse
- Design and implement a data warehouse
- Debug and troubleshoot SSIS packages
- Deploy and configure SSIS packagesSQL Server 2014 : Database Development (Course MS20464 – Exam 70-464)
Duration : 5 days
Goals :
- Present the SQL server platform and its major tools
- Read and interpret details of common elements from execution plans
- Design and implement views and stored proceduresSQL Server 2014 : Designing Database Solutions (Course MS20465 – Exam 70-465)
Duration : 5 days
Goals :
- Evaluate the existing business environment
- Plan and implement policy-based management
- Describe the needs to consolidate workloads with SQL Server 2014
- Use Microsoft Azure storage with SQL Server 2014
- Plan high-level solutions Availability and Disaster Recovery
- Plan and implement database replicationSQL Server 2014 : Implementing Data Models and Reports (Course MS20466 – Exam 70-466)
Duration : 5 days
Goals :
- Describe the components, architecture and nature of a BI solution
- Create a multidimensional base with Analysis Services
- Implement the dimensions of a cube
- Implement the measures and groups of measures in a cube
- Use the MDX syntax
- Implement a model of tabular data in SQL Server Analysis ServicesSQL Server 2014 : Business Intelligence and Big Data Solutions Design (Course MS20467 – Exam 70-467)
Duration : 5 days
Goals :
- Describe the key points and benefits of self-service BI
- Use SQL Server Reporting Services to implement a reporting solution
- Design and implement Big Data processes for self-service BI support