torrents rarbg
Catalog Top 10

RARBG
Home
Movies
XXX
TV Shows
Games
Music
Anime
Apps
Doc
Other
Non XXX

SkillShare | Conquer SQL Queries Step By Step From Scratch In Less Time Than Watching Netflix [FCO]

Torrent: SkillShare | Conquer SQL Queries Step By Step From Scratch In Less Time Than Watching Netflix [FCO]
Description:





Created by : Farouk Aregbe
Language : English
Released : 2021
Duration : 2h 23m
Course Source : https://www.skillshare.com/classes/CONQUER-SQL-queries-STEP-BY-STEP-FROM-SCRATCH-in-less-time-than-watching-NETFLIX/895880108

Description

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

Projects & Resources

The project for this class consists of two part which you will complete throughout the course.

PART 1: For part 1, you will create a world class oracle database and load data into it. Share a picture of your database once created.

PART 2: For part 2, as you go over the class please answer the following questions and post your answers

1) Write a query that will return the name, degree, city and totaldonated for alums with a BIOLOGY or STATISTICS degree

2) Find all alums that have a last name starting with an M.

3) How many alums have in each city have donated at least $1?

Remember to have some fun and make the learning process your own.

HAPPY LEARNING

Covered Topics

• Technology
• SQL
• Data Science

Downloads: 199
Category: Other/Tutorials
Size: 1.2 GB
Show Files »
files
Added: 2021-02-05 11:03:22
Language: English
Peers: Seeders : 29 , Leechers : 4
Tags: FCO SkillShare Conquer SQL Queries Watching Netflix  
Release name: SkillShare | Conquer SQL Queries Step By Step From Scratch In Less Time Than Watching Netflix [FCO]
Trackers:

udp://opentor.org:2710/announce

udp://p4p.arenabg.com:1337/announce

udp://tracker.torrent.eu.org:451/announce

udp://tracker.cyberia.is:6969/announce

udp://9.rarbg.to:2710/announce

udp://exodus.desync.com:6969/announce

udp://explodie.org:6969/announce

udp://tracker.moeking.me:6969/announce

udp://tracker.opentrackr.org:1337/announce

udp://tracker.tiny-vps.com:6969/announce

udp://ipv4.tracker.harry.lu:80/announce

http://tracker.foreverpirates.co:80/announce

udp://tracker.leechers-paradise.org:6969/announce

udp://open.stealth.si:80/announce

udp://tracker.internetwarriors.net:1337/announce





By using this site you agree to and accept our user agreement. If you havent read the user agreement please do so here