Packt – MySQL 8 for Administrators

Packt – MySQL 8 for Administrators
English | Size: 1.27 GB
Category: CBTs

This course goes over the basics of MySQL administration, through examples on MySQL 8. It also covers the differences between various MySQL versions. It starts off with the basics: Installing MySQL and Creating users. After that, we will get sysbench up and running. Sysbench, responsible for issuing queries against databases, is the de-facto benchmarking tool for MySQL. With that hands-on lab environment at hand, we will learn about various database administration topics like backups, replication, monitoring, point in time recovery, switchovers, user management and version upgrades.
[Read more…]

Sams Teach Yourself PHP And MySQL Video Learning Starter Kit-DDUiSO

Sams Teach Yourself PHP And MySQL Video Learning Starter Kit-DDUiSO
English | Size: 922 MB
Category: Tutorial

Sams Teach Yourself PHP and MySQL Video Learning brings the successful Teach Yourself book series from Sams Publishing to life on video – with the same clear and concise style, practical hands-on examples, and self-paced learning approach that have made the bestselling books so popular with beginners looking for the easiest way to quickly get up to speed on a new technology. [Read more…]

Learn Database Design with MySQL

Learn Database Design with MySQL
English | Size: 822.46 MB
Category: CBTs

Database design is one of the most important aspects of web programming. Successful implementation of any system with data storage will always need proper database design. In order to create great database design you will not only have to master database technology but will also have to master database design process and normalization. This course will also teach you SQL and you will be a SQL power user by the end of this course. You will start with a basic introduction to data storage and will follow it up with storage engines and other tools. You will also learn about MySQL installation and database design process. Database design, normalization, structure mapping, keys, and junction tables come next. The next units will teach you SQL and Advance SQL and you will also learn to use PHP with MySQL. This complete database course will help you become a database design guru. [Read more…]

MySQL practical tips by Experts – Part 1

MySQL practical tips by Experts – Part 1
English | Size: 146.75 MB
Category: CBTs

This course focuses on practical tips for MySQL admins(DBAs) ,engineers and developers. It is designed by experts with 10+ years of MySQL/RDBMS experience. It is designed in question and answer mode to answer common FAQs. Mysqldump(backup) best practices , pt-kill to find long running queries , methods to execute scripts , password security , static/dynamic variables , Error log monitoring are some of the topics discussed. This is part 1 of the series
Who is the target audience? [Read more…]

O’Reilly – Learn to Build Web Applications with PHP, MySQL, and JavaScript

O’Reilly – Learn to Build Web Applications with PHP, MySQL, and JavaScript
English | Size: 3.80 GB
Category: Tutorial

Becoming a professional full stack web developer requires a solid understanding of the software tools most commonly used to create websites and mobile apps: JavaScript, jQuery, HTML, CSS, PHP, and MySQL. This course teaches you about each of these tools, including their purpose, how they interact with the other tools, and detailed instruction on how to use them. Steve also covers the skill sets used in web development, such as image manipulation, page design, and database development. You’ll learn how modern websites really work, as well as gain hands-on experience using the tools and skill sets the professionals use to make those websites.
[Read more…]

The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert
English | Size: 15.05 GB
Category: Tutorial

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.
[Read more…]

Lynda – Database Clinic: MySQL

Lynda – Database Clinic: MySQL
English | Size: 373.37 MB
Category: Tutorial

The Database Clinic series pits experts and their databases of choice against a series of the same challenges, to highlight the unique capabilities of each database. In this installment of the series, Brad Wheeler demonstrates how MySQL-one of the most widely-used database programs-would rise to meet each task. After going over the strengths and weaknesses of MySQL, Brad shows how to create a database, and quickly load data into MySQL. He also explains how to join data sets; how to search, transform, and perform calculations with your data; and how to use external programming tools to interact with MySQL. [Read more…]

Lynda.com – PHP with MySQL Beyond the Basics

Lynda.com – PHP with MySQL Beyond the Basics
English | Size: 704 MB
Category: Tutorial

In PHP with MySQL Beyond the Basics, expert instructor Kevin Skoglund introduces powerful PHP programming techniques using object-oriented programming (OOP). Both novice and experienced PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that OOP offers. Kevin shows how OOP techniques can streamline database queries, help manage sessions, and simplify user logins. While building a real-world web application, Kevin also includes practical advice on topics ranging from structuring code to logging user actions. [Read more…]

Lynda PHP with MySQL Essential Training 2 Build a CMS

Lynda PHP with MySQL Essential Training 2 Build a CMS
English | Size: 641.87 MB
Category: Tutorial

This course-the second installment in a series-builds on the fundamentals of PHP with MySQL and teaches the intermediate concepts necessary to develop real-world web applications while creating a working content management system. Kevin Skoglund shows how to create dynamic navigation to allow public users to browse different pages of database-driven content. He demonstrates how to hide content from the public and to write functions which are context-sensitive and use argument options for conditional behavior. He shows how to implement user authentication and utilize PHP’s built-in password functions to securely regulate page access. Finally, he shows how related database tables can become nested resources by modifying and scoping functions. Along the way, Kevin provides practical advice and offers examples of best practices. [Read more…]

Sams Teach Yourself PHP and MySQL Video Learning Starter Kit

Sams Teach Yourself PHP and MySQL: Video Learning Starter Kit
English | Size: 922 MB
Category: Tutorial

Sams Teach Yourself PHP and MySQL Video Learning brings the successful Teach Yourself book series from Sams Publishing to life on video – with the same clear and concise style, practical hands-on examples, and self-paced learning approach that have made the bestselling books so popular with beginners looking for the easiest way to quickly get up to speed on a new technology.
[Read more…]