The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the mysql client program and MySQL Workbench.
The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the mysql client program and MySQL Workbench.
The basic SQL statements,including the use of SQL functions and the basic table and view handling statements are introduced.
Audience
Anyone who needs to access and work with a MySQL Database.
Objectives
To provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.
Contents
COURSE INTRODUCTION
Administration and course materials
Course structure and agenda
Delegate and trainer introductions
SESSION 1: DATABASE CONCEPTS
What is a database?
Database management systems
Tables,rows and columns
Indexes,primary keys,unique constraints and foreign keys
Client-Server architecture
Supported data types
Storage engines and table types
The Information_Schema and MySQL Databases
Exercise: Using a MySQL Database
SESSION 2: USING THE MYSQL CLIENT
What is the MySQL client?
Getting started and Logging in
Selecting a database
Client commands
Entering and executing SQL statements
Retrieving previous commands
Creating,editing and executing SQL files
Redirecting output into a file
Command line execution of MySQL Scripts
Exercise: Using the MySQL Client
SESSION 3: BASIC SELECT
The SQL SELECT statement
Case sensitivity
Quotes
Statement terminator
Syntax conventions
The select clause
The FROM clause
Conditions and the WHERE clause
Logical operators
The ORDER BY clause
Column aliases
Arithmetic expressions
Precedence of operators
Exercises: Querying the sample database
SESSION 4: LIMIT,UNION AND AGGREGATE FUNCTIONS
The LIMIT clause
UNION
UNION ALL
Aggregate functions
The GROUP BY clause
Using Rollup with GROUP BY
The HAVING clause
Exercises: Using Limit,Union and Aggregate Functions
SESSION 5: SUBQUERIES AND JOINS
Subqueries
Cartesian products
Joins with original syntax
Table aliases
Natural joins
Join using
Join on
Multi-table joins
Exercises: Using Subqueries and Joins
SESSION 6: NUMERIC AND CHARACTER FUNCTIONS
Function types
Testing functions
Numeric functions
Character functions
Exercise: Using Numeric and Character Functions
SESSION 7: DATE,TIME AND OTHER FUNCTIONS
Date and time column types
Date and time formats
The date format function
Functions to return date time
Functions to extract components from date time
Date time arithmetic
Miscellaneous functions
Exercise: Using Date,Time and other functions
SESSION 8: DATABASES AND TABLES
Creating a database
Selecting a database
Obtaining database metadata
Table properties
Creating tables
Auto_increment
Show create table
Column operations
Constraint operations
Copying tables
Renaming tables
Changing engine for tables
Obtaining table metadata
Altering tables
Dropping tables
Temporary tables
Memory tables
Exercises: Maintaining databases and tables
SESSION 9: INDEXES AND VIEWS
What is an index?
Structure of an index
Creating an index
Reviewing indexes
Composite indexes
Altering a table to add an index
Dropping indexes
What is a view?
Creating views
View restrictions
Dropping views
Exercise: Maintaining indexes and views
SESSION 10: MANAGING DATA
Inserting rows
Replacing rows
Updating rows
Deleting rows
The truncate statement
The COMMIT and ROLLBACK commands
Savepoints
Implicit commits
Exercise: Managing data
SESSION 11: ACCESS CONTROL
Creating users
Renaming users
Dropping users
Granting privileges
Revoking privileges
Exercise: Creating users,granting and revoking
SESSION 12: IMPORT AND EXPORT
Exporting using SQL
Importing using SQL
Exporting from the command line
Importing from the command line
Exercise: Export and import data
Prerequisities
There are no formal pre-requisites for the Introduction to MySQL course,although an understanding of databases and exposure to information technology in general would be useful. This knowledge can be gained by attendance on the Relational Databases & Data Modelling Overview course.
Global Knowledge is a worldwide leader in IT and technology training, helping individuals and organizations build the skills they need to succeed in an ever-changing world.
With an international network of offices and training facilities, Global Knowledge has the unique flexibility to deliver a broad portfolio of courses on over 100 countries online, in classrooms, and through a worldwide partner network.
Established in 1995, Global Knowledge has over 1000 employees worldwide and enables the success of more than 200,000 tech professionals each year.
In June 2021, Global Knowledge merged with Skillsoft to create the world’s leading corporate learning company.
Leadership
Investor Relations
A Foundation In The Technology Community
Our contribution within the global technology community is more than just IT training. Technology’s expanding reach is making every level of staff some sort of technology professional.
The hyper-focused, specialty roles aren’t going anywhere—they’re more necessary than ever—but we also must account for the T-shaped skills. Thus, we train beyond the traditional IT topics and train more people than corporate IT.
Whether you’re managing mission critical technology initiatives, developing your technical talent pipeline or taking IT products and services to market, our innovative and flexible learning solutions equip you for success.
Why Global Knowledge? Impact.
Sustainable, scalable, repeatable IMPACT--with minimal disruption. That’s why for over 20 years organizations large and small, technology providers, enterprises, and governments around the world come to us.
By providing access to subject matter experts, delivering authorized and industry-leading instruction through multiple delivery formats, we set the stage for your success by reducing skill gaps. You’ll also see impacts in onboarding and employee retention through improved skills and higher job satisfaction.
This is all driven by level of quality we set for ourselves. We believe in consistency and maintain rigorous in-house standards, so you receive an exceptional training experience anywhere in the world. Only a dedicated learning organization specializing in more than one or two topics can deliver this level of impact—and we’re ready to provide it to you.
Quick facts:
World’s largest dedicated IT training company
5,000+ guaranteed to run classes per year
3,000+ unique IT courses
1,100+ subject matter experts
95% overall student satisfaction
Authorized training partner for Amazon Web Services, Cisco, Citrix, Google, IBM, ITIL®, Microsoft, Red Hat®, VMware and more.
Trained in over 100 countries (and in international waters)
Since 1995, we’ve grown to 15 offices and 1,500 employees. Our U.S.-based corporate headquarters is located in Cary, North Carolina (United States). Canadian headquarters are in Toronto, and our Europe, Middle East and Africa headquarters are in Wokingham, UK.
International locations: Belgium, Canada, Denmark, Egypt, France, Ireland, Netherlands, Norway, Qatar, Saudi Arabia, Spain, Sweden, United Arab Emirates, the United Kingdom and, via partnership, Colombia, India and Mexico.
Between our international locations and online capabilities, we deliver what you need, when and where you need it and to who needs it. And we do it every day.
During this 2 day course, you will optimise your understanding of how to use DQS to cleanse, match, standardise, and enrich data to guarantee a result of reliable and consistent analytics. This course will equip you with up-to-date regulations and fundamental objectives to ensure the highest qualit...
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
Database designers and developers are now being considered the key part of the IT infrastructure of any organization.
This is a hands-on course. Our experienced trainers will have you writing your own SQL queries in no time. We make sure that you have plenty of time to try things out and ask questions if you’re not sure of anything.
In this course, you’ll learn the core concepts of relational databases, and you’ll get your feet wet with structured query language (SQL), which is used to manage data in a relational database management system.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy