SQL Server Programming

Rated 4.67 out of 5 based on 3 customer ratings
(3 customer reviews)

$5.00

Job-Ready Microsoft SQL – Online Course

Category: Tag:

Curriculum For This Course

Module 1 Course Introduction (Video: 17m8s, Words: 2,327)
Unit 1 Introduction (2m13s)
Unit 2 Course Curriculum Overview
Unit 3 Database and SQL (5m26s)
Unit 4 SSMS Setup and Installation
Unit 5 Your First Query (9m29s)
Module 2 Advanced Filtering & Sorting (Video: 48m33s, Words: 2,547)
Unit 1 Different Types of Values (7m16s)
Unit 2 Sorting Data (10m44s)
Unit 3 Filtering Operators and Order of Evaluation (17m43s)
Unit 4 Wildcard Filtering (12m50s)
Module 3 Project #1: Uncovering Trends
There are no units in this module.
Module 4 Calculated Fields & Functions (Video: , Words: 1,482)
Unit 1 Calculated Fields (10m48s)
Unit 2 Text Manipulation Functions (11m0s)
Unit 3 Date & Time Manipulation Functions
Module 5 Summarizing Data
Unit 1 Aggregate Functions
Unit 2 Grouping Data
Unit 3 Filtering Groups
Module 6 Subqueries
Unit 1 Why use subqueries and an example
Unit 2 Filtering with subqueries
Unit 3 Subqueries as calculated fields
Module 7 Joining Tables and Combining Queries
Unit 1 The Different Join Types
Unit 2 Joins and Aggregate Functions
Unit 3 Combining Queries

Requirements

  • Analytical skills, and nothing else. I’ll take you from zero to job-ready!

Full Description

Hello and welcome to the “Job-Ready SQL Server” Course.

My name is Alex Mancini, and I’ll be your instructor for this course. I’ve thaught hundreds of people about Math/Stats & Programming over the last 10 years. I’m really excited to teach you about SQL Server in this course. Wondering why?

If you type “SQL” in GlassdoorPayScaleIndeed, and other platforms, you’ll notice how great salaries are for people with this skill. This is a real opportunity to grow your career! This course will be covering what you need to know about SQL Server to be job-ready, including:

  • Basic SQL Queries
  • Aggregate functions
  • Conditionals
  • Analytic functions
  • Joins and Unions
  • Tricks & Tips for big queries
  • and much more!

By the end of this course you’ll be very comfortable adding all of these to your resume.

Also, you need to know that you will be able to run real queries in this course using SSMS. You will also work on projects that I will review myself. You will be learning by doing.

This course contains hours of HD videos, explanation documents, and query templates. You can learn in whatever way works best for you. I will offer you support when you need it. You can ask me your questions directly by email.

After completing this course, you’ll also receive a certificate of completion that you can post in your Linked In profile.

Thank you for enrolling! I’ll see you inside the course.

3 reviews for SQL Server Programming

  1. Rated 5 out of 5

    Vincent Lambert (verified owner)

    Excellent, well explained course! I highly recommend!

    0 out of 2 people found this helpful. Was this review helpful to you?
  2. Rated 4 out of 5

    Mathieu Morin (verified owner)

    I learned a lot of tricks for my new job even if I am not a data analyst. Everyone should know basics on data as it’s the future!

    Was this review helpful to you?
  3. Rated 5 out of 5

    Gabriel St-Jean (verified owner)

    Really nice courses! Very easy (step-by-step) and helpful for beginner with SQL like me! Tough to find something like that on YouTube…

    Was this review helpful to you?

Only logged in customers who have purchased this product may leave a review.