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 Create A Web Hosting Business With Wordress - WHMCS Tutorial (Skillshare)

CS: Information & Technology

Welcome! In This Wordpress Tutorial, I Will Show you How to use the WHMCS App to create your own web hosting business from scratch! The WHMCS platform is an automated platform that basically allows your to create your own web hosting company. People can come to your wordpress website, purchase a domain and hosting and also install wordpress. Many companies use this same platform like namehero.com and a2hosting.

Self Paced

Self-Paced

Web Design Web Development Website

Skillshare

Functional Excel Skills (Skillshare)

CS: Programming

This class is for people who use Excel everyday. It is aimed towards users who want to learn a few more functional skills. We will cover: Keyboard shortcuts; Absolute and Relative referencing, including when using Tables; Some useful formulas including VLookup and the new XLookup; Delimiters; Data Validation; Conditional Formatting; Dealing with raw data; Inserting Tables; Inserting Slicers; Nested IF Statements; OR Statements; AND Statements

Self Paced

Self-Paced

Excel Productivity Data Analysis

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

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

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

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

Skillshare

Create a website with your own simple, custom CMS using HTML, CSS, JavaScript, Django, & Python! (Skillshare)

CS: Programming

In the next few videos, I'm going to teach you how to create a completely custom, CMS-driven website from scratch using a Job Listing website as an example. *This is a step by step tutorial with explanations along the way. This class is mainly going to be for designers who have some HTML, CSS, and JavaScript experience, who are maybe tired of manually entering data for portfolio pages and want to create a more efficient solution.

Self Paced

Self-Paced

Python HTML Javascript

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

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

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

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

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