SQL Training

We run scheduled courses in SQL at four levels. For course dates and prices please look at our course schedule.

SQL Introduction (Oracle / SQL Server) - 1 day

To give delegates an introduction to the features and capabilities of Structured Query Language (SQL). The course covers elements of ANSI SQL using either Oracle or SQL Server as an example database. After this course, delegates will have a good understanding of the SELECT statement including joining multiple tables, grouping, agregate functions and sorting data. Please click here for an outline.

Next courses:

17th September 2008

13th October 2008

12th November 2008

8th December 2008

Please call 01483 688488 to book.

SQL Advanced (Oracle / SQL Server) - 2 days

To develop the delegate’s use of SQL to manage a relational database, introducing data manipulation language and database definition language. After this course, delegates will have a good understanding of all DML statements (SELECT, INSERT, UPDATE, DELETE) and all of the DDL statements needed to build database objects (CREATE, DROP, ALTER). This course also covers the use of views, access control, transaction control, advanced select queries and using SQL scripts. Please click here for an outline.

Next courses:

18th & 19th September 2008

14th & 15th October 2008

13th & 14th November 2008

9th & 10th December 2008

Please call 01483 688488 to book.

Please contact us for detailed outlines. One-to-one or group bookings can also be arranged on dates to suit you and customised to your specific requirements. Please give us a call on 01483 688488.

Back to Courses

SQL Queries Training Courses for all major releases All levels of SQL Queries Training including customised training and fast-track On-site SQL Queries Training throughout the UK ensure that you get the most from your SQL Queries training. SQL Queries Info 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? 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. 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. SQL Queries Training Courses and Learning SQL Queries What can Systematix offer you? Our SQL Queries Instructors Are proven, certified instructor/industry experts Communicate effectively to students of all skill levels Combine software skills and practical business experience Make you feel at ease Include lots of practical, hands-on exercises Welcome questions during and after the course Customised SQL Queries courses SQL Queries course customisation. After evaluating your needs, we can easily customise course topics to meet your requirements. Classroom environment We know that the best way to become familiar with software is through expert instruction and lots of hands-on practice. We strive to make you feel comfortable in the training environment, and provide you with extensive group and individual tuition and guidance during the training day. Superior SQL Queries course manuals Serve as in-class training manuals and after-class reference guide Include step-by-step instructions Offer lots of hands-on exercises and reference information SQL Queries exercise files by web, email or disk We realise that SQL Queries courses and documentation cannot address every situation a user may eventually encounter. As a result, we offer students unlimited after class email support on any topic they have covered in training.