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

50 G3 courses

Oracle 11g PL/SQL Beginner

4.3(43)

By John Academy

Description PL/SQL is program units which are composed by the Oracle Database server and stored in the database. The main function of PL/SQL is to hold SQL proclamation within its syntax. If you are interested to know more about SL/SQL function, and how it brings optimal competence in terms of 'procedural language', you may have a look at the Oracle 11g PL/SQL Beginner course. The course is designed in such a way that will assist the learners to know how it works with various strings, numbers, table row record, and error management. It also teaches the learner how to use different key data lexicon to synopsize and maintain the data. The learners will also be able to know about portability, productivity, and manageability of this most widely manipulative language. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Oracle 11g PL/SQL Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:09:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FORLOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Oracle 11g PL/SQL Beginner
Delivered Online On Demand9 hours 55 minutes
£18

Cosmeti-Craft® G&T Workshop (Gin & Teamwork!)

5.0(129)

By Cosmeti-Craft

An exciting bath bomb making workshop awaits as you firstly learn to make a Gin inspired bath bomb to match your complimentary ‘Bath Tub Gin’ for each person, served in a mini bath tub. You then undertake an advanced level tutorial of technique to make a colour changing bath bomb to match your captivating second complimentary colour changing Gin.

Cosmeti-Craft® G&T Workshop (Gin & Teamwork!)
Delivered In-PersonFlexible Dates
£28

Order in Space - Carving the Platonic Solids in Stone with Daniel Docherty and Nicholas G. Durnan

By Sacred Art of Geometry

Join Daniel Docherty and master stone-mason Nicholas G. Durnan for this week-long course where participants will learn the principles of Order in Space through a deep study and immersion in the five platonic solids. Daniel will lead the first two days where we will familiarise and befriend the forms as we draw, model and weave them in various ways and at various scales. The focus of the Thurs/Fri/Sat sessions will be on the carving of the forms in stone. It is likely that particpants will be able to carve a full set of all five 'Platonic' solids.

Order in Space - Carving the Platonic Solids in Stone with Daniel Docherty and Nicholas G. Durnan
Delivered In-PersonFlexible Dates
£385

Google G Suite Connect and Access

4.3(43)

By John Academy

Description Learn the advanced features of Google G Suit with the Google G Suite Connect and Access course. Google G Suite is the productivity and collaboration tool that is comprised of Google Drive, Google Docs, Slides, Sheets, Gmail, Calendar, Forms, Google Hangouts, Google Plus, and more. The course is split into five sections that show you how to use the five applications of Google G Suit such as Gmail, Google Calendar, Google Forms, Google Hangouts, and Google Plus. At first, you will master how to receive, send and manage the email service of Google. Then, the course shows you how to manage your schedule on Google Calendar. Next, you will know how to create and manage forms by using Google Forms. After that, the course teaches you how to communicate effectively by using Google Hangouts. Finally, the course illustrates the techniques of using the social media platform of Google and helps you to manage your social presence with Google Plus. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Google G Suite Connect and Access is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Google G Suite Connect and Access is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Lesson 1: Google Gmail TOPIC A Getting Started with Gmail 00:15:00 TOPIC B Sending, Reading, and Replying to Messages 00:15:00 TOPIC C Organizing and Searching Mail 00:15:00 TOPIC D Managing Your Contacts 00:15:00 Lesson 2: Google Calendar TOPIC A Getting Started with Google Calendar 00:15:00 TOPIC B Create and Manage Events 00:15:00 TOPIC C Create Additional Calendars 00:15:00 TOPIC D Sharing Your Calendar 00:15:00 Lesson 3: Google Forms TOPIC A Getting Started with Google Forms 00:15:00 TOPIC B Build Forms 00:15:00 TOPIC C Work with Responses 00:15:00 Lesson 4: Google Hangouts TOPIC A Overview 00:15:00 TOPIC B Messaging and Text Hangouts 00:15:00 TOPIC C Video and Phone Hangouts 00:15:00 TOPIC D Hangouts Chat 00:15:00 Lesson 5: Google Plus TOPIC A Getting Started with Google Plus 00:15:00 TOPIC B Create and Optimize Your Profile 00:15:00 TOPIC C Creating Posts 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Google G Suite Connect and Access
Delivered Online On Demand4 hours 30 minutes
£18

NVQ Level 3 in Electrical Installations

5.0(9)

By Optima Electrical Training

The NVQ Level 3 is designed to provide both new entrants and those seeking progression in their career, with the opportunity to develop the necessary skills to carry out job roles and responsibilities associated with the installation and maintenance of Electrotechnical systems. There are two options to complete the NVQ Level 3 in Electrical Installations, these are the C&G 2346 and C&G 2357. Successful completion of the NVQ and AM2 assessment will satisfy the entry criteria for JIB accredited electricians

NVQ Level 3 in Electrical Installations
Delivered In-Person in London + 2 more or UK WideFlexible Dates
£1,795 to £1,995

Telecommuting Skills Using G Suite & Google Drive

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Telecommuting Skills Using G Suite & Google Drive
Delivered Online On Demand4 hours
£25

CT03g - Clinical trial monitor’s GCP responsibilities

By Zenosis

