35282 Design courses delivered Online

This comprehensive course will show you how to use SQL Server, ASP.NET Core, Angular 14, and Bootstrap to build a blog from scratch.

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

About this Training Course To the non-geologist, working with Petroleum Geologists can be confusing. Petroleum geology has specific terminology and many concepts and data sources unfamiliar to the uninitiated. This course has been designed to introduce these terms and provide an insight into how oil and gas are formed, how they are found and how they are extracted. Using a holistic combination of lectures, experiments, case study and practical exercises, the course involves an introduction to fundamental geological concepts, to exploration techniques, prospecting, drilling, well logs and recovery methods. The course will also demystify the terminology surrounding petroleum geology, demonstrate the use of geological information to show the value and weakness of different datasets, and lead to better communication and decision-making between the geologists and non-geologists. It will feature world-class virtual reality field trips that incorporate activities and features unavailable in the physical field, and provide for a more integrated and flexible learning resource (also see the trainer's article on page 4 which was first published in GEO ExPro Magazine, the upstream oil and gas industry's favourite magazine). Course Highlights: Course facilitator has delivered petroleum geology training to many companies over the years Facilitator is also a professionally trained teacher and former university lecturer who is experienced in communicating with people at all levels of technical knowledge Practical exercises, experiments, examination of real rocks, a virtual reality field trip and case study are used to clarify and reinforce important concepts Training Objectives By attending this training, you will be able to acquire the following: Understand the geological methods and principles used in hydrocarbon exploration, development and production. Understand the key elements of a petroleum system, from hydrocarbon source to reservoir and seal Appreciate basin analysis, regional geology and play based exploration techniques Be aware of the different sorts of hydrocarbon trap from structural to stratigraphic Understand the technical terminology, tools and methods used in exploration geology Learn about unconventional Understand and evaluate the sources and reliability of various types of geological information Understand acquisition, processing and interpretation of seismic data Learn the technical processes and terminology involved in exploration Understand how a prospect is defined and risked Understand how seismic, existing well information and outcrop geology can be used for exploration Gain an understanding of the methods used for petroleum geology to allow a discovery to be appraised and then developed Target Audience The course is suitable to all personnel, but those that benefit most include: This course will benefit Petroleum Engineers (reservoir, drilling, production) who work with geological data, Geophysicists with little or no geological background, Project managers whose teams include petroleum geologists, Finance, Procurement, Marketing and Communications staff, and government Data Managers who handle petroleum geological data and need to understand the sources of different types of data. Trainer Your expert course leader is the Geosciences Technical Director for PetroEdge. She was previously, the manager of Robertson Petroleum Training Centre and a Senior Project Scientist at Robertson CGG. She has over 20 years of experience in teaching geology and leading field trips. Prior to her 8 years at Robertson, she was in academia as a lecturer for 6 years and a Research Fellow for 3 years. She has conducted fieldwork and led field trips in the US and many areas in the UK. In addition, she has led university regional geology day schools and has comprehensive experience in course and study programme writing. She has extensive experience in delivering courses and in Clastic and Carbonate Reservoir Geology, Deepwater Turbidites, Sandstone Reservoirs, Wireline Log Interpretation, Integrated Sequence Stratigraphy, Basin Analysis and Exploration & Appraisal workshops globally. In delivering the Exploration Team Management Workshop, she has project managed and taught key principles and modules on project planning, data collection/collation, geophysical assessment, stratigraphy and facies mapping, source rock facies and hydrocarbon generation, play fairway mapping, risking and prospect evaluation. Her knowledge and enthusiasm for instructing is reflected in consistently being rated as excellent by trainees, and clients specifically requesting her participation in courses. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Are you looking to enhance your Game Development skills? If yes, then you have come to the right place. Our comprehensive course on Game Development will assist you in producing the best possible outcome by mastering the Game Development skills. The Game Development course is for those who want to be successful. In the Game Development course, you will learn the essential knowledge needed to become well versed in Game Development. Our Game Development course starts with the basics of Game Development and gradually progresses towards advanced topics. Therefore, each lesson of this Game Development course is intuitive and easy to understand. Why would you choose the Game Development course from Compliance Central: Lifetime access to Game Development course materials Full tutor support is available from Monday to Friday with the Game Development course Learn Game Development skills at your own pace from the comfort of your home Gain a complete understanding of Game Development course Accessible, informative Game Development learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Game Development Study Game Development in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Game Development Course Game Development Curriculum Breakdown of the Game Development Course Section 01: Introduction Section 02: Basic Building Blocks Section 03: Putting Blocks Together Section 04: Winning Managers Section 05: Creating Basic Game Section 06: Advanced Scratching And Winning Options Section 07: Finishing The Game Section 08: Creating Custom Animation System Section 09: Creating Game Animations Section 10: Building Your Game Section 11: Initial Scratching CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Game Development course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Game Development. It is also great for professionals who are already working in Game Development and want to get promoted at work. Requirements To enrol in this Game Development course, all you need is a basic understanding of the English Language and an internet connection. Career path The Game Development course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Game Development. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Elevate your web development skills with our Python Django Training. Master the Django framework and unleash the power of Python for building robust, scalable, and feature-rich web applications. Join our comprehensive training program to gain hands-on experience, expert guidance, and propel your career in the world of web development. Start your journey today!

