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

547 Manipulation courses

Consumerism Escape Plan: Design a Life Beyond Buying

4.3(43)

By John Academy

Transform your life with our 'Consumerism Escape Plan' course! Uncover the secrets of consumerism, explore alternatives, and design a sustainable, mindful existence. Break free from materialism, redefine your identity, and embark on a journey towards purposeful living. Join us on a path beyond buying, where conscious choices reshape your life. Discover the power of anti-consumption, sustainable practices, and mindfulness. Craft a life aligned with your values—choose experiences over possessions. Enroll now and liberate yourself from the grip of consumer culture!

Consumerism Escape Plan: Design a Life Beyond Buying
Delivered Online On Demand
£24.99

Financial Engineering Diploma - CPD Accredited

5.0(10)

By Apex Learning

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Financial Engineering Package Now Give a compliment to your career and take it to the next level. This Financial Engineering will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate skills for your next promotion, this Financial Engineering will help you keep ahead of the pack. The Financial Engineering incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this Financial Engineering will add extra value to your resume to stand out to potential employers. Along with this Financial Engineering course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Financial Engineering Bundle Consists of the following Premium courses: Course 01: Financial Analysis Course 02: Basic Business Finance Course 03: Team Management Course 04: Financial Modeling Using Excel Course 05: Statistics Essentials Course 06: Applied Economics Course 07: Basics Blockchain Course 08: Integration of Blockchain dapps with WEB3.JS Course 09: Advanced Blockchain Coding Course 10: Know Your Customer (KYC) Course 11: Level 3 Cyber Security Key features of this Financial Engineering course: This Financial Engineering bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Financial Engineering is entirely online 24/7 Learner support So enrol now in this Financial Engineering Bundle to advance your career! The Financial Engineering bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Financial Engineering Training expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Financial Engineering Course 01: Financial Analysis Introduction Profitability Return Ratio Liqudity Ratio Operational Analysis Detecting Manipulation -------- 10 additional Financial Engineering courses---------- How will I get my Financial Engineering Certificate? After successfully completing the Financial Engineering 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 £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) PS The delivery charge inside the UK is £3.99, and international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Financial Engineering bundle. Requirements Our Financial Engineering course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Financial Engineering Training expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Financial Engineering Diploma - CPD Accredited
Delivered Online On Demand
£45

Photoshop Basics to Essentials Training

By London Design Training Courses

Why Choose Photoshop Basics to Essentials Training Course? Course Link Mastering Photoshop is crucial for securing positions in creative fields such as graphic design, digital design, and user interface (UI) design. Acquiring this skill serves as a foundation to excel in various design programs essential for creative professionals. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Monday to Saturday between 9 am and 7 pm. Photoshop Course: Total 16 hrs  Module 1: Keyboard and Toolbar Shortcuts Customize toolbars and keyboard shortcuts for efficient workflow Learn essential keyboard shortcuts for faster navigation Module 2: Advanced Layer Management Filter, search, and color code layers for better organization Group and merge layers to streamline your design process Explore Blending Modes for creative effects Module 3: Blending Modes Understand Blending Modes and their usage within layers and effects Apply Blending Modes to enhance your designs Module 4: Layer Comps Discover Layer Comps and their benefits in managing complex designs Create, edit, and update Layer Comps for different design versions Export Layer Comps to PSD, PDF, and JPEG formats Module 5: Drawing Vectors Work with Vector images using shapes and the Pen Tool Use the Direct Selection Tool for precise editing Apply colors and create Clipping Masks with vectors Module 6: Advanced Type Techniques Convert text into Shapes and utilize font style changes with the Pen Tool Use text as a Clipping Mask and create text Outlines Design 3D text for impactful typography Module 7: Advanced Adjustment Layers Master advanced adjustments like Curves, Levels, and Black and White Utilize Selective Color and Gradient Maps for creative color control Module 8: Advanced Selection Techniques Use Smart Radius and Select and Mask for precise selections Learn to select complex objects like hair using Color Range and the Pen Tool Save and manage selections using the Path Panel Module 9: Colorizing Black and White Images Module 10: Displacement Maps Module 11: Advanced Filters Create Trees, Frames, Clouds, and Fire with filters Use Polarized, Wave, and Extrusion for artistic effects like "Japanese Sun" Explore Vanishing Point Filter, Camera RAW, Blur for depth of field, and Filter Gallery Combine 3D text with Vanishing Point for stunning designs Use Liquify for image manipulation Module 12: Introduction to Actions Automate tasks using Photoshop's preset Actions Create your own Actions to save time and effort Module 13: Creating an Animated GIF Learn frame by frame animation Utilize the Timeline to create engaging animated GIFs Learning Outcomes: Master advanced selection techniques, including the Path and Pen Tool, for precise editing. Gain proficiency in advanced layer management and utilize Layer Comps for efficient design organization. Enhance your designs with a deeper understanding and application of Blending Modes. Create visually appealing 3D text and text outlines to add depth and impact to your artwork. Explore advanced Filters like Displacement Maps, Blurs, and Distortion for creative effects. Automate tasks with actions and batch processing, streamlining your workflow. Craft engaging animated GIFs to add dynamic elements to your designs. Skillfully set project requirements by identifying the purpose, target audience, copyright considerations, and project management tasks for successful project execution.

