SQL Starter Pack: A Beginner's #1 Resource for Learning SQL
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Starter Pack: A Beginner's #1 Resource for Learning SQL to your Wishlist.

Add to Wishlist

SQL Starter Pack: A Beginner's #1 Resource for Learning SQL

Learn the essential skills for how to use SQL to query and manipulate databases. Jumpstart your career today!
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Created by Hoddy Mahon
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 2 Articles
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Write SQL Queries to Read and Manipulate Data
  • Understand Best Practices from Someone in the Industry
  • Create and Delete Tables and Data
  • Download and Install SQL Server Database and Sample Dataset
View Curriculum
Requirements
  • No prior knowledge required! Just a willingness to learn and better yourself
Description

How can I learn the fundamental data skill that is being used across all industries? How can I get started in an industry with a surplus amount of jobs? How can I enhance my skillset beyond using just Excel? 

If you've asked any of those questions, you've come to the right course. 

Because in this course, you will learn the essentials to the fundamental SQL language. 

You see, SQL is needed for anyone who's in the data and analytics industry. It's a great place to begin one's journey. 

In this course, I will show you all of the SQL essentials to get you started in this rapidly growing field! 

It's the introductory course I wish I had years ago...

Who is the target audience?
  • Beginners who want to get started in the data and analytics field. SQL is a fundamental skill you must possess
  • Excel business users who want to enhance their data analysis skills
  • People looking to change jobs, who want to add an in-demand easy to learn skill
Students Who Viewed This Course Also Viewed
Curriculum For This Course
36 Lectures
01:41:45
+
Course Introduction
2 Lectures 04:54
+
Installation of SQL Server
1 Lecture 00:15
SQL Server Install
00:15
+
Data Definition Language
5 Lectures 12:21



how well can you complete the assignment mentioned?

Pop Quiz: Insert Values
2 questions

Delete & Truncate
04:19

Drop Table
01:34
+
Let's Get Some Data!
1 Lecture 00:19
AdventureWorks Install
00:19
+
Data Manipulation Language
10 Lectures 38:45
Select
03:53

Select Distinct
02:31

Select Top
03:19

Where
03:14

Count
03:58

Order By
01:44

Select the code that answers the problem seen on the lecture 

Pop Quiz: Order By
1 question

Like
04:15

Group By Pt. 1
04:45

What what wrong with this Group By query??

Pop Quiz: Group By
1 question

Group By Pt. 2
03:34

Having
07:32
+
Joins - The Power of SQL
7 Lectures 25:39
Joins Overview
02:04

Left Outer Join Pt. 1
06:37

Why did the query in 'Left Outer Join Pt. 1' fail?

Pop Quiz: Left Outer Join
1 question

Left Outer Join Pt. 2
04:45

Inner Join Pt. 1
06:27

Answer the question asked in 'Inner Join Pt. 1'. 

Pop Quiz: Inner Join
1 question

Inner Join Pt. 2
01:17

Right Outer Join
02:06

Full Outer Join
02:23
+
Unions
5 Lectures 04:51
Union Overview
00:59

Union Pt. 1
01:31

What do you think will happen?

Pop Quiz: Unions
1 question

Union Pt. 2
00:45

Union All Pt. 1
00:49

What do you think will happen to this hypothetical query? 

Pop Quiz: Union All
1 question

Union All Pt. 2
00:47
+
Final Tips, Comments, and Wrap-up
5 Lectures 14:42
Query Formatting
03:39

Aliases
03:04

Subqueries
03:06

Comments
03:53

Conclusion and Thank You!
01:00
About the Instructor
Hoddy Mahon
5.0 Average rating
1 Review
6 Students
1 Course
Data Analyst

Hoddy Mahon is an Associate Consultant at Clarity Insights. Clarity Insights is the largest consulting company in the US that focuses exclusively on data strategy, engineering, science and visualization.

Hoddy holds a BS from Villanova University for Finance and worked at a large, global bank for the first three years of his career. Sensing that his career wasn't progressing as he'd like, Hoddy made the switch into the data and analytics industry by taking online classes on Udemy and various other online platforms -  which eventually led to his current job. 

Over the course of his career, he has developed a skill set in analyzing data and he hopes to help other people learn the power of data and analytics much the same way he did. Hoddy takes pride in giving very clear instruction in order to help the user better grasp the material. He is also a big sports fan and will try and make his courses as lively as possible through the use of various sports references.