A clinical trial monitor acts on behalf of the sponsor to support investigational site personnel, verify the accuracy of data recorded, and ensure that the trial is conducted in compliance with the protocol, GCP and other study specific requirements. He or she acts as the ‘eyes and ears’ of the sponsor at the investigational site and provides the main channel of communication between sponsor and investigator. This short course explores the responsibilities of the monitor and provides insight into key challenges. We discuss assessment of investigators and investigational sites, education and trial initiation, monitoring of clinical conduct, including CRF review and source document verification, and trial close-out. We discuss noncompliance and how to deal with it.

CT03g - Clinical trial monitor’s GCP responsibilities
Delivered Online On Demand30 minutes
£25

CT04g - Data capture and management in clinical trials

By Zenosis

Capture and management of clinical trial data is a challenge. The industry is under pressure to obtain and analyse such data more quickly, while maintaining data integrity, so that products can be brought to market sooner. Effective planning and adequate resources can ensure clinical trials yield high quality data within strict timelines and budget requirements, at the same time satisfying regulatory standards. This short course describes the purpose of data capture and explores efficiencies in data management as part of the evolving regulatory landscape.

CT04g - Data capture and management in clinical trials
Delivered Online On Demand15 minutes
£25

5G Essentials - WIFI RAN

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for AT&T Custom Course - 5G Essentials - WiFi Ran Overview AT&T Custom Course - 5G Essentials - WiFi Ran AT&T Custom Course - 5G Essentials - WiFi Ran AT&T Custom Course - 5G Essentials - WiFi Ran

5G Essentials - WIFI RAN
Delivered OnlineFlexible Dates
Price on Enquiry

Baby-G BA-112-1ADR

By YiWon

Đồng hồ Baby-G BA-112-1ADR - đồng hồ thể thao dành cho các cô gái cá tính, với chất liệu cao cấp, thiết kế năng động, màu sắc thời thượng, hứa hẹn sẽ phá đảo giới trẻ toàn thế giới. Là chiếc đồng hồ vô cùng phù hợp với những cô gái mạnh mẽ, cá tính và thể thao. Đồng hồ Baby-G BA-112-1ADR, lưu ý về thương hiệu: Chiếc đồng hồ G-Shock đầu tiên được phát minh năm 1983 bởi một kỹ sư của Casio. Với thiết kế thể thao, nhiều tính năng nổi trội như chống nước, đèn Led thì G-Shock chính thức tạo nên một cơn sốt sốt hồ cho giới trẻ toàn thế giới. Và đến năm 1988 thì đã có 19 triệu chiếc G-shock đã được bán trên toàn thế giới. Baby-G đồng hồ thể thao vô cùng năng động Sau thành công vang dội đó, Casio tiếp tục cho ra dòng sản phẩm tương tư nhưng dành cho nữ giới mang tên Baby-G. Xin giới thiệu các bạn nữ yêu thích thể thao, tham gia nhiều hoạt động ngoài trời. Đồng hồ Baby-G BA-112-1ADR, lưu ý về thiết kế và chất lượng Đồng hồ Baby-G BA-112-1ADR có 4 màu chính : đen, hồng, xanh dương và vàng. Ít có thương hiệu đồng hồ cao cấp dù bong kết hợp nhiều màu sắc rực rỡ trong thiết kế của mình như Baby-G vì rất khó có thể hiện được sự đẳng cấp nhưng Baby-G lại làm được điều đó. Cách để xem tại đây nhé Nền đồng hồ với 4 tần số màu: Hồng, xanh dương, vàng, đen theo thứ tự từ ngoài vào trong. Mỗi tầng màu đềo có thêm các chi tiết như chữ, hình, số trên nó. Nhưng mọi thứ không hề gây mặt đồng hồ trở nên rối mà vô cùng hòa hợp và hài hòa. Không hề thô đi đeo lên tay các cô gái dù nhỏ nhắn Kim đồng hồ khá lớn và màu chủ đạo là hồng kết hợp với tầng ngoài cùng đồng hồ cũng màu hồng. Làm cho chiếc đồng hồ bắt đầu hơi nữ tính một chút. Ngoài ra trong chia làm 3 khoảng: khoảng thời gian, khoảng ngày và khoảng đếm giây. Mặt kính đồng hồ từ Mineral Crystal cường lực, vô cùng cứng và bền bỉ, rất khó bị trầy xước hay bễ gãy. Ngoài ra, vô cùng trong suốt, sáng bóng, khó bị mờ kể cả dùng lâu. Khung đồng hồ Baby-G BA-112-1ADR ôm chặt mặt đồng hồ và được thiết kế máy móc, có nhiều nút bấm xung quanh. Và đồng bộ với dây đeo cũng có màu đen bóng. Tạo một thành phần có thể tải xuống tối đa. Cả hai đều làm từ nhựa cao cấp vô cùng cứng cáp, chịu lực rất tốt. Cách để xem tại đây nhé Vì dây đeo nhựa, nên đeo vào rất thoải mái dễ chịu, nhưng lại vô cùng chắc chắn. Có thể tha hồ vận động, chơi thể thao trong thời gian dài mà không bị ảnh hưởng. Đối với người hay đổ nhiều mồ hôi vẫn cảm thấy mát mẻ và không ảnh hưởng.VHQUAN20240524

Baby-G BA-112-1ADR
Delivered In-PersonFlexible Dates
FREE