1047 Courses in Cardiff delivered Online

Course Overview Peek into the world of data science and machine learning with the comprehensive Data Science & Machine Learning With R in 2021 course. This course will provide you with a detailed understanding of both machine learning and data science. In addition, you will acquire essential skills to pursue a career in this growing industry. The Data Science & Machine Learning With R in 2021 course will teach you the core concept of data science. You will be able to recognize different data types and structures. From the modules, you will receive an introduction to the intermediate R Section. The course will show you the techniques of data manipulation in R. You will know the process of data visualization with R and learn to create reports with R markdown. The Data Science & Machine Learning With R in 2021 course will provide you with an insight into the fundamentals of machine learning. You will understand the principles of data processing, linear regression, logistic regression and more.  This highly informative Data Science & Machine Learning With R in 2021 course will equip you with the essential skills of data science. If you desire to become a professional data scientist, this course can be your stepping stone. So, enroll in the course and fast track your career. Learning Outcomes Learn the definition of data science Understand the basics of machine learning Enrich your knowledge of data types and structures Know the process of data manipulation in R Gain the ability to create reports with R markdown Become skilled in building web apps with R shiny Who is this course for? Aspiring data scientists or individuals interested in learning data science and machine learning  Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The Data Science & Machine Learning With R in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Data Scientist Data Science and Machine Learning Course Intro Data Science and Machine Learning Introduction 00:03:00 What is Data Science 00:10:00 Machine Learning Overview 00:05:00 Who is This Course for 00:03:00 Data Science and Machine Learning Marketplace 00:05:00 Data Science and Machine Learning Job Opportunities 00:03:00 Data Types and Structures in R Getting Started 00:16:00 Basics 00:06:00 Files 00:11:00 RStudio 00:07:00 Tidyverse 00:05:00 Resources 00:04:00 Data Types and Structures in R Unit Introduction 00:30:00 Basic Type 00:09:00 Vector Part One 00:20:00 Vectors Part Two 00:25:00 Vectors - Missing Values 00:16:00 Vectors - Coercion 00:14:00 Vectors - Naming 00:10:00 Vectors - Misc 00:06:00 Creating Matrics 00:31:00 List 00:32:00 Introduction to Data Frames 00:19:00 Creating Data Frames 00:20:00 Data Frames: Helper Functions 00:31:00 Data Frames Tibbles 00:39:00 Intermediate R Intermediate Introduction 00:47:00 Relational Operations 00:11:00 Conditional Statements 00:11:00 Loops 00:08:00 Functions 00:14:00 Packages 00:11:00 Factors 00:28:00 Dates and Times 00:30:00 Functional Programming 00:37:00 Data Import or Export 00:22:00 Database1 00:27:00 Data Manipulation in R Data Manipulation in R Introduction 00:36:00 Tidy Data 00:11:00 The Pipe Operator 00:15:00 The Filter Verb 00:22:00 The Select Verb 00:46:00 The Mutate Verb 00:32:00 The Arrange Verb 00:10:00 The Summarize Verb 00:23:00 Data Pivoting 00:43:00 JSON Parsing 00:11:00 String Manipulation 00:33:00 Web Scraping 00:59:00 Data Visualization in R Data Visualization in R Section Intro 00:17:00 Getting Started 00:16:00 Aesthetics Mappings 00:25:00 Single Variable Plots 00:37:00 Two Variable Plots 00:21:00 Facets, Layering, and Coordinate Systems 00:18:00 Styling and Saving 00:12:00 Creating Reports with R Markdown Creating with R Markdown 00:29:00 Building Webapps with R Shiny Introduction to R Shiny 00:26:00 A Basic R Shiny App 00:31:00 Other Examples with R Shiny 00:34:00 Introduction to Machine Learning Machine Learning Part 1 00:22:00 Machine Learning Part 2 00:47:00 Starting A Career in Data Science Starting a Data Science Career Section Overview 00:03:00 Data Science Resume 00:04:00 Getting Started with Freelancing 00:05:00 Top Freelance Websites 00:05:00 Personal Branding 00:05:00 Importance of Website and Blo 00:04:00 Networking Do's and Don'ts 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 4 Hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft PowerPont Understand the core competencies and principles of Microsoft PowerPont Explore the various areas of Microsoft PowerPont Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners Course Master the skills you need to propel your career forward in Microsoft PowerPoint. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft PowerPoint course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft PowerPoint course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft PowerPoint practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft PowerPoint industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft PowerPoint. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft PowerPoint. Enrol in this Microsoft PowerPoint course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft PowerPoint course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft PowerPoint can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft PowerPoint course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft PowerPoint course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft PowerPoint course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Getting Started With PowerPoint Navigate the PowerPoint Environment - Introduction 00:01:00 Navigate the PowerPoint Environment 00:11:00 View and Navigate a Presentation - Introduction 00:01:00 View and Navigate a Presentation 00:09:00 Create and Save a PowerPoint Presentation - Introduction 00:01:00 Create and Save a PowerPoint Presentation 00:07:00 Use PowerPoint Help - Introduction 00:01:00 Use PowerPoint Help 00:06:00 Developing a PowerPoint Presentation Select a Presentation Type - Introduction 00:01:00 Select a Presentation Type 00:06:00 Edit Text 00:10:00 Add, Delete and Modify Slides 00:09:00 Work with Themes - Introduction 00:01:00 Work With Themes 00:05:00 Performing Advanced Text Editing Operations Format Characters - Introduction 00:01:00 Format Characters 00:08:00 Format Paragraphs - Introduction 00:01:00 Text Alignment Options 00:08:00 Text Alignment Options 00:08:00 Format Text Boxes 00:10:00 Adding Graphical Elements to Your Presentation Add Graphical Elements to Your Presentation - Introduction 00:01:00 Insert Images 00:08:00 Insert Shapes 00:08:00 Modifying Objects in Your Presentation Modify Objects In Your Presentation - Introduction 00:01:00 Edit Objects 00:09:00 Format Objects 00:08:00 Animate Objects 00:06:00 Adding Tables to Your Presentation Add A Table - Introduction 00:01:00 Create a Table 00:05:00 Format a Table 00:07:00 Insert A Table From Others Office Applictions 00:08:00 Adding Charts to Your Presentation Add A Chart - Introduction 00:01:00 Create a Chart 00:07:00 Format a Chart 00:08:00 Insert a Chart from Microsoft Excel 00:03:00 Preparing to Deliver Your Presentation Prepare Your Presentation - Introduction 00:02:00 Review Your Presentation - Part 1 00:06:00 Review Your Presentation - Part 2 00:06:00 Apply Transitions 00:06:00 Print Your Presentation 00:06:00 Present a Slide Show 00:07:00 Export a Presentation to a PDF File 00:03:00 Bonus Lecture 00:01:00 What's New In PowerPoint 2019/365? Highlight Text 00:03:00 How to Adjust the Link Color 00:02:00 Draw and Write Digitally 00:04:00 Animate Freehand Drawings 00:04:00 Create Professional Slide Layouts With PowerPoint Designer 00:04:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Description Are you looking forward to learn the world's most powerful and efficient editing application, used by professional photographers? Light-room is software for the professional and keen amateur photographer, helping you organize, edit and share your photography. It also allows for a cross-platform interaction with other programs such as Adobe Photoshop. By getting involved with Lightroom, you save time and are more productive, which means you can get back to doing what you love - taking amazing pictures. If so, having this Adobe Lightroom Complete Training will be a great choice for you! Boost your skills to rapidly import, categorize and batch edit your photography. This course will teach you everything you to start photo editing today. You will learn to manage and store your digital images, and how to properly edit, print and display your work for the world to see.  Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Adobe Lightroom Complete Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Adobe Lightroom Complete Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Edit Like a Pro! - 1 - Navvy on the river Liffey, Dublin, Ireland Opening Titles FREE 00:01:00 Introduction to our image 00:03:00 Let's start with some global adjustments Fix verticals using transform 00:02:00 Crop out distracting elements 00:01:00 Tonal range, black and white points 00:03:00 Decisions about clarity 00:01:00 now we focus in and make localised adjustments to different parts of the image Localised adjustments using the radial filter 00:03:00 Localised adjustments using the clone tool 00:06:00 Localised brightening using the adjustment brush 00:01:00 Localised adjustments - white balance 00:03:00 Finishing off... Final edits - subject, background, corners 00:02:00 Thanks for watching! 00:01:00 Let's get started Titles and promo 00:01:00 Edit Like a Pro promo 00:02:00 Introduction to our image 00:03:00 Initial Processing - Assessing the image Reading the Histogram 00:03:00 Creating the HDR merge 00:05:00 Sorting your images in Grid view 00:02:00 Using Survey mode (N) to compare images 00:01:00 Keywording our new image 00:03:00 Main Edits Editing - the Basic tab 00:06:00 Editing - the Transform tab 00:04:00 Editing - Sharpening 00:03:00 Edit - Radial filters 00:08:00 Editing - Adjustment brush 00:07:00 Thanks for Watching! Editing - Final Tweaks 00:04:00 Thanks for watching! 00:01:00 Edit Like a Pro! - 3 - Light Trails on O'Connell Street Bridge, Dublin, Ireland Opening titles 00:01:00 Introduction to our image 00:03:00 Using Lightroom and Photoshop Selecting the images to export into Photoshop 00:02:00 Combining our images in Photoshop 00:04:00 Finding the new composite file back in Lightroom 00:01:00 Editing our composite image back in Lightroom Editing our merged image 00:02:00 Edit - fixing verticals with the transform tab 00:02:00 Edit - changing the crop 00:02:00 Edit - Basic panel adjustments 00:05:00 Edit - tone curve and sharpening 00:02:00 Finishing off... Final touches 00:02:00 Thanks for watching! 00:01:00 Let's set our image up for editing... Opening titles 00:01:00 Promo for Edit Like a Pro! - 4 - Castletown Stately Home 00:01:00 Introduction to our image 00:01:00 Keywording our image 00:02:00 Editing metadata pre-sets 00:02:00 The Basic Tab - initial editing Setting the Crop 00:05:00 Adjusting tonal range using the Histogram 00:04:00 Highlights, Shadows, Whites & Blacks 00:03:00 Clarity, Vibrance & Saturation 00:02:00 Adjusting Contrast using the Tone Curve 00:02:00 The HSL tab Adjusting Hue, Saturation and Luminance 00:04:00 Sharpening and Orientation Sharpening & the Detail tab 00:04:00 Lens Corrections 00:02:00 Tweaking verticals with the Transform tab 00:04:00 Subtle finishing touches Applying a vignette in the Effects tab 00:01:00 Using Camera Calibration for different 'looks' 00:03:00 Bring out shadow detail with Radial Filters & Adjustment Brushes 00:06:00 Cloning out distracting elements 00:10:00 B&W using Nik Silver Efex Pro 2 00:10:00 Thanks for watching! 00:01:00 Introduction Opening titles 00:01:00 Basic edits Setting up the develop tab 00:02:00 Correcting perspective 00:04:00 Applying a panoramic crop 00:03:00 Complex selections in Lightroom Selecting the sky 00:16:00 Adjusting the building 00:08:00 Cleaning the clock faces 00:04:00 Finishing off The Basic tab 00:04:00 Seeing the before and after 00:01:00 Thanks for watching 00:01:00 Assessment Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about graphics design Understand the core competencies and principles of graphics design Explore the various areas of graphics design Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert graphics designer Inkscape Tutorials - Learn To Create Vector Graphics Course Master the skills you need to propel your career forward in vector graphics design. This course will equip you with the essential knowledge and skillset that will make you a confident graphics designer and take your career to the next level. This comprehensive inkscape tutorials - learn to create vector graphics course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this learn inkscape now - create vector graphics course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective vector graphics design practice and equip you with the essential skills, confidence and competence to assist you in the vector graphics design industry. You'll gain a solid understanding of the core competencies required to drive a successful career in vector graphics design. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for graphics designer or for people who are aspiring to specialise in vector graphics design. Enrol in this inkscape tutorials - learn to create vector graphics course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive inkscape tutorials - learn to create vector graphics course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this vector graphics design can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This learn inkscape tutorials - learn to create vector graphics course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This learn inkscape tutorials - learn to create vector graphics course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This learn inkscape tutorials - learn to create vector graphics course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 The User Interface 00:04:00 Your First Drawing Draw Your First Object 00:03:00 Saving Your Work and Exporting 00:03:00 Select and Transform Objects 00:04:00 Dealing with Multiple Objects 00:07:00 Let's Color it - the Basics of Color Usage 00:09:00 Groups and Basic Drawings 00:06:00 Learn More Tools Edit Path by Nodes 00:11:00 Another View on Colors 00:06:00 Gradients 00:07:00 Going for the 3D Look - Gradients and Blur 00:09:00 Clipping and Masking 00:10:00 Working with Text 00:10:00 Layers 00:04:00 Guidelines, Rulers, Align and Distribute 00:06:00 Being a Bit More Creative The Spray Tool 00:08:00 The Pencil Tool - Create Custom Brushes 00:08:00 Sculpt Tool 00:05:00 Pattern Along Path 00:05:00 Filters and Extensions 00:04:00 Import Photos and Tracing 00:08:00 How to Create Patterns 00:05:00 Blending Modes 00:05:00 Put Everything Together Create a Christmas Card 00:03:00 Draw a Funny elf Character 00:18:00 Finish Your Character and Create Falling Snow 00:15:00 Put Text on Card 00:06:00 Finalize and Export Your Drawing 00:01:00 What's New in Inkscape 0.91? New Way to Deal with Gradients 00:03:00 Tips and Tricks Use “Find and Replace” to Manage Multiple Objects 00:05:00 How to Create Mandala 00:05:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Duration 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. Introduction to Data on the Google Cloud Platform Highlight Analytics Challenges Faced by Data Analysts Compare Big Data On-Premises vs on the Cloud Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud Navigate Google Cloud Platform Project Basics Lab: Getting started with Google Cloud Platform Big Data Tools Overview Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools Demo: Analyze 10 Billion Records with Google BigQuery Explore 9 Fundamental Google BigQuery Features Compare GCP Tools for Analysts, Data Scientists, and Data Engineers Lab: Exploring Datasets with Google BigQuery Exploring your Data with SQL Compare Common Data Exploration Techniques Learn How to Code High Quality Standard SQL Explore Google BigQuery Public Datasets Visualization Preview: Google Data Studio Lab: Troubleshoot Common SQL Errors Google BigQuery Pricing Walkthrough of a BigQuery Job Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs Optimize Queries for Cost Lab: Calculate Google BigQuery Pricing Cleaning and Transforming your Data Examine the 5 Principles of Dataset Integrity Characterize Dataset Shape and Skew Clean and Transform Data using SQL Clean and Transform Data using a new UI: Introducing Cloud Dataprep Lab: Explore and Shape Data with Cloud Dataprep Storing and Exporting Data Compare Permanent vs Temporary Tables Save and Export Query Results Performance Preview: Query Cache Lab: Creating new Permanent Tables Ingesting New Datasets into Google BigQuery Query from External Data Sources Avoid Data Ingesting Pitfalls Ingest New Data into Permanent Tables Discuss Streaming Inserts Lab: Ingesting and Querying New Datasets Data Visualization Overview of Data Visualization Principles Exploratory vs Explanatory Analysis Approaches Demo: Google Data Studio UI Connect Google Data Studio to Google BigQuery Lab: Exploring a Dataset in Google Data Studio Joining and Merging Datasets Merge Historical Data Tables with UNION Introduce Table Wildcards for Easy Merges Review Data Schemas: Linking Data Across Multiple Tables Walkthrough JOIN Examples and Pitfalls Lab: Join and Union Data from Multiple Tables Advanced Functions and Clauses Review SQL Case Statements Introduce Analytical Window Functions Safeguard Data with One-Way Field Encryption Discuss Effective Sub-query and CTE design Compare SQL and Javascript UDFs Lab: Deriving Insights with Advanced SQL Functions Schema Design and Nested Data Structures Compare Google BigQuery vs Traditional RDBMS Data Architecture Normalization vs Denormalization: Performance Tradeoffs Schema Review: The Good, The Bad, and The Ugly Arrays and Nested Data in Google BigQuery Lab: Querying Nested and Repeated Data More Visualization with Google Data Studio Create Case Statements and Calculated Fields Avoid Performance Pitfalls with Cache considerations Share Dashboards and Discuss Data Access considerations Optimizing for Performance Avoid Google BigQuery Performance Pitfalls Prevent Hotspots in your Data Diagnose Performance Issues with the Query Explanation map Lab: Optimizing and Troubleshooting Query Performance Advanced Insights Introducing Cloud Datalab Cloud Datalab Notebooks and Cells Benefits of Cloud Datalab Data Access Compare IAM and BigQuery Dataset Roles Avoid Access Pitfalls Review Members, Roles, Organizations, Account Administration, and Service Accounts

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want You can master the art of web design with our comprehensive WordPress Web Design Training Course. You will learn to create stunning and professional websites using the versatile WordPress platform with no prior coding experience required. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Learn website online hosting plan and steps to install WordPress on the website Understand classic editor vs Gutenburg Know how to create WordPress website pages and menus Get acquainted with WordPress page builder familiarisation Understand WordPress home page design and development Know WordPress About us page design and development Discover free plugins to mimic the elementor pro and premium plugins Learn how to create a WordPress e-commerce store Understand WordPress website backup and official mail Learn how to export and import elementor pages Why WordPress Web Design Training Course right for you? This comprehensive online course is designed for those who want to understand WordPress elementor, website online hosting plan, and steps to install WordPress on the website. You will learn interesting concepts such as WordPress page builder familiarisation, home page design and development, About us page design and development, and much more. In addition, this extensive course will give you a solid knowledge of exporting and importing elementor pages, steps to create a WordPress eCommerce store and website backup. By the end of the course, you will have a broad understanding of WordPress installation, website backup, free plug-ins, web page design and development. WordPress Web Design Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Introduction & Installing WordPress WordPress Elementor Course Outline Website Online Hosting Plan Installing WordPress on Our Website Installing WordPress Ocean WP Theme & Elementor Page Builder Classic Editor Vs Gutenburg (Optional) Creating WordPress Website Pages & Menus WordPress Page Builder Familiarization Quick Tour in Elementor Creative Art Directions & Layout Inspirations for WordPress Design Familiarize with Elementor Part 1 (sections) Familiarize with Elementor Part2 (widgets) Brain Storming & Tips for Fast Workflow with Elementor WordPress home page Design & development WordPress Header & Banner Design Part 1 WordPress Header & Banner Design Part2 WordPress Header & Banner Design Part3 WordPress Website Middle Sections Design & Development WordPress Png Section Design WordPress Email Opt-in Section Design WordPress Testimonials Section Design WordPress Image Carousel Section Design WordPress Website Footer Design WordPress Website Theme Customizer Tour & Logo Finalizing Our WordPress Home Page & Design Tips WordPress About Us Page Design & Development WordPress About Us Page Design Part1 WordPress About Us Design Part2 WordPress About Us Design Part3 WordPress Contact Us & Blog Page Design & Development WordPress Website Contact Us Page & Blog Page Design Creating WordPress Blog & Posting With Elementor WordPress Responsive Website & Publishing Website WordPress Mobile & Tablet Responsive Website Publishing WordPress Website & Creating Maintenance & Coming Soon Pages Free Plugins to Mimic The Elementor Pro & Premium Plugins Free Plugins to Convert Your Elementor Into Pro Crocoblock For Elementor Exporting & Importing Our Elementor Pages Exporting & Importing Our Elementor Web Pages Creating Our WordPress Ecommerce Store Installing Woocommerce Plugin ( For WordPress Ecommerce ) Making First Ecommerce Product (Simple Product) Variable Ecommerce Product Up Sells & Cross Sells WordPress Woocommerce Settings Ecommerce Discount Coupons Designing Ecommerce Store with Elementor & WordPress Theme WordPress Website Customization Converting WordPress Website to HTTPS (SSL Certificate) Google Analytics & Webmasters Tool Speeding Up Our WordPress Website Optimizing Images & Creative Art Directions Subdomain WordPress Website Backup, Official Email & More Website Domian Official Email WordPress Site Back up & Trust Lock Seal Who should take this course? This comprehensive course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of WordPress web design training . Entry Requirements There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This WordPress Web Design Training Course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

