427 Courses

Duration 4 Days 24 CPD hours This course is intended for This class is intended for experienced developers who are responsible for managing big data transformations including: Extracting, loading, transforming, cleaning, and validating data. Designing pipelines and architectures for data processing. Creating and maintaining machine learning and statistical models. Querying datasets, visualizing query results and creating reports Overview Design and build data processing systems on Google Cloud Platform. Leverage unstructured data using Spark and ML APIs on Cloud Dataproc. Process batch and streaming data by implementing autoscaling data pipelines on Cloud Dataflow. Derive business insights from extremely large datasets using Google BigQuery. Train, evaluate and predict using machine learning models using TensorFlow and Cloud ML. Enable instant insights from streaming data Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hand-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data. Introduction to Data Engineering Explore the role of a data engineer. Analyze data engineering challenges. Intro to BigQuery. Data Lakes and Data Warehouses. Demo: Federated Queries with BigQuery. Transactional Databases vs Data Warehouses. Website Demo: Finding PII in your dataset with DLP API. Partner effectively with other data teams. Manage data access and governance. Build production-ready pipelines. Review GCP customer case study. Lab: Analyzing Data with BigQuery. Building a Data Lake Introduction to Data Lakes. Data Storage and ETL options on GCP. Building a Data Lake using Cloud Storage. Optional Demo: Optimizing cost with Google Cloud Storage classes and Cloud Functions. Securing Cloud Storage. Storing All Sorts of Data Types. Video Demo: Running federated queries on Parquet and ORC files in BigQuery. Cloud SQL as a relational Data Lake. Lab: Loading Taxi Data into Cloud SQL. Building a Data Warehouse The modern data warehouse. Intro to BigQuery. Demo: Query TB+ of data in seconds. Getting Started. Loading Data. Video Demo: Querying Cloud SQL from BigQuery. Lab: Loading Data into BigQuery. Exploring Schemas. Demo: Exploring BigQuery Public Datasets with SQL using INFORMATION_SCHEMA. Schema Design. Nested and Repeated Fields. Demo: Nested and repeated fields in BigQuery. Lab: Working with JSON and Array data in BigQuery. Optimizing with Partitioning and Clustering. Demo: Partitioned and Clustered Tables in BigQuery. Preview: Transforming Batch and Streaming Data. Introduction to Building Batch Data Pipelines EL, ELT, ETL. Quality considerations. How to carry out operations in BigQuery. Demo: ELT to improve data quality in BigQuery. Shortcomings. ETL to solve data quality issues. Executing Spark on Cloud Dataproc The Hadoop ecosystem. Running Hadoop on Cloud Dataproc. GCS instead of HDFS. Optimizing Dataproc. Lab: Running Apache Spark jobs on Cloud Dataproc. Serverless Data Processing with Cloud Dataflow Cloud Dataflow. Why customers value Dataflow. Dataflow Pipelines. Lab: A Simple Dataflow Pipeline (Python/Java). Lab: MapReduce in Dataflow (Python/Java). Lab: Side Inputs (Python/Java). Dataflow Templates. Dataflow SQL. Manage Data Pipelines with Cloud Data Fusion and Cloud Composer Building Batch Data Pipelines visually with Cloud Data Fusion. Components. UI Overview. Building a Pipeline. Exploring Data using Wrangler. Lab: Building and executing a pipeline graph in Cloud Data Fusion. Orchestrating work between GCP services with Cloud Composer. Apache Airflow Environment. DAGs and Operators. Workflow Scheduling. Optional Long Demo: Event-triggered Loading of data with Cloud Composer, Cloud Functions, Cloud Storage, and BigQuery. Monitoring and Logging. Lab: An Introduction to Cloud Composer. Introduction to Processing Streaming Data Processing Streaming Data. Serverless Messaging with Cloud Pub/Sub Cloud Pub/Sub. Lab: Publish Streaming Data into Pub/Sub. Cloud Dataflow Streaming Features Cloud Dataflow Streaming Features. Lab: Streaming Data Pipelines. High-Throughput BigQuery and Bigtable Streaming Features BigQuery Streaming Features. Lab: Streaming Analytics and Dashboards. Cloud Bigtable. Lab: Streaming Data Pipelines into Bigtable. Advanced BigQuery Functionality and Performance Analytic Window Functions. Using With Clauses. GIS Functions. Demo: Mapping Fastest Growing Zip Codes with BigQuery GeoViz. Performance Considerations. Lab: Optimizing your BigQuery Queries for Performance. Optional Lab: Creating Date-Partitioned Tables in BigQuery. Introduction to Analytics and AI What is AI?. From Ad-hoc Data Analysis to Data Driven Decisions. Options for ML models on GCP. Prebuilt ML model APIs for Unstructured Data Unstructured Data is Hard. ML APIs for Enriching Data. Lab: Using the Natural Language API to Classify Unstructured Text. Big Data Analytics with Cloud AI Platform Notebooks What's a Notebook. BigQuery Magic and Ties to Pandas. Lab: BigQuery in Jupyter Labs on AI Platform. Production ML Pipelines with Kubeflow Ways to do ML on GCP. Kubeflow. AI Hub. Lab: Running AI models on Kubeflow. Custom Model building with SQL in BigQuery ML BigQuery ML for Quick Model Building. Demo: Train a model with BigQuery ML to predict NYC taxi fares. Supported Models. Lab Option 1: Predict Bike Trip Duration with a Regression Model in BQML. Lab Option 2: Movie Recommendations in BigQuery ML. Custom Model building with Cloud AutoML Why Auto ML? Auto ML Vision. Auto ML NLP. Auto ML Tables.

Give a compliment to your career and take it to the next level. This Digital Marketing 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 Digital Marketing bundle will help you stay ahead of the pack. Throughout the Digital Marketing programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Digital Marketing course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Digital Marketing Bundle Consists of the following Premium courses: Course 01: Digital Marketing and Advertising Level 3 Course 02: Content Management Course 03: Blogging Course 04: Pinterest Marketing Course 05: WordPress Website Creation and Hosting System with Affiliate Marketing Course 06: Writing Short Story Training Course 07: Professional Photography Course 08: Level 2 Adobe Graphics Design Course Course 09: Freelancing on UpWork Course 10: Sales and Marketing Skills Course 11: Applied Business Analysis Diploma Enrol now in Digital Marketing to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Digital Marketing 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 Digital Marketing and Advertising Level 3 Module 01: Introduction Welcome Module 02: General Tips & Tricks Series How to register your company How to see Email Sender's Company and Logo in Your Gmail How to Generate sitemap of a website How to protect a website from Spam on WordPress Quick way to identify whether the website is Mobile optimized How to identify registration data of website How to identify duplicate content from the web How to create google alerts How to find the age of the domin How to check if the website server is down How to create text notes thatwill self destruct after being read How to send google search information to your friends How to find webhost of any website Discover new sites that are similar to what you like alredy How to easily highlight the important parts of a web page How to share you email online without worrying about spam How to get compute level answers without searching The easiest way to setup email reminders How to find the original URL tht's hiding behind a short URL How to corrupt a file you shared online How to create a throwaway email How to check if your email account has been compromised Module 03: SEO (Search Engine Optimisation) How to register website on Google search console How to Optimize your website homepage How to add a sitemap on google search How to shortlist targeted keyword list in google keyword planner How to set international targeting on google search How to remove a URL from google search engine How to identify competitors keyword How to leverage top sites to get on google search results Discover powerful data analytics to mesure SEO performance How to do keyword research How to write perfect title tags for search engines How to optimise heading tags, external and internal links What are backlinks & how to get them How to write a perfect Meta description How to enhance speed & performance of your website Module 04: YouTube Youtube account setup Account optimization How to create & setup Youtube channel banner Youtube channel tags, thumbnails & custom thumbnails Analyse Youtube keyword research Youtube SEO techniques What are Youtube cards & how does it work How to optimise comments & reply them in bulk How to grow your channel with competitor Analysis How to manage multiple YouTube accounts A simple yet powerful trick to increase your subscribers list Youtube Paid Advertising How to monetise your YouTube channel Module 05: Google Adwords What are Google Ads & how does it work Account setup Competitors analysis Campaign types & how to select the right campaign Bids & Budgets How to target the right audience Google Ads advance campaign settings Choosing the right keywords How to write ads that gets more clicks Module 06: Google Analytics How to install tracking code on your website How to add filters & remove internal traffic How to track paid campaigns How to look and analyse different segment data How to configure goals in google analysics How to link google Adwords account How to manage multiple analytics accounts How to remove spam traffic Module 07: Email Marketing How to install signup or popup forms on the website How to collect email address without a wbsite How to create a 'Hook' to your signup forms Discover the psychology behind acquiring more leads Email analytics And Much More..... Module 08: LinkedIn How to increase your connections in no time Secret of LinkedIn InMails Discover the best ways to use Linkedin Groups How to setup a company page on Linkedin How to increase traffic to your website using Linkedin blog Module 09: Twitter Twitter Account setup Knowing Twitter features Following twitter accounts Twitter profile optimisation How to get Twitter followers Posting first 5 tweets for engagement Leveraging Hashtags to increase your tweets visibility What are twitter polls & how do you use them A powerful trick to acquire customers on twitter How to get followers retweet your post How to embed a twitter button to your website or post Twitter analytics Module 10: Facebook Set your Facebook page Facebook Icon, cover image & description How to get your first page likes Discover how to increase your page likes How to manage multiple Facebook page Facebook comments Leveraging Facebook groups Facebook Autoposting Run a competition Facebook Ads How to get best out of Facebook And Much More..... Module 11: Instagram How to set up an Instagram business profile Set up Instagram bio & profile image Leveraging Instagram accounts A simple way to create free content on Instagram Secret of hashtags on Instagram Reposting Instagram App How to get genuine Instagram followers Discover how to grow your business through Instagram stories How to get your posts reposted on Instagram by influencers Module 12: Mobile App How to discover the estimated size of your market Discover the best ways to promote your app App installs via Facebook Ads App installs via Google Ads How to make money from your app How to optimise your App store listing? Discover growth hacking techniques for App downloads Techniques to get to the top of App store ranking And Much More..... Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Digital Marketing bundle. Requirements This Digital Marketing 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. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Digital Marketing) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The de.livery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost

