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|
|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|
- Analytical skills, and nothing else. I’ll take you from zero to job-ready!
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 Glassdoor, PayScale, Indeed, 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
- 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.