Learning MySQL 5 Training Video

Courses For Success
Online

AU$189 - (R$479)

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.

Q: How do I access my digital download...