Introduction to Structured Query Language (SQL) for Data Analytics

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 it

Curriculum:

• Installing Microsoft SQL Express and Management Studio
• Learning history of SQL and basic concepts of the structure of a relational database
• Understanding structured programming
• Understanding naming convention
• Understanding basic syntax to query one table
• Using built-in functions for strings
• Querying two or more datasets (tables or views) using INNER JOIN, OUTER LEFT JOIN and OUTER RIGHT JOIN
• Using built-in functions for numeric values including aggregate functions and GROUP BY
• Using clauses ORDER BY, CASE, WHERE and operators
• Sub-queries
• Understanding function FORMAT() for dates and currencies including culture codes
• Understanding data types
• Creating, dropping, and altering databases, schemata, tables and columns
• Inserting values into tables and updating values
• Differences between DROP, TRUNCATE and DELETE
• Altering databases, schemata, tables and views
• Understanding NULL and NOT NULL
• Understanding functions CONVERT(), CAST(), DAY(), MONTH(), YEAR() and GETDATE()
• Creating, dropping, and altering views