Querying MySQL (Live Online)

MySQL® is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines. This course covers MySQL 8.0.AudienceApplication and web developers.PrerequisitesPrior experience installing software and programming in any language, such as HTML, is recommended but not requiredCourse OutlineAn introduction to relational databases and SQLAn introduction to client/server systemsAn introduction to the relational database modelAn introduction to SQL and SQL-based systemsThe SQL statementsHow to use SQL from an application programHow to use MySQL Workbench and other development toolsAn introduction to MySQL WorkbenchHow to use MySQL Workbench to run SQL statementsHow to use the MySQL Reference ManualHow to use the MySQL Command Line ClientHow to retrieve data from a single tableAn introduction to the SELECT statementHow to code the SELECT clauseHow to code the WHERE clauseHow to code the ORDER BY clauseHow to code the LIMIT clauseHow to retrieve data from two or more tablesHow to work with inner joinsHow to work with outer joinsOther skills for working with joinsHow to work with unionsHow to insert, update, and delete dataHow to create test tablesHow to insert new rowsHow to update existing rowsHow to delete existing rowsHow to code summary queriesHow to work with aggregate functionsHow to group and summarize dataHow to code aggregate window functionsHow to code subqueriesAn introduction to subqueriesHow to code subqueries in the WHERE clauseHow to use the ALL keywordHow to code subqueries in other clausesHow to work with complex queriesHow to work with common table expressionsHow to work with data typesThe data typesHow to convert dataHow to use functionsHow to work with string dataHow to work with numeric dataHow to work with date/time dataOther functions you should know aboutHow to create databases, tables, and indexesHow to work with databasesHow to work with tablesHow to work with indexesHow to use MySQL WorkbenchHow to work with character sets and collationsHow to work with storage enginesHow to create viewsAn introduction to viewsHow to work with viewsLanguage skills for writing stored programsAn introduction to stored programsHow to write procedural codeHow to use transactions and lockingHow to work with transactionsHow to work with concurrency and lockingHow to create stored procedures and functionsHow to code stored proceduresHow to code stored functionsHow to use Workbench with procedures and functions