In the digital age, the ability to interpret and predict data trends is paramount. Introducing 'Data Analysis and Forecasting in Excel', a comprehensive course tailored to unveil the intricacies of Excel's powerful tools. Dive deep into the world of worksheets, discover the magic of PivotTables, and unravel the secrets of data visualisation. Whether you're a novice eager to delve into data or a seasoned analyst looking to refine your skills, this course promises a transformative journey into the realm of Excel analytics. The curriculum is designed with the utmost care to ensure a holistic understanding. From the basics of modifying worksheets to the advanced techniques of forecasting data, every module is a step towards mastering Excel. With a focus on real-world applications, learners will be equipped to harness the potential of Excel, making data-driven decisions with confidence and precision. Visualisation is at the heart of understanding data. This course not only teaches you how to analyse data but also how to represent it effectively using charts, PivotCharts, and the innovative Sparklines. By the end of this course, you'll be adept at mapping data, automating workbook functionalities, and employing lookup functions with finesse. Learning Outcomes: Master the techniques of modifying and organising worksheets for optimal data representation. Understand and implement effective list management strategies within Excel. Analyse complex datasets and derive meaningful insights. Design and create compelling visual representations using charts and other visual tools. Efficiently utilise PivotTables and PivotCharts for advanced data analysis. Integrate and manage data across multiple worksheets and workbooks. Implement lookup functions and audit formulas to ensure data accuracy and integrity. Why buy this Data Analysis and Forecasting in Excel course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis and Forecasting in Excel Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Data Analysis and Forecasting in Excel course for? Individuals keen on mastering Excel for data interpretation and visualisation. Business analysts aiming to enhance their data forecasting abilities. Students pursuing a career in data analytics or business intelligence. Managers and decision-makers seeking to make data-driven strategies. Researchers looking to streamline and enhance their data processing techniques. Career path Data Analyst: Average salary range £30,000 - £50,000 annually. Business Intelligence Analyst: Average salary range £35,000 - £55,000 annually. Market Research Analyst: Average salary range £27,000 - £45,000 annually. Financial Analyst: Average salary range £35,000 - £60,000 annually. Operations Research Analyst: Average salary range £40,000 - £65,000 annually. Management Analyst: Average salary range £45,000 - £70,000 annually. Prerequisites This Data Analysis and Forecasting in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis and Forecasting in Excel 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00

