Learning with Jelly
Learning with Jelly
  • Видео 139
  • Просмотров 355 856

Видео

Basics of SQL in 10 Minutes: SQL 30 Day Challenge Day 30 (Final Recap)
Просмотров 2103 месяца назад
You made it!!! Keep learning sql, this video gives you a quick recap of sql in ten minutes. Sign up for Github for FREE: github.com My medium site for blogs: medium.com/@angelica.spratley/crafting-your-path-to-a-tech-career-navigating-certifications-education-and-hands-on-projects-to-dade97795c5b Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net...
Showcasing Your SQL Work: SQL 30 Day Challenge Day 29
Просмотров 833 месяца назад
Be sure to use platforms like LinkedIn, Medium, Github and more to showcase your work. Save your query code as .sql files and get them uploaded for everyone to see! Sign up for Github for FREE: github.com My medium site for blogs: medium.com/@angelica.spratley/crafting-your-path-to-a-tech-career-navigating-certifications-education-and-hands-on-projects-to-dade97795c5b Download SQLite Studio Her...
SQL Practice Window Functions and CTES: SQL 30 Day Challenge Day 28
Просмотров 1293 месяца назад
Three practice problems using common table expressions (CTEs) in SQL, window functions, and joins. Save your queries so you can showcase them in a project :) Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7vBA0/edit?usp=sharing Link t...
Practice SQL Mini Project: SQL 30 Day Challenge Day 27
Просмотров 1093 месяца назад
Use this mini project scenario to practice aggregate functions, having clause, aliasing, joins, ordering data and more. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7vBA0/edit?usp=sharing Link to Facebook Support Group: facebook.com...
Coalesce, Strftime, and More SQL Functions: SQL 30 Day Challenge Day 26
Просмотров 1033 месяца назад
Learn coalesce function in sql (how to handle nulls), strftime function (formatting dates and times), the round function and more! There are tons of SQL functions so make sure you look at documentation. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxE...
CASE WHEN Statements in SQL: SQL 30 Day Challenge Day 25
Просмотров 833 месяца назад
Learn conditional logic in SQL the great case when sql statements which are very similar to if then statements in many other languages. Love to use this to create new columns in sql. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7vBA...
Practice Window and String Functions in SQL: SQL 30 Day Challenge Day 24
Просмотров 783 месяца назад
Practice three problems that use window and string functions in sql. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7vBA0/edit?usp=sharing Link to Facebook Support Group: groups/767988395118964/ Link to my Data Etsy Shop ...
String Functions in SQL: SQL 30 Day Challenge Day 23
Просмотров 753 месяца назад
Learn how to standardize and clean up text columns in sql. Learn the length function in sql, the upper function in sql, the lower function in sql, the substr (substring) function in sql, and the trim function. Look at sqlite documentation online for more functions :) Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link ...
Window Functions in SQL (Part 2): SQL 30 Day Challenge Day 22
Просмотров 1043 месяца назад
Window functions retain row-level detail and can be used for calculating rate of change, running totals, and more. Learn row_number() in sql, rank() in sql, dense_rank() in sql, and lag() in sql. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7...
Window Functions in SQL (Part 1): SQL 30 Day Challenge Day 21
Просмотров 1763 месяца назад
Window functions allows us to retain row level detail in SQL and do calculations such as running totals. This video shows the difference between window functions and group bys and introduces the row_number sql function to you. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d...
Practice Common Table Expressions (CTES): SQL 30 Day Challenge Day 20
Просмотров 1643 месяца назад
Practice using common table expressions (CTEs) in SQL using the www.sql-practice.com online editor. After practicing CTEs try to get the same results using sql joins or sql subqueries. Questions: Select ALL Product Names & their Category Names Select CustomerID and Each Customers Number or Orders. Select the ProductName and the TOTAL Number of Orders for Each Product (only return products that ...
Common Table Expressions (CTEs) in SQL: SQL 30 Day Challenge Day 19
Просмотров 1463 месяца назад
Learn how to create temporary tables that can limit the use of SQL subqueries (and make your life easier) This is just an intro feel free to practice more CTEs online (they are very important) Questions: /* Use a CTE to calculate the average track length per album */ with tracklength as ( select AlbumId, AVG(Milliseconds) as AvgTrackLength from tracks group by AlbumId ) select al.Title, trackle...
SET Operators in SQL: SQL 30 Day Challenge Day 18
Просмотров 923 месяца назад
Learn set operators like union, union all, except, and intersect in SQL. Similar to joins except you are combining two queries into one result set. Just be familiar with set operators. Download SQLite Studio Here: sqlitestudio.pl/ Download the Chinook Database: www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7v...
Practice JOINS in SQL: SQL 30 Day Challenge Day 17
Просмотров 1803 месяца назад
Day 17 we are going to practice joins with 3 questions to get more hands on practice with inner joins, joining two tables in SQL, and joining three tables in SQL. Practice, practice, practice your SQL joins. Video Questions: /* Question 1: Retrieve the names of all tracks along with each track’s genre name */ /* Question 2: Retrieve the names of ALL tracks from the album “Let There Be Rock” */ ...
Subqueries in SQL: SQL 30 Day Challenge Day 16
Просмотров 1903 месяца назад
Subqueries in SQL: SQL 30 Day Challenge Day 16
JOINS in SQL Part Two: SQL 30 Day Challenge Day 15
Просмотров 1813 месяца назад
JOINS in SQL Part Two: SQL 30 Day Challenge Day 15
Intro to JOINS in SQL: SQL 30 Day Challenge Day 14
Просмотров 2163 месяца назад
Intro to JOINS in SQL: SQL 30 Day Challenge Day 14
SECOND MINI PROJECT IN SQL: SQL 30 Day Challenge Day 13
Просмотров 2204 месяца назад
SECOND MINI PROJECT IN SQL: SQL 30 Day Challenge Day 13
GROUP BY and HAVING CLAUSE IN SQL: SQL 30 Day Challenge Day 12
Просмотров 1434 месяца назад
GROUP BY and HAVING CLAUSE IN SQL: SQL 30 Day Challenge Day 12
Aggregate Functions in SQL: SQL 30 Day Challenge Day 11
Просмотров 2404 месяца назад
Aggregate Functions in SQL: SQL 30 Day Challenge Day 11
UPDATE, DELETE FROM, ALTER TABLE SQL Commands: SQL 30 Day Challenge Day 10
Просмотров 2154 месяца назад
UPDATE, DELETE FROM, ALTER TABLE SQL Commands: SQL 30 Day Challenge Day 10
ORDER BY Clause in SQL: SQL 30 Day Challenge Day 9
Просмотров 1434 месяца назад
ORDER BY Clause in SQL: SQL 30 Day Challenge Day 9
WHERE Clause in SQL: SQL 30 Day Challenge Day 8
Просмотров 2064 месяца назад
WHERE Clause in SQL: SQL 30 Day Challenge Day 8
Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 7
Просмотров 2414 месяца назад
Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 7
SELECT Clause in SQL: SQL 30 Day Challenge Day 6
Просмотров 2104 месяца назад
SELECT Clause in SQL: SQL 30 Day Challenge Day 6
Creating Tables in SQL: SQL 30 Day Challenge Day 5
Просмотров 3154 месяца назад
Creating Tables in SQL: SQL 30 Day Challenge Day 5
Using and Exploring SQL Databases: SQL 30 Day Challenge Day 4
Просмотров 3794 месяца назад
Using and Exploring SQL Databases: SQL 30 Day Challenge Day 4
Intro to SQL Syntax: SQL 30 Day Challenge Day 3
Просмотров 5144 месяца назад
Intro to SQL Syntax: SQL 30 Day Challenge Day 3
Download SQLite Studio: SQL 30 Day Challenge Day 2
Просмотров 5624 месяца назад
Download SQLite Studio: SQL 30 Day Challenge Day 2

Комментарии

  • @PurpleMomgoose
    @PurpleMomgoose День назад

    This is exactly the level a simpleton like me needs. Thank you so much!

  • @trane5947
    @trane5947 2 дня назад

    Thanks Jelly~ I have a question. Do you know how to run a logistic regression with instrumental variable in SAS ? It seems like we could use "proc qlim" ? Yet, I still do not know how to specify the model statement...Are the following codes correct ? Proc Qlim; model Y=X1 control variable /discrete(d=logit) ; model X1 = IV control variable ; Run; Thanks again.

  • @anikdasdigital
    @anikdasdigital 7 дней назад

    Your videos are amazing. I really like it. I am a new subscriber to your channel. Can I talk with you Jelly?

  • @davidmusoke
    @davidmusoke 9 дней назад

    Nice work sis ... workin' on my phd and need to know statistics coding in SAS. Well recorded and well taught videos. Thanks!

  • @kuralanbuselvaraj
    @kuralanbuselvaraj 12 дней назад

    Can I get all materials for all PROC statements including PROC SQL ?

  • @ibrahimakaba392
    @ibrahimakaba392 12 дней назад

    Thank you Jelly, I am a new student in the US and your videos help me a lot.

  • @begon8077
    @begon8077 15 дней назад

    Thank you for this intro video. It was easy to follow and your teaching style kept me engaged. I usually tune out of lectures after a while.

  • @pensamientosinorganicos
    @pensamientosinorganicos 15 дней назад

    Thanks a lot for the video and the links!

  • @sakshimohite3583
    @sakshimohite3583 18 дней назад

    Appreciated! Very well explained

  • @dantheman-adadwithchores4857
    @dantheman-adadwithchores4857 20 дней назад

    I am using version SQLite Studion 3.4.4 - i don't use a semi-colon ";" at the end and it still seems to work.

  • @paulabrown7919
    @paulabrown7919 20 дней назад

    Your video is a life saver! thanks so much!

  • @raphaeldayan
    @raphaeldayan 22 дня назад

    great content, thank you

  • @dantheman-adadwithchores4857
    @dantheman-adadwithchores4857 23 дня назад

    Thank you for this!

  • @obadelej
    @obadelej 25 дней назад

    I have an SQLite database with with a table called cc_results for the results of a cross country race. The tables have the following fields, team_code, first_name, last_name, gender, position, mark. I will like to write a query that will group the teams, sum the top3 positions for each team and rank the teams in ascending order. How can this be done?

  • @kamaqlmolvi7812
    @kamaqlmolvi7812 25 дней назад

    Where are full courses for this playlist.

  • @kamaqlmolvi7812
    @kamaqlmolvi7812 26 дней назад

    You are awesome. can you please if possible do SAS for generalized linear model, logistic regression, Nonparametric, Bayesian and mixed models.

  • @djlovedeluxe
    @djlovedeluxe 28 дней назад

    Thank you!

  • @Abdouazizushutang
    @Abdouazizushutang Месяц назад

    Wow that is very great i love the content

  • @manny1manito2
    @manny1manito2 Месяц назад

    this video helped me land a job! thank you !

  • @eg4016
    @eg4016 Месяц назад

    Indeed, this is a very professional and good video! Great work!

  • @kwetsimajunior8532
    @kwetsimajunior8532 Месяц назад

    You didn't do non parametric test?😭😭😭i depend on you

    • @learningwithjelly
      @learningwithjelly Месяц назад

      Haha lol I may add it to an upcoming SAS video thanks for the request

  • @keepcalmmiilii
    @keepcalmmiilii Месяц назад

    thank you so much! I dont know what i would do without your tutorials!

  • @Hanhan-b7e
    @Hanhan-b7e Месяц назад

    Easy to understand, perfect for when you're bored on vacation❤

    • @learningwithjelly
      @learningwithjelly Месяц назад

      Glad I can be a part of a vacation that's an honor!

  • @분할매수분할매도
    @분할매수분할매도 Месяц назад

    Thank you so much Jelly for precise and detailed explanations on learning SAS Basic. I have been watching several SAS tutorial videos on RUclips but your SAS tutorial videos are the BEST of the BEST. Let me recommend your youTube Channel for all my classmates who are having struggle from learning from classroom. I will also watch your Python videos together soon.. Thank you so much again for your time and effort to create these awesome tutorials.

  • @ossomasmeee2010
    @ossomasmeee2010 Месяц назад

    Could you please do on deep learning projects with clinical imaging data analysis with examples

    • @learningwithjelly
      @learningwithjelly Месяц назад

      Thanks for the recommendation deep learning in SAS won't be coming to my playlist anytime soon but I can add it to future goals

  • @kevinrambo
    @kevinrambo Месяц назад

    Thank you Jelly. You are a great teacher.

  • @Uinfinite-r7n
    @Uinfinite-r7n Месяц назад

    TOP G - Jelly! May God bless you for this videos!

  • @dawnb3384
    @dawnb3384 2 месяца назад

    I really love all 3 of these! I can't wait to see more of your videos.

  • @Uinfinite-r7n
    @Uinfinite-r7n 2 месяца назад

    YOU are the GOAT of SAS! Thank you!

  • @ShashankNaithani
    @ShashankNaithani 2 месяца назад

    HEllo Mam can I get sas studio free for learning?

    • @learningwithjelly
      @learningwithjelly Месяц назад

      Yes just search sas ondemand for academics and sign up for free. Check out Video 1

  • @quinyardomcclain1142
    @quinyardomcclain1142 2 месяца назад

    Thanks. I'm going to complete the course

  • @mitch6043
    @mitch6043 2 месяца назад

    As someone with a short attention span... thank you! Great video!

  • @theosagie
    @theosagie 2 месяца назад

    Excellent!

  • @ravisankarreddy5697
    @ravisankarreddy5697 2 месяца назад

    Hi

  • @lindsaytruax234
    @lindsaytruax234 2 месяца назад

    Thank-you for the explanation!

  • @Tx_Nay
    @Tx_Nay 2 месяца назад

    Excellent Video. I love that you are very detailed with your explanations! Thank you

  • @szas5650
    @szas5650 2 месяца назад

    Thanks for explaining the basics, little by little, I appreciate.

  • @prashanthjaila3412
    @prashanthjaila3412 2 месяца назад

    Please make video on PROC GENMOD mam.

  • @Nkjin996
    @Nkjin996 3 месяца назад

    Really appreciate this

  • @Nkjin996
    @Nkjin996 3 месяца назад

    Thank you!!!!!

  • @ngaybepavel6362
    @ngaybepavel6362 3 месяца назад

    Hi Jelly, thank you for facilitating this 30-day challenge. Your insights and explanations were incredibly clear and helpful. As someone passionate about data analytics, I found your content inspiring and educational. Thank you for sharing your expertise and for making such valuable information accessible. Keep up the fantastic work!

    • @learningwithjelly
      @learningwithjelly 3 месяца назад

      This warms my heart thank you so much for the kind words

  • @joannaj.9020
    @joannaj.9020 3 месяца назад

    Any words can express how wonderful Jelly is! Thank you for everything you have done, Jelly!

  • @mahalakshmiravi4814
    @mahalakshmiravi4814 3 месяца назад

    Hi Jelly, your contents are very much informative. I really appreciate all your efforts. I have few doubts in SAS, 1) how to exclude a section of a file in SAS. 2) if there are two dataset that needed to be joined together but have no common field names how you would go about finding the common element to combine the data.

  • @llexcusesll7933
    @llexcusesll7933 3 месяца назад

    omg after so many videos youre the only person that makes it make sense to me! thank you! Is there a video on conditional probability or multiple/single regression? thanks

    • @learningwithjelly
      @learningwithjelly 3 месяца назад

      Not yet but will be coming soon as part of a Data science bootcamp :)

  • @willokomba
    @willokomba 3 месяца назад

    This is awesome and easy to follow along.

  • @schoolwerk3744
    @schoolwerk3744 3 месяца назад

    Awesome. Thank you!

  • @malcorub
    @malcorub 3 месяца назад

    Awesome content Jelly! Thank you for the 30 day challenge. I followed along from days 1-20 but had to step away from this last weekend to focus on SAS programming because I had a SAS interview earlier this week. I guess I'm going back to working in SAS soon so I will be rewatching your older videos to get re-familiar with my old friend SAS.

    • @learningwithjelly
      @learningwithjelly 3 месяца назад

      Sounds like a plan thank you for watching the first 20 and SAS is awesome

  • @Nkjin996
    @Nkjin996 3 месяца назад

    thank you, this is important info!

  • @janardhan58
    @janardhan58 3 месяца назад

    thanks Jelly

  • @dgsh5185
    @dgsh5185 3 месяца назад