SQL Training Overview
This 3-day SQL Server course, Introduction to SQL for Report Writers and Analysts, teaches attendees the basics of Transact-SQL, including writing simple and complex queries, working with data types, building functions, and more. Students will also learn how to combine data from multiple tables and result sets using JOIN operations and subqueries.
Note: This class can be customized to use SQL Server 2012 through 2022.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Understand database design concepts
- Query the database
- Work with different data types
- Join Multiple Tables
- Work with functions
- Perform subqueries
Prerequisites
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Basic knowledge of the Microsoft Windows operating system including the ability to easily open and save files in a variety of programs and the ability to launch new applications
- Working knowledge of basic database concepts such as relational database design, normalization, and table structure would be helpful
- Exposure to query writing or having experience with another programming background would be helpful
Outline
Expand All | Collapse All
Introduction
- Course Overview
- Data Manipulation Verbs
- Courseware Overview
- Datasets Overview
Overview of SSMS and Query Writing
- Working with SSMS
- Using the SQL Editor
- Creating SSMS Script Projects
- Tips and Tricks with SSMS
- Adding Comments to Queries
- Understanding Batches and Scripts
Database Design Concepts
- What is SQL
- Database Diagrams
- Database Terminology Overview
Basic SELECT Statements
- The SELECT Statement
- Execution Order of SELECT Statements
- Ordering Results
- Additional SELECT Options
Working with Data Types
- Data Type Precedence
- String Related Data Types
- Numeric Data Types
- Date and Time Data Types
- Converting Between Data Types
- How to Find Help on Functions
- Understanding Data Type Conversion
Enhanced SELECT Statements
- Expressions
- Filtering Rows
- Comparison Operators
- Logical Operators
Handling NULL Data
- NULL vs Blank
- = vs IS NULL
- ISNULL function
- COALESCE
- Concatenating NULL Data
Aggregating and Grouping Data
- Aggregate Functions
- GROUP BY
- HAVING
- HAVING vs WHERE
Joining Multiple Tables
- JOINS
- INNER JOIN
- OUTER JOIN
- CROSS JOIN
- Joining Three or More Tables
- Self-join
- Alternate Syntax, Implicit Joins
- Set Operations
- Working with Multiple Set Operators
- Viewing Graphical Execution Plans
Built-in Functions Overview
- Working with Functions
- Mathematical Function Overview
- String Function Overview
- Date Time Function Overview
- Nesting Functions
Subqueries
- Subqueries
- Nested vs Correlated Subqueries
- Subqueries in the SELECT Clause
- Subqueries in the WHERE Clause
- EXISTS
- Subqueries in FROM Clause
- Alternatives to Subqueries
Conclusion
Training Materials
All SQL Server training students receive comprehensive courseware.
Software Requirements
Attendees will not need to install any software on their computers for this class. The class will be conducted in a remote environment that Accelebrate will provide; students will only need a local computer with a web browser and a stable Internet connection. Any recent version of Microsoft Edge, Mozilla Firefox, or Google Chrome will work well.
