1635 Database courses delivered Online

Course Overview Become a PHP & MySQL pro by learning all the web development features for creating websites. The PHP & MySQL Web Development & OOP Coding course covers everything you need to know to master PHP programming and gain valuable industry skills. It will take you through the fundamentals of PHP and MySQL, starting from the very basics for complete beginners.  Through this in-depth training course, you will familiarise with all the features of MySQL, and learn best practices for cross platform development, taught by an expert in the field. If you are looking to kickstart a career in programming or computer science, then this course will equip you with up-to-date skills that will ensure you gain a competitive edge in the job market. This best selling PHP & MySQL Web Development & OOP Coding has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth PHP & MySQL Web Development & OOP Coding is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The PHP & MySQL Web Development & OOP Coding is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The PHP & MySQL Web Development & OOP Coding is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the PHP & MySQL Web Development & OOP Coding, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the PHP & MySQL Web Development & OOP Coding will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the PHP & MySQL Web Development & OOP Coding to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Advanced SAS Programming With MacrosSQL has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Advanced SAS Programming With MacrosSQL today, and learn from the very best the industry has to offer! This best selling Advanced SAS Programming With MacrosSQL has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced SAS Programming With MacrosSQL is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced SAS Programming With MacrosSQL is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Advanced SAS Programming With MacrosSQL is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Advanced SAS Programming With MacrosSQL, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced SAS Programming With MacrosSQL will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Advanced SAS Programming With MacrosSQL to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the SQL Server 101 : Microsoft SQL Server for Absolute Beginners today, and learn from the very best the industry has to offer! This best selling SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth SQL Server 101 : Microsoft SQL Server for Absolute Beginners is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the SQL Server 101 : Microsoft SQL Server for Absolute Beginners, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the SQL Server 101 : Microsoft SQL Server for Absolute Beginners will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the SQL Server 101 : Microsoft SQL Server for Absolute Beginners to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Description: This Microsoft Office 2016 Excel Intermediate - Complete Video Course will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level. If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course. You will also work with charts and advanced formatting including styles. So, why are you thinking? Come and be a part of this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Microsoft Office 2016 Excel Intermediate - Complete Video Course 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 Microsoft Office 2016 Excel Intermediate - Complete Video Course 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. Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11: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 Create and Modify Tables 00:15:00 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 Mock Exam Mock Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This series builds on the concepts and skills taught in the Basic course. This Microsoft Office 2010 Access Beginners - Complete Video Course will teach you how to work with templates, create baseline plans, monitor and update projects, analyze project statistics, handle delays and conflicts, create reports, consolidate project files, share resources, and customize Project. You will also learn how to communicate project information by using Project Server 2010 and how to integrate Project data with other Office applications. This course is intended for information workers who want to learn beginning level Access 2010 skills. So, if you have the basic knowledge of computer and basic file management skill you can join this course. If you want to know more detail you have to be a part of this course. You will get all the basic knowledge from here, which will help you to pull up ahead. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Microsoft Office 2010 Access Beginners - Complete Video Course 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 Microsoft Office 2010 Access Beginners - Complete Video Course 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. Getting Started Database Concepts FREE 00:04:00 Exploring the Access Environment 00:11:00 Getting Help 00:02:00 Databases and Tables Planning and Designing Databases 00:12:00 Exploring Tables 00:11:00 Creating Tables 00:33:00 Fields and Records Changing the Design of a Table 00:15:00 Finding and Editing Records 00:06:00 Organizing Records 00:16:00 Data Entry Rules Setting Field Properties 00:14:00 Working with Input Masks 00:07:00 Setting Validation Rules 00:06:00 Basic Queries Creating and Using Queries 00:13:00 Modifying Query Results and Queries 00:05:00 Performing Operations in Queries 00:17:00 Using Forms Creating Forms 00:11:00 Using Design View 00:14:00 Sorting and Filtering Records 00:04:00 Working with Reports Creating Reports 00:10:00 Modifying and Printing Reports 00:16:00 Mock Exam Mock Exam- Microsoft Office 2010 Access Beginers - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Access Beginers - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Duration 2 Days 12 CPD hours This course is intended for Developers & Developer Consultants Overview Learn simple ABAP codeTrace the flow of a program and troubleshoot simple problems In this course, students will learn simple ABAP code. Basics of ABAP Programming Developing a Simple ABAP Program Introducing ABAP Syntax Implementing a Simple Dialog Customizing the ABAP Editor Coding & Debugging in ABAP Defining Simple Variables Defining Text Symbols Performing Arithmetic Operations Using Simple Variables Using System Variables Debugging a Program Creating an ABAP List Processing Character Strings Current Flow Structures in ABAP Implementing Conditional Logic Implementing Loops Runtime Errors & Error Handling Analyzing Runtime Errors Implementing Error Handling Additional ABAP Programming Techniques Retrieving Data From the Database Describing Modularization in ABAP Using Function Modules Additional course details: Nexus Humans BC100 SAP Introduction to Programming with ABAP training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BC100 SAP Introduction to Programming with ABAP course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Description: Microsoft Office Visio is a vector graphics and diagramming application. Its latest iteration, Microsoft Office Visio 2016, brings a lot of updates and functionality. Microsoft Visio 2016 Beginner to Advanced Course has been designed deliberately for the ease of learning in an efficient way. This course will help you get started from the basics; you will get accustomed with the interface, tools and features, simple diagrams, floor plans, flowcharts, etc. As you move up the skillset, you will be exposed to advanced stuff: organization chart, making a floor plan, cross-functional flowchart, network diagram, shapes, stencils, templates, leveraging development tools, etc. This course will give you an overall outlook from basic to advanced level aspects of this application. Learning Outcomes: Working with shape styles, utilizing 3D shapes, apply backgrounds, borders and titles in order to make your work stand out Creating custom stencils, simple custom shapes, master shapes and custom templates Connecting features, like pivot tables and data, from other Microsoft Office programs and using them Utilizing macros, ShapeSheets and advanced shape tools Sharing your drawings across multiple platforms Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Microsoft Visio 2016 Advanced 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 Microsoft Visio 2016 Advanced 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. Work with Shape Styles 00:30:00 Use 3D Shapes 00:30:00 Apply Backgrounds, Borders, and Titles 00:30:00 Create Custom Stencils 00:30:00 Create Simple Custom Shapes 00:30:00 Create Master Shapes 00:30:00 Create Custom Templates 00:30:00 Generate a Pivot Diagram from an Excel Spreadsheet 00:30:00 Create a Chart from a Project File 00:30:00 Create a Timeline from a Project File 00:30:00 Connect to an Access Database 00:30:00 Create Macros 00:30:00 Modify ShapeSheets 00:30:00 Use Advanced Shape Tools 00:30:00 Save and Share Drawings with One Drive 00:30:00 Review Drawings 00:30:00 Insert Drawings into Other Office Files 00:30:00 Export Drawings 00:30:00 Print Drawings 00:30:00 Activities Activities - Microsoft Visio 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Visio 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Visio 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This Web Application Penetration Testing and Security course will unlock your full potential and will show you how to excel in a career in Web Application Penetration Testing and Security. So upskill now and reach your full potential. Everything you need to get started in Web Application Penetration Testing and Security is available in this course. Learning and progressing are the hallmarks of personal development. This Web Application Penetration Testing and Security will quickly teach you the must-have skills needed to start in the relevant industry. In This Web Application Penetration Testing and Security Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Web Application Penetration Testing and Security skills to help you advance your career. Acquire a comprehensive understanding of various Web Application Penetration Testing and Security topics and tips from industry experts. Learn in-demand Web Application Penetration Testing and Security skills that are in high demand among UK employers, which will help you to kickstart your career. This Web Application Penetration Testing and Security course covers everything you must know to stand against the tough competition in the Web Application Penetration Testing and Security field.  The future is truly yours to seize with this Web Application Penetration Testing and Security. Enrol today and complete the course to achieve a Web Application Penetration Testing and Security 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 Web Application Penetration Testing and Security 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 Web Application Penetration Testing and Security 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 Web Application Penetration Testing and Security 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 Web Application Penetration Testing and Security is suitable for anyone aspiring to start a career in Web Application Penetration Testing and Security; even if you are new to this and have no prior knowledge on Web Application Penetration Testing and Security, this course is going to be very easy for you to understand.  And if you are already working in the Web Application Penetration Testing and Security 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 Web Application Penetration Testing and Security 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 Web Application Penetration Testing and Security course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Web Application Penetration Testing and Security 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 Web Application Penetration Testing and Security course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 01: Introduction About The Course 00:03:00 Unit 02: BE PREPARED Web Attack Simulation Lab 00:12:00 Unit 03: WEB APPLICATION TECHNOLOGIES Web application technologies 101 - PDF 00:00:00 HTTP Protocol Basics 00:11:00 Encoding Schemes 00:13:00 Same Origin Policy - SOP 00:06:00 HTTP Cookies 00:11:00 Cross-origin resource sharing 00:05:00 Web application proxy - Burp suite 00:09:00 Unit 04: INFORMATION GATHERING - MAPPING THE APPLICATIONS Fingerprinting web server 00:05:00 DNS Analysis - Enumerating subdomains 00:04:00 Metasploit for web application attacks 00:12:00 Web technologies analysis in real time 00:03:00 Outdated web application to server takeover 00:08:00 BruteForcing Web applications 00:06:00 Shodan HQ 00:07:00 Harvesting the data 00:05:00 Finding link of target with Maltego CE 00:09:00 Unit 05: CROSS-SITE SCRIPTING ATTACKS - XSS Cross Site Scripting- XSS - PDF 01:08:00 Cross site scripting 00:07:00 Reflected XSS 00:14:00 Persistent XSS 00:11:00 DOM-based XSS 00:10:00 Website defacement through XSS 00:09:00 XML Documents & database 00:14:00 Generating XSS attack payloads 00:13:00 XSS in PHP, ASP & JS Code review 00:13:00 Cookie stealing through XSS 00:12:00 Advanced XSS phishing attacks 00:08:00 Advanced XSS with BeEF attacks 00:10:00 Advanced XSS attacks with Burp suite 00:08:00 Code Review Guide 06:20:00 Unit 06: SQL INJECTION ATTACKS - EXPLOITATIONS SQL Injection attacks - PDF 01:30:00 Introduction to SQL Injection 00:16:00 Dangers of SQL Injection 00:05:00 Hunting for SQL Injection vulnerabilities 00:20:00 In-band SQL Injection attacks 00:27:00 Blind SQL Injection attack in-action 00:10:00 Exploiting SQL injection - SQLMap 00:09:00 Fuzzing for SQL Injection - Burp Intruder 00:14:00 Unit 07: CROSS SITE REQUEST FORGERY - XSRF CSRF or XSRF attack methods 00:12:00 Anti-CSRF Token methods 00:15:00 Anti-CSRF token stealing-NOT easy 00:11:00 Unit 08: AUTHENTICATION & AUTHORIZATION ATTACKS Authentication bypass-hydra 00:11:00 HTTP Verb Tampering 00:09:00 HTTP parameter pollution - HPP 00:06:00 Authentication 00:10:00 Unit 09: CLIENT SIDE SECURITY TESTING Client side control bypass 00:10:00 Unit 10: FILE RELATED VULNERABILITIES LFI & RFI attacks 00:13:00 Unrestricted file upload - content type 00:06:00 Unrestricted File Upload - Extension Type 00:06:00 Remote code execution using Shell Uploads 00:09:00 Unit 11: XML EXTERNAL ENTITY ATTACKS - XXE XML Documents & database 00:14:00 XXE attacks in action 00:14:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Microsoft Power BI Masterclass 2021 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Microsoft Power BI Masterclass 2021 Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Power BI Masterclass 2021 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Microsoft Power BI Masterclass 2021 Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Microsoft Power BI Masterclass 2021? 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 Microsoft Power BI Masterclass 2021 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 Microsoft Power BI Masterclass 2021 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill.   Prerequisites This Microsoft Power BI Masterclass 2021 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Power BI Masterclass 2021 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Power BI Masterclass 2021 is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:02:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up - Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Microsoft Power BI Masterclass 2021 00:00:00 Assignment Assignment - Microsoft Power BI 00:00:00