Learn RabbitMQ: Asynchronous Messaging with Java and Spring

Master essential Microsoft Office skills with our comprehensive course covering Word, Excel, PowerPoint, Access, Outlook, and Publisher. Gain proficiency in document creation, spreadsheet management, presentation design, database handling, email communication, and desktop publishing.

Overview This Website for Service Business course will unlock your full potential and will show you how to excel in a career in Website for Service Business. So upskill now and reach your full potential. Everything you need to get started in Website for Service Business is available in this course. Learning and progressing are the hallmarks of personal development. This Website for Service Business will quickly teach you the must-have skills needed to start in the relevant industry. In This Website for Service Business Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Website for Service Business skills to help you advance your career. Acquire a comprehensive understanding of various Website for Service Business topics and tips from industry experts. Learn in-demand Website for Service Business skills that are in high demand among UK employers, which will help you to kickstart your career. This Website for Service Business course covers everything you must know to stand against the tough competition in the Website for Service Business field.  The future is truly yours to seize with this Website for Service Business. Enrol today and complete the course to achieve a Website for Service Business certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Website for Service Business course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Website for Service Business course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Website for Service Business course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Website for Service Business is suitable for anyone aspiring to start a career in Website for Service Business; even if you are new to this and have no prior knowledge on Website for Service Business, this course is going to be very easy for you to understand.  And if you are already working in the Website for Service Business field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Website for Service Business course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Website for Service Business course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Website for Service Business course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Website for Service Business course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Section 01: Build a Stunning Static Website for Your Accounting Business Using Wix ADI Introduction 00:01:00 Importance of an Online Presence of an Accounting Firm 00:03:00 Multi-Page Accounting Website - Part 1 00:03:00 Multi-Page Accounting Website - Part 2 00:02:00 Single-Page Accounting Website 00:03:00 How to Build a Multi-Page Accounting Website Using WIX 00:04:00 How to Edit the Homepage of an Accounting Website 00:06:00 How to Edit the About Page, Service Page and Contact Page 00:04:00 How to Make an Accounting Website Mobile Friendly 00:03:00 Section 02: Create a Stunning One-Page Accounting Website Using Wix Editor A Brief View 00:01:00 Set Up Wix Editor 00:02:00 Dashboard - Part 1 00:02:00 Dashboard - Part 2 00:03:00 Edit the Header Part 1 00:03:00 Edit the Header Part 2 00:03:00 Edit the Hero Section 00:03:00 Edit the Services Section Part 1 00:05:00 Edit the Services Section Part 2 00:02:00 Edit the Contact Section and Footer 00:01:00 Mobile Version 00:01:00

Learn how to become an effective primary school teacher through the Primary Teaching Course. Explore essential topics, teaching strategies, and EYFS Framework. Gain insights into Importance of Early Years in Development, child development, EYFS Teaching Techniques and fostering a positive learning environment. Kickstart your teaching career with this comprehensive course!

