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
