Change Location × London, UK

    Recent Locations

      MYSQL Intermediate 3-Days, London in Covent Garden


      • MYSQL Intermediate 3-Days, London Photo #1
      1 of 1
      March 25, 2019

      Monday  11:00 AM (on various days)

      5 Southampton Street
      Covent Garden, Greater London WC2E 7HA

      Performers:
      • No Performers Listed
      EVENT DETAILS
      MYSQL Intermediate 3-Days, London

      MySQL Intermediate 3-day Course Course summary Learn how to get valuable information, trends, summaries, statistics and insights from your company data. This course is ideal for managers who need to get business intelligence from their data, or data analysts who should provide such information. This course uses MySQL Workbench. MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.   Prerequisites: Understanding of dataDuration: 3 days.Max group size : 4 delegates.Included in the price: Certificate on completion (assessment based), Course notes, Practical Class exercises, Teas/Coffees but no lunchTo assist after the course: 1-Hour mentoring, online via Skype   Course Contents: Session 1,2and 3: Brief revision of Basics Session 4: LIMIT, UNION and AGGERGATE Functions The LIMIT clause, Union, Union all, Aggregate, GroupBy , Rollup with group By, Having. Session 5: Joins and Subqueries. Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products. Correlated and uncorrelated Subqueries. Session 6: Numeric and Character Functions. DATE, TIME and Other functions. Session 7: Create, alter and drop Views. Stored procedures, without and with parameters. Custom Functions. Session 8: Create and drop Databases. Create, alter and drop Tables. Datatypes. Constraints. Session 9: Create, alter and drop Indexes. Session 10: Managing Data Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits Session 11: Access Control Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges Session 12: Import and Export

      Categories: Business & Networking

      This event repeats on various days: Jun 17, Jun 24

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.