Description: MySQL is open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it, etc.
Curriculum
- 1 Section
- 33 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- MySQL Database33
- 2.1Introduction to Databases
- 2.2Getting a MySQL Server
- 2.3Creating a Database
- 2.4SHOW and SELECT
- 2.5Basic Rules for SQL Statements
- 2.6Getting Multiple Columns
- 2.7DISTINCT and LIMIT
- 2.8Sorting Results
- 2.9Sort Direction
- 2.10Basic Data Filtering and WHERE
- 2.11Advanced Filtering Using AND and OR
- 2.12Are you IN or are you NOT IN?
- 2.13How Search Engines Work
- 2.14Wildcards
- 2.15Regular Expressions
- 2.16Creating Custom Columns
- 2.17Functions
- 2.18More on Aggregate Functions
- 2.19GROUP BY
- 2.20Subqueries
- 2.21Another Subquery Example
- 2.22How to Join Tables
- 2.23Outer Joins
- 2.24UNION
- 2.25Full-Text Searching
- 2.26INSERT INTO
- 2.27How to Insert Multiple Rows
- 2.28UPDATE and DELETE
- 2.29CREATE TABLE
- 2.30NOT NULL and AUTO INCREMENT
- 2.31ALTER / DROP / RENAME TABLE
- 2.32Views
- 2.33Final Video!
