8 SQL Server courses in Shoreham-by-Sea

ADMINISTERING MICROSOFT SQL SERVER COURSE DESCRIPTION This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. WHAT WILL YOU LEARN * Describe core database administration tasks and tools. * Configure SQL Server databases and storage. * Import and export data. * Monitor SQL Server. * Trace SQL Server activity. * Manage SQL Server security. * Audit data access and encrypt data. ADMINISTERING MICROSOFT SQL SERVER COURSE DETAILS * Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. * Prerequisites: Introduction to data communications & networking. * Duration 3 days ADMINISTERING MICROSOFT SQL SERVER COURSE CONTENTS * Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. * Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. * Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. * Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. * Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. * Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

SUPPORTING MICROSOFT SQL SERVER COURSE DESCRIPTION A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. WHAT WILL YOU LEARN * Install SQL server. * Backup SQL server databases. * Recover SQL server databases. * Secure SQL server databases. * Perform routine maintenance. * Automate tasks. SUPPORTING MICROSOFT SQL SERVER COURSE DETAILS * Who will benefit: Anyone working with Microsoft SQL server * Prerequisites: Supporting Windows server. * Duration 3 days SUPPORTING MICROSOFT SQL SERVER COURSE CONTENTS * SQL server introduction Platform, Tools, services. Installation. Creating databases. * Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. * Security Users, server roles, database roles. Permissions. * Monitoring Routine database maintenance. Performance data. * Jobs and alerts The SQL server agent, database mail, alerts, jobs.

QUERYING MICROSOFT SQL SERVER COURSE DESCRIPTION This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. WHAT WILL YOU LEARN * Write SELECT statements. * Create and implement views and table-valued functions. * Transform data by implementing pivot, unpivot, rollup and cube. * Create and implement stored procedures. * Add programming constructs such as variables, conditions, and loops to T-SQL code. QUERYING MICROSOFT SQL SERVER COURSE DETAILS * Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. * Prerequisites: Database fundamentals * Duration 5 days QUERYING MICROSOFT SQL SERVER COURSE CONTENTS * Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. * T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. * Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. * Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. * Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. * SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. * DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. * Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions * Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. * Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. * Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. * Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. * Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. * Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets * Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. * Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL * Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. * Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

MICROSOFT LYNC TRAINING COURSE DESCRIPTION This course teaches IT staff how to plan, design, deploy, configure, and administer a Microsoft Lync Server solution. The course emphasizes Lync Server Enterprise Unified Communications features focussing particularly on coexisting with and migrating from legacy communication services. The labs in this course create a solution that includes IM and Presence, Conferencing, and Persistent Chat. This course helps prepare for Exam 70-336. WHAT WILL YOU LEARN * Describe the Lync Server architecture. * Install and deploy Lync Server. * Use Lync Server management interfaces. * Deploy and manage clients. * Manage and administer dial-in conferencing. * Design audio and video for web conferencing. * Plan for instant message and presence Federation. * Deploy and configure persistent chat in Lync. * Configure archiving and monitoring services. * Troubleshoot Lync Server. * Describe the required daily, weekly, and monthly maintenance tasks. * Use SIP commands and analyze SIP logs. * Configure high availability features in Lync. * Design load balancing in Lync Server. * Backup and restore Lync Server data. MICROSOFT LYNC TRAINING COURSE DETAILS * Who will benefit: Technical staff working with Microsoft Lync. * Prerequisites: Supporting Windows 2008 or 2012. * Duration 5 days MICROSOFT LYNC TRAINING COURSE CONTENTS * Microsoft Lync Server architecture Lync Server architecture, Lync core capabilities, Lync design process, assessing infrastructure requirements and updating the design, planning for all Microsoft solutions framework phases. * Designing a Lync Server topology Infrastructure requirements for Lync Server, using the planning tool, using topology builder, server infrastructure, documentation. Hands on Environment preparation and Lync Server pools. * Users and rights in Microsoft Lync Server Managing Lync Server, role based access control. Hands on Using the management shell, configuring role-based access control. * Client/device deployment and management Deploy and manage clients, prepare for device deployment, IP phones. Hands on Clients. * Conferencing in Lync Server Introduction to conferencing in Lync Server, designing for audio\video and web conferencing, dial-in conferencing in Lync Server, managing and administering conferencing. Hands on Conferencing in Microsoft Lync. * Designing and deploying external access Conferencing and external capabilities of Lync Server, planning for IM and presence federation, designing edge services. Hands on Deploying Edge Server and Configuring Remote Access, Validating the Edge Server. * Deploying Lync Server persistent chat Overview of persistent chat architecture in Lync Server, designing persistent chat, deploying and persistent chat. Hands on persistent chat server. * Monitoring and archiving The archiving service, the monitoring service, configuring archiving and monitoring. Hands on Archiving and monitoring in Lync Server. * Administration and maintenance of Lync Lync Server troubleshooting tools, Lync Server operational tasks, Lync Server troubleshooting techniques. Hands on Lync administration tools, centralized logging service, analysing Lync Server logs and traces. * High Availability in Lync Server High availability in Lync Server, configuring high availability in Lync Server, planning for load balancing, designing load balancing. Hands on Configuring database mirroring, experiencing a scheduled SQL Server outage, experiencing an unscheduled SQL Server outage. * Disaster recovery in Lync Server Disaster recovery in Lync Server, tools for backing up and restoring Lync Server, critical Lync Server data to back up and restore, critical data to export and import, designing branch site resiliency. Hands on Configure pool pairing, experiencing a pool failure or outage. * Planning a migration to Lync Server Coexistence and migration, migration steps, planning for clients and devices. Designing a client migration and device migration strategy. Hands on Creating a migration plan, documenting the migration phases.

