Introduction to Structured Query Language (SQL) for Data Analytics (Live Online)

Structured Query Language (SQL) is used to extract information from a relational database to address an array of business information needs. Thus, the goal of the course is to teach participates how to query a relational database for information and analysis.Course Objectives:Students will learn how to query a relational database for information and analysis using Transact-SQL.Understand how data is retrieved prior to analyze itCurriculum:Installing Microsoft SQL Express and Management StudioLearning history of SQL and basic concepts of the structure of a relational databaseUnderstanding structured programmingUnderstanding naming conventionUnderstanding basic syntax to query one tableUsing built-in functions for stringsQuerying two or more datasets (tables or views) using INNER JOIN, OUTER LEFT JOIN and OUTER RIGHT JOINUsing built-in functions for numeric values including aggregate functions and GROUP BYUsing clauses ORDER BY, CASE, WHERE and operatorsSub-queriesUnderstanding function FORMAT() for dates and currencies including culture codesUnderstanding data typesCreating, dropping, and altering databases, schemata, tables and columnsInserting values into tables and updating valuesDifferences between DROP, TRUNCATE and DELETEAltering databases, schemata, tables and viewsUnderstanding NULL and NOT NULLUnderstanding functions CONVERT(), CAST(), DAY(), MONTH(), YEAR() and GETDATE()Creating, dropping, and altering views