This module aims to develop knowledge and understanding of customs procedures associated with international trade. The module includes trade agreements, tariffs and taxes, immigration, intellectual property rights, clearance procedures, transport regulations, sanitary and Phyto-sanitary measures, customs valuation, preference systems and anti-dumping measures.

Overview This Tutorial For Inkscape - Learn Vector Graphics Design course will unlock your full potential and will show you how to excel in a career in Tutorial For Inkscape - Learn Vector Graphics Design. So upskill now and reach your full potential. Everything you need to get started in Tutorial For Inkscape - Learn Vector Graphics Design is available in this course. Learning and progressing are the hallmarks of personal development. This Tutorial For Inkscape - Learn Vector Graphics Design will quickly teach you the must-have skills needed to start in the relevant industry. In This Tutorial For Inkscape - Learn Vector Graphics Design Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Tutorial For Inkscape - Learn Vector Graphics Design skills to help you advance your career. Acquire a comprehensive understanding of various Tutorial For Inkscape - Learn Vector Graphics Design topics and tips from industry experts. Learn in-demand Tutorial For Inkscape - Learn Vector Graphics Design skills that are in high demand among UK employers, which will help you to kickstart your career. This Tutorial For Inkscape - Learn Vector Graphics Design course covers everything you must know to stand against the tough competition in the Tutorial For Inkscape - Learn Vector Graphics Design field.  The future is truly yours to seize with this Tutorial For Inkscape - Learn Vector Graphics Design. Enrol today and complete the course to achieve a Tutorial For Inkscape - Learn Vector Graphics Design 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 Tutorial For Inkscape - Learn Vector Graphics Design 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 Tutorial For Inkscape - Learn Vector Graphics Design 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 Tutorial For Inkscape - Learn Vector Graphics Design 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 Tutorial For Inkscape - Learn Vector Graphics Design is suitable for anyone aspiring to start a career in Tutorial For Inkscape - Learn Vector Graphics Design; even if you are new to this and have no prior knowledge on Tutorial For Inkscape - Learn Vector Graphics Design, this course is going to be very easy for you to understand.  And if you are already working in the Tutorial For Inkscape - Learn Vector Graphics Design 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 Tutorial For Inkscape - Learn Vector Graphics Design 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 Tutorial For Inkscape - Learn Vector Graphics Design course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Tutorial For Inkscape - Learn Vector Graphics Design 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 Tutorial For Inkscape - Learn Vector Graphics Design course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction Introduction 00:02:00 The user interface 00:05:00 Your first tools! Draw your first object 00:04:00 Saving your work and exporting 00:03:00 Select and transform objects 00:04:00 Dealing with multiple objects 00:07:00 Let's color it! - the basics of color usage 00:09:00 Shape and path 00:08:00 Groups and basic drawings 00:07:00 Learn more tools! Edit path by nodes 00:12:00 Another view on colors 00:06:00 Gradients 00:07:00 Going for the 3D look - gradients and blur 00:09:00 Clipping and masking 00:01:00 Working with text 00:11:00 Layers 00:04:00 Guidelines, rulers, align and distribute 00:06:00 Being a bit more creative! The spray tool 00:08:00 The pencil tool - create custom brushes 00:08:00 Sculpt tool 00:05:00 Pattern along path 00:05:00 Filters and extensions 00:04:00 Import photos and tracing 00:08:00 How to create patterns 00:06:00 Blending modes 00:06:00 Put everything together! Create a Christmas card 00:04:00 Draw a funny elf character 00:18:00 Finish your character and create falling snow 00:15:00 Finalize and export your drawing 00:01:00 What's newin Inkscape 0.91? Why Inkscape 0.91 What is new 00:05:00 New way to deal with gradients! 00:04:00 Powerstroke and the symbol library 00:05:00 Tip and tricks Change canvas color 00:04:00 Use Find and replace to manage multiple objects 00:06:00 Tips for creating a good pattern 00:06:00 How to create mandala 00:06:00 Bonus lecture - check this out! 00:01:00

