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

Shopify Essentials for Web Developers: From Store Setup to Custom Themes (Skillshare)

CS: Design & Product

Join Shopify Expert and agency owner Kurt Elster to learn how to setup, design, build, and customise a Shopify ecommerce store. Intended for web designers and developers, this course is a primer on the complete Shopify ecosystem, with a focus on how to get started with theme modification, a stepping stone to complete custom development.

Self Paced

Self-Paced

Web Design Web Development Shopify

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

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

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

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

Register Your Domain Name - Class 1 of 6, Website Basics Course (Skillshare)

CS: Information & Technology

Register your own domain name using the service provider of your choice. You will have step-by-step instructions and a Case Study to guide you. The Case Study corresponds to the Project for each class and as you progress through all 6 classes in the Website Basics Course the Case Study will continue and tie everything together.

Self Paced

Self-Paced

Web Development Website Domain Name

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

Kotlin For Beginners: References, Immutability (Const and Val), Properties, Variables, Data Classes (Skillshare)

CS: Information & Technology

In this short class, you will learn the fundamentals of how to represent information virtually in a Kotlin program. About half of what we do as programmers is design data structures to represent real world information virtually, and it turns out that there are good and bad ways to do this! One of the most important takeaways of this class, is that it is critically important to separate things which change (mutable) from things which don't change (immutable).

Self Paced

Self-Paced

Android Mobile Development Web Development

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 Website - Elementor Tutorial (Skillshare)

CS: Design & Product

Come learn how to make a wordpress website in 1 hour! I will show you step by step to easily create your wordpress website in a few clicks! Lets Get Started! Its simple, gets your domain for your wordpress website. Install Wordpress. Install Your Wordpress Theme. Than simply install a plugin that will give you access to more than 1700+ elementor templates for free!

Self Paced

Self-Paced

Web Design Web Development WordPress

Skillshare

Web Design Essentials: Creating Marketing Homepages That Drive Results (Skillshare)

CS: Design & Product

Design websites that drive results! In this 60-minute class, join Dennis Field — a designer and product evangelist for web prototyping leader InVision — as he shares how to refine your creative process, capitalize on feedback, and use best practices to design a marketing site that leads to conversions for your company. This class is perfect for freelance website and product designers, small web design teams, and everyone who wants to increase the effectiveness of their web design.

Self Paced

Self-Paced

Marketing Web Design Web Development

Skillshare

Try Django : Learn and Master the Python Programming Web Framework (Skillshare)

CS: Information & Technology

Django is a web framework written in Python. In this class, you'll be building and learning about Django bit by bit. What is Django? The idea of Django is to build something powerful fast. We believe it's approachable enough for beginners with Python yet powerful enough for pros.

Self Paced

Self-Paced

Python Web Development Web Frameworks