Sql Server for Beginners - Part 2

Sql Server querying essentials and concepts
Rating: 4.2 out of 5 (23 ratings)
3,485 students
Sql Server for Beginners - Part 2
Rating: 4.2 out of 5 (23 ratings)
3,488 students
Basic of querying in T-SQL with SQL Server

Requirements

  • Basic knowledge on computing
Description

In this course we'll cover basics of SQL querying and concepts with SQL Server. We'll start with basics and essentials of SQL Server, followed by SQL syntax and lastly we'll delve into SQL joins and set operators.

Following is the manifest we'll be covering. Each course video is designed to be short and concept wise complete.

  1. Learning SQL

    • Overview

    • Logical Query Processing Order

    • Select statement fundamentals

    • Filtering data with where clause - overview

    • Filtering data with where clause - Part 1

    • Filtering data with where clause - Part 2

    • Filtering data with where clause - Part 3

    • Sorting data with order by clause

    • Grouping data with Group By clause - Part 1

    • Grouping data with Group By clause - Part 2

    • Grouping data with Group By clause - Part 3

    • Limit data with top clause

    • Summary and Quiz

Who this course is for:
  • Beginners in T-SQL
Course content
1 section • 13 lectures • 1h 23m total length
  • Overview
    02:33
  • Logical Query Processing Order
    05:10
  • Select statement fundamentals
    07:35
  • Filtering data with WHERE clause - Overview
    03:39
  • Filtering data with WHERE clause - Part 1
    09:22
  • Filtering data with WHERE clause - Part 2
    06:32
  • Filtering data using WHERE clause - Part 3
    03:24
  • Sorting data using ORDER BY clause
    09:37
  • Grouping data with GROUP BY clause Part-1
    08:46
  • Grouping data with GROUP BY clause Part-2
    06:50
  • Grouping data with GROUP BY clause Part-3
    04:39
  • Limiting data with TOP clause
    06:08
  • Summary and Quiz
    08:51

Instructor
Bytescout Learning Academy
Bytescout Academy
  • 4.1 Instructor Rating
  • 76 Reviews
  • 7,082 Students
  • 5 Courses

Founded in 2006, ByteScout, Inc. is the recognized vendor of solutions, tools and APIs for unstructured data extraction. Thousands of companies are using our technologies to replace manual data entry, decrease costs and risks in their business processes. Our products and solutions are recognized by respectful online and offline magazines such as Wall Street Journal, PC Advisor, CNET and many others. We also support academic and non-profit organizations involved into cancer research and cancer eliminating activities.