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

Understanding Domains (Skillshare)

CS: Information & Technology

Understanding Domains is an introduction into the world of domains. At some point many of us will have a website, but we don't really know anything about our domains or how they work. This course will take you through everything you need to know as a beginner with domains. This is not an advanced course and will not go in depth on any topic. You will learn enough to be able to confidently maintain and understand your domain records.

Self Paced

Self-Paced

Technology Small Business Web Design

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

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

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

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

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

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

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

Know Your Audience - Bring Your Personas to Life! (Skillshare)

CS: Design & Product

User Personas - high-level descriptions of your target audience's needs and challenges - are becoming mainstays for software product teams. But like many other requirements documentation, they can often feel flat, overly generic, and nearly useless once development has actually begun. In becoming “just another form to fill out,” your User Personas have lost connection with their original purpose: to help product teams build connection and empathy with your primary customer base, and in doing so provide the grounding basis for fast and deliberate decision making.

Self Paced

Self-Paced

User Experience Web Development Audiences

Skillshare

Typescript Design Patterns (Object-oriented programming) (Skillshare)

CS: Information & Technology

Object oriented design patterns help you create more robust and flexible software. In this course I will show you how to use these patterns in TypeScript. Design patterns are best practices that will help you solve common problems in programming. There is no need to solve a generic problem that has been solved many times before. Simple example: how do you write a system that allows user to order a product and customize some of its features?

Self Paced

Self-Paced

Javascript Technology Object-Oriented Programming

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

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