SELECT *
FROM zoho_course_dates
WHERE 1 AND ( (training_centre_id = "1947939561") OR (training_centre_id = "1947939562"))
AND (
start_date >= 1680183732
OR
start_date = 0
)
Array
(
[0] => stdClass Object
(
[id] => 17
[course_id] => 905282000000957183
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1681084800
[end_date] => 1683244800
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => 4-week course
<br>Monday-Friday, 9am-5pm
<br>All course fees included.
[provider] => Edinburgh (Queen Street), UK
[provider_full_address] => 66 Queen St, , Edinburgh, EH2 4NA, United Kingdom
[provider_address_line_1] => 66 Queen St,
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH2 4NA
[provider_country] => United Kingdom
[provider_longitude] => -3.2074976
[provider_latitude] => 55.9535862
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939562
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[1] => stdClass Object
(
[id] => 103
[course_id] => 905282000000957183
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1684713600
[end_date] => 1686873600
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => 4-week course
<br>Monday-Friday, 9am-5pm
<br>All course fees included.
[provider] => Edinburgh (Queen Street), UK
[provider_full_address] => 66 Queen St, , Edinburgh, EH2 4NA, United Kingdom
[provider_address_line_1] => 66 Queen St,
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH2 4NA
[provider_country] => United Kingdom
[provider_longitude] => -3.2074976
[provider_latitude] => 55.9535862
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939562
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[2] => stdClass Object
(
[id] => 138
[course_id] => 905282000000876227
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1685923200
[end_date] => 1688083200
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => Monday to Friday 09:00 - 17:30.
<br>All course fees included.
[provider] => Edinburgh (Manor Place), UK
[provider_full_address] => 54 Manor Place, Edinburgh, EH3 7EH, United Kingdom
[provider_address_line_1] => 54 Manor Place
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH3 7EH
[provider_country] => United Kingdom
[provider_longitude] => -3.2198031
[provider_latitude] => 55.9499665
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939561
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[3] => stdClass Object
(
[id] => 198
[course_id] => 905282000000957183
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1688342400
[end_date] => 1690502400
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => 4-week course
<br>Monday-Friday, 9am-5pm
<br>All course fees included.
[provider] => Edinburgh (Queen Street), UK
[provider_full_address] => 66 Queen St, , Edinburgh, EH2 4NA, United Kingdom
[provider_address_line_1] => 66 Queen St,
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH2 4NA
[provider_country] => United Kingdom
[provider_longitude] => -3.2074976
[provider_latitude] => 55.9535862
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939562
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[4] => stdClass Object
(
[id] => 288
[course_id] => 905282000000876227
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1690761600
[end_date] => 1692921600
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => Monday to Friday 09:00 - 17:30.
<br>All course fees included.
[provider] => Edinburgh (Manor Place), UK
[provider_full_address] => 54 Manor Place, Edinburgh, EH3 7EH, United Kingdom
[provider_address_line_1] => 54 Manor Place
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH3 7EH
[provider_country] => United Kingdom
[provider_longitude] => -3.2198031
[provider_latitude] => 55.9499665
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939561
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[5] => stdClass Object
(
[id] => 315
[course_id] => 905282000000957183
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1691971200
[end_date] => 1694131200
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => 4-week course
<br>Monday-Friday, 9am-5pm
<br>All course fees included.
[provider] => Edinburgh (Queen Street), UK
[provider_full_address] => 66 Queen St, , Edinburgh, EH2 4NA, United Kingdom
[provider_address_line_1] => 66 Queen St,
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH2 4NA
[provider_country] => United Kingdom
[provider_longitude] => -3.2074976
[provider_latitude] => 55.9535862
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939562
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[6] => stdClass Object
(
[id] => 394
[course_id] => 905282000000876235
[course_name] => CELTA Online (Part-Time)
[start_date] => 1694822400
[end_date] => 1701475200
[price] => 1300
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => 11-week course. Teaching Practice teaching real students via Zoom, feedback and guided lesson planning online sessions Monday and Wednesday evenings from 5.30 to 7.30 (UK time). Rest of the course done via Cambridge Learning platform in your own time, self paced.
<br>Time Zone: Edinburgh, Scotland (GMT+1).
<br>All course fees included.
[provider] => Edinburgh (Manor Place), UK
[provider_full_address] => 54 Manor Place, Edinburgh, EH3 7EH, United Kingdom
[provider_address_line_1] => 54 Manor Place
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH3 7EH
[provider_country] => United Kingdom
[provider_longitude] => -3.2198031
[provider_latitude] => 55.9499665
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939561
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Online
[sub_format] => Part Time
[published] => 1
)
[7] => stdClass Object
(
[id] => 423
[course_id] => 905282000000957183
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1695600000
[end_date] => 1697760000
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => 4-week course
<br>Monday-Friday, 9am-5pm
<br>All course fees included.
[provider] => Edinburgh (Queen Street), UK
[provider_full_address] => 66 Queen St, , Edinburgh, EH2 4NA, United Kingdom
[provider_address_line_1] => 66 Queen St,
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH2 4NA
[provider_country] => United Kingdom
[provider_longitude] => -3.2074976
[provider_latitude] => 55.9535862
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939562
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[8] => stdClass Object
(
[id] => 442
[course_id] => 905282000000876227
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1696204800
[end_date] => 1698364800
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => Monday to Friday 09:00 - 17:30.
<br>All course fees included.
[provider] => Edinburgh (Manor Place), UK
[provider_full_address] => 54 Manor Place, Edinburgh, EH3 7EH, United Kingdom
[provider_address_line_1] => 54 Manor Place
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH3 7EH
[provider_country] => United Kingdom
[provider_longitude] => -3.2198031
[provider_latitude] => 55.9499665
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939561
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[9] => stdClass Object
(
[id] => 513
[course_id] => 905282000000957183
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1699228800
[end_date] => 1701388800
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => 4-week course
<br>Monday-Friday, 9am-5pm
<br>All course fees included.
[provider] => Edinburgh (Queen Street), UK
[provider_full_address] => 66 Queen St, , Edinburgh, EH2 4NA, United Kingdom
[provider_address_line_1] => 66 Queen St,
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH2 4NA
[provider_country] => United Kingdom
[provider_longitude] => -3.2074976
[provider_latitude] => 55.9535862
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939562
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
[10] => stdClass Object
(
[id] => 523
[course_id] => 905282000000876227
[course_name] => CELTA Face-to-Face (Full-Time)
[start_date] => 1699833600
[end_date] => 1701993600
[price] => 1495
[currency] => GBP (£)
[offer] => 0
[offer_price] => 0
[details] =>
[terms] => Monday to Friday 09:00 - 17:30.
<br>All course fees included.
[provider] => Edinburgh (Manor Place), UK
[provider_full_address] => 54 Manor Place, Edinburgh, EH3 7EH, United Kingdom
[provider_address_line_1] => 54 Manor Place
[provider_address_line_2] =>
[provider_district_city] => Edinburgh
[provider_state_province] =>
[provider_postal_code] => EH3 7EH
[provider_country] => United Kingdom
[provider_longitude] => -3.2198031
[provider_latitude] => 55.9499665
[provider_timezone] => 0.00
[provider_native_currency] => GBP (£)
[training_centre_id] => 1947939561
[training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-edinburgh-united-kingdom.jpg
[type] => CELTA
[types] => CELTA
[format] => Face to Face
[sub_format] => Full time
[published] => 1
)
)
Shops, cafés and restaurants within 10 minutes’ walk
Self-access study centre, trainee resources, wifi
Common room and garden
24 hour emergency phone number
The teacher training centre in Manor Place is centrally located in Edinburgh and is just a ten-minute walk from Haymarket train station. It is just minutes away from Princes Street with many snack bars, takeaways, pubs and restaurants nearby. The personnel at the Manor Place Teacher Training Centre have been running CELTA courses in Edinburgh since 1999.
The Queen Street Edinburgh training centre has a long tradition of academic excellence and remains dedicated to empowering each student in their education. The Edinburgh training centre provides a unique academic environment, where you will study alongside international and local students.
Experienced and well-qualified teaching staff work hard to ensure that you receive a high level of academic support, encouraging your progression. We believe that learning happens both inside and outside the classroom and we are committed to helping you progress.
During the interview stage of the application process, applicants can discuss their accommodation needs with the CELTA course tutor. Alternatively, trainees are welcome to organise their own accommodation, using websites such as www.airbnb.com and www.booking.com.
Edinburgh and Surroundings
Getting to Edinburgh:
Edinburgh Airport is located around 9 miles from the city centre and the journey takes around 30 minutes by bus. Book an Airport Transfer through us, take a taxi (around £30) or catch the Airlink Airport bus from outside the Arrivals Hall.
Getting around Edinburgh:
Buses - most buses start at 0600 and stop around 2300. Visit the Lothian Bus website for up-to-date travel information.
Tram - a new and popular method to travel to the city centre. Trams every 10 minutes each way, taking 40 minutes to arrive centrally at Princes Street.
Taxis - taxis are available throughout the city and are available for hire when the orange FOR HIRE sign is illuminated.
Trains - the college is located very close to Edinburgh Waverley and Haymarket stations. Tickets vary in price - book early for the best deals. Visit National Rail for timetables and pricing.
Did you know?
Edinburgh has a population of around 450,000 people, which grows to over 1.5 million during the Festival.
The Edinburgh Fringe Festival in August is the largest in the world, attracting over 3000 international performers.
The city's Hogmanay (or New Year) celebrations are also the biggest in the world, ending with a spectacular fireworks display at the stroke of midnight.
Edinburgh was the first UNESCO World City of Literature. J.K. Rowling wrote the first Harry Potter book in "The Elephant House" café in Edinburgh.
Famous people born in Edinburgh include: Sean Connery, Alexander Graham Bell, Robert Louis Stevenson, Tony Blair, Ian Rankin, and Sir Arthur Conan Doyle.
The city's airport hosts almost 9 million visitors every year, with flights from over 100 destinations around the world. Flights from London take just 1 hour.
Edinburgh University is one of the oldest universities in the world, dating back to 1582. Charles Darwin studied Medicine here from October 1825.
Edinburgh's economy is the strongest in the UK after London, worth around £11bn per year.
Shops, cafés and restaurants within 10 minutes’ walk
Self-access study centre, trainee resources, wifi
Common room and garden
24 hour emergency phone number
The teacher training centre in Manor Place is centrally located in Edinburgh and is just a ten-minute walk from Haymarket train station. It is just minutes away from Princes Street with many snack bars, takeaways, pubs and restaurants nearby. The personnel at the Manor Place Teacher Training Centre have been running CELTA courses in Edinburgh since 1999.
The Queen Street Edinburgh training centre has a long tradition of academic excellence and remains dedicated to empowering each student in their education. The Edinburgh training centre provides a unique academic environment, where you will study alongside international and local students.
Experienced and well-qualified teaching staff work hard to ensure that you receive a high level of academic support, encouraging your progression. We believe that learning happens both inside and outside the classroom and we are committed to helping you progress.
Why do I need to choose a location for an online CELTA?
Though you can take the CELTA course online from anywhere in the world, the courses are run by centres based in a physical location – so you need to choose a location for your online CELTA course.
Why do I need to choose a location for an online DELTA?
Though you can take the DELTA course online from anywhere in the world, the courses are run by centres based in a physical location – so you need to choose a location for your online DELTA course.