[FreeCoursesOnline Me] SkillShare – Conquer SQL Queries Step By Step From Scratch In Less Time Than Watching Netflix
English | Size: 1.15GB
Category: Tutorial
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
RAPIDGATOR
rapidgator.net/file/8a485f079407627a61e36be296fb7e37/%5BFreeCoursesOnline.Me%5D_SkillShare_-_Conquer_SQL_Queries_Step_By_Step_From_Scratch_In_Less_Time_Than_Watching_Netflix.part1.rar.html
rapidgator.net/file/413929befec25442193f3100ccb9033f/%5BFreeCoursesOnline.Me%5D_SkillShare_-_Conquer_SQL_Queries_Step_By_Step_From_Scratch_In_Less_Time_Than_Watching_Netflix.part2.rar.html
NITROFLARE
nitroflare.com/view/CD0697955CC60F4/_FreeCoursesOnline.Me__SkillShare_-_Conquer_SQL_Queries_Step_By_Step_From_Scratch_In_Less_Time_Than_Watching_Netflix.part1.rar
nitroflare.com/view/FA1BA39EBE80070/_FreeCoursesOnline.Me__SkillShare_-_Conquer_SQL_Queries_Step_By_Step_From_Scratch_In_Less_Time_Than_Watching_Netflix.part2.rar