MySQL as a Datastore

Apache Tomcat 8.5    |    Intermediate
  • 12 videos | 45m 33s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 36 users Rating 4.4 of 36 users (36)
Most web applications use a backend database for data storage, querying, and retrieval. Discover how to configure and manage MySQL databases and tables.

WHAT YOU WILL LEARN

  • Recognize how mysql is commonly used as a backend data store for web applications
    List common permissions related to mysql objects
    Use a variety of methods to create mysql users
    Grant mysql permissions to support a web application
    Establish mysql database and table storage
    Populate mysql with data
  • Choose the appropriate query language syntax to extract mysql data
    Retrieve mysql data using a query
    Define mysql logging details
    View mysql stats
    Determine how to apply mysql best practices
    Perform common mysql configuration and management tasks

IN THIS COURSE

  • 6m 56s
    After completing this video, you will be able to recognize how MySQL is commonly used as a backend data store for web applications. FREE ACCESS
  • 3m 38s
    After completing this video, you will be able to list common permissions related to MySQL objects. FREE ACCESS
  • Locked
    3.  MySQL User Management
    6m 26s
    In this video, you will learn how to use a variety of methods to create MySQL users. FREE ACCESS
  • Locked
    4.  Assigning MySQL Permissions
    3m 29s
    In this video, find out how to grant MySQL permissions to support a web application. FREE ACCESS
  • Locked
    5.  Creating a MySQL Database and Table
    2m 59s
    Find out how to establish a MySQL database and table storage. FREE ACCESS
  • Locked
    6.  Adding Records to a MySQL Table
    2m 31s
    During this video, you will learn how to insert data into MySQL. FREE ACCESS
  • Locked
    7.  MySQL Querying
    2m 57s
    In this video, you will learn how to choose the appropriate query language syntax to extract MySQL data. FREE ACCESS
  • Locked
    8.  Constructing a MySQL Query
    3m 23s
    In this video, you will learn how to retrieve data from MySQL using a query. FREE ACCESS
  • Locked
    9.  MySQL Logging
    2m 43s
    Learn how to define MySQL logging parameters. FREE ACCESS
  • Locked
    10.  Use phpMyAdmin to View MySQL Stats
    3m 38s
    During this video, you will learn how to view MySQL statistics. FREE ACCESS
  • Locked
    11.  MySQL Best Practices
    3m 10s
    In this video, you will learn how to apply MySQL best practices. FREE ACCESS
  • Locked
    12.  Exercise: Configure and Troubleshoot MySQL
    3m 44s
    During this video, you will learn how to perform common MySQL configuration and management tasks. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Book MySQL Crash Course: A Hands-on Introduction to Database Development
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Design
Rating 4.3 of 224 users Rating 4.3 of 224 users (224)
Course SQL & Concurrency Concepts
Rating 4.6 of 245 users Rating 4.6 of 245 users (245)
Course SQL Concepts & Queries
Rating 4.6 of 2013 users Rating 4.6 of 2013 users (2013)