-
All
- Online
-
Filters
SQL courses London
- Course
- Londonand5 other venues
- Manchester, Birmingham, Bristol, Leeds, Edinburgh
- 3 Days
...By the end of this course, the delegate will be able to: Describe the basic structure of a relational database, Use the command line features of SQL*Plus, Use SQL Developer to access an Oracle Database, Create SQL statements to select data from an Oracle Database, Use SQL run time parameters...
- Course
- Londonand2 other venues
- Manchester, Birmingham
...suggested follow-on Oracle and MySQL/MariaDB courses. You may wish to review the content of the three day Oracle SQL course, the three day Introduction...
- Course
- London
- Different dates available
...This is a new course and we are still developing the course outline. Please visit our website again for further details. Using the free Microsoft SQL Server...
- Course
- London
- Different dates available
- 1 Day
...This course is designed to help students understand and use Big SQL. Students will learn to use different BigInsights components to access Big SQL to access and analyze their Hadoop data Next, the course will cover Big SQL data types where students will learn how to work with the data in Big...
- Course
- Londonandanother venue.
- Edinburgh
- 5 Days
...By the end of this course, the delegate will be able to: Describe the structure of a relational database, Use the command line features of SQL*Plus and SQL Developer, Create SQL statements to select data from an Oracle database, Use single row functions, Use enhanced grouping functions, Generate...
- Course
- London
...foreign keys Joins Components of SQL Data Manipulation Language SELECT operations DISTINCT Virtual columns Column aliases Functions Restricting the...
- Course
- London
- Different dates available
...Using the popular and free SQLite database management system used extensively by Apple and Microsoft you will learn how to create, manage and query databases... Learn about: Database Management, Database training...
- Course
- London
- 8 Weeks
.... Suitable for: This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database...
- Course
- Londonand2 other venues
- Leeds, Edinburgh
- Advanced
- 2 Days
...By the end of this course, the delegate will be able to: Use SQL Developer as an alternative to SQL*Plus, Manage Schema Objects with Data Dictionary Views, Write Multiple Column Subqueries, Manage Large Data Sets with Subqueries, Construct Hierarchical Queries, Use the ROLLUP, CUBE and GROUPING...
- Course
- Londonand6 other venues
- Manchester, Bristol, Birmingham, Leeds, Edinburgh, Sunderland
...Rows Updating Rows Deleting Rows Verifying Updates Transaction Control Commit and Rollback Savepoints Commits and Constraints Amending Data in SQL Developer...
- Course
- London
- Different dates available
...that are addressed in this course: SUBSTR POSSTR COALESCE/VALUE DECIMAL ROUND DIGITS CHAR DATE/TIME Table Expressions and Recursive SQL Identify reasons...
- Course
- London
- Different dates available
...to participate in rigorous activity from time to time. Please consider whether you could do this; if you are in any doubt, consult a medical practitioner... Learn about: Database training, Database Design, Microsoft Access XP...
- Course
- London
- 2 Days
... and alter tables, indexes and views, Insert, update, merge and delete rows, Grant and. Suitable for: This course is designed for experienced SQL users who need to access and work with an Oracle Database. This course is suitable for users of versions 9i, 10g and...
- Course
- Londonand5 other venues
- Manchester, Bristol, Birmingham, Leeds, Edinburgh
...Construct WHILE and FOR Loops Nested and Labeled Loops The GOTO Statement The CONTINUE Statement Using Cursors What is a Cursor? Implicit and Explicit...
- Course
- London
- 1 Day
...This course is designed to introduce the student to the capabilities of IBM Big SQL. IBM Big SQL allows you to access your HDFS data by providing a logical view to it. You can use the same SQL that was developed for your data warehouse data on your HDFS data. This course provides context on why...
-
The course was useful. For instance, I didn’t know anything about SQL but now I am able to write basic queries.
← | →
-
Totally informative course --it’s an excellent introduction to HTML and CSS. The course leader, Dean, was real expert on the subject and helped us a lot. Good exercises too that reinforced was taught in the course.
← | →
-
Very informative - exactly what I needed. Venue, staff and tutor were pretty great :)
← | →
- Course
- Londonand5 other venues
- Manchester, , Shadwell
- 2 Days
.... You'll also retrieve your data using standard SQL. You will also learn about the most common features of the proprietary extensions to the standard SQL language supported by the two most common databases - Microsoft SQL Server and Oracle... Learn about: Foreign Keys, SQL Server, Primary keys...
.... You'll also retrieve your data using standard SQL. You will also learn about the most common features of the proprietary extensions to the standard SQL language supported by the two most common databases - Microsoft SQL Server and Oracle... Learn about: Foreign Keys, SQL Server, Primary keys...
-
The course was useful. For instance, I didn’t know anything about SQL but now I am able to write basic queries.
← | → see all
-
Totally informative course --it’s an excellent introduction to HTML and CSS. The course leader, Dean, was real expert on the subject and helped us a lot. Good exercises too that reinforced was taught in the course.
← | → see all
-
Very informative - exactly what I needed. Venue, staff and tutor were pretty great :)
← | → see all
-
This course is very good for people who want to start their career in testing, especially if you want to get into the banking field. The educational experience here is high quality and at the same time gives you skills in different areas which would help your career to grow. Totally recommend it for beginners, it is an excellent first step in SQS.
← | →
- Course
- London
- 1 Month
...of Normalisation First, second and third Normal Forms Other Normalisation Forms The SELECT Statement Basic SELECT Select DISTINCT Select with formulas/calculations... Learn about: Primary keys, Foreign Keys, Database training...
...of Normalisation First, second and third Normal Forms Other Normalisation Forms The SELECT Statement Basic SELECT Select DISTINCT Select with formulas/calculations... Learn about: Primary keys, Foreign Keys, Database training...
-
This course is very good for people who want to start their career in testing, especially if you want to get into the banking field. The educational experience here is high quality and at the same time gives you skills in different areas which would help your career to grow. Totally recommend it for beginners, it is an excellent first step in SQS.
← | →
- Course
- Londonand6 other venues
- Manchester, Bristol, Birmingham, Leeds, Edinburgh, Sunderland
...Privileges and Roles Create Users Alter User Details Grant and Revoke Object Privileges...
- Course
- London
- Different dates available
- 3 Days
...and advantages of referential integrity, including impacts of delete rules Identify considerations when using triggers and check constraints Define...
-
Highly recommended, gave good insight into T-SQL and its real world usage.
← | →
-
Overall, the course was well-structured and difficulty rises in line you’re your own knowledge. My instructor knew very well the subject and was happy to answer all my inquiries, and he made sure that I was completely sure of my understanding of each topic before moving on. I would certainly take more courses with my trainer and recommended them to my employers.
← | →
- Course
- Londonand5 other venues
- Manchester, , Shadwell
- 2 Days
... language capabilities of T-SQL, such as local variables, flow control constructs, error handling and built-in functions... Learn about: Object oriented, Transact SQL...
... language capabilities of T-SQL, such as local variables, flow control constructs, error handling and built-in functions... Learn about: Object oriented, Transact SQL...
-
Highly recommended, gave good insight into T-SQL and its real world usage.
← | → see all
-
Overall, the course was well-structured and difficulty rises in line you’re your own knowledge. My instructor knew very well the subject and was happy to answer all my inquiries, and he made sure that I was completely sure of my understanding of each topic before moving on. I would certainly take more courses with my trainer and recommended them to my employers.
← | → see all
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you