DTBS 0016 - SQL – Introduction
Course Description
Everyone wants to make data-driven decisions, but learning how to access and handle data can seem overwhelming. SQL (Structured Query Language) is a great place to start building your expertise in extracting data and creating actionable insights. Knowledge of SQL is a top skill employers seek in data-related positions.
The course involves lecture, demonstration, hands-on practice and instructor coaching.
Course Outline/Topics
- Relational Databases
- Select Statement
- Column Aliases
- Derived Columns
- Conditional Operators
- Logical Operators
- Nulls
- Where Clause
- Order by Clause
- Expressions
- Inner, Outer, Mixed and Self Joins
- Aggregate Functions
- Grouping
- Having Clause
- Subqueries
- Unions
- Insert, Update and Delete Queries
Benefits and Learning Outcomes
- Understand database management system terminology and concepts
- Apply database concepts to gain an understanding of formatting, preparation and maintenance of data
- Apply database concepts to understand basic SQL queries
- Analyze existing sample SQL queries
- Create new SQL queries to answer sample business questions
Who Should Attend
Anyone seeking to answer questions based on data. No prior experience is required. This course is especially useful for individuals who have been running previously created SQL queries without understanding them.
Testimonials
"Rick did great and made it really clear that questions were wanted and was willing to work through any problems without getting frustrated. He also tried to hit home the importance of the most important concepts."
- Participant, Spring 2024
"Very knowledgeable, always willing to help answer any questions."
- Participant, Spring 2024
"A lot was covered in these two-day courses. Mr. Richard took time to give examples that helped with staying engaged and absorbing the information."
- Participant, Spring 2024
Instructors
Applies Towards the Following Credentials
- Business Analysis Certificate : Elective
- Data Analysis Certificate : Core
