In this lesson of the MySQL tutorial, you will learn...
About the database we'll be using in class.
To comment your SQL code.
To understand SQL syntax.
To select all rows from a table.
To sort record sets.
To filter records.
To use the CASE function to display different values depending on the values of a column or columns.
The SELECT statement is used to retrieve data from tables. SELECT statements can be used to perform simple tasks such as retrieving records from a single table or complicated tasks such as retrieving data from multiple tables with record grouping and sorting. In this lesson, we will look at several of the more basic ways to retrieve data from a single table.
In this lesson of the MySQL tutorial, you will learn...
How to GROUP data elements.
How to aggregate values to generate summary results.
How to filter on grouped results using HAVING.
How to use ROLLUP to generate summary rows.
How to find TOP-n and BOTTOM-n entities.
The SELECT statement is used to retrieve data from tables. SELECT statements can be used to perform simple tasks such as retrieving records from a single table or complicated tasks such as retrieving data from multiple tables with record grouping and sorting. In this lesson, we will look at several of the more basic ways to retrieve data from a single table.
In this lesson of the MySQL tutorial, you will learn...
How to write functions in MySQL.
How to write Stored Procedures.
How to write Triggers.
This lesson focuses on the programming aspects of MySQL covering traditional control-structure based code artifacts in MySQL to supplement the regular SQL-based functionality.
In this lesson of the MySQL tutorial, you will learn...
Securing the mysqld Daemon
Securing Your Installation Files
Securing network
Using Encryption and Signatures
Using SSL
Securing Accounts
Limiting User Resources
In this lesson of the MySQL tutorial, we learn how to secure an MySQL Installation at Operating level. The data-level security (inside of MySQL) is covered in another lesson.
In this lesson of the MySQL tutorial, you will learn...
To understand how the Privilege System works in MySQL.
To understand the Privilege Tables and Scopes.
To manage User accounts.
To learn use of GRANT and REVOKE.
To evaluate and set up Privilege Levels.
Just as in normal life, not all information is intended to be accessible to all individuals. Defying the principles of pure democracy, a MySQL database is often set up to provide selective access where not everyone can view entire data store (let alone alter it).
In this lesson of the MySQL tutorial, you will learn...
To understand optimization basis
To manage Resources
To optimally use indexes
Advantages and disadvantages of indexing and when you should use indexing.
To effectively tune your queries and learn steps to improve data-related operations.
To use slow query log.
In this lesson of the MySQL tutorial, we learn about the several steps that you can take to optimize the performance of your SQL statements. By optimizing performance, you're maximizing the speed and efficiency at which those statements are executed.
In this lesson of the MySQL tutorial, you will learn...
Install tuning, Optimizing MySQL System Variables
Tuning Server Parameters
Tuning Other Factors
System Characteristics and Slowness Elements
Enabling your system's query cache
Compiling and Linking for Speed
In this lesson of the MySQL tutorial, we learn various elements of tuning an MySQL Installation at Operating level. The query and database optimizations are covered in other lessons.
In this lesson of the MySQL tutorial, you will learn...
Replication concepts and principles
Setting up replication on master and slave servers
Managing replication
Replication settings
In this lesson of the MySQL tutorial, we learn about the process of database Replication in MySQL.
Beside performing regular backups of your databases, you can also replicate your databases meaning that you maintain a copy of the database that is kept up-to-date (synchronized) with the original database. If the original database becomes unavailable, the replicated database can continue to provide users immediate access to the same data with a minimal amount of downtime.
This lesson describes setting up replication on master and slave servers and then managing the replication process.