MySQL Querying Fundamentals (Live Online)

Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau, or Crystal Reports. Analysts and Data Scientists can use SQL to select the data they need for additional analysis and reporting. This class, MySQL Querying: Fundamentals, provides an overview of the SQL statements that can be used to access that data. This course covers MySQL 8.0.You will:Connect to the MySQL Server database and execute a simple query.Include a search condition in a simple query.Use various functions to perform calculations on data.Organize the data obtained from a query before it is displayed on-screen.Retrieve data from multiple tables.Target StudentThis course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.PrerequisitesSome familiarity with database terminology and structure is helpful.Course OutlineHow 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 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 about