Please help the site by white listing it in your Ad-Blocker.


User log in
User registration
Registrations are closed. If you have an invitation code, click here, or join our twitter, we post invites often there.
Email: forgotten email?
Password: lost pass?
  Resend activation email
Protect your privacy! Use a VPN When Downloading Torrents
Your IP Address is . Location is .
Your Internet Provider is tracking your torrent activity! Hide your IP ADDRESS with a VPN!
We strongly recommend using NORD VPN to anonymize your torrenting.
Also, while you are using NORD you get No Ads for Demonoid members Get VPN Now!
Details for SkillShare | Conquer SQL Queries Step By Step From Scratch In Less Time Than Watching Netflix [FCO]
Created by Ratio: 1.00SaM 29 days ago[ Add to bookmark ]
Miscellaneous
Lynda and other Courses >>> https://www.freecoursesonline.me/
For Developer Tools & Apps >>> https://ftuapps.com/
Forum for discussion >>> https://1hack.us/




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

Facebook Twitter Digg Reddit LinkedIn StumbleUpon Email
Show Demonoid some love with BitCoin: 1DNoidyJgB159bLJT5hDnCkZ4uQrhkfBVk How to get BitCoins?
Peers: 24 seeders, 4 leechers, 716 total - Updated: 5 days ago
Size: 1.16 GB 

Sponsored links
Related torrents
Torrents you may also like:
Download this torrent
Extra information
Tracker: udp://opentor.org:2710/announce
Torrent hash: 126B4862 26F70563 B098679C E6A7B018 9756DBF6
Files described inside the torrent: 28 [ Click here to show the full list ]
Comments
No comments posted yet

Disclaimer: None of the files shown here are actually hosted or transmitted by this server. The links are provided solely by this site's users. The site moderation is also a service provided by the site's users. The administrator of this site (demonoid.is) cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms.

By using this site you indicate your agreement to our terms and conditions
   
Link to us | Contact us | API | Commemoration | Twitter: @DemonoidBT | Feeds/RSS | DMCA
This site and the Demonoid logo are Copyright © Demonoid. All rights reserved.

Show Demonoid some love with 1DNoidyJgB159bLJT5hDnCkZ4uQrhkfBVk