Course Description
When working with SQL, being able to pull the right data is the key to effective business operations. This course on "Intermediate MySQL" will expand your skills in setting up queries to pull the right data in the right ways for your reports. Learn how to retrieve data using different statements like SELECT or WHERE, string functions, and sorting. Learn how to create views so you can see at-a-glance data, and learn how to group and merge data, too. Come away from this course knowing how to more precisely query your data for more accurate reports.
So you've mastered the basics of SQL. If you want to do more specific data pulls to get more detailed reports tailored to your business needs, this course will broaden your skills in knowing how to use SQL to report data. This course will show you new statements to use, like SELECT, WHERE, LIKE, and IN to retrieve more drilled-down data. You'll also learn how to query across databases, and understand how to normalize your database to reduce redundancy and increase efficiency. Learn how to nest or intersect data when setting up queries as well. Finally, learn how to create your own custom variables and functions so you can get the data you need quickly and accurately. The instruction in this course will not only help you grow your technical knowledge, but can help you grow your career as well.
Learning Objectives:
- Learn how to generate reports and retrieve data in SQL
- Find out how to use SELECT, WHERE, LIKE, and IN to retrieve data
- Learn how to filter and sort data using SQL with ORDER BY operations
- Learn how to change report headings with aliases
- Understand how to use string functions
- Learn how to group and summarize SQL results
- Learn how to query data from a table using SQL
- Discover how to query multiple tables in SQL
- Learn how to merge across tables using the UNION function
- Learn how to group SQL results using GROUP BY
- Gain advanced skills like knowing how to create functions in SQL, as well as custom variables, and procedures
Skills You Will Learn
- Database Programming
- Extended Sql
- Mysql++
- MySQL
- Relational Databases
- SQL (Programming Language)
What You'll Learn
- Retrieve data using SELECT, WHERE, LIKE, and IN statements to pull more drilled-down data
- Filter and sort data with the WHERE clause and ORDER BY operations
- Use string functions, date and time functions, and aliases to change report headings
- Group and summarize SQL results using GROUP BY, COUNT, and the HAVING clause
- Merge data across tables using JOIN and UNION, and query multiple tables
- Create views, subselects, custom variables, functions, and procedures for faster, more accurate queries
Key Takeaways
- This intermediate course builds on SQL basics to help learners set up queries that pull the right data for more detailed, tailored reports.
- Learners practice retrieving data with statements such as SELECT, WHERE, LIKE, and IN, and refine results through sorting, filtering, and aliases.
- The course covers querying across multiple tables and databases, and normalizing a database to reduce redundancy and increase efficiency.
- Data can be combined and analyzed by merging across tables with JOIN and UNION and by grouping and summarizing results with GROUP BY and HAVING.
- Advanced topics include creating views, subselects, custom variables, functions, and procedures to get needed data quickly and accurately.
Frequently Asked Questions
Who is this course for?
It is for learners who have mastered the basics of SQL and want to do more specific data pulls to get more detailed reports tailored to their business needs.
What query statements and functions does the course cover?
It covers SELECT, WHERE, LIKE, and IN for retrieving data; ORDER BY for sorting; aliases for changing report headings; string functions and date and time functions; and GROUP BY, COUNT, and the HAVING clause for grouping and summarizing results.
Does the course teach how to combine data from multiple tables?
Yes. It teaches how to query multiple tables, merge data across tables using JOIN and UNION (along with Intersect and Except), and merge rows using the GROUP BY clause.
What advanced skills will I gain?
You will learn how to create views and subselects, normalize a database to reduce redundancy and increase efficiency, and create custom variables, functions, and procedures.
What prior knowledge is expected?
The course assumes you have already mastered the basics of SQL and want to broaden your skills in using SQL to report data.
