40 Hours 
TDXBI-109 Course outline
This course is designed to introduce students to Transact SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server c urriculum. Days 4 & 5 teach the remaining skills required and expose the participants to the new revolutions in the field, the course will include a module on 'generic artificial intelligence in database management'. This module will demonstrate how AI is changing SQL databases, from creating synthetic datasets to optimizing queries
On completing this course, delegates will be able to: 1. Understanding the SQL fundamentals 2. Understanding of queries and store procedures 3. Better understanding SQL as a language
Upcoming meetings
There are no upcoming meetings for this course. Contact us to schedule this course, which will be customized specifically for your organization.
info@hackerupro.comModules
- The Basic Architecture of SQL Server
- SQL Server Editions and Versions
- Getting Started with SQL Server Management Studio
- Introducing T-SQL
- Understanding Sets
- Understanding Predicate Logic
- Understanding the Logical Order of Operations in SELECT statements
- Writing Simple SELECT Statements
- Eliminating Duplicates with DISTINCT
- Using Column and Table Aliases
- Writing Simple CASE Expressions
- Understanding Joins
- Querying with Inner Joins
- Querying with Outer Joins
- Querying with Cross Joins and Self Joins
- Sorting Data
- Filtering Data with Predicates
- Filtering Data with TOP and OFFSET-FETCH
- Working with Unknown Values
- Introducing SQL Server Data Types
- Working with Character Data
- Working with Date and Time Data
- Inserting Data
- Modifying and Deleting Data
- Writing Queries with Built-In Functions
- Using Conversion Functions
- Using Logical Functions
- Using Functions to Work with NULL
- Using Aggregate Functions
- Using the GROUP BY Clause
- Filtering Groups with HAVING
- Writing Self-Contained Subqueries
- Writing Correlated Subqueries
- Using the EXISTS Predicate with Subqueries
- Using Views
- Using Inline Table-Valued Functions
- Using Derived Tables
- Using Common Table Expressions
- Writing Queries with the UNION operator
- Using EXCEPT and INTERSECT
- Using APPLY
- Creating Windows with OVER
- Exploring Window Functions
- Writing Queries with PIVOT and UNPIVOT
- Working with Grouping Sets
- Transactions and the database engines
- Controlling transactions
- Introduction to Generative AI
- Importance of AI in the SQL Domain
- Enhance and simplify SQL query
- Integrating Generative AI with MS SQL for Data Analytics
Prerequisites
- 01 Basic knowledge of the Microsoft Windows operating system and its core functionality.
- 02 Working knowledge of relational databases
