Learning MySQL 5 Training Video

Informação importante

Curso

Online

Quando:à escolha

Descrição

Learning MySQL 5 Training Video A Practical MySQL Training Course That Teaches Real World Skills In this project-based Learning MySQL 5 video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Learning MySQL 5 Training Video course to get: Concise, informative and broadcast-quality MySQL 5 training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex MySQL 5 subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of MySQL 5 tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 6.5 hours to complete this course 91 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning MySQL 5 Training Video course, expert author Jason Gilmore introduces you to MySQL, a popular relational database used most often in the LAMP (Linux, Apache, MySQL, PHP) stack, or development environment. This training video covering MySQL 5 is designed for the beginner, and no previous MySQL experience is necessary. Throughout this tutorial, Jason covers some of the fundamental topics that you will need to use and manage MySQL, such as: installing MySQL, configuring MySQL, connecting to MySQL, securing MySQL, and managing MySQL. You will learn about data types, primary and foreign keys, creating, retrieving and updating data, and using stored functions. You will also learn tricks for optimizing,...

Informação importante

Requisitos: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Instalações

Instalações e datas

Início

Localização

à escolha

Online

O que se aprende nesse curso?

PHP

MySQL

Database

SQL

Database training

Primary

IT Development

Mac

Skills and Training

Programa

01. Introducing The Relational Database

0101 Course Introduction

0102 What Is A Relational Database

0103 The Database Hierarchy

0104 Table Relations

0105 The Structured Query Language

0106 Conclusion

02. Installing And Configuring MySQL

0201 Introduction To MySQL

0202 MySQL Features

0203 Installing MySQL - Introduction

0204 Downloading MySQL

0205 Installing MySQL - Part 1

0206 Installing MySQL - Part 2

0207 Configuring MySQL

0208 Setting The System Path - Part 1

0209 Setting The System Path - Part 2

0210 Installing MySQL On The Mac

0211 The Sakila Database

0212 Installing The Sakila Database

03. Connecting To MySQL And Creating Your First Database

0301 Introduction To MySQL Connections

0302 Role Of The Root User

0303 Logging In For The First Time

0304 Change The Root Password

0305 Creating Your First Database

0306 Creating Your First User Account

0307 Creating Your First Table

04. Introducing MySQL's Data Types

0401 Intro To Data Types

0402 String Data Types - Part 1

0403 String Data Types - Part 2

0404 Data Attributes

0405 Customers Table Revised

0406 Numerical Data Types - Part 1

0407 Numerical Data Types - Part 2

0408 Numerical Data Attributes

0409 Date And Time Types

0410 Multiple Timestamp Columns In Table

05. Primary And Foreign Keys

0501 Primary Keys - Part 1

0502 Primary Keys - Part 2

0503 Creating A Primary Key

0504 Foreign Key Introduction

0505 Create Foreign Key

06. Introducing phpMyAdmin, MySQL Workbench, SQLyog

0601 Graphical MySQL Clients

0602 phpMyAdmin Intro

0603 MySQL Workbench Intro

0604 MySQL Workbench SQL Development Intro

0605 MySQL Workbench Data Modelling Intro

0606 MySQL Workbench Server Administration Intro

0607 SQLyog Introduction

0608 SQLyog Creating A Database

0609 SQLyog Navigating And Modifying Data

0610 SQLyog Scheduling Backups

07. Creating, Retrieving, Updating And Deleting Data

0701 Performing CRUD Operations

0702 Creating Data

0703 Retrieving Data

0704 Ordering Results

0705 Filtering Results

0706 Grouping Results

0707 Removing Duplicate Rows

0708 The LIKE Clause

0709 The LIMIT Clause

0710 Updating Data

0711 Deleting Data

08. Using String, Numeric, Temporal And Stored Functions

0801 Introduction To Functions

0802 String Functions

0803 Numeric Functions

0804 Temporal Functions - Introduction

0805 Temporal Functions - Example

0806 Stored Functions - Part 1

0807 Stored Functions - Part 2

0808 Stored Functions - Part 3

09. Introducing Subqueries

0901 Subqueries Intro

0902 Subqueries

10. Introducing SQL Joins

1001 SQL Joins

1002 The Inner Join

1003 The Left Join

11. Optimizing MySQL

1101 Optimizing MySQL

1102 Column Indexing

1103 Column Indexing Explained

1104 Optimizing The MySQL Configuration

1105 Query Caching

1106 Query Caching Explained

1107 Optimizing MySQL Conclusions

12. Importing, Exporting And Backing Up MySQL Databases

1201 Introduction To MySQL Data Tasks

1202 Exporting Data With MySQL Workbench

1203 Importing Data With phpMyAdmin

1204 Automatically Backing Up Your MySQL Database

1205 Automating Your Backups With mysqldump And cron

13. Managing MySQL User Privileges

1301 Managing MySQL Privileges

1302 MySQL Privilege Management Walkthrough

14.Using PHP And MySQL

1401 Introduction to PHP and MySQL

1402 Querying Your MySQL Database With PHP

15. About The Author

1501 About The Author

Informação adicional

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.