Duration 5 Days 30 CPD hours This course is intended for This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore: The Oracle Database Architecture Query Optimizer Tuning Container Databases and Pluggable Databases Oracle 19c Tuning features Evaluating Execution Plans Oracle Tuning Tools Using Automatic Workload Repository Join Types AWR Using Baselines Additional AWR performance tools Optimizer Statistics Monitoring a Service Bind Variables and database parameters Oracle's Real Application Testing (RAT) SQL Tuning Advisor Automatic Sql Tuning Sql Plan Management Shared Pool Tuning Tuning the database buffer cache Tuning the PGA (Program Global Area) Automatic Memory Management (AMM) Tuning Segment Space Utilization (ASSM) Automatic Storage Management Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more. Overview Oracle Database Architecture Instance Definition Define SGA Define Background Processes Datafile Definition Query Optimizer SQL Parsing Optimizing Terms Optimizing Methods Query Plan Generation Query Plan Control Tuning Container Databases and Pluggable Databases Pluggable tuning parameters Define Container tuning structure Using PDB$SEED Create a new PDB Plug and unplug a PDB Oracle 12c Tuning features Identifying and Using Oracle's Heat Map 12c Compression Levels and Types Evaluating Execution Plans Defining SQL execution plans Automatic Workload Repository Reading execution plans Oracle Tuning Tools Monitoring tools overview Enterprise Manager Dynamic Performance Views Automatic Workload Repository Automatic Database Diagnostic Monitor Sql Tuning Advisor SQL Access Advisor Sql Access Advisor DB operation Tuning DB operation Active Reporting Using Automatic Workload Repository Defining AWR AWR Settings Creating AWR Baselines Metrics, Alerts, and Thresholds Defining Metrics Setting Alerts Setting Corrective Actions User Defined Metrics Metric Dynamic Views Join Types Nested Loops Join Sort Merge join Hash Join and Cartesian Join Equijoins and Nonequijoins Outer Joins Semijoins AWR Using Baselines Creating AWR baselines Creating AWR Repeating baselines Moving Window Baseline Additional AWR performance tools Automatic Maintenance Tasks Segment Advisor Statistics Gathering Automatic Tuning Optimizer Automatic Database Diagnostic Monitor Active Session History (ASH) Optimizer Statistics Optimizer Statistics Overview Table and Index Statistics Statistic Preferences Statistics Gathering e) Locking Statistics, Export/Import Statistics Pending and published statistics Optimizer Hints Optimizer Paths Cost Base Optimization Monitoring a Service Overview of what is an Oracle Service Creating an Oracle Service for Single instance and RAC Monitoring a Service Resource Management and a Service Enterprise Manager and a Service Bind Variables and database parameters Bind variable definition Cursor_sharing parameter Adaptive Cursor Sharing Oracle's Real Application Testing (RAT) Sql Performance Analyzer overview Sql Performance Analyzer Options Database Parameter changes Database version changes Creating SQL Tuning Sets Database Replay Overview Database Replay Configuration Database Replay Options SQL Tuning Advisor SQL Tuning Advisor: Overview SQL Tuning Advisor Limited Mode Sql Tuning Advisor Comprehensive mode Sql Tuning Profiles SQL Access Advisor SQL Access Advisor: Overview Sql Access Advisor options SQL Access Advisor and Sql Tuning Sets Sql Access Advisor and AWR Results and Implementation Automatic Sql Tuning Automatic Sql Tuning Maintenance Task Automatic Tuning Optimization implementation(ATO) Automatic Tuning Optimization Results Enable/Disable Automatic Tuning Optimization Sql Plan Management Sql plan Management and baseline overview Enable sql plan management Loading Sql Plan baselines into the SGA Adaptive plan management Shared Pool Tuning Shared pool architecture Shared pool parameters Library Cache Dictionary cache Large pool considerations and contents Tuning the database buffer cache Database buffer cache overview Database buffer cache parameters Oracle and Dirty reads and writes Automatic Shared Memory Management (ASMM) Buffer Cache goals and responsibility Buffer Cache pools Tuning the PGA (Program Global Area) PGA Overview PGA Database Parameters Temporary Segments Temporary Tablespace Sizing the PGA Automatic Memory Management (AMM) Oracle's Automatic Memory Management Overview Database Auto-tuned Parameters Database Non Auto-tuned Parameters Automatic Memory Management Hints and Sizing suggestions AMM versus ASMM Tuning Segment Space Utilization (ASSM) Overview of Automatic Segment Space Management Defining the DB_BLOCK_SIZE Defining DB_nk_CACHE_SIZE parameter The DB_BLOCK_SIZE Parameter Overview of table compression, block chaining, and block migration Automatic Storage Management Overview of ASM Definition of Grid Infrastructure ASM Instance ASM Diskgroups ASM Diskgroup parameters and templates ASMCMD