SQL Training Courses
SQL 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 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 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 2000
SQL 6.5
Each of us returned extremely positive and motivated - the arrangements, as usual, ran like clockwork - we certainly felt the course was of benefit
- Local Charity
SQL Training at Systematix
Systematix provides Structured Query Language training courses at two levels, from fundamentals classes to advanced classes. 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?
SQL (Structured Query Language) standard interactive and programming language for getting information from and updating a database. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. You can:
- Get to grips with the SELECT command and extract the data you are interested in, calculate sums and averages, filter and order data
- Summarise data with GROUP BY and then filter it with HAVING, join multiple tables together with inner and outer joins.
- Develop UNION queries and advanced joins together with subqueries.
- Update records and delete records as well as inserting records, allowing you to maintain data.
- Plus lots more ...
Are you taking advantage of what SQL has to offer?
Public SQL 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.
