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

Channel SQL Database Development & Design
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
Course Final Exam: Database Fundamentals
Rating 4.6 of 28 users Rating 4.6 of 28 users (28)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Facilitation in Action: Finding Your Authentic Training Style
Course SQL 2016 Tables
Rating 4.5 of 473 users Rating 4.5 of 473 users (473)
Course New Developments in Python
Rating 4.5 of 122 users Rating 4.5 of 122 users (122)