Skillshare

Beginner friendly SQL course using MySQL for 2020 (Skillshare)

Offered by Skillshare,

A beginner friendly SQL class. This course has a database for you to set up so you can follow along and get the best experience! Do not worry I will go over how to set this up as well! This course will be broken down into two halves.

NO PRIOR EXPERIENCE REQUIRED!
The first half will focus on simple queries that have basic single table queries

SELECT
DISTINCT
WHERE/LIKE/WILDCARD OPERATOR(%)
AND/OR/IN
ORDER BY/LIMIT
NOT/IS/NULL

The second half of the course will contain multi table queries, group by states, date manipulation and subqueries, these topics will be for more advance querying

GROUP BY/HAVING
JOINS
SUBQUERY
DATE MANIPULATION

Please let me know if there is anything I can do better to help you learn for this course. I strive for a teacher student connection and am always willing to help with any problems you come across in this course. I would also love suggestions on how to make this course better or if you want me to make an additional video to a topic that I may have missed that you would like!

Go to Class

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Skillshare

How To Make A Wordpress Website -- Complete Beginners Guide (Skillshare)

Architecture & Design

Want To Learn How To Make A Website With Wordpress? In this tutorial, I go step by step to show you how to build a wordpress website step by step! After you watch this video, you will be able to create a website from scratch with no experience. I use elementor and the oceanwp wordpress theme in this tutorial!

Self Paced

Self-Paced

Web Graphics Web Development Responsive Design

Skillshare

Power Pivot Introduction - A Beginners Guide to Power Pivot (Skillshare)

CS: Programming

This class is a beginners guide to Power Pivot. If you are new to Power Pivot, maybe you've never heard of it, well this class was made for you. The class starts with learning what Power Pivot is and what its advantages are. Then we take you through the whole lifecycle from importing data into the model, preparing it, writing powerful DAX calculations and finally creating PivotTables and Slicers to analyse the data.

Self Paced

Self-Paced

Excel Data Analysis Microsoft Excel

Skillshare

Javascript Fun: Build a Photo Effects App! (Skillshare)

CS: Design & Product

Welcome to the Javascript fun series! For web design or development, there are 3 must-know technologies, HTML, CSS, and Javascript. The main aim of the Javascript fun series is to take your knowledge of these 3 (only a little is required!), and put them into practice by building a series of educational, yet fun projects that show you exactly how they work perfectly together. Working on projects and solving problems is a great way to learn.

Self Paced

Self-Paced

HTML Javascript CSS

Skillshare

How To Make A WordPress Blog For Beginners Step By Step (Skillshare)

Marketing & Communication

Hi, in this class I’m going to show you how to start blogging and create a beautiful blog which is perfect for 2018 and beyond! I’ve been making websites and blogs and also teaching how to properly set them up for years now and I get bombarded with questions on a daily basis like…How do I start a blog? What’s the easiest way to get started without overwhelm? Which platform should I use?

Self Paced

Self-Paced

Marketing Entrepreneurship Web Development

Skillshare

Tableau 10: Practical and Concise Part 1 (Skillshare)

Statistics & Data Analysis

So, you've heard a lot about Tableau 10, but you don't know how to get started? This Udemy course is exactly what you need! This course will teach you all the fundamentals you need. Trust me, you won't need any other course to reach the intermediate/advanced level after this course.

Self Paced

Self-Paced

Data Analysis Data Visualization Business Analytics

Skillshare

Unleash The Raspberry Pi Through Physical Computing (Skillshare)

CS: Information & Technology CS: Programming

This class is for beginners interested in unlocking the hardware potential of their Raspberry Pi so that it can interact with the physical world. This is the first class on Skillshare to cover the Raspberry Pi and contains just over 3 hours of video instruction.

Self Paced

Self-Paced

Web Development Computing Technology Raspberry Pi

Skillshare

Javascript Fun: Build a Number Match Game! (Skillshare)

CS: Information & Technology

Self Paced

Self-Paced

HTML Javascript CSS

Skillshare

Data Structures and Algorithms in Python (Skillshare)

CS: Programming

This course will help you in better understanding of the basics of Data Structures and how algorithms are implemented in the high level programming language. This course consists of lectures on data structures and algorithms which covers the computer science theory + implementation of data structures in python language. This course will also help students to face interviews at the top technology companies. This course is like having personal tutors to teach you about data structures and algorithms.

Self Paced

Self-Paced

Programming Algorithms Data Structures

Skillshare

Mobile App Prototyping: Designing Custom Interactions (Skillshare)

CS: Design & Product

Have a great idea for an app and unsure where to start? Join Product Designer Noah Levin for an informative 50-minute class on how to use mobile app prototyping to communicate your ideas and execute your vision. In this class you'll learn the basics of using mobile app prototyping to pioneer new patterns, make unique designs, and find unexpected solutions.

Self Paced

Self-Paced

Prototyping Web Development Mobile Applications

Skillshare

WordPress for Beginners - Understand WordPress Quickly (Skillshare)

CS: Information & Technology

Learn how to work with WordPress and develop a website using AIT WordPress Themes. No coding or experience required. This class presents the basics of working with WordPress and offers practical screencast tutorials to teach you how to use our themes when building a new website. In short videos, you can find answers to FAQs that beginners most often encounter when getting familiar with WordPress. The course contains more than one hour of video tutorials.

Self Paced

Self-Paced

Web Design Web Development Responsive Design

Skillshare

Writing Code Faster with Emmet (Skillshare)

CS: Information & Technology CS: Programming

I LOVE finding ways to speed up or automate my work. So I'm very excited to introduce you to Emmet, a plugin that enables you to write code FASTER. What you will need: Emmet is available in most web editors. Adobe Dreamweaver, Brackets, Sublime Text etc. For this class, I'll be demonstrating Emmet using an online web editor I use on a daily basis - Codepen.

Self Paced

Self-Paced

HTML Technology Coding

Skillshare

How to Create a Personal/Portfolio Website (Skillshare)

Architecture & Design

This class will teach you how to professionally create an awesome personal/portfolio website! By the end of the class,you'll have a beautiful and fully functioning website that can help you land jobs, clients, and mega style points with employers. This class is taught step-by-step so it's very easy to follow along with your own website. I also include a free template of the website we will we making (in the Projects Tab > Resources), as well as follow along images for you.

Self Paced

Self-Paced

Web Design Web Development Website