GETTING STARTED WITH SQL Exercises with PhpMyAdmin and MySQL

Mixkit: Known for its user-friendly interface, Mixkit provides a vast collection of free video assets, including motion graphics and video templates. While they aren't directly from Videohive, they offer a comparable quality that can be integrated into your projects seamlessly.
Videezy: Videezy offers a variety of free and paid video assets, including After Effects templates. Their extensive library is perfect for those looking to enhance their videos without breaking the bank.
Motion Elements: While Motion Elements primarily focuses on premium content, they regularly feature free downloads that include video templates similar to those found on Videohive. Their search interface allows you to filter out the free options easily.
Editor’s Depot: This site provides free editing tools and templates, ensuring you have access to some elements similar to Videohive offerings. Though the selection might not be as vast, it’s a valuable resource for cost-effective production.
Motion Array: With a solid reputation, Motion Array occasionally offers free downloads that replicate some Videohive elements. Subscribing to their newsletter might help you get alerts about any new freebies available.

SQL (Structured Query Language) is a query language for relational database management. In this book, you will discover the basics of its organization and its characteristics. Using the PhpMyAdmin environment, you will learn how to create a database, tables, columns, constraints, keys (primary and for), joins and many other specificities.

SQL has a small set of statements and enables you to select records from one or more tables using the universal SELECT command.

Other expressions like UPDATE, INSERT or DELETE will help you to update, insert or delete records. You will also study several functions that manipulate text, dates and numbers.

Thanks to the exercises in this book, you will understand how a small set of statements can perform accurate actions and enhance your skills.

Enjoy your reading!

ABOUT THE AUTHOR

Remy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has several computer books to his credit.

Top Rated News