Maxtrain.com - info@maxtrain.com - 513-322-8888 - 866-595-6863
Transact SQL for Developers
Description
Transact SQL for Developers Introduction
Welcome to the Transact SQL for Developers course, a meticulously designed journey into the world of Transact-SQL (T-SQL) for SQL Server. This course is your comprehensive guide to mastering T-SQL query writing, an essential skill for effectively managing and utilizing SQL Server databases.
Tailored for professionals across the spectrum – from SQL Server Developers and Database Administrators (DBAs) to System Engineers – this course promises to enhance your ability to develop efficient SQL queries, fully leveraging the capabilities of SQL Server in your applications and databases.
Our curriculum is structured to provide a strong foundation in database fundamentals and terminology, setting the stage for a deep dive into the nuances of T-SQL. You will explore a range of Microsoft tools designed to simplify and enhance the query creation process, ensuring you can extract exactly the data your projects require.
Our unique pedagogical approach emphasizes a practical, step-by-step methodology in constructing SQL queries, closely aligning with real-world business scenarios and the way SQL Server processes SQL statements. This hands-on, experiential learning style not only differentiates our course from others, which often treat SQL as a mere collection of features, but also ensures a comprehensive understanding and application of each concept, preparing you to meet and exceed professional challenges in the field of SQL Server development and administration.
Course Objectives
- Possess a solid grasp of database fundamentals and SQL Server tools.
- Be proficient in crafting Transact-SQL queries tailored to business requirements.
- Understand how to efficiently filter and present data.
- Excel at aggregating and modifying data.
- Create and leverage diverse database objects.
- Master procedural logic for SQL scripts.
Prerequisites
- Before attending this course, students should have familiarity with programming and developing software using any language.
Audience
- This course is intended for SQL Server Developers, Database Administrators, and System Engineers who are responsible for writing T-SQL queries for an application.
Transact SQL for Developers Outline:
Database Concepts
- Conceptual View
- Logical View
- Database Diagramming
Using the Tools
- SQL Server Management Studio (SSMS) Overview
- Viewing Basic Table Metadata
- Viewing Other Table Constraints
- SSMS Database Diagramming
Getting the Data
- SQL Language
- The SELECT Statement
- The FROM clause
- Joining Tables
- Using Views and Subqueries
- Reformulating Subqueries using Common Table Expressions
- Old Form Join Syntax
Filtering the Data
- When is the WHERE clause processed?
- The WHERE Clause
- Filtering Data with Equality
- Using a List of Values
- Using Subqueries to Filter Data
- Data Type Precedence
- Proper Search Arguments
What to Display
- When is the Column List Processed?
- Identifying Columns
- Renaming Columns through a Column Alias
- When and How to use Built-in Functions
- Using Subqueries in the Column List
- Using the CASE Expression
- Ordering Rows
- Controlling Row Display
Aggregating the Data
- When is the Aggregation Performed?
- Grouping and Aggregating
- Pivoting Data
- Aggregate Window Functions
- Using Ranking Functions
Modifying the Data
- Defining Database Transactions
- INSERT Statement
- DELETE Statement
- UPDATE Statement
- MERGE Statement
Modules
- Layers of Abstraction-Three Schema Architecture
- Creating and Using Views
- Creating and Using User-Defined Scalar Functions
- Creating and Using Inline-Table Valued Function
- Creating and using Stored Procedures
- Creating and Using Multi-Statement Table-Valued Functions
Procedural Logic
- SQL Batch
- Niladic Functions
- Local Variables
- Conditional Processing
- Iterative Processing
- Branching
- Exception Handling
- Structured Exception Handling
- PRINT and RAISERROR Statement
$2795.00
|
5 Days Course |