SQL Server Training Courses
SQL Server Training Version
- SQL Introduction to Querying
Learn to: Use SQL and databases, Use SELECT statements. Use aggregate functions , Use the WHERE clause, Search for specific data, Write queries for aggregrate data, and Write multi-table queries. Use advanced queries, Query with subqueries, Add data to a database, Change and delete data from a database, Create, alter, and delete tables, Create, use, and delete views, Create and delete indexes, Use transactions, and Create and drop databases.
- Relational Database Design
Learn to: Analyze client requirements, Create a preliminary design, Implement the database design, Generate reports, and Customize a database.
- SQL Fundamentals of Querying
Learn to: Understand relational database concepts and SQL, Use SQL SELECT statements. Use aggregate functions, column aliases, and mathematical expressions in a query statement, Use the WHERE clause to select specific rows of information from a database, Search for specific character strings or numeric data in a database, Write queries that return both aggregate and non-aggregate data, and Write multi-table queries.
- SQL Advanced Querying
Learn to: Use advanced techniques for querying a database, Query with subqueries, Add data to a database, Change and delete data from a database, Create, alter, and delete tables, Create, use, and delete views, Create and delete indexes, Manage how data is altered through the use of transactions, and Create and drop databases.
- MySQL Database Fundamentals
Learn to: Identify the fundamental concepts of databases and explore the MySQL RDBMS interface elements, Create a preliminary database design, Apply normalization techniques to a database, Use SQL commands to execute simple queries, Use SQL compound statements to query efficiently, Manage databases by creating views, indexes, and transactions, and Administer and maintain a database.
SQL Server Training Version 2008
- SQL Server 2008 Administration
Learn to: Install and Configure SQL Server 2008, Create, Configure and Manage Databases, Create and Manage Tables, Implement and Manage Data Integrity, Create and Manage Indexes, Create and Manage Partitions, Use SQL Server 2008 Security, Implement Policy-Based Management, Transfer Data, Make Backups and Recovery, Harness SQL Server Automation, Monitor SQL Server, Maintain High Availability, Troubleshoot and Performance Tune, and Setup Replication.
- SQL Server 2008 Administration Fundamentals
Learn to: Install and Configure SQL Server 2008, Create Configure and Manage Databases, Create and Manage Tables, Implement and Manage Data Integrity, Create and Manage Indexes, Configure SQL Server 2008 Security, Transfer Data, Make Backups and Recovery, Harness SQL Server Automation, and Monitor SQL Server.
- SQL Server 2008 Introduction to Querying
Learn to: Understand SQL Server databases, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Combine and Limit Result Sets, Work with Subqueries, and Insert, delete and update data in tables.
- SQL Server 2008 Programming
Learn to: Use SQL Server Management Studio, Undertand SQL and Transact-SQL concepts, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Rank Grouped Data, Combine and Limitg Result Sets, Work with Subqueries, Optimise Queries, Use Crosstab Queries, Use Common Table Expressions, Insert, delete and update data in tables, Work with SQL Server Date and Time Data, Use Transactions and Locking, Query XML Data, Implement Views, Use Stored Procedures, Handling Errors, Implement User Defined Functions and Use Triggers.
SQL Server Training Version 2005
- SQL Server 2005 Reporting Services
- Maintaining a Microsoft SQL Server 2005 Database - Course 2780
- Implementing a Microsoft SQL Server 2005 Database - Course 2779
- SQL Server 2005 Querying with Transact-SQL
- Implementing and Maintaining Microsoft SQL Server 2005 Integration Services - Course 2792
- Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services - Course 2791
SQL Server 2000
SQL Server 6.5
Very good - the time flew by
- DLR
SQL Server Training at Systematix
Systematix provides Microsoft SQL Server training courses at many levels from systems administration to design and programing, and for all versions of Exchange. Our experienced trainers are knowledgeable and friendly and will answer all your questions and make sure you are happy with every topic that you need to cover.
What is SQL Server?
Microsoft SQL Server is the leading database management server. SQL Server exceeds dependability requirements and provides innovative capabilities that increase employee effectiveness, integrate heterogeneous IT ecosystems, and maximize capital and operating budgets. SQL Server provides the enterprise data management platform your organization needs to adapt quickly in a fast-changing environment.
Benchmarked for scalability, speed, and performance, SQL Server is a fully enterprise-class database product, providing core support for Extensible Markup Language (XML) and Internet queries.
- Easy-to-Use Business Intelligence (BI) Tools - Through rich data analysis and data mining capabilities that integrate with familiar applications such as Microsoft Office, SQL Server enables you to provide all of your employees with critical, timely business information tailored to their specific information needs.
- Self-Tuning and Management Capabilities - Revolutionary self-tuning and dynamic self-configuring features optimize database performance, while management tools automate standard activities. Graphical tools and wizards simplify setup, database design, and performance monitoring, allowing database administrators to focus on meeting strategic business needs.
- Data Management Applications and Services - SQL Server provides a powerful and comprehensive data management platform including extensive management and development tools, a powerful extraction, transformation, and loading (ETL) tool, business intelligence and analysis services, and new capabilities such as Notification Services.
Are you gaining the benefits that SQL Server has to offer?
Public SQL Server Training Courses
We offer public courses which have a standard content and take place at scheduled times. Alternatively we provide private courses which can be tailored to suit your particular learning requirements and delivered when and where you want them.
