Booking Enquiry
MySQL Intermediate Beginners
Course Aims
This course provides the knowledge and skills needed to retrieve and update data held in a relational database.
Who Should Attend
Anyone who needs to understand and use SQL to manipulate a database. There are no formal pre-requisites for this Introduction to SQL course, although an understanding of databases and exposure to information technology in general would be useful.
Duration: 1 Day
Course Outline
Relational Database Concepts
Relational Database Concepts
- What is a Relational Database?
- Tables, Rows and Columns
- Indexes, Primary Keys and Foreign Keys
- Data Types
- The Data Dictionary
- Getting Started
SQL Language Essentials
- Tables, Rows and Columns
- Indexes, Primary Keys and Foreign Keys
- Data Types
- The Data Dictionary
- Getting Started
SQL Language Essentials
- The Select Statement
- The Select and From Clauses
- Conditions and the Where Clause
- The Order By Clause
- Arithmetic Operations
- Column Aliases
- Practical Exercises
Summarizing and Grouping Data
- The Select and From Clauses
- Conditions and the Where Clause
- The Order By Clause
- Arithmetic Operations
- Column Aliases
- Practical Exercises
Summarizing and Grouping Data
- Aggregate Functions
- The Group By Clause
- The Having Clause
- Practical Exercises
Querying Multiple Tables
- The Group By Clause
- The Having Clause
- Practical Exercises
Querying Multiple Tables
- Joining Tables
- Inner Joins
- Column Qualification and Table Aliases
- Outer Joins
- Self Joins
- Alternative Join Syntax
- Practical Exercises
- Inner Joins
- Column Qualification and Table Aliases
- Outer Joins
- Self Joins
- Alternative Join Syntax
- Practical Exercises
Additional SQL Features
- Combining Queries
- The Union, Intersect and Minus Operators
- Basic Subqueries
- Practical Exercises
- The Union, Intersect and Minus Operators
- Basic Subqueries
- Practical Exercises
What happens next?
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
© 2024 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy
