Querying Data with Microsoft Transact-SQL

Course Description


Curriculum for this course

29 Lessons
Module 1: Introduction to Transact-SQL
6 Lessons
  • Understand what SQL is for
    .
  • Identify database objects in schemas
    .
  • Identify SQL statement types
    .
  • Use the SELECT statement
    .
  • Work with data types
    .
  • Handle NULLs
    .
Module 2: Sort and filter results in T-SQL
5 Lessons
  • Sort Results
    .
  • Limit the sorted results
    .
  • Return paged results
    .
  • Remove duplicates
    .
  • Filter data with predicates
    .
Module 3: Combine multiple tables with JOINs in T-SQL
4 Lessons
  • Describe join concepts and syntax
    .
  • Write queries that use inner and outer joins
    .
  • Write queries that use cross joins
    .
  • Write queries that use self joins
    .
Module 4: Write Subqueries in T-SQL
3 Lessons
  • Understand what subqueries are
    .
  • Use scalar or multi-valued subqueries
    .
  • Use self-contained or correlated subqueries
    .
Module 5: Use built-in functions and GROUP BY in Transact-SQL
6 Lessons
  • Categorize built-in functions
    .
  • Use scalar functions
    .
  • Use ranking and rowset functions
    .
  • Use aggregate functions
    .
  • Summarize data with GROUP BY
    .
  • Filter groups with HAVING
    .
Module 6: Modify data with T-SQL
5 Lessons
  • Insert data into a table
    .
  • Generate automatic values
    .
  • Update data in a table
    .
  • Delete data from a table
    .
  • Merge data based on multiple tables
    .

Drop us a message for any query

For more information about our courses, get in touch
with Alchemy contacts

Course rating

Star

90%

Star

80%

Star

65%

Star

60%

Reviews

  • Ruma Sriwastav

    Cover all my needs

    The course identify things we want to change and then figure out the things that need to be done to create the desired outcome. The course helped me in clearly define problems and generate a wider variety of quality solutions. Support more structures analysis of options.

All Courses

Skills Offered

Emerging Skills Offered by Alchemy for 2024-2025

Image
Image

Data Science & Analytics
  • Advanced Data Engineering (e.g., Snowflake, Databricks)
  • Real-Time Data Streaming (e.g., Kafka, Flink)
  • Predictive Analytics with AI/ML Models
  • Advanced Business Intelligence Tools (e.g., Power BI, Tableau)
Image

Emerging Programming Frameworks
  • Quantum Computing Basics (IBM Qiskit, Google Cirq)
  • Web3 Development: Solidity, Smart Contracts
  • Low-code/No-code Platforms (OutSystems, Mendix)
Image

Infrastructure Modernization
  • Software-Defined Networking (SDN) and NFV
  • Advanced Virtualization (Citrix, VMware updates)
  • Hybrid and Edge Computing
Image

Soft Skills and Leadership in Tech
  • Agile Transformation and Leadership
  • Design Thinking for Problem Solving
  • Leading AI-Driven Innovation
Image

AI & Machine Learning
  • Generative AI (e.g., ChatGPT, Bard, MidJourney integrations)
  • Machine Learning Operations (MLOps)
  • Advanced NLP and Speech Recognition
  • AI for Edge Computing
Image

Cloud Technologies
  • Multi-Cloud Management: Azure, AWS, GCP integrations
  • Cloud-Native Development: Kubernetes, Docker, Serverless Architectures
  • AI and ML integration in Cloud Platforms
  • FinOps: Cloud Cost Management
Image

Cybersecurity
  • Zero Trust Architecture (e.g., Illumio)
  • Incident Response and Threat Intelligence
  • Cloud Security (AWS, Azure, and GCP-focused)
  • Advanced Penetration Testing and Ethical Hacking
Image

DevOps and DevSecOps
  • Infrastructure as Code (IaC) with Terraform and Ansible
  • GitOps and Continuous Integration/Continuous Delivery (CI/CD)
  • Security in DevOps Pipelines
Image

Data Science & Analytics
  • Advanced Data Engineering (e.g., Snowflake, Databricks)
  • Real-Time Data Streaming (e.g., Kafka, Flink)
  • Predictive Analytics with AI/ML Models
  • Advanced Business Intelligence Tools (e.g., Power BI, Tableau)
Image

Emerging Programming Frameworks
  • Quantum Computing Basics (IBM Qiskit, Google Cirq)
  • Web3 Development: Solidity, Smart Contracts
  • Low-code/No-code Platforms (OutSystems, Mendix)
Image

Infrastructure Modernization
  • Software-Defined Networking (SDN) and NFV
  • Advanced Virtualization (Citrix, VMware updates)
  • Hybrid and Edge Computing
Image

Soft Skills and Leadership in Tech
  • Agile Transformation and Leadership
  • Design Thinking for Problem Solving
  • Leading AI-Driven Innovation
Image

AI & Machine Learning
  • Generative AI (e.g., ChatGPT, Bard, MidJourney integrations)
  • Machine Learning Operations (MLOps)
  • Advanced NLP and Speech Recognition
  • AI for Edge Computing
Image

Cloud Technologies
  • Multi-Cloud Management: Azure, AWS, GCP integrations
  • Cloud-Native Development: Kubernetes, Docker, Serverless Architectures
  • AI and ML integration in Cloud Platforms
  • FinOps: Cloud Cost Management
Image

Cybersecurity
  • Zero Trust Architecture (e.g., Illumio)
  • Incident Response and Threat Intelligence
  • Cloud Security (AWS, Azure, and GCP-focused)
  • Advanced Penetration Testing and Ethical Hacking
Image

DevOps and DevSecOps
  • Infrastructure as Code (IaC) with Terraform and Ansible
  • GitOps and Continuous Integration/Continuous Delivery (CI/CD)
  • Security in DevOps Pipelines