1339 Scientist courses

Learn the skills of a Crime Scene Investigator ... Explore the exciting world of the Forensic Investigator in this unforgettable interactive experience day. You will spend the day using real forensic methods and techniques to perform a range of established crime scene investigations. All investigations that you perform are "hands-on", giving you the opportunity to learn how these procedures work in real life. Your day will include: DRUG TESTING: Perform a drugs test! The suspect was carrying a small plastic bag of a white substance when arrested. He was known to police as a cocaine dealer. Was he carrying cocaine? Carry out chemical tests to establish if the white powder was cocaine? FINGERPRINTING: Learn how to lift and record fingerprints using the conventional dusting process to detect and preserve fingerprints. MICROSCOPY: Use a light microscope to forensically examine crime scene samples. Discover how to use different magnifying powers to optimise the results. FABRIC SAMPLE ANALYSIS: Compare samples collected at the crime scene and on the suspect to identify human hairs. SOIL ANALYSIS: Analyse soil samples collected from the crime scene and compare against soil recovered from the suspect's shoes. Identify which soil sample is common between both crime scene and suspect. Use chemical tests to confirm your results. TOOL MARK IDENTIFICATION: You have a known tool impression from the crime scene. Use forensic casting techniques to create clay impressions and compare with a range of tools recovered from the suspect's tool shed. Which tool did he use? BLOOD DETECTION: Blood-like stains were found at the crime scene. Before sending samples to the forensic lab we need to establish if they are blood samples. Use established forensic tests and procedures to identify blood spots and stains that may not be visible to the naked eye. DNA EXTRACTION: Perform an extraction procedure to extract DNA from samples provided. You will be able to see (and feel) actual DNA once you have completed the process! Awards a Certificate of Completion OPEN TO ALL APPLICANTS LOCATIONS THROUGHOUT THE U.K. AFTER THE COURSE … Understand the breadth of career opportunities available to you in nearly 100 specific disciplines of forensic science, including: Forensic Art Forensic Photography Wildlife Forensics Forensic Statistics Entomology Cypercrime and Cyper-IT Forensic Meteorology DNA analysis Counterfeiting & Forgery Casts & Impressions incl. tyres & shoes and many more! Appreciate the difference in roles between Forensic Scientist posts and Crime Scene Investigator posts. Understand that there are many forensic posts in niche areas that may benefit from existing transferrable skills (such as IT). Apply qualifications and skills acquired to parallel fields such as teaching. For a more detailed overview please see our "Opportunities in Forensic Science" guide. 

NATIONALLY RECOGNISED AND ACCREDITED FORENSIC SCIENCE COURSE Level Three (advanced), awarding 3 credits.   DUAL ACCREDITATION: Awarding Body: Open College Network (OCN Credit4Learning) Awarding Body: CPD (21 CPD Points)   A modular "hybrid" forensic science course - eLearning (online) theory and one full day classroom based practical training (Crime Scene Investigations). The practical day covers a wide range of CSI techniques with "hands-on" practical training. On completion awards an OCN Nationally Recognised and Accredited Certificate in Forensic Science. This course is additionally CPD Accredited and also awards 21 CPD points on completion.   PART 1 - THEORY Complete this part of your course online (eLearning Course) in the comfort of your own home or workplace. Please allow approx. 6-8 hours to complete the elearning modules. You do not need to complete Part 1 in one single "sitting” and can log on/off as many times as you wish and when convenient to you. You must complete both parts 1 and 2 to successfully pass this course.   PART 2 - CLASSROOM Attend your forensic science practical day in the classroom, covering a number of key CSI investigative processes and procedures. You will develop your crime scene investigator skills with "hands-on" training in a classroom environment at the training location you have selected. Please note that we will provide protective clothing (disposable aprons), goggles and gloves. As you will be participating in a range of forensic activities we would suggest you wear easy clothing, short-sleeved top and closed-toe shoes.   You can complete Part 1 before or after comleting Part 2.   DOWNLOAD A COURSE ITINERARY HERE Course Itinerary M01 - Overview and Historical Background: A look at definitions, historical perspective highlighting major forensic advancements covering since early times, the beginning of modern forensics including the advent of fingerprinting, toxicology and DNA, and how DNA solved the first case (a double murder). Understanding the services of Forensic Labs and the major disciplines.   M02 - Observational Skills Crime Scene Investigation & Recording Examination of the crime scene, photography, videography, sketch recording principles, using a CAD package.   M03 - Forensic Pathology Understanding the job role, working within hospitals, mortuaries, the pathological processes and manner of death.   M04 - Forensic Anthropology How does forensic anthropology help forensic scientists? Using physical markers present on a skeleton to determine age, sex, stature, and race. Bone anatomy and stages of development from foetal to elderly individual. Differentiating male and female: skull, pelvis, femur and humerus.   M05 - Forensic Entomology How entomologists determine time of death as well as advanced investigations involving abuse and neglect. The life cycle of the blowfly and environmental influences. Using insect gut DNA to help solve crimes.   CS01 - Case Study - Forensic Entomology - The Jigsaw Murders   M06 - Forensic Serology Understanding presumptive tests and confirmatory tests. Tests in detail - processes and methods with options for: Blood, Saliva, Semen, Urine.   M07 - Using the Microscope Correct procedures for using the light microscope. A look at the electron microscope and scanning probe microscope and their applications in forensic science. Detailed process guide including mounting slides.

