Free online courseIntroduction to MySQL

Conteúdo do Curso

• Video class: MySQL - MySQL Introduction

  0h39m

• Exercise: In the context of MySQL databases, which of the following statements best describes the function of a database?

• Video class: MySQL - Structure Introduction

  0h41m

• Exercise: When setting up a MySQL database, what is an important consideration for maintaining data integrity?

• Video class: MySQL - Data Types Introduction

  0h31m

• Exercise: Why is it important to assign correct data types to fields within a MySQL database?

• Video class: MySQL - Install LAMP Server for MySQL Labs (tasksel)

  0h27m

• Exercise: What is the purpose of using Tasksel to set up a lab environment in the context of learning MySQL?

• Video class: MySQL - Create, Delete Database and Show Grants (Create Database, Drop Database, Show Grants)

  0h25m

• Exercise: What is a potential consequence of misusing the DROP command in MySQL without proper precautions?

• Video class: MySQL - Create, Alter and Delete Tables (Create Table, Alter Table, Drop Table )

  0h22m

• Exercise: In MySQL, what command is used to enter a database to work within it?

• Video class: MySQL - Add Records and Search Tables (insert, select)

  0h31m

• Exercise: Which sequence of SQL commands can be used to create a table and then add a user with specific attributes in a MySQL database?

• Video class: MySQL - Update and Delete Records (update, delete)

  0h26m

• Exercise: What MySQL command is used to modify an existing record in a table?

• Video class: MySQL - Create, Delete User Accounts and Grant Privileges (create/drop user, grant, show grants)

  0h46m

• Exercise: What is the purpose of assigning specific privileges to user accounts in MySQL?

• Video class: MySQL - Table Joins Introduction (inner join)

  0h21m

• Exercise: What is the primary function of an 'inner join' in a MySQL database?

• Video class: MySQL - Stored Procedures Introduction

  0h25m

• Exercise: In MySQL, when creating a stored procedure, why is it important to set a custom delimiter temporarily?

• Video class: MySQL - Stored Functions Introduction

  0h36m

• Exercise: In the context of MySQL stored functions, what is the primary role of these functions when applied to tables in a database?

• Video class: MySQL - Backup, Restore, Copy Tables and Databases

  0h41m

• Exercise: What is the main benefit of creating backups of tables and databases in MySQL, as described in the course material?

• Video class: MySQL - Connect with PHP (mysqli)

  0h32m

• Exercise: Which PHP extension is used to connect to a MySQL database without needing additional installations in PHP?

• Video class: MySQL - PHP Print Records to HTML (mysqli)

  0h24m

• Exercise: Which programming languages are essential to know when developing a web application that involves accessing a MySQL database and outputting results in a web browser?

• Video class: MySQL - PHP to INSERT Into Table

  0h19m

• Exercise: What is the purpose of using PHP to insert data into a MySQL database table in a development environment?

• Video class: MySQL - UPDATE Records with PHP

  0h21m

• Exercise: What is a crucial step to take before performing mass updates on a MySQL database using scripts?

• Video class: MySQL - INSERT Records with HTML Form and PHP

  0h31m

• Exercise: In a web application where a form is used to insert data into a MySQL database, which component primarily handles the data parsing and execution of SQL statements?

• Video class: MySQL - SEARCH Form with HTML and PHP

  0h33m

• Exercise: When constructing a MySQL search query with a wildcard, which SQL clause should be used to enable matching partial strings?

• Video class: MySQL - UPDATE Records with HTML Form and PHP

  0h32m

• Exercise: What is a key warning to consider when working with dynamically generated HTML forms in PHP, as described in the lesson?