
BASICS OF TRANSACT SQL WITH SQL SERVER 2008
Developed in-house by SolidQ, this T-SQL Fundamentals course is intended for T-SQL developers, DBAs, data scientists and SQL Server power users who work with SQL Server and need to write queries and develop code using Transact-SQL—SQL Server’s dialect of the standard ANSI-SQL language. The course covers querying, including retrieving and modifying data, and also provides an overview of programmable objects supported by SQL Server.
This course is intended both for people who just started working with SQL Server, as well as those with some experience. If you are self-taught, and gained your knowledge “by the seat of your pants,” this course can fill the gaps in your knowledge and teach you how to think correctly in SQL terms. This course doesn’t get into performance discussions and advanced problems* rather focuses on the logical aspects of T-SQL. Note though that it is not merely a step-by-step course. It doesn’t just focus on syntactical elements of T-SQL, rather explains the logic behind the language and its elements.
There are many aspects of SQL that are very different than other programming languages. This course will help students adopt the right state of mind and get a true understanding of the language elements. Students will learn how to think in terms of sets and follow good SQL programming practices.
To complement the learning experience, students will be provided with exercises that will enable them to practice what they’ve learned.
Duration
3 days
Program
Module 1: Background to T-SQL Querying and Programming
-
Theoretical Background
-
SQL Server’s Architecture
-
SQL Server Management Studio
-
Creating Tables
-
Defining Data Integrity
-
Sample Database
LAB 01
Module 2: Single-Table Queries
-
Elements of SELECT Statement
-
Predicates and Operators
-
CASE Expressions
-
NULLs
-
All-At-Once Operations
-
Working with Character Data
-
Working with Date and Time Data
-
Querying Metadata
LAB 02
Module 3: Joins
-
Joins
-
Cross Joins
-
Inner Joins
-
Further Join Examples
-
Outer Joins
LAB 03
Module 4: Subqueries
-
Self-Contained Subqueries
-
Correlated Subqueries
-
Scalar Subqueries
-
Multi-Valued Subqueries
-
EXISTS
-
Beyond the Fundamentals of Subqueries
LAB 04
Module 05: Table Expressions
-
Derived Tables
-
Common Table Expressions
-
Views
-
Inline Table-Valued Functions
-
APPLY
LAB 05
Module 6: Set Operators
-
Set Operators, Described
-
UNION
-
INTERSECT
-
EXCEPT
-
Precedence
-
Circumventing Unsupported Logical Phases
LAB 06
Module 7 - Beyond the Fundamentals of Querying
-
Window Functions
-
Pivoting Data
-
Unpivoting Data
-
Grouping Sets
LAB 07
Module 8: Data Modification
-
Inserting Data
-
Deleting Data
-
Updating Data
-
Merging Data
-
Modifying Data through Table Expressions
-
Modifications with TOP / OFFSET-FETCH
-
OUTPUT
LAB 08
Module 9: Temporal Tables
-
Temporal Tables, Described
-
Creating Tables
-
Modifying Tables
-
Querying Temporal Tables
LAB 09
Module 10: Transactions and Concurrency
-
Transactions
-
Locks and Blocking
-
Isolation Levels
-
Deadlocks
LAB 10
Module 11: Programmable Objects
-
Variables
-
Batches
-
Flow Elements
-
Cursors
-
Temporary Tables
-
Dynamic SQL
-
Routines
-
Error Handling
Objectives
-
Understand the logic behind T-SQL and thinking in terms of sets
-
Write T-SQL code to create tables and define data integrity
-
Write queries against single and multiple tables
-
Write T-SQL statements that modify data
-
Get familiar with T-SQL programmable objects
Certifications
At the end of this course every learner will receive a certificate of attendance.
TORNA ALLA LISTA DEI CORSI DI "INFORMATICA"
Vuoi maggiori informazioni? Contattaci!
Saremo lieti di assisterti.