This AWS SageMaker Canvas course will help you become a machine learning expert and will enhance your skills by offering you comprehensive knowledge and the required hands-on experience on this newly launched cloud-based ML tool, by solving real-time industry-based projects, without needing any complex coding expertise.

This advanced certification drills deep into the latest thinking to develop true digital marketing expertise. Course Overview This advanced certification drills deep into the latest thinking to develop true digital marketing expertise. Learn about Digital Strategy, CX, Search Marketing, Social Media, Leadership and more. Get world class, knowledge and insight: DMI EXPERT is our postgraduate level 140-hour course with an advanced, professional certification. It delivers breadth and depth of understanding of digital marketing and provides the learner with the digital and research skills to work at a management or strategic level. This certification is credit rated at level 11 on the Scottish Credit and Qualifications Framework and awarded 120 credit points by the SQA (Scottish Qualifications Authority), which is comparable to a postgraduate diploma awarded by a UK university. Program learning outcomes and content: What Will I Learn? We give you the thinking and tools to become a leading player on the digital stage. Create powerful and dynamic digital strategy, and access modern, career-defining training covering all key digital marketing disciplines. Course Content: Social Media Marketing: Learn how to create engaging content on social media and how to plan, execute, optimize and report on social media marketing campaigns across the key social platforms. • Social Research • Social Content • Facebook, Instagram, Pinterest • Twitter • LinkedIn • YouTube & Social Video • Social Apps • Social Commerce & Affiliate Marketing • Social Customer Service • Social Strategy Strategy and Planning: Gain all the key skills and practices associated with planning a successful digital strategy. Everything from digital channels, marketing automation, budgeting, analytics and digital leadership. • Digital Communications v Traditional Communications • Marketing automation and CRM • Budget and Resourcing • Big Data & Analytics • Strategy Formulation and Plan • Digital Communications & Channels • Omnichannel tactics CX, eCommerce and CRO: Learn the key concepts underpinning website optimization, conversion rate optimization and effective e-commerce for every business requirement. Build highly effective user experiences for your customers. • Website Optimization • UX Research & Design • E-Commerce Strategy • Applied E-Commerce • Graphic Design Essentials for Marketers Search and Digital Channels: Plan, implement, refine and report on search marketing campaigns. Drive traffic across all digital channels. Taught directly by Neil Patel and DMI’s experts, you’ll gain knowledge from people who actually use these tactics in the field. • SEO Setup & Content • SEO Workshop • Paid Search & Display Advertising • Measurement with Google Analytics • Email Marketing Strategy • Applied Email Marketing • SEO for ecommerce Digital Selling: Recognize the value of social selling and incorporate digital techniques to better engage with customers and prospects to drive increased conversion rates. • Fundamentals of Social Selling • Finding & Targeting Prospects • Attracting Customers • Closing & Retaining • Increasing Engagement Essential Skills: Gain all the essential skills all marketers, professionals and business leaders need to work effectively, productively and professionally in a collaborative business environment. • Project Planning • Creativity Skills • Personal Skills • Working With Others Leadership and Management: Develop practical skills and techniques that you can use to think strategically, build effective teams, deal with conflict and crisis and persuade and influence others. • Thinking Strategically • Building Effective Teams • Dealing with Conflicts and Crises • Persuading and Influencing DURATION 52 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Land Your Dream Job! Get Personalised Career Support & Expert Tips, Craft Your CV, Explore Top Jobs & Ace Interviews!

All-in-one Package| CPD Certified| 35 Courses Training| 350 CPD Points| Free PDF+ Transcript Certificate| Lifetime Access

Duco Digital Training's Practitioner course in BCS Requirements Engineering develops your skills in the understanding and application of elicitation, analysis and management of business analysis requirements.

Our training programme will provide those involved at any stage of the process for procuring goods and/or services within their organisations with the knowledge and skillset to identify and mitigate the threat posed by the breadth and multi-layered complexity of procurement fraud, corruption and associated financial crime and money laundering.

