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

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

Power BI Desktop Introduction - A Complete Beginners Guide (Skillshare)

Business

This class is an introduction to Power BI Desktop. This class is a complete beginners guide to the software. It starts by explaining what Power BI Desktop is and why you would use it. We then show how to install the software and the different options available. We then create a Power BI report following the entire process. We get the data from different external sources, clean and shape the data, model it and then create DAX formulas and visualizations.

Self Paced

Self-Paced

Business Data Analysis Analytics

Skillshare

Core Java Interview Bootcamp: Part 1 (Skillshare)

CS: Programming

Hi everyone :) Having you stop here simply means you are either preparing for a core java interview or want to know the most widely asked questions in the room. This course is intended for you folks, perfectly. The course basically aims at providing an in-depth explanation to most continuously asked questions through very engaging animated PPTs. Whether it's string, or exceptions, or multi-threading, I have got your back on most asked questions from these topics. The much important thing is the clear and concise clarity in explanations that you will get from this course.

Self Paced

Self-Paced

Programming Java Technology

Skillshare

Master Data Analysis with Python - Intro to Pandas (Skillshare)

CS: Programming

Master Data Analysis with Python - Intro to Pandas targets those who want to completely master doing data analysis with pandas. This course provides an introduction to the components of the two primary pandas objects, the DataFrame and Series, and how to select subsets of data from them. This course is taught by expert instructor Ted Petrou, author of the highly-rated book Pandas Cookbook.

Self Paced

Self-Paced

Technology Data Analysis Data Science

Skillshare

Introduction to Java Programming (Skillshare)

CS: Programming

High paying Java programming jobs are going unfilled because companies cannot find Java programmers. Do you want to start a career as a Java Programmer? Start Here! The Java Programming is the number one programming language in the world. Companies big and small rely upon Java for their software needs.

Self Paced

Self-Paced

Programming Java Technology

Skillshare

Twitter API JavaScript Node Exercise (Skillshare)

CS: Information & Technology

Twitter API JavaScript Node Exercise. Explore the Twitter Developer API connect from your local machine. Use AJAX JavaScript and Node to setup twitter search. Perfect course for beginners to explore the MASSIVE twitter API. This course will teach you how to setup a local server, connect the Twitter API and return data to output into your web page. Its amazing how much information is available on Twitter, connecting the API is easy and can provide real world working experience with JSON AJAX and APIs.

Self Paced

Self-Paced

Javascript AJAX Node.js

Skillshare

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

CS: Information & Technology

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

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

ES6 JavaScript Classes the Easy Way (Skillshare)

CS: Programming

In 2015, the JavaScript programming language got a major facelift with many improvements to the syntax and tons of new features. This new version is known as ES6, or ES2015, and each year since an updated version has been released. ES6 Classes, as well as instance and static methods, are vitally important to know and understand because so many projects and companies are migrating to the newest version of JavaScript. Many Front End libraries, such as React, rely heavily on the new Class syntax.

Self Paced

Self-Paced

Programming Javascript Web Development

Skillshare

Introduction to PHP (Skillshare)

CS: Programming

In this course, You will learn about What is PHP and How it Works? Right after this course, you will be able to explain concepts like Client Server Model, Request Response Pattern and Describe about PHP Language in your own words. This is the second course topic that you should take which helps you to understand the basic concepts Why PHP was developed and What problem PHP language solves. This course is a Introduction to PHP and will introduce you to Core Web Concepts and PHP.

Self Paced

Self-Paced

Technology PHP Web Development

Skillshare

How To Start A Profitable Wordpress Blog Step By Step 2016 (Skillshare)

Business

Blogging is huge right now! Do you dream of running a successful online business which allows you to enjoy more autonomy? If so, you should know that learning how to create a blog will be the key to setting up an online business which attracts the interest – and sales – of customers all over the world! While the idea of starting a blog yourself, without outsourcing the task to a web design firm, may seem a little daunting, you should know that the process really isn’t that difficult or complicated.

Self Paced

Self-Paced

Entrepreneurship Web Development Blogs

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