Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. By the end of this course, you’ll be able to: - Utilize the MySQL DBMS to build and modify relational databases with SQL - Add records to a MySQL database - Perform intricate queries on database records with filters and groupings - Create simple joins and unions within a database - Create relationships between tables using primary and foreign keys - Demonstrate the ability to complete a database normalization project You’ll gain experience with the following tools and software: - MySQL DBMS - Joins and Unions - SQL statements, clauses and data types - Primary and foreign keys - Database normalization

Learn foundational programming concepts (e.g., functions, for loops, conditional statements) and how to solve problems like a programmer. In addition, learn basic web development as you build web pages using HTML, CSS, JavaScript. By the end of the course, will create a web page where others can upload their images and apply image filters that you create. After completing this course, you will be able to: 1. Think critically about how to solve a problem using programming; 2. Write JavaScript programs using functions, for loops, and conditional statements; 3. Use HTML to construct a web page with paragraphs, divs, images, links, and lists; 4. Add styles to a web page with CSS IDs and classes; and 5. Make a web page interactive with JavaScript commands like alert, onClick, onChange, adding input features like an image canvas, button, and slider.

Learn how to install and use Matomo, leading free open source web analytics software, on Windows IIS server for local testing or production

By the end of this project, you will have used Visual Studio to explore the use of variables and data types in a VB.NET desktop application. You will write VB.NET code to create and populate variables using a variety of data types. Because most programs process data, working with variables and data types are fundamental skills required in application development. 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.

This is a self-paced lab that takes place in the Google Cloud console. In this lab, you will learn how to use the Elastic Stack to monitor Google Cloud. You will start by creating a simple Elasticsearch deployment using Elastic Cloud. The goal of this lab will be to install and deploy Elasticsearch then use Beats, which are Elastic's lightweight data shippers, which sends operational data - logs and metrics - from systems and applications. You will use Beats to collect and monitor your services on Google Cloud.

In this project you will create an Android app that that uses four activities . You will begin with an Android Studio project that has an ActivityMain.java file (with nothing added to it) and an activity_main.xml file (with nothing added to it). You will create three new activities in this project, onTouch (onTouch.java & activity_on_touch.xml), ReadReview (ReadReview.java & activity_read_review.xml), and WriteReview (WriteReview.java & activity_write_review.xml). You will have access to all of the relevant content (code and comments) needed for those files in text files so that you can copy and paste into the appropriate java and xml files in the project. You will make adjustments to the AndroidManifest.xml file in the project which will allow your app to switch between activities when instructed to do so by the actions of the user. Once we have created our activities, inserted all of the relevant code to our java and xml files, and updated our Manifest file, we will build an APK of your app. You will then upload the APK of the app to a website called Appetize.io where you will test the app. Projects in Series 1: 1. Build a Simple App in Android Studio with Java 2. Build a Persistent Storage App in Android Studio 3. Build a Linear Layout App in Android Studio 4. Build a Relative Layout App in Android Studio 5. Build a Table Layout App in Android Studio Projects in Series 2: 1. Build an App in Android Studio using Resources 2. Build an App in Android Studio using Static Files 3. Build an App in Android Studio using Read - Write 4. Build an App in Android Studio using onTouch 5. Build an App in Android Studio using Activities

In this project you will build an Android app that that uses onTouch functionality to show certain information when a user clicks (Action Down) on an image, and then have the information change when the user releases (Action Up). The app also creates text files in internal storage when needed, will write to those files, and will read from those files. The app will interact with text files, images, strings, and a string array that are saved as resources in the project (can be accessed by reference throughout the app). This app will have a piece of text (from the strings file) asking the user to select the name of an author from a spinner (a type of drop down menu where the user selects from a set of options - from the strings file). There will be an image (ImageView) below the spinner which will change (from the drawable directory) to match whichever author the user selects. Beneath this will be a piece of text (TextView) with the name of a book and the year it was published (from the strings file) which will change to match the selected author. There will be another piece of text (TextView) which will contain an appropriate quote (read from the appropriate text file in a raw directory) from the named book Below this quote will be two buttons, one with "Read Review" on it, and the second with "Submit Review" on it. When the user clicks the "Read Review" button a TextView will appear containing a the previously submitted review (if one exists). The user will also be given the option to "Submit Review" whiich when clicked gives access to an imput box (EditText) into which a review can be typed. When a "Submit" button is then clicked this review is written to a text file in internal storage (not resources) to a review file for that author. If the file does not exist then the app will create the file first, then write the review to it. When the user closes the app the program will remember the final choice made by the user in their previous visit. When launched the app will also read all information in the review files in internal storage and bring the reviews into the app for use. You will upload an APK of the app to a website called Appetize.io to test the app. Projects in Series 1: 1. Build a Simple App in Android Studio with Java 2. Build a Persistent Storage App in Android Studio 3. Build a Linear Layout App in Android Studio 4. Build a Relative Layout App in Android Studio 5. Build a Table Layout App in Android Studio Projects in Series 2: 1. Build an App in Android Studio using Resources 2. Build an App in Android Studio using Static Files 3. Build an App in Android Studio using Read - Write 4. Build an App in Android Studio using onTouch 5. Build an App in Android Studio using Activities

In this course, you will learn how to build Django-based web applications suitable for use by end users. You will learn about cookies, sessions, and authentication processes in Django. You will build navigation into your applications and explore ways to easily improve the look and feel of Django applications. You will begin to develop a simple application to support a classified ads website that will walk you through many of the issues and techniques that you encounter in website development. You will also learn how to move an application from development to production.

React Components are generally implemented using Classes. Although they work well, they have their own set of limitations. The stateful logic provided by the class components lack reusability. To enhance the productivity, codes developers are expected to develop codes with reusability. This course will enable you to develop simple, readable, React components with reusable stateful logic using JavaScript functions and React Hooks. You will also explore the different React Hooks and test the stateful logic.

This course concentrates mainly on Javascript based front-end frameworks, and in particular the Angular framework (Currently Ver. 6.x). This course will use Typescript for developing Angular application. Typescript features will be introduced in the context of Angular as part of the exercises. You will also get an introduction to the use of Angular Material and Angular Flex-Layout for responsive UI design. You will be introduced to various aspects of Angular including components, directives and services. You will learn about data binding, Angular router and its use for developing single-page applications. You will also learn about designing both template-driven forms and reactive forms. A quick introduction to Observables, reactive programming and RxJS in the context of Angular is included. You will then learn about Angular support for client-server communication through the HTTP client and the use of REST API on the server side. A quick tour through Angular animation support and Angular testing rounds off the course. You must have either completed the previous course in the specialization on Bootstrap 4, or have a working knowledge of front end web-UI frameworks to be able to navigate this course. Also a good working knowledge of JavaScript, especially ES 5 is strongly recommended. At the end of this course you will: - Be familiar with client-side Javascript frameworks and the Angular framework - Be able to implement single page applications in Angular - Be able to use various Angular features including directives, components and services - Be able to implement a functional front-end web application using Angular - Be able to use Angular Material and Angular Flex-Layout for designing responsive Angular applications - Be able to use Observables and RxJS in the context of Angular applications