SUPPORTING MICROSOFT SHAREPOINT COURSE DESCRIPTION A concise hands on course enabling delegates to manage and administer a SharePoint site. WHAT WILL YOU LEARN * Perform initial farm configuration. * Use stsadm commands. * Manage content. * Secure SharePoint. * Customise SharePoint search. * Monitor and performance tune SharePoint. SUPPORTING MICROSOFT SHAREPOINT SERVER COURSE DETAILS * Who will benefit: Anyone working with Microsoft SQL server * Prerequisites: SharePoint Administrators. * Duration 2 days SUPPORTING MICROSOFT SHAREPOINT COURSE CONTENTS * SharePoint Introduction A SharePoint installation. Initial farm configuration. Creating a site collection. * Administering SharePoint Stsadm commands, automation with PowerShell. * Managing content Lists, libraries, items and documents * Security SecureStore, Users and groups, roles and role assignments. Permission levels. * SharePoint search Configure search, refine search. * SharePoint performance Diagnostic logging, logging levels, Health anaylzer, performance bottlenecks.

DATABASE FUNDAMENTALS TRAINING COURSE DESCRIPTION This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. WHAT WILL YOU LEARN * Describe core database concepts. * Create database objects. * Manipulate data. * Describe data storage. * Administer a database. * Create a relational database consisting of 3 related tables. DATABASE FUNDAMENTALS TRAINING COURSE DETAILS * Who will benefit: Those working with databases. * Prerequisites: None. * Duration 3 days DATABASE FUNDAMENTALS TRAINING COURSE CONTENTS * Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. * Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. * Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. * Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. * Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

