San Francisco, California
London, United Kingdom
Nearly a decade ago, GeekAustin launched a series of community classes. The classes ran for several years, until we lost access to the facility where the classes were taught. One of the most popular classes was the basic SQL/MySQL class, taught by Mark Lehmann of the Austin MySQL Meetup group. Based on community requests, we are re-launching this series, and the first class offered will be Mark's SQL class. There is no better person in Austin from whom to learn basic SQL/MySQL. This class has always sold out.
A special thanks to the folks at Tech Ranch for providing the venue.
This is an eight-session class taught by Mark Lehmann. The class meets on Wednesdays once a week for 2.5 hours (2 hours for class, 30 mins available for office hours).
This class is designed for those without SQL or MySQL experience. The instructor will use MySQL to teach basic SQL concepts.
There will be reading and exercises outside of class as well as labs during class. Access to the internet outside of class. During the class, students will be able to access class MySQL server and manipulate their data. Classes will primarily be a review of the concepts and interactive group problem solving.
MySQL Associates Certification
After taking this course, the student will be prepared to review the MySQL 5.0 Certification Guide. The topics covered in the course will actually cover more advanced topics than strictly required for the Associate certification. Some of the tedious details from the certification are skipped in the course because they are not helpful on a daily basis for using MySQL.
As the core textbook, we will be using the O'Reilly book, Learning MySQL and MariaDB by Russell Dyer. Students can purchase the book from O'Reilly at a 40% discount (or 50% discount for the ebook) using the following discount code: PCGDG.
Students will use their laptop or tablet with text terminal combined SSH to access the "mysql" command line to perform book exercises and do labs. There is a free graphical interface for MySQL and students are welcome to use that as well, but class time will not be spent setting it up.
Minimum Class Topics
• Creating a MySQL Database
• Using the mysql Command-Line Tool
• DataTypes: MySQL
• Table Creation
• Basic Queries : SELECT, FROM, and WHERE
• Data manipulation with INSERT, UPDATE, DELETE statements
• GROUP BY clause
• ORDER BY clause
• Collation and Character Sets
• Conditional evaluation
• NULL statement
• Simple JOIN statements
• Intermediate joins: Outer JOIN, Self-JOIN, equi-JOIN, and others
• Basic SQL Functions
• Backups and Restores
• Cloud MySQL turnkey solutions