Who it's for: This course has been designed for individuals who wish to learn how to use SQL to query databases and extract information.
What it is: SQL stands for Structured Query Language. It’s a common language for gathering, organizing, and exporting data stored in relational databases.
What you'll learn: In this course, you’ll learn basic SQL usage and terminology, as well as how to execute simple queries and queries using criteria conditions. Next, you’ll learn how to summarize, organize, and export valuable query data and results.
Exercise Files - Download Before Starting the Course
Available in
days
days
after you enroll
Course
Available in
days
days
after you enroll
- Introduction (0:09)
- Introduction to SQL (3:57)
- Installing SQL Server (3:59)
- SQL Keyword Command Language and Hierarchy (5:08)
- Connecting to a SQL Database (9:09)
- Creating and Saving a Query (9:58)
- Using One or More Query Conditions (7:53)
- Applying AND OR Operators (6:11)
- NULL NOT NULL (2:40)
- Range of Values (8:36)
- Querying Data Using Wildcard Characters (6:43)
- Formatting Column Headings with Aliases (5:17)
- Formatting Query Data Results (4:03)
- Performing Date Calculations - DateDifDateAdd (8:29)
- Summarizing Data Using Aggregate Functions AVG COUNT SUM min max (7:47)
- Manipulating Text Results with String Functions CONCAT_SUBSTR (7:40)
- Sorting Data Order BY and GROUPBY (8:17)
- RANK and HAVING (5:58)
- Mathematical Financial Expressions (6:01)
- PIVOT (9:02)
- JOIN (13:02)
- Union ALL (5:59)
- Except Clause (1:55)
- Sub Queries (12:16)
- Exports (3:23)
- Conclusion (0:45)