• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

23 Educators providing SQL courses in Bushey

Acornford Technical Services

acornford technical services

London

Effective Solutions for Small Business Social Media Shortcuts Useful Links Our Partners Home Oracle MySQL MS SQL Server IBM DB2 StayAhead Contact Us Shopping Cart HomeAbout UsOracle TrainingContact Us Acornford Technical Services Ltd © 2012 | Terms and Conditions Share on FacebookShare on TwitterHead start for IT Professionals As an IT consultancy we offer an experienced DBA resource to compliment your support staff, who can provide complex technical advice or simply add an extra pair of hands during staff shortages during the holiday season, peaks of activity, or special projects for example. We specialize in providing technical training for the database subject mater experts. Most of our courses are in the form of classroom training. We also able to offer courses that are tailored made for you. Our experienced trainers can build a bespoke course and materials to meet your needs. We offer free advise for appropriate licensing, aiming to reduce the cost and maximize return on investment, while retaining legal compliance. Database Administration Technical Training for the Database SME Licensing Rationalization The ‘Container’ database feature of the Oracle 12c Database is generating a fair amount of interest as well as a range of new features in Oracle Grid Infrastructure. The ‘Container’ database with the Multitenant option addresses the data consolidation issues that were difficult to address in the previous versions and not easily solved using the virtualization. The course curriculum covers the general database administration and thorough run through the new features and new behaviours of the Oracle 12c Database engine.

Courses matching "SQL"

Show all 46

Java Bootcamp, 12-weeks

4.6(12)

By PCWorkshops

Full stack, in depth , comprehensive in classroom 3 month training on Java programming. 1 lesson a week, the other days you work on your own on structured homework and supported with a 1-1 mentor.

Java Bootcamp, 12-weeks
Delivered In-Person in London
£2,100

Python Beginners Course, 1-Day

4.6(12)

By PCWorkshops

his course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects.

Python Beginners Course, 1-Day
Delivered Online + more
£185

Python Data Analytics Course

4.6(12)

By PCWorkshops

Python Data Analytics with Python using Numpy, Pandas, Dataframes. Most attendees are in-work Data Professional. Private individuals are very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led

Python Data Analytics Course
Delivered Online
£185

Oracle SQL Fundamentals, 3 Days

4.6(12)

By PCWorkshops

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Oracle SQL Fundamentals, 3 Days
Delivered OnlineFlexible Dates
£750

SQL Intermediate Course, 3 Days

4.6(12)

By PCWorkshops

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

SQL Intermediate Course, 3 Days
Delivered OnlineFlexible Dates
£600

SQL Course Advanced, 2 Days

4.6(12)

By PCWorkshops

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.

SQL Course Advanced, 2 Days
Delivered OnlineFlexible Dates
£450

Learn SQL Basics, 1-day Course, Online Instructor-Led

4.6(12)

By PCWorkshops

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

Learn SQL Basics, 1-day Course, Online Instructor-Led
Delivered OnlineFlexible Dates
£185

Google BigQuery SQL Course Webinar

4.6(12)

By PCWorkshops

This BigQuery Conversion course is for users of SQL. We cover the interface and licensing differences and additional capabilities. Highlights of BigQuery. We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are. You would be able to move to this platform easily.

Google BigQuery SQL Course Webinar
Delivered OnlineFlexible Dates
£15

Introduction to SQL

5.0(3)

By Systems & Network Training

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

Introduction to SQL
Delivered in Internationally or OnlineFlexible Dates
£1,497

Administering Microsoft SQL Server

5.0(3)

By Systems & Network Training

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.

Administering Microsoft SQL Server
Delivered in Internationally or OnlineFlexible Dates
£2,367