Explore the latest trends in carbon capture, utilization, and storage with EnerygyEdge's interactive virtual instructor-led training course.

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.

Learn to assess, design, and monitor solar PV power plants with EnergyEdge's comprehensive training. Master PVsyst software for bankable system simulations.

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

Join us this November for a FREE in-person workshop in Braintree, which introduces SMEs to a variety of AI tools useful for improving business processes!

Duration 1 Days 6 CPD hours This course is intended for The primary audience for this course is data professionals who are familiar with data modeling, extraction, and analytics. It is designed for professionals who are interested in gaining knowledge about Lakehouse architecture, the Microsoft Fabric platform, and how to enable end-to-end analytics using these technologies. Job role: Data Analyst, Data Engineer, Data Scientist Overview Describe end-to-end analytics in Microsoft Fabric Describe core features and capabilities of lakehouses in Microsoft Fabric Create a lakehouse Ingest data into files and tables in a lakehouse Query lakehouse tables with SQL Configure Spark in a Microsoft Fabric workspace Identify suitable scenarios for Spark notebooks and Spark jobs Use Spark dataframes to analyze and transform data Use Spark SQL to query data in tables and views Visualize data in a Spark notebook Understand Delta Lake and delta tables in Microsoft Fabric Create and manage delta tables using Spark Use Spark to query and transform data in delta tables Use delta tables with Spark structured streaming Describe Dataflow (Gen2) capabilities in Microsoft Fabric Create Dataflow (Gen2) solutions to ingest and transform data Include a Dataflow (Gen2) in a pipeline This course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on the Lakehouse concept. This course will explore the powerful capabilities of Apache Spark for distributed data processing and the essential techniques for efficient data management, versioning, and reliability by working with Delta Lake tables. This course will also explore data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines. This course includes a combination of lectures and hands-on exercises that will prepare you to work with lakehouses in Microsoft Fabric. Introduction to end-to-end analytics using Microsoft Fabric Explore end-to-end analytics with Microsoft Fabric Data teams and Microsoft Fabric Enable and use Microsoft Fabric Knowledge Check Get started with lakehouses in Microsoft Fabric Explore the Microsoft Fabric Lakehouse Work with Microsoft Fabric Lakehouses Exercise - Create and ingest data with a Microsoft Fabric Lakehouse Use Apache Spark in Microsoft Fabric Prepare to use Apache Spark Run Spark code Work with data in a Spark dataframe Work with data using Spark SQL Visualize data in a Spark notebook Exercise - Analyze data with Apache Spark Work with Delta Lake Tables in Microsoft Fabric Understand Delta Lake Create delta tables Work with delta tables in Spark Use delta tables with streaming data Exercise - Use delta tables in Apache Spark Ingest Data with DataFlows Gen2 in Microsoft Fabric Understand Dataflows (Gen2) in Microsoft Fabric Explore Dataflows (Gen2) in Microsoft Fabric Integrate Dataflows (Gen2) and Pipelines in Microsoft Fabric Exercise - Create and use a Dataflow (Gen2) in Microsoft Fabric