WINDOWS POWERSHELL TRAINING COURSE DESCRIPTION This course is intended for IT Professionals who are already experienced in general Windows Server and Windows Client administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of Windows PowerShell, or any scripting language, is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Exchange Server, SharePoint Server, SQL Server, System Center, and others. WHAT WILL YOU LEARN * Work with Windows PowerShell pipeline. * Query system information by using WMI and CIM. * Work with variables, arrays, and hash tables. * Write advanced scripts in Windows PowerShell. * Administer remote computers. * Use advanced Windows PowerShell techniques. WINDOWS POWERSHELL TRAINING COURSE DETAILS * Who will benefit: IT professionals. * Prerequisites: Supporting Windows Server * Duration 5 days WINDOWS POWERSHELL TRAINING COURSE CONTENTS * Getting started with Windows PowerShell Overview and background of Windows PowerShell, Understanding command syntax, Finding commands. Hands on Configuring Windows PowerShell console & ISE application. Hands on Finding and running basic commands, Using the About files. * Cmdlets for administration Active Directory administration cmdlets, Network configuration cmdlets, Other server administration cmdlets. Hands on Windows Administration. Creating and managing Active Directory objects, Configuring network settings on Windows Server, Creating a web site. * Working with the Windows PowerShell pipeline Understanding the pipeline, Selecting, sorting, and measuring objects, Filtering objects out of the pipeline, enumerating objects in the pipeline, Sending pipeline data as output. Hands on Using the pipeline. Selecting, sorting, and displaying data. Hands on Filtering objects. Hands on Enumerating objects. Hands on Sending output to a file. Exporting user information to a file. * Understanding how the pipeline works Passing the pipeline data, Advanced considerations for pipeline data. Hands on Working with pipeline parameter binding. Predicting pipeline behaviour. * Using PSProviders and PSDrives Using PSProviders, Using PSDrives. Hands on Using PSProviders and PSDrives Creating files and folders on a remote computer, Creating a registry key for your future scripts, Create a new Active Directory group. * Querying system information by using WMI and CIM Understanding WMI and CIM, Querying data by using WMI and CIM, Making changes with WMI/CIM. Hands on Working with WMI and CIM. Querying information by using WMI, Querying information by using CIM, Invoking methods. * Working with variables, arrays, and hash tables Manipulating variables, arrays and hash tables. Hands on Working with variables, Using arrays, Using hash tables. * Basic scripting Introduction to scripting, Scripting constructs, Importing data from files. Hands on Basic scripting. Setting a script, Processing an array with a ForEach loop, Processing items by using If statements, Creating a random password, Creating users based on a CSV file. * Advanced scripting Accepting user input, Overview of script documentation, Troubleshooting and error handling, Functions and modules. Hands on Accepting data from users. Querying disk information from remote computers, Updating the script to use alternate credentials, Documenting a script. Hands on Implementing functions and modules. Creating a logging function, Adding error handling to a script, Converting a function to a module. * Administering Remote Computers Using basic Windows PowerShell remoting, Using advanced Windows PowerShell remoting techniques, Using PSSessions. Hands on Using basic remoting. Enabling remoting on the local computer, Performing one-to-one remoting, Performing one-to-many remoting. Hands on Using PSSessions. Using implicit remoting, Managing multiple computers. * Using background jobs and scheduled jobs Using background jobs, Using scheduled jobs. Hands on Using background jobs and scheduled jobs. Starting and managing jobs, Creating a scheduled job. * Using advanced Windows PowerShell techniques Creating profile scripts, Using advanced techniques. Hands on Practicing advanced techniques. Creating a profile script, Verifying the validity of an IP address, Reporting disk information, Configuring NTFS permissions, Creating user accounts with passwords from a CSV file. Hands on Practicing script development (optional)

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 GETTING STARTED * The Power BI ecosystem * Opening Power BI Desktop * Power BI's four views * Introduction to Dashboards 2 IMPORTING FILES * Importing data sources * Importing an Excel file * Importing a CSV file * Importing a database * Connect to an SQL Server Database * Import vs. Direct Query * Importing from the web * Importing a folder of files * Managing file connections 3 SHAPE DATA IN THE QUERY EDITOR * The process of shaping data * Managing data types * Keeping and removing rows * Add a custom column * Appending tables together * Hiding queries in reports * Fixing error issues * Basic maths operations 4 THE DATA MODEL * Table relationships * Relationship properties 5 MERGE QUERIES * Table join kinds * Merging tables 6 INSERTING DASHBOARD VISUALS * Things to keep in mind * Inserting maps * Formatting Maps * Inserting charts * Formatting Charts * Inserting a tree map * Inserting a table, matrix, and card * Controlling number formats * About report themes * Highlighting key points * Filter reports with slicers * Sync slicers across dashboards * Custom web visuals 7 PUBLISH AND SHARE REPORTS * Publishing to Power BI service * Editing online reports * Pinning visuals to a dashboard * What is Q&A? * Sharing dashboards * Exporting reports to PowerPoint * Exporting reports as PDF files 8 THE POWER QUERY EDITOR * Fill data up and down * Split column by delimiter * Add a conditional column * More custom columns * Merging columns 9 THE M FUNCTIONS * Inserting text functions * Insert an IF function * Create a query group 10 PIVOTING TABLES * Pivot a table * Pivot and append tables * Pivot but don't aggregate * Unpivot tables * Append mismatched headers 11 DATA MODELLING EXPANDED * Understanding relationships * Mark a date table 12 DAX NEW COLUMNS * New columns and measures * New column calculations * Insert a SWITCH function 13 INTRODUCTION TO DAX MEASURES * Common measure functions * Insert a SUM function * Insert a COUNTROWS function * Insert a DISTINCTCOUNT function * Insert a DIVIDE function * DAX rules 14 THE CALCULATE MEASURE * The syntax of CALCULATE * Insert a CALCULATE function * Control field summarisation * Things of note 15 THE SUMX MEASURE * X iterator functions * Anatomy of SUMX * Insert a SUMX function * When to use X functions 16 TIME INTELLIGENCE MEASURES * Importance of a calendar table * Insert a TOTALYTD function * Change financial year end date * Comparing historical data * Insert a DATEADD function 17 HIERARCHIES AND GROUPS * Mine data using hierarchies * Compare data in groups