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

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

Skillshare

How To Make A Wordpress Website - Simple For Beginners (Skillshare)

CS: Information & Technology

Why Take This AMAZING Course? Learn how to use the #1 Best selling Wordpress Theme In The World. Master WORDPRESS and the Brizy Page Builder. Complete Beginners Guide I Am A TOP 10% RATED INSTRUCTOR on Udemy and Youtube. Find out Why!! Get a Modern And Amazing Look For Your Website That Will Impress! Learn From A Professional Who Creates Websites For a Living with over 500,000 Monthly Visits! THE MOST UPDATE AND MODERN TUTORIAL. Dont Settle For Outdated Content! Get A fully Responsive Website And Mobile Responsive

Self Paced

Self-Paced

Web Design Web Development Website

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

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 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

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

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

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

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

Javascript Fun: Build a Tip Calculator! (Skillshare)

CS: Programming Computer Science

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

Programming HTML Javascript

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