Are you bored keeping track of expenses in your company and constantly creating the same old reports for another time period? Don't worry, with the help of Power Apps and Power Automate you can easily create an app and flow that will solve all your problems! In this beginner-level guided project "Generate Reports with the Help of a Flow Inside Power Apps", you will learn how to generate reports with Power Automate flow and integrate the flow inside the Power Apps application. We will also create an application that allows us to create new records, delete and modify old records, and search by different fields to find the specific record. First, we will create our data source in SharePoint lists and then we are going to create a model-driven app with the SharePoint template We will be able to create a new expense with the app, see all of the expenses, filter the expenses depending on various criteria and even change some of the old records. Aside from that, we will create an instant flow that will be triggered by pressing a button in our application. The flow will generate a report for a specific time period according to our requirements and will be sent to the desired email address. The requirement for this project is having a Microsoft Developer Program account and you will be provided with instructions on how to acquire it. Anyone with basic understanding of data types and Excel-like formulas can learn to use Power Automate and Power Apps. If you would like to make your life easier by automating manual, time-consuming business tasks, then this project is for you! Let's get started!

In this 1-hour 20-minutes long project-based course, you will learn how to create a fully functioning Front-End for a Twitter clone with ReactJS. You will learn how to start a project from scratch with create-react-app, how to build functional React components and pass props down the components tree, how to implement components state, how to fetch data from an external API and how to store and display it. And, lastly, you will be able to style the components with Bootstrap and CSS. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

In this course, you'll begin to push beyond simple SQL statements in MySQL to an advanced level in database engineering. By the end of this course, you'll be able to: - Use control statements and variables in different contexts in MySQL - Develop user defined functions and procedures - Optimize MySQL database queries - Demonstrate a working knowledge of common table expressions and the JSON data type - Understand how and when to use triggers and events - Utilize subqueries, JOINS, views and transactions to perform data analysis - and use database optimization techniques such as MySQL transactions You'll gain experience with the following advanced MySQL database skills: - MySQL user defined functions - Advanced MySQL stored procedures - MySQL optimization techniques including Indexes, Transactions, CTE and JSON - MySQL triggers and events - Database analytics in MySQL - Advanced SQL queries for data analysis with JOINS, views and subqueries Through this course you'll develop new skills, improve your productivity, learn to act effectively with data and boost your career prospects. To be successful in this course, you should have already completed the previous course, “Database Structures and Management with MySQL,” or have prior experience with the skills taught in that course.

By the end of this project, you will have used Visual Studio to explore the use of controls and their properties in a VB.NET desktop application. You will design and build a form by adding controls such as labels, text boxes, and buttons. To customize the form, you will learn to alter the values of the properties associated with each control. Working with controls and their properties provides an application developer with the skills needed to develop the user interface—the visual component—of an application. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Welcome to the “Deploying a Python data analytics web app on Heroku” guided project. This project is for anyone interested in breaking or transitioning into the data science field and hopes to build a portfolio that stands out with unique projects. In this project we’re going to be building and deploying a python data analytics web application leveraging the General Social Survey data, which collects information and records of behaviours, experiences and opinions of residents of the Us and is funded by the National Science Foundation, particularly finding the correlation between education, income and happiness for US residents in 2016. At the end of this project, learners will be able to deploy a python data analytics website using Python, Streamlit, Git and Heroku that they can show to potential hiring managers and recruiters as part of their portfolio.

The Capstone project enables you to demonstrate multiple skills by solving an authentic real-world problem. You’ll test your abilities in full-stack back-end development in a real-life scenario by composing a Django web app. You will use clean and bug free coding to create a Django web server with multiple API endpoints, and connect it to a MySQL database. You’ll also create a template system driven by Django views. On completion of the Capstone project, you’ll have a project-based portfolio that you can show to potential employers when interviewing for an engineer role.