Photoshop Basics to Essentials Training
Delivered in London or OnlineFlexible Dates
£465

AutoCAD Basics-Advanced Training Classes

By London Design Training Courses

Why AutoCAD Basics-Advanced Training Classes? Click here for more info AutoCAD Basics to Advanced Level Training Master drawing, editing, and advanced techniques. Optimize productivity and customize workspace. Create precise 2D drawings for various industries. Access recorded lessons and lifetime email support. Duration: 16 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. The AutoCAD from Basics leading to Advanced Training Course offers a comprehensive learning experience for participants to become proficient in AutoCAD. Whether you're a beginner or an experienced user, this progressive program covers the full spectrum of AutoCAD functionality. Participants will learn core features like drawing, editing, annotations, and dimensioning, progressing to advanced topics such as object manipulation, workspace customization, and workflow optimization. Upon completion, participants will create precise 2D drawings and designs. Interactive learning experiences with experienced instructors are available in-person or through live online sessions. AutoCAD 2D Course Outline: Session 1: Introduction to AutoCAD interface, commands, and tools Managing drawings and drawing basic shapes Basic modification techniques (erase, move, rotate, scale) Session 2: Working with layers and properties Creating and modifying text and dimensions Introduction to blocks and attributes Session 3: Advanced object modification techniques (fillet, chamfer, trim, extend) Using grips to modify objects Creating and modifying polylines and splines Session 4: Creating and editing tables Working with layouts and viewports Printing and exporting drawings Construction detailing and Detailed sections Course Highlights: Engaging exercises and projects to reinforce skills. Q&A and troubleshooting support. Solid understanding of AutoCAD 2D for basic to intermediate drawings. List of Topics Covered: Drawing: Line, Polyline, Circle, Arc, Rectangle, Ellipse, Spline, Polygon, Ray, Hatching, Gradient. Inquiry: Measure and Select All. Modify: Move, Copy, Rotate, Mirror, Fillet, Trim, Extend, Erase, Offset, Explode, Array, Stretch, Break, Polyline Edit, Hatch Edit, Scale. Layers: Creating, Managing, Changing, Line Type, Line Weights. Annotation: Dimensions, Text, Dimension Style, Text Style, Leaders. Properties: Colors, Line weights, Line Types, Line Type Scaling. Blocks: Create, Insert, Edit, Explode, Export. Insert: Insert, Attach. View: Navigate, View, Windows. Plot/Print: Model Space, Layouts/Workspaces, Viewports, Layout Scaling, Paper Setup, What To Plot, Plot Scale, Plot Offset, Plot Options. Final Project: Create a Plan, Section, and Elevation drawing. Option for a personal project. Free Trial - Download AutoCAD Software & Toolsets: Participants can download a free trial of AutoCAD and industry-specific toolsets from Autodesk's official website: (https://www.autodesk.co.uk). Master AutoCAD Basics: Understand the interface, commands, and drawing tools. Create and Modify Drawings: Proficiently manage drawings and apply various modification techniques. Work with Layers and Annotations: Effectively use layers, text, and dimensions. Utilize Advanced Drawing Techniques: Apply advanced object modifications and work with polylines. Navigate Layouts and Viewports: Manage layouts, viewports, and printing/exporting. Hands-On Project Experience: Practice skills through exercises and a final project. Personalized Learning: Receive focused one-to-one attention. Convenient Options: Choose in-person or live online sessions. Lesson Recordings and Support: Access recorded lessons and receive ongoing email assistance. Enhance Career Opportunities: Develop valuable 2D drawing skills for career advancement.

AutoCAD Basics-Advanced Training Classes
Delivered in London or OnlineFlexible Dates
£465

Financial Analysis Training

5.0(10)

By Apex Learning

Best Price Of The Market Give a compliment to your career and take it to the next level. This Financial Analysis bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Financial Analysis bundle will help you stay ahead of the pack. Throughout the Financial Analysis programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant Financial Analysis job sector. Along with this Financial Analysis course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Financial Analysis Bundle Consists of the following Premium courses: Course 01: Financial Analysis Course 02: Financial Management Course 03: Financial Investigator Course 04: Corporate Finance and Investment Decisions Course 05: Commercial Law 2021 Course 06: Risk Management Course 07: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 08: Internal Audit Training Diploma Course 09: Level 3 Tax Accounting Course 10: Diploma in Accounting and Bookkeeping Course 11: Business Analysis Level 3 So, enrol now to advance your Financial Analysis career! How will I get my Certificate? After successfully completing the Financial Analysis 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 £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. The Financial Analysis bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Financial Analysis expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum of Financial Analysis Bundle Course 01: Financial Analysis Section-1. Introduction Section-2. Profitability Section-3. Return Ratio Section-4. Liqudity Ratio Section-5.Operational Analysis Section-6. Detecting Manipulation And 10 more courses... CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Financial Analysis bundle. Requirements This Financial Analysis course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors in Financial Analysis relevant job field. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

Financial Analysis Training
Delivered Online On Demand
£53

SQL Programming with MySQL Database

5.0(1)

By LearnDrive UK

“Master SQL programming and database management with MySQL. Learn to create, manage, and analyze data with SQL’s powerful tools in this comprehensive online course.”

SQL Programming with MySQL Database
Delivered Online On Demand1 hour
£5

SQL Database Management

4.5(3)

By Studyhub UK

Dive into the world of structured data manipulation and management with the SQL course. Explore database fundamentals, constraints, functions, clauses, and advanced concepts such as joins and wild cards. From creating to altering databases, this course empowers you with a versatile skill set to navigate and manipulate data efficiently using SQL. Learning Outcomes: Acquire a foundational understanding of SQL, its role, and importance in database management. Master the creation, organization, and manipulation of databases. Implement constraints to ensure data integrity and enforce business rules. Utilize SQL functions to transform and manipulate data effectively. Employ SQL clauses to filter, sort, and analyze data for specific purposes. Perform alterations on databases and tables to accommodate evolving data needs. Explore the intricacies of joins and relationships to retrieve and consolidate data from multiple tables. Harness the power of wild cards to perform flexible and dynamic data searches. Why buy this SQL Database Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL Database Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL Database Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring Database Administrators and SQL Developers. Software Engineers Seeking Proficiency in SQL for Application Development. Data Analysts and Business Intelligence Professionals. IT Professionals Looking to Enhance Their Database Management Skills. Prerequisites This SQL Database Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path SQL Developer - $70,000 to $110,000/year. Database Administrator - $60,000 to $100,000/year. Data Analyst - $60,000 to $90,000/year. Business Intelligence Developer - $70,000 to $120,000/year. Database Manager - $80,000 to $130,000/year. Course Curriculum Unit 01: Introduction Module 01: Introduction 00:09:00 Module 02: Xampp (PHPmyadmin) installation 00:05:00 Unit 02: Getting Started With Databases Module 01: Creating a database 00:02:00 Module 02: Creating Tables 00:03:00 Module 03: More about Tables 00:01:00 Module 04: Inserting into Tables 00:03:00 Module 05: Updating and Deleting 00:04:00 Module 06: Data Types 00:03:00 Module 07: Conditional and comparison operators 00:04:00 Unit 03: Constraints Module 01: Primary Keys 00:05:00 Module 02: Foreign Keys 00:07:00 Module 03: Indexes 00:03:00 Module 04: Unique Indexes 00:03:00 Unit 04: SQL Functions Module 01: Functions (Part: 01) 00:02:00 Module 02: Functions (Part: 02) 00:03:00 Unit 05: SQL Clauses Module 01: Basic Queries and Where Claueses 00:04:00 Module 02: Order by 00:03:00 Module 03: Distinct 00:05:00 Module 04: In 00:04:00 Module 05: Group by 00:07:00 Unit 06: Alters Module 01: Alters (Part: 01) 00:03:00 Module 02: Alters (Part: 02) 00:05:00 Module 03: Alters (Part: 03) 00:05:00 Unit 07: All about Joins and SQL Relations Module 01: Aliases 00:04:00 Module 02: Inner joins 00:07:00 Module 03: Left and right joins 00:06:00 Module 04: Unions 00:06:00 Unit 08: Wild Cards Module 01: Wild Cards (Part: 01) 00:07:00 Module 02: Wild cards (Part: 02) 00:05:00 Unit 09: More Advanced Areas of SQL Module 01: Views 00:09:00 Module 02: Creating Functions 00:07:00 Module 03: Triggers 00:09:00 Assignment Assignment - SQL 00:00:00

SQL Database Management
Delivered Online On Demand2 hours 33 minutes
£10.99

Vectorworks Basics to Intermediate Training

By London Design Training Courses

Why learn Vectorworks Basics to Intermediate Training Course? Course Link Vectorworks skills with our course! Led by certified expert tutors, this course takes you from basics to intermediate level, enabling you to create plans and sections. The course will cover 2D and 3D modeling, rendering, and visualization.  Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. At London Design Training Course, we offer a range of Vectorworks training options to meet your specific needs and those of your business. Explore the links below for detailed information about the various training types and their content. On-Site Training: London Design Training Course comes to your location, eliminating the need for you to travel. This approach allows us to fully understand your business culture and requirements. Training can be conducted in your studio or conference room, with scheduling flexibility tailored to your preferences. In-House Training: Our studio in London SW96DE, hosts In-House Vectorworks training for both individuals and groups. During the sessions, we provide the necessary software and hardware to ensure a seamless learning experience. Vectorworks Basic to Intermediate Course Course Duration: 16 hours The Vectorworks Basic to Intermediate Course is tailored for individuals with basic Vectorworks knowledge, aiming to master advanced 2D and 3D techniques, including modeling and rendering. Participants will customize Vectorworks to their needs, create custom tools, and automate tasks with scripting. I. Review of Basic Concepts (1 hour) - Vectorworks interface and navigation - Creating and editing 2D and 3D geometry - Working with layers and classes - Utilizing views and viewports II. Advanced 2D Drawing Techniques (2 hours) - Creating complex geometry using advanced drawing tools - Editing and modifying intricate geometry - Customizing line types and hatches - Utilizing advanced annotation tools III. Advanced 3D Modeling (3 hours) - Creating 3D forms and custom 3D objects - Exploring advanced 3D tools such as Solid Modeling - Converting 2D plans into 3D models IV. Visualization and Rendering (3 hours) - Setting up cameras and lights for visualization purposes - Utilizing the Renderworks engine for rendering - Enhancing visuals with the visualization palette - Creating and editing textures and materials V. Customizing Vectorworks (3 hours) - Personalizing the interface to suit specific preferences - Creating custom tools and automating tasks using the scripting language - Developing custom object styles and resources - Creating custom plug-ins and scripts VI. Collaboration and Sharing (2 hours) - Importing and exporting data from other software - Collaborating with others on the same project - Utilizing cloud-based collaboration tools VII. Conclusion and Next Steps (1 hour) - Review of course content and key skills learned - Tips for further learning and available resources - Q&A and feedback session Free 30-day, BIM & CAD Software Trial Request | Vectorworks https://www.vectorworks.net/trial Vectorworks Trial Version Request. Please fill out the following form. We will provide you with an evaluation serial number to activate your trial copy. Learning Outcomes of the Vectorworks Basics to Intermediate Training Course: Proficiency in Vectorworks interface, tools, and navigation. Master 2D drafting and 3D modeling skills. Efficiently manage workflows using layers, classes, and views. Spotlighting techniques for lighting design and stage productions. Advanced object manipulation with solid modeling and Boolean operations. Utilize the symbol library for enhanced productivity. Create professional presentation drawings using viewports and annotations. Integrate with other software and CAD/BIM workflows. Apply skills to real-world projects for practical application. Upon completing the course, participants will have essential skills to effectively use Vectorworks, advancing their proficiency to an intermediate level.

Vectorworks Basics to Intermediate Training
Delivered in London or OnlineFlexible Dates
£465

Learn MySQL from Scratch for Data Science and Analytics

4.5(3)

By Studyhub UK

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Learn MySQL from Scratch for Data Science and Analytics
Delivered Online On Demand5 hours 47 minutes
£10.99

Data Science & Machine Learning with Python

4.8(9)

By Skill Up

Master Data Science and Machine Learning with Python to transform data-driven decisions in businesses.

Data Science & Machine Learning with Python
Delivered Online On Demand10 hours 24 minutes
£25