Embark on a transformative journey into the realm of data mastery with our comprehensive course, 'Advanced SAS Programming Using MacrosSQL.' From demystifying the intricacies of SAS Studio to unlocking the potential of Proc SQL, this course is a gateway to proficiency in SAS programming and macro scripting. The curriculum, thoughtfully designed to accommodate learners of all levels, takes you through the essential foundations of SAS, the nuances of macro variables, and the power-packed functionalities of Proc SQL. Dive into the world of nested macro variables, conditional logic, and data manipulation, all while honing your skills through practical examples. This course isn't just about learning syntax; it's a hands-on exploration that empowers you to seamlessly connect the dots between SAS Studio and Proc SQL, bringing your data analytics capabilities to new heights. Learning Outcomes Master the fundamentals of SAS Studio and navigate through its interface effortlessly. Develop a deep understanding of macro variables, exploring their applications and delving into nested variations. Acquire proficiency in SAS Macros, from basic examples to advanced keyword usage and conditional logic. Unlock the potential of Proc SQL, gaining expertise in data copying, filtering, sorting, and removing duplicates. Harness the power of data merging using Joins, creating macro variables dynamically in the process. Why choose this Advanced SAS Programming Using MacrosSQL course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Advanced SAS Programming Using MacrosSQL course for? Data enthusiasts seeking to enhance their SAS programming skills. Business analysts aiming to leverage SAS for more effective data analysis. IT professionals aspiring to streamline data management through SAS. Career path SAS Programmer: £35,000 - £55,000 Data Analyst: £30,000 - £50,000 Business Intelligence Developer: £40,000 - £60,000 Database Administrator: £35,000 - £60,000 Data Scientist: £45,000 - £70,000 Analytics Manager: £50,000 - £80,000 Prerequisites This Advanced SAS Programming Using MacrosSQL does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced SAS Programming Using MacrosSQL 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Advanced SAS Programming Using MacrosSQL Unit - 1 Section 0-00- Why SAS 00:01:00 Unit - 2 Section 2-02- SAS Studio through SAS OnDemand- Registration 00:04:00 Section 2-03- Logging-in to SAS after installation 00:01:00 Section 2-04- SAS Interface and windows 00:06:00 Unit - 3 Section 3-00- Section Overview - Macros 00:01:00 Section 3-01-Macro Variables - introduction 00:14:00 Section 3-02-Application of macro variables 00:13:00 Section 3-03-01-Nested macro vars 00:11:00 Section 3-03-02-More on Ampersand resolutions using a cool example 00:09:00 Section 3-04-00-SAS Macros - introduction 00:10:00 Section 3-04-01-SAS Macros - Examples 00:07:00 Section 3-04-02-Keyword positional and mixed params 00:06:00 Section 3-04-03-Conditional Logic in Macros 00:11:00 Section 3-05-Macro Functions 00:12:00 Section 3-05-Options Statement- mprint-mlogic-symbolgen 00:13:00 Section 3-07-Connecting the two worlds - Call Symput - Symget 00:14:00 Section 3-09-01-02- Bringing data into SAS using Import Wizard 00:04:00 Section 3-09-02- Bringing data into SAS using LIBNAME statement 00:05:00 Section 3-09-03- Bringing data into SAS using FILENAME 00:05:00 Unit - 4 Section 4-00- Section Overview - Proc SQL 00:01:00 Section 4-01-01-Proc SQL - copying data 00:13:00 Section 4-01-02-Proc SQL - filtering data 00:07:00 Section 4-01-03-Proc SQL - sorting data 00:08:00 Section 4-01-04-Proc SQL - removing duplicates 00:05:00 Section 4-02-01-Proc SQL - Union 00:09:00 Section 4-02-02-Proc SQL - Except 00:04:00 Section 4-02-03-Proc SQL - Intersect 00:02:00 Section 4-03-00-Merging data using Joins-Introduction 00:08:00 Section 4-03-01-Proc SQL - inner join 00:14:00 Section 4-03-02-Proc SQL - full join 00:08:00 Section 4-03-03-Proc SQL - left and right joins 00:07:00 Section 4-04-01-Proc SQL - creating macro vars 00:07:00 Unit - 5 Section 5-00- Bonus lecture 00:02:00