CONQUER SQL queries STEP BY STEP FROM SCRATCH in less time than watching NETFLIX

CONQUER SQL queries STEP BY STEP FROM SCRATCH in less time than watching NETFLIX | Skillshare
English | Size: 1.20 GB
Genre: eLearning

If you are looking to acquire new skills, start a career or make a change this is the course for you. Whether you are preparing to work with data or build software, this class provides a step-by-step introduction to SQL (also known as SEQUEL). This is part one of a 2 part course

In this course you will:

Learn how a database works
Create a world-class database like the pros
Write SQL queries
Store and retrieve information from the database
Test your knowledge with in-course quizzes
Have fun learning
Together we cover the following topics:

== Beginnings ==

Select, From and Where
Operators
And, Or
In, Not In, Between
Is Null, Is Not Null
Like and Wildcards
== Aggregate Functions==

Count and Distinct
Sum, Average, Min and Max
Working With Groups (Group By, Order By, Having)
Giving Nicknames (Aliases)
== CRUD ==

Create
Insert
Update
Delete, Drop
== More Than One Table ==

Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Aliases For Tables