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 2018 - Divi Theme Tutorial (Skillshare)

CS: Information & Technology

Why Take This AMAZING Course? I am a highly rated instructor on udemy. I have over 400,000 views a month on tutorials with positive reviews! Use The #1 Selling Theme for Wordpress On The PLANET. I Have Helped Teach And Create Over 500 Wordpress Websites! Get a Modern And Amazing Look For Your Website That Will Impress! Learn From A Professional Who Creates Websites For a Living with over 6,000 Visits! THE MOST UPDATE AND MODERN TUTORIAL. Dont Settle For Outdated Content!; Get A fully Responsive Website And Mobile Responsive; Over 15,000,000 Minutes Watched. Over 4 Million Views. In 180 Countries.

Self Paced

Self-Paced

Technology Web Design 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

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

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

HTML5 for Web Development (HTML5 for Beginners) (Skillshare)

CS: Information & Technology CS: Programming

HTML is a hypertext markup language. It is the most important building block of any website on the internet. HTML is used to describe the content of the website. In this class, I will teach you everything you need to know about HTML and HTML5 (the newest version). I try to go directly to the point and teach by example.

Self Paced

Self-Paced

HTML HTML5 Web Design

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

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

Javascript Fun: Build a Tip Calculator! (Skillshare)

CS: Programming Computer Science

Self Paced

Self-Paced

Programming HTML Javascript

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

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

Introduction To HTML5 For Absolute Beginners (Skillshare)

CS: Information & Technology CS: Programming

Hi, welcome to this crash course on HTML5 for complete beginners. In this class, you will learn everything you need to know about getting started with web development. The first step in becoming a web developer is learning HTML. The latest version of HTML is HTML5 and I will walk you through everything you need to know to get started with it. HTML is based on tags. You write HTML content inside tags. Tags tell the browser how to display the content on the screen.

Self Paced

Self-Paced

Programming HTML5 Web Design