Introduction to TSQL Course

Our Introduction to T-SQL course teaches you how to retrieve the information stored in a Microsoft SQL Server database using [...]

What you will learn

  • Installing & Using SQL Server and SQL Management Studio
  • Writing SELECT queries
  • Filtering and sorting retrieved data
  • Matching text with LIKE and wildcards
  • Grouping records
  • Retrieving data using subqueries
  • Retrieving records from multiple tables
  • Using functions in T-SQL
  • Writing SQL scripts
  • Creating and using variables in a query
  • Monitoring and management Security and improving performance

Requirements

  • Familiarity with Windows 10
  • Knowing how to install programs and navigate files
  • Videos are best viewed with 1920 x 1080 resolution
  • A stable internet connection (10 Mbps recommended)

Description

Our Introduction to T-SQL course teaches you how to retrieve the information stored in a Microsoft SQL Server database using the Transact-SQL language. Learn the fundamental structure of a query and skillfully handle data using the language’s built-in functions, operators, filters, and other features to return datasets that meet the needs of your customers.

Work your way up from simple tasks like data retrieval to more complex concepts like the use of joins, sub-queries, full text-based searches, stored procedures, cursors, triggers, and table constraints. After completing this course, you will be able to pursue a career in database administration.

   

Course Content
9 Lectures
28 Quizzes
20 Hands on Labs
  • Module1: Getting Started with TSQL
    In this module, you will learn the basics of databases and SQL to prepare you for T-SQL. We will also walk you through the installation of SQL Server 2019 and SQL Server Management Studio (SSMS).
    Lessons Duration
    Lesson 1: Introduction
    Lesson 2: Understanding SQL
    Lesson 3: Introducing SQL Server
    Module 1 Lesson 1 Quiz
    Module 1 Lesson 2 Quiz
    Labs Duration
    Lab 1: Enabling SQL Sever Authentication
  • Module 2: Write your first T-SQL Query
    This module details how to log into SQL Server, how to select databases using USE, and how to introspect SQL databases and tables. You will also learn how to use the SQL SELECT statement to retrieve single, multiple, and all table columns, as well as how to sort the retrieved data.
    Lessons Duration
    Lesson 1: Working with SQL
    Lesson 2: Retrieving Data
    Lesson 3: Sorting Retrieved Data
    Module 2 Lesson 1 Quiz
    Module 2 Lesson 2 Quiz
    Module 2 Lesson 3 Quiz
    Labs Duration
    Lab 1: Making connections with SQL Server and selecting databases
    Lab 2: Retrieving and sorting data using the SELECT statement
  • Module 3: Filtering Data Techniques
    Filter returned data using the SELECT the statement’s WHERE clause. Combine WHERE clauses with the AND and OR operators. Manage the order of evaluation explicitly use the IN and NOT operators. Use SQL wildcards within your WHERE clauses.
    Lessons Duration
    Lesson 1: Filtering Data Techniques
    Lesson 2: Advance Data Filtering
    Lesson 3: Using Wildcard Filtering
    Module 3 Lesson 1 Quiz
    Module 3 Lesson 2 Quiz
    Module 3 Lesson 3 Quiz
    Labs Duration
    Lab1: Using WHERE to filter data
    Lab 2: Using IN and NOT IN
    Lab3: Usage of Wildcards to filter data
  • Module 4: Caculated Fields and Data Manipulation
    Overview of what calculated fields are and how to create them. We used examples to demonstrate the uses of calculated fields for both string concatenation and mathematical operations. We will also dive into T-SQL’s data manipulation functions.
    Lessons Duration
    Lesson1: Creating Calculated Fields
    Lesson 2: Using Data Manipulation Functions
    Module 4 Lesson 1 Quiz
    Module 4 Lesson 2 Quiz
    Labs Duration
    Lab1: Apply Arithmetic on Calculated Fields
    Lab2: Data manipulation T-SQL functions in action
  • Module 5: Summarizing and Grouping Data
    SQL aggregate functions and how you can use them to summarize the data in tables. GROUP BY clause to perform calculations on groups of data, returning results for each group. Using HAVING clause to filter specific groups.
    Lessons Duration
    Lesson 1: Summarizing Data
    Lesson 2: Grouping Data
    Module 5 Lesson 1 Quiz
    Module 5 Lesson 2 Quiz
    Labs Duration
    Lab1: Using Aggregate function
    Lab2: Grouping Data
  • Module 6: Subqueries and Joining multiple tables
    Learn the basics of relational database design as an introduction to learning about joins. Create an equijoin (also known as an inner join), which is the most commonly used form of join.
    Lessons Duration
    Lesson 1: Working with Subqueries
    Lesson 2: Joining Tables
    Module 6 Lesson 1 Quiz
    Module 6 Lesson 2 Quiz
    Labs Duration
    Lab1: Using Subquery
    Lab1: Joining Multiple Tables
  • Module 7: Combining Queries and Full-text search
    Combine SELECT statements with the UNION operator. The use of UNION to simplify complex WHERE clauses and retrieving data from multiple tables. Full-text searching capabilities to perform sophisticated data querying and selection.
    Lessons Duration
    Lesson 1: Combining Queries
    Lesson 2: Full Text Searching
    Module 7 Lesson 1 Quiz
    Module 7 Lesson 2 Quiz
    Labs Duration
    Lab1: Combining Queries using UNION operation
    Lab 2: Full Text Searching
  • Module 8: Adding and Modifying Data in tables
    In this module, you will learn how to insert data into tables using the SQL INSERT statement and how to modify the data found in each table. You will also learn how to use the UPDATE and DELETE statements to manipulate your table data.
    Lessons Duration
    Lesson 1: Inserting Data
    Lesson 2: Updating and Deleting Data
    Module 8 Lesson 1 Quiz
    Module 8 Lesson 2 Quiz
    Labs Duration
    Lab 1: Inserting data in SQL tables
    Lab 2: Updating and Deleting data in action
  • Module 9: Creating Tables and Views
    Learn the basics of table creation, alteration, and deletion. Identity fields, defining primary and foreign keys, and other important tables and column options. What views are, how they work, and when they should be used. How views can be used to simplify some of the SQL operations.
    Lessons Duration
    Lesson 1: Creating and Manipulating Tables
    Lesson 2: Creating Views
    Module 9 Lesson 1 Quiz
    Module 9 Lesson 2 Quiz
    Labs Duration
    Lab 1: Using CREATE clause to create new tables
    Lab 2: Creating Views

About the Instructor


Imran Khalil ( IT Instructor )

Imran Khalil is a tech course author with a Master's in Computer Science. His teaching journey began when he first became interested in computers at the age of seven. Every time he learned something new, he would teach it to his friends and family.

Over time, his geeky hobby turned into a full-time IT job position he fulfilled while attending Sargodha University, where he completed his Master's Degree in Computer Science. His understanding of the ins and outs of development allowed him to help shape a wide array of Developer lectures for the University of Lahore.

He also enjoys building web apps and exploring innovative tech trends, which he always keeps in mind when he writes and records video courses on MYSQL, Open Source, C++, Java, Php, SQL, and other IT-related topics.

As a seasoned developer... Read More

Introduction to TSQL Course

$99.00

    Prominent Features
  • 60 hours of course content
  • Custom enhanced HTML5 RDP labs
  • Interactive video lessons & quizzes
  • Mobile app
  • Dedicated support (16 hours a day)
  • Certification after completion
  • Licenses for hands on training