3837 Courses in Epsom

About this Training Course  This 3 full-day training course will introduce participants to the Microsoft Power BI® software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI® environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data. The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they've learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn't be able to do what they need to do. This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Microsoft® PowerBI® is a trademark of Microsoft Corporation in the United States and/or other countries. Training Objectives Upon completion of this training course, participants will be able to: Confidently use the Power BI® solution, including Power BI® Desktop, PowerBI®.com and the Power BI® Gateway Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis Combine data sources together and gain an introductory understanding of the M language Write formulas using the DAX language for generating custom columns, measures and tables Design reports and dashboards using a wide range of both built-in and custom visuals Publish reports and dashboards to PowerBI®.com Share reports and dashboards with others using PowerBI®.com Customize reports and dashboards so that different user groups automatically see their own personalized views Target Audience This training course is intended for: Financial Analysts Accountants Budgeting and planning specialists Treasury Risk Managers Strategic Planners This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Course Level Basic or Foundation Trainer Your expert course leader has a Masters (Applied Finance & Investment), B.Comm (Accounting & Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years' experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings. He has trained delegates from a wide variety of Oil & Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions. Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm. He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing. Highlights from his oil and gas experience include: Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil & gas assets. Auditing and further development of life of project models for Chevron's Strategic Planning Division analysing their North West Shelf assets. Development of business plan and budgeting models for multinational oil & gas assets. Development of cash flow and taxation models for a variety of oil gas companies. Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment. 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

About this Virtual Instructor Led Training (VILT)  The Advanced Reservoir Engineering VILT course will address modern practical aspects of reservoir engineering during 5 half-days packed with lectures, virtual exercises, discussions and literature reviews. The participants' understanding of fundamental concepts and modern practical reservoir engineering methods will be deepened and a wide range of topics will be addressed. Topics covered The VILT course will emphasise reservoir engineering applications and include topics such as: Rock properties of clastic and carbonate reservoirs Reservoir characterisation Reservoir fluid behaviour Identification of main production mechanisms Design and analysis of well tests Production forecasting Application of Decline Curve Analysis in mature fields Detailed modeling of wells and reservoirs Water flooding Application of EOR methods Reserves and resource estimation Reservoir simulation approaches, model construction and well, aquifer and fluid modelling Development planning Uncertainty handling and scenario methods Depending on the background and requirements of the participants, some topics may be given more emphasis.   Training Objectives In this VILT course, reservoir engineering methods will be addressed which are of use in the daily reservoir engineering practice. The focus will be on practical applicability. Use is made of practical and actual reservoir engineering problems and examples to illustrate relevant subjects. By attending this VILT course, participants will have a deeper knowledge of modern reservoir engineering practices for reservoir development and production, including the construction and use of reservoir models. Target Audience The VILT course is intended for experienced reservoir engineers with prior technical or engineering exposure to production activities. Petroleum engineers and geoscientists who require more than general knowledge of reservoir engineering will also find this course useful. Participants are invited but not obliged to bring a short presentation (max of 15 minutes) on a practical problem they encountered in their work. This will then be explained and discussed in the VILT class. A short test or quiz will be held at the end the VILT course. Training Methods This VILT course will be delivered online over 5 half-days. There will be 2 blocks of two hours per day, including lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be required. Two breaks of 10 minutes will be provided each day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your course leader is an independent Reservoir Engineering Consultant. He provides project consultancy, quality assurance and reservoir engineering training for major oil companies, governments, engineering firms and other global customers. Before he retired from Shell in 2012, he held positions as Senior Reserves Consultant for the Middle East and Reservoir Engineering Discipline Lead. He is a petroleum engineering professional, with global experience, mostly in Shell companies and joint ventures (NAM, SSB, SCL, PDO, SKDBV). He has been involved in reserves and resource management, has extensive reservoir modelling and reservoir simulation expertise, and wide experience in the design and delivery of training programmes for employee development. PROFESSIONAL EXPERIENCE 2012 - 2016 Independent Reservoir Engineering Consultant Project consultancy, quality assurance and reservoir engineering training for major oil companies, governments, engineering firms and other global customers. Delivering specialised and general Reservoir Engineering courses to a multitude of international companies. 2008 - 2012 Shell International E&P, the Hague, the Netherlands Senior Reserves Consultant for the Middle East Region Assurance of SEC and SPE compliance of reserves and resources in Shell Middle East region. Contributor to the 2012 SPE guidelines on reserves and resources assessment. 2006 - 2008 Shell E&P Technology Solutions, Rijswijk, the Netherlands Reservoir Engineering Discipline Lead Responsible for QA/QC of Reservoir Engineering in global E&P projects as well as for staff development. (over 60 international Reservoir Engineers) 2001 - 2005 Centre for Carbonate Studies, SQU, Oman / Shell International E&P Technology Applications and Research /Shell Representative Office Oman Petroleum Engineering Manager PE manager in the Carbonate Research centre, at Sultan Qaboos University in Oman. Industrial research projects and support to teaching on recovery aspects of carbonate reservoir development. Design and delivery of industrial courses on carbonate reservoirs 1997- 2000 Shell International E&P, Rijswijk, the Netherlands Principal Reservoir engineer. Acting Shell Group Reserves Co-ordinator in 1997-1998. Facilitation of workshops with government shareholders, including discussions on sensitive reserves issues (BSP Petroleum Unit Brunei, PDO Oman, SPDC government Nigeria). Co-ordination of the NOV subsurface team in Shell Kazakhstan Development BV in 2000. Leading role in Shell Gamechanger project on natural gas hydrates. 1992- 1996 Shell Training Centre, Noordwijkerhout, the Netherlands Reservoir Engineering Programme Training Director Directed Shell Group Reservoir Engineering Training. Introduced advanced PE training events, QA/QC and learning transfer measures, Design and delivery of reservoir engineering and multidiscipline courses to Shell staff from a wide range of nationalities. 1985- 1992 Shell International, SIPM, the Hague, The Netherlands Senior Reservoir Engineer Full field reservoir simulation projects supporting Field Development Plans, operational strategies and unitisation negotiations for Shell Group Operating Companies in the United Kingdom, New Zealand and Egypt. Major contributor to the Shell internal Gas Field Planning Tool development. 1984- 1985 Geological Survey of the Netherlands (RGD), Ministry of Economic Affairs Reservoir Engineering Section Head Responsible for Petroleum Engineering advice on oil and gas licences to the Ministry of Economic Affairs. First-hand experience with a government view on resource management. 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

Our students will receive theoretical knowledge and practical skills for 3 key facial areas using dermal fillers techniques for the face to ensure they understand the importance of facial harmony and balance. Our goal at the Cosmetic College is to deliver the highest quality training in dermal fillers using the safest and most up-to-date techniques. Our Essential dermal filler training courses are carried out in small groups. This enables us to provide you with a training programme tailored to your needs, with more time and emphasis on the hands-on practical sessions. Course Prerequisites This course is suitable for those with or without a medical background. It is designed to allow the student to seek employment or start their own business upon completion. At a minimum, students will be required to be qualified with one or more of the following: Medically trained as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. NVQ Level 3 in Beauty Therapy, ITEC or HND 12 months of needling experience 6 Months of micropigmentation experience and Anatomy & Physiology Level 3 Please note that if your qualification does not appear above, we offer a fast-track access course for those new to the industry.  Course Agenda A mixture of online study, virtual lectures and practical onsite sessions A series of online and onsite assessments 1 day online webinar followed by 2 days onsite training program Course Structure All courses are kept intimate with a maximum of 4 students per course Course Agenda Anatomy and physiology of the face Infection control Sharps and hazardous waste training First aid and anaphylaxis training Introduction to dermal filler injection techniques Elective and emergency dissolving Start Business up (How to set up a business, insurance, stockist, social media, managed, join our Instagram group) Injection techniques practice Danger zones training Vessels, muscles, fat pads workshop Professional live demonstrations Legal requirements, obtaining consent with consultation techniques and documentation Practical training Clinical setup procedures Areas Covered (Dermal Filler) Lips Nasolabial Folds (Smile lines) Marionette lines Professional Kit Dermal filler (For Training purposes) Numbing cream Massage gel Chlorhexidine pre-injection wipes Sterile treatment packs Gloves Surgical face masks Skin marker pencils Ice pack Consultation forms Course Benefits Student Benefits Comprehensive Knowledge: By enrolling in this training, students will gain in-depth knowledge about dermal fillers, including facial anatomy, product selection, injection techniques, and patient assessment. This knowledge will provide a solid foundation for performing dermal filler treatments effectively and safely. Practical Skills: The course includes hands-on training, allowing students to develop practical skills in administering dermal fillers. Through supervised practice on live models, students can refine their techniques and gain confidence in delivering natural-looking results. Professional Advancement: Acquiring expertise in dermal fillers can significantly enhance a student's career prospects in the aesthetics industry. Client Benefits Natural-Looking Results: Clients can expect natural-looking results from trained professionals who have a thorough understanding of facial anatomy and the skill to administer dermal fillers effectively. The training ensures that students are equipped to enhance facial features and address specific concerns with precision. Safety and Care: Clients can have confidence in the skills and knowledge of practitioners who have undergone comprehensive training. Trained professionals prioritise client safety, follow proper hygiene protocols, and provide appropriate aftercare instructions. Earning Potential Earning potential and salary in the field of dermal fillers can vary depending on several factors, including geographic location, experience, and the number of clients. As professionals gain experience and build their reputation, they may have the potential to earn a competitive income. It's important to note that individual earning potential may vary and is influenced by various factors in the aesthetics industry. Additionally, continuing education and expanding your skill set by taking advanced courses and staying updated with the latest techniques and trends can also contribute to your earning potential. This allows you to offer a wider range of services and attract more clients seeking specialised treatments. Frequently Asked Questions Is prior experience required to enrol in the course? No, this course is suitable for both beginners and experienced practitioners. It provides a comprehensive foundation in dermal fillers, covering essential knowledge and practical skills. Are live models provided for the practical training? Yes, live models will be provided for the practical training sessions. This allows you to practice your skills under the guidance and supervision of experienced instructors.

DWDM training course description A concise overview of Wave Division Multiplexing (WDM) with both Coarse Wave Division Multiplexing (CWDM) and Dense Wave Division Multiplexing (DWDM) being covered. The course starts with a review of the relevant elements of fibre transmission and multiplexing before then studying WDM components and architectures. Reliability, resilience and management are then followed by WDM services and futures. What will you learn Explain the benefits of WDM. Describe Dispersion and four way mixing. Describe the different WDM equipment components. Describe different WDM architectures. Explain How DWDM works. DWDM training course details Who will benefit: Anyone working with CWDM/DWDM. Prerequisites: Telecommunications Introduction Duration 2 days DWDM training course contents Fibre communications review Optical transmission, Fibre characteristics, Fibre component parts. Multi Mode Fibre (MMF). Single Mode Fibre (SMF). Fibre connections. Lasers. Attenuations, dispersion, optical signal noise ratios (OSNR) and their effects. Channel Spacing and Signal Direction. Limiting factors to single wavelength. WDM overview Multiplexing, TDM, WDM benefits. WDM standards. CWDM vs. DWDM. Four Wave Mixing (FWM). Impact and countermeasures to FWM on WDM. CWDM ITU G.694.2, channels, channel spacing. DWDM ITU G.694.1, channels, channel spacing. WDM Equipment Components Equipment components and building blocks. Optical Terminal Multiplexers (OTM). Optical Add/Drop Multiplexers (OADM). Adding versus dropping. Optical Amplifiers. Erbium Doped Fibre Amplifiers (EDFA). Transponders and Combiners. WDM/DWDM Hubs. Optical and Electrical Cross Connects (OXCs/DXCs). Types of Cross Connects (Transparent/Opaque). Advantages and disadvantages of various Optical cross connects. WDM Architectures WDM network sections. Point-to-Point, Optical switches, mesh, ring and star topology. Example of combined WDM and other technology network. Wavelength converting transponders, 1R, 2R, 3R. Protection for WDM Sub 50ms failover. Equipment protection. Card protection. Y cable, Splitter protection. Far end laser control. Line protection. OMSP 1+1, OMSP 1:1, OMSP 1: N. Self healing optical ring. Sub Network Connection Protection (SNCP). Automatically Switched Optical Networks (ASON). WDM Management Options In band management. Out of band management. The Optical Supervisory Channel (OSC). OSC capabilities. WDM services WDM Access. Bit rates, Transparent Networks. Modulation, DQPSK. SDH over WDM. Migrating from SDH to DWDM. Ethernet over WDM, IP over WDM. Optical Transport Networks G.709, 'digital wrapper', Optical Channel Payload Unit (OPU), Optical Channel Transport Unit ( OTU), Optical Channel Data Unit (ODU). OTU1, OTU2, OTU3, OTU4. WDM Futures All optical amplification, Raman amplification, distributed, lumped. Bit rates. Solitons. Coherent technologies.

Advanced Kibana training course description This training course is aimed at users who already have some experience with Kibana, who are looking to further their knowledge. What will you learn Lens Timelion Maps Custom Visualisations with Vega Canvas Filters and Controls Drilldown and Dashboards KQSL and ElasticQueries Scripted and RunTime Fields Alerts and Alarms Advanced Kibana training course details Who will benefit: Users who already have some experience with Kibana, who are looking to further their knowledge. Prerequisites: None Duration 1 day Advanced Kibana training course contents Topics Lens Visualisation types (tables,bars,charts) Category breakdown Adding multiple metrics Using formulas in metrics Labels Adding reference layer Limitations Visualise Library Timeseries, Metrics Different types of aggregations Maps GeoMapping Heat Maps Using ES index as data source Visualisation, tool tips Custom Visualisations with Vega Introduction to vega scripting Canvas Widgets and Texts Elasticsearch SQL Canvas Expressions Filters and Controls Dropdown filters Ad-hoc filters Searchbar filters Drilldown Dashboards Linking one dashboard to another KQSL and ElasticQueries Bool Query AND/OR Phrase Part match vs keyword search Wildcard search Scripted and RunTime Fields Creating ad-hoc calculated fields using scripts Performance issues Alerts and Alarms Query Based Formatting output Connector types(email,index,teams etc)

Cloud technologies training course description This course provides an introduction to cloud technologies, including, configuration and deployment, security, maintenance, and management. It covers all aspects of cloud computing infrastructure. It will help you to master the fundamental concepts, terminology, and characteristics of cloud computing. . What will you learn Contrast and compare AWS, GCP and Azure. Explain the different cloud services, models and characteristics. Explain cloud virtualization components and options. Explain cloud security options. Describe cloud automation, orchestration, monitoring and performance options. Cloud technologies training course details Who will benefit: Anyone working with or looking to work with cloud technologies. Prerequisites: None. Duration 2 days Cloud technologies training course contents What is the cloud? The Internet Cloud computing Benefits Disadvantages Cloud services IaaS, PaaS, SaaS, others. Cloud service providers AWS, GCP Microsoft Azure, others Cloud architectures Private, public, hybrid others Cloud based delivery The cloud and virtualization Virtual Machines, networks, storage, deployment. Accessing the Virtual Machine Secure cloud environments Security considerations. Data privacy considerations Automation and orchestration Monitoring and performance Performance Cost issues Cost containment

SDH training course description Our SDH training course is designed for those with a basic knowledge of the principles of telecommunication digital transmission techniques. An overview of the existing transmission hierarchies and their limitations is provided with an introduction to the Synchronous Digital Hierarchy (SDH). The advantages of SDH are explained fully. What will you learn Identify the major limitations of the PDH network. Outline the advantages of using the SDH. Illustrate the various SDH equipment and network topologies. Describe the principles of the SDH multiplexing structure. SDH training course details Who will benefit: Anyone working with SDH. Prerequisites: It should be noted that this course will assume some basic telecommunication transmission knowledge from the delegates attending. This may be accomplished by attending the Introduction to Telecommunications course. Duration 2 days SDH training course contents Introduction to SDH Timing and synchronisation of digital signals, the plesiochronous digital hierarchy (PDH), the synchronous digital hierarchy (SDH), service protection with SDH SDH Multiplexing Techniques The multiplexing principles of SDH, mapping and aligning a 2Mbit/s tributary into a TU-12, aligning the VC-12 in a TU-12, multiplexing TU-12's into a TUG-2, multiplexing TUG-2's into a TUG-3, multiplexing TUG-3's into a VC-4, the VC-4 path overhead, the STM-1 frame, the AU-4 pointer, the STM-1 section overheads, multiplexer section protection, transmission at rates higher than STM-1, concatenation line transmission functions in SDH SONET Multiplexing Techniques Mapping a DS1 tributary into a virtual tributary, aligning the VT-SPE into a VT frame, mapping the VTGs into a STS-1 SPE, the STS-1 synchronous payload envelope, the STS-1 frame SONET network sections and lines transmissions at higher rates than STS-1 SDH Functions and Facilities SDH network topologies, structure of SDH equipment, synchronisation of SDH networks, protection switching in SDH networks, SDH alarm structure, SDH performance monitoring, testing of SDH, equipment and systems, network management and SDH, asynchronous transfer mode (ATM), future services and technologies OSI Telecommunications Network Management Definition of network management, managing telecom equipment, the managed object library, the management information base, the telecommunications management network (TMN), the Q3 protocol.

Mobile comms training course description A complete overview of mobile communications covering all the major technologies in a 2-day format. What will you learn GSM GPRS UMTS LTE Alternative mobile strategies Mobile comms training course details Who will benefit: Anyone involved in mobile communications. Prerequisites: None. Duration 2 days Mobile comms training course contents Introduction Telephony, RF, mobile and wireless technologies, distances, mobile phone generations, base stations, cells, frequencies, cell types, MSC, handoffs, channels, internetworking, the Internet, wireless Internet access. UK operators, worldwide operators. GSM What is it? Timeline, digitising voice, channels, GSM architecture, Abis, A, Um, MS, BTS, BSC, MSC, HLR, VLR, EIR, AuC. Radio link aspects, GSM signalling overview, signalling protocols, roaming, GSM call flows, authentication. IMEI. SIM cards. GPRS What it is, 2G to 3G, GPRS user features, GPRS network features, GPRS elements, GPRS architecture, overlay, SGSN, GGSN, GPRS ATTACH, GPRS protocol stack, GPRS timeslots, EDGE, GPRS classes, GPRS routing, GPRS packet format. UMTS and 3G What is 3G? IMT-2000, 3G proposals, what is UMTS? Speed comparison, evolution to 3G, CDMA, CDMA 2000, W-CDMA, UMTS components, UMTS infrastructure, RNC, Node B, network architecture, packet switched attach, mobility in 3G, HSDPA. LTE and 4G LTE architecture and principles, Physical layer, Air interface, E-UTRAN, Evolved packet core, service provision. Other wireless solutions Integration of services, Bluetooth, Blackberry, VoIP, Mobile IP, 802.11, WiFi, 802.16, WiMax, What is 5G?

HP ProCurve training course description A hands on course covering the product specifics of HP switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. VLANs often take up a large part of the course. The course covers all interfaces but concentrates on using the command line interface. Delegates are, however, free to use the web based interface in all exercises. What will you learn Install HP ProCurve switches. Use the command line interface and the web based interface to manage HP ProCurve switches. Configure and troubleshoot HP ProCurve switches. Perform software upgrades and maintain configurations using TFTP. HP ProCurve training course details Who will benefit: Anyone working with HP switches. Particularly aimed at engineers and technicians supporting HP switches. Prerequisites: None. Duration 2 days HP ProCurve training course content Introduction Traditional Ethernet, Hubs, Frames, MAC addresses. Hands on Building a network with a hub What is a switch? Switches versus hubs, the MAC address table, handling unknown addresses. Hands on Building a network with HP switches. Configuration methods How to configure a HP switch using: Console port access menus, CLI, telnet, web based access. Hands on Console access, show commands, using the menus, IP address configuration, telnet. Command Line Interface Operator mode, Manager mode, configuration mode, passwords, online help, CLI commands, basic troubleshooting. Hands on More show commands, basic troubleshooting, setting a password, displaying status and counters. Web based interface Web access, basic format, Getting started. SSL. Hands on Web based configuration. Port configuration Common port configuration tasks, port security, port aggregation. Hands on Configuring ports. Trunking and failover. STP configuration Broadcast storms. What is STP? RSTP. Configuring STP. Hands on Enabling and disabling STP, investigation failover. VLAN configuration What are VLANS? 802.1Q, tagged/untagged, creating VLANS, applying VLANS. Addressing and VLANs, Layer 3 switches and VLANs. Hands on Setting up VLANS, setting up tagged ports, Inter VLAN traffic. Housekeeping TFTP, software upgrades, downloading configurations. Hands on Software upgrade, downloading a configuration. SNMP SNMP configuration, HP OpenView. Hands on Using SNMP to manage a HP ProCurve switch. Basic troubleshooting Putting it all together. Layer 1 troubleshooting, Layer 2 troubleshooting. Miscellaneous exercises CDP. Logging

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.