Did you know that the hairdressing industry is worth over £7 billion in the UK alone? With such a huge demand for skilled professionals, it's no wonder that many are turning to online courses to boost their skills and increase their employability in the industry. The Diploma of Hairdressing (Online) bundle offers 11 CPD-certified courses that cover a range of topics from hairdressing and haircutting to beauty and nutrition. With a CPD hardcopy certificate included with the first course, learners can be confident in their newfound skills and knowledge. The Hairdressing Level 3 course provides a solid foundation in hairdressing techniques, while the Facial Barbering Training course teaches learners how to create sharp and precise facial hairstyles. Acne Treatments and Beauty Care covers the latest skincare trends and treatments, while the Advanced Diploma in Nutrition and Ketogenic Diet explores the relationship between food and hair health. The Diploma in Hairdressing and Hair Cutting delves deeper into the art of hairdressing, while Beauty & Fashion Training offers insights into the beauty industry and fashion trends. Along with this Hairdressing course, you will get 10 premium courses, an original Hardcopy, 10 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: Hairdressing Level 3 Course 02: Facial Barbering Training Course 03: Acne Treatments and Beauty Care Course 04: Advanced Diploma in Nutrition and Ketogenic Diet Course 05: Diploma in Hairdressing and Hair Cutting Course 06: Beauty & Fashion Training Course 07: Acrylic Nail Course 08: Online Nail Technician Diploma Course 09: Bridal and Occasional Makeup Artist Masterclass Course 10: Nutrition and Hydration Course 11: Personal Hygiene Key Features of the Course: FREE Diploma of Hairdressing (Online) CPD-accredited certificate Get a free student ID card with Diploma of Hairdressing (Online)training (£10 applicable for international delivery) Lifetime access to the Diploma of Hairdressing (Online) course materials The Diploma of Hairdressing (Online) program comes with 24/7 tutor support Get instant access to this Diploma of Hairdressing (Online) course Learn Diploma of Hairdressing (Online) training from anywhere in the world The Diploma of Hairdressing (Online) training is affordable and simple to understand The Diploma of Hairdressing (Online) training is an entirely online Learning Outcomes: Upon completion of the Diploma of Hairdressing course bundle, you will be able to: Learn advanced hairdressing techniques and hair-cutting skills Gain knowledge in skincare treatments and beauty care Understand the principles of nutrition and hydration for hair health Develop expertise in acrylic nail design and online nail technician skills Master bridal and occasional makeup artistry techniques Gain insights into the beauty industry and fashion trends Understand personal hygiene practices for the salon environment Enhance your employability and career prospects in the hair and beauty industry Description The Diploma of Hairdressing (Online) offers a comprehensive education in the art and science of hairdressing, combining practical skills with theoretical knowledge. The course covers a wide range of topics, including Introduction to Barbering, Hair Cutting, Hair Braiding, and Hair Styling in its Hairdressing Level 3 module. It also includes specialized training in Facial Barbering, focusing on essential technical skills and techniques. Additionally, the program offers detailed insights into Acne Treatments and Beauty Care, covering aspects such as understanding acne, developing effective skincare routines, and the impact of diet and lifestyle on skin health. Enrol in this online diploma to build a solid foundation in hairdressing and enhance your expertise in both hairstyling and beauty care. Curriculum of Hairdressing Training Course Course 01: Hairdressing Level 3 Introduction to Barbering Hair Cutting Hair Braiding Hair Styling Course 02: Facial Barbering Training Introduction Technical skills Course 03: Acne Treatments and Beauty Care Module 01: Understanding Acne Module 02: Skincare Routine Module 03: Medications Module 04: Diet Module 05: Lifestyle and 8 more courses. How will I get my Certificate? After successfully completing the Diploma of Hairdressing (Online) course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Hairdressing bundle. Requirements This Hairdressing course has been designed to be fully compatible with tablets and smartphones. Career path This Diploma of Hairdressing course bundle will help you to pursue a range of career paths, such as: Hairdresser - £13,000 to £30,000 per year Barber - £14,000 to £30,000 per year Nail technician - £12,000 to £25,000 per year Makeup artist - £15,000 to £40,000 per year Beauty therapist - £14,000 to £30,000 per year Salon owner/manager - £18,000 to £50,000 per year Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Hairdressing Level 3) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.