MySQL as a Datastore

Apache Tomcat 8.5    |    Intermediate
  • 12 videos | 45m 33s
  • Includes Assessment
  • Earns a Badge
Likes 9 Likes 9
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 Database Fundamentals: Database Administration Basics
Channel NoSQL
Likes 42 Likes 42  
Course MySQL Database Development: SELECT Statement & Operators
Likes 37 Likes 37  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Concepts & Queries
Likes 498 Likes 498  
Course SQL & Concurrency Concepts
Likes 205 Likes 205  
Course Objects & Retrieving Data
Likes 121 Likes 121