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

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

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

Power Pivot Introduction - A Beginners Guide to Power Pivot (Skillshare)

CS: Programming

This class is a beginners guide to Power Pivot. If you are new to Power Pivot, maybe you've never heard of it, well this class was made for you. The class starts with learning what Power Pivot is and what its advantages are. Then we take you through the whole lifecycle from importing data into the model, preparing it, writing powerful DAX calculations and finally creating PivotTables and Slicers to analyse the data.

Self Paced

Self-Paced

Excel Data Analysis Microsoft Excel

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

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

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

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

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

Build Your Online Portfolio Without Writing Code (Skillshare)

CS: Information & Technology

With the web becoming more and more involved in our daily lives, being able to create your own little corner of the web has never been more important (or exciting). In under one hour with Webflow's Mat Vogels, you'll cover a variety of different topics, including: Why you should be online in the first place; Basic web concepts, like the box model and responsive design; Building a website from scratch; Publishing a website.

Self Paced

Self-Paced

Portfolio 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