ASTROCOHORS CLUB ORIGINS

Episode Title: Multiple Choice Tests - Techniqes & Strategies - Study Tips Produced by: Socratica Description: Hello Socratica Friends! We’re here to help you be a Great Student. Do you think Multiple Choice tests are unfair? Is this because you don’t do very well on them? Be honest, now. Wouldn’t you like to know how to do better on these tests? We can help. The truth is, that while multiple choice tests can seem tricky, they really can be the best way to test for CERTAIN kinds of knowledge. Namely - can you draw distinctions between closely related ideas? To do well on Multiple choice tests, you have to stay calm and proceed through the test without getting too hung up on any one question. In this video, we share some of our best strategies for doing well on multiple choice tests. Our number one tip is to take a practice test, and then use it to figure out what you DON’T know. Then, study only the material you don’t know! This can feel uncomfortable, but it really is the most...

Episode Title: Ring Definition (expanded) - Abstract Algebra Produced by: Socratica Description: A ring is a commutative group under addition that has a second operation: multiplication. These generalize a wide variety of mathematical objects like the integers, polynomials, matrices, modular arithmetic, and more. In this video we will take an in depth look at the definition of a ring. Our Abstract Algebra playlist is here: http://bit.ly/AbstractAlgebraSocratica ************** To​ ​help​ ​us​ make ​videos more quickly,​ please ​support​ Socratica at: ​Patreon​: https://www.patreon.com/socratica Socratica Paypal: https://www.paypal.me/socratica We also accept Bitcoin! :) Our​ ​address​ ​is: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ************** We recommend the following textbooks: Dummit & Foote, Abstract Algebra 3rd Edition http://amzn.to/2oOBd5S Milne, Algebra Course Notes (available free online) http://www.jmilne.org/math/CourseNotes/index.html ************** You​ ​c...

Episode Title: How to Use Office Hours | Study Tips | Corson Technique Produced by: Socratica Description: Hello Socratica Friends! We've built you a Study Tips Website! If you want to create your own website, go to: https://www.wix.com/go/socratica We often suggest you go to your instructor’s Office Hours. It’s like free, expert tutoring. But do you know how to actually use this valuable resource? There’s more to it than just showing up. First, you need to do some preparation. Don’t go in to office hours empty handed. You should bring in very specific questions that your professor or TA can help you with. We recommend you use the CORSON technique. This is a simple but very effective study method, introduced by Physics professor and Cornell president Dale Corson. The key to the Corson Technique is to carefully identify where your understanding breaks down. This usually means going very SLOWLY through the reading or equations, step by step, until you find where you really get st...

Episode Title: Ring Definition (expanded) - Abstract Algebra Produced by: Socratica Description: A ring is a commutative group under addition that has a second operation: multiplication. These generalize a wide variety of mathematical objects like the integers, polynomials, matrices, modular arithmetic, and more. In this video we will take an in depth look at the definition of a ring. Our Abstract Algebra playlist is here: http://bit.ly/AbstractAlgebraSocratica ************** To​ ​help​ ​us​ make ​videos more quickly,​ please ​support​ Socratica at: ​Patreon​: https://www.patreon.com/socratica Socratica Paypal: https://www.paypal.me/socratica We also accept Bitcoin! :) Our​ ​address​ ​is: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ************** We recommend the following textbooks: Dummit & Foote, Abstract Algebra 3rd Edition http://amzn.to/2oOBd5S Milne, Algebra Course Notes (available free online) http://www.jmilne.org/math/CourseNotes/index.html ************** You​ ​c...

Episode Title: How to Pick Your Major | Study Tips Produced by: Socratica Description: Hello Socratica Friends! We've built you a Study Tips Website! If you want to create your own website, go to: https://www.wix.com/go/socratica If you're headed off to college, you're bound to hear this question soon: What's Your MAJOR? What are you going to MAJOR in? What, you don't know what you're doing for the rest of your life yet? Don't worry, Socratica Friends. Let's talk about how to figure out what major is right for you. For instance, we recommend you start paying closer attention to what GRABS your attention! What headlines do you pay attention to in the news? Are you interested in medical discoveries? Or are you more interested in what's happening in politics? Little clues like this will help you become more aware of what might be your true calling in life. You may also be interested in taking an "Interests Assessment" test. Your school may...

Episode Title: How we made Socratica Study Tips Website Produced by: Socratica Description: Hello Socratica Friends! We've built you a Study Tips Website! If you want to create your own website, go to: https://www.wix.com/go/socratica Do you need to learn how to make a professional website from scratch? This video is a step by step guide. Follow along as we make the Socratica Study Tips Website. Our friends at Wix sponsored this video. We used one of their FREE templates to build our new Study Tips site! Check it out at https://socratica.wixsite.com/studytips This video shares our tips on making a website. Notice that it's a very short website tutorial! That's because a lot of the work was already done for us. We were able to build our website in a single afternoon. You may be wondering why we didn't build our own site from scratch. Well, back in the day when we first stated Socratica, we did! We designed, coded, debugged, the whole shebang. And it took us MONTHS. W...

Indexes in SQL are used to speed up SQL queries. A database index works much like an index in a book. For example, if you have a database table with a list of people, a common query would be to lookup someone by name. Creating an index means the database will not have to scan the entire table looking for matches. Instead, it will restrict its search to a small portion of the rows. In this video we use a table with 100 million rows to illustrate how much an index can change the speed of a query. Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socr...

In SQL, a VIEW is a virtual table. It lets you package a complex query into a single table. We will discuss several queries in increasing difficulty to show how VIEWs can greatly simplify your work. In our examples we will introduce CROSS JOINs, Unions, the CONCAT() function, and the COALESCE() function. Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written & P...

A SQL JOIN lets you retrieve data from 2 or more tables in your database. In this video we give examples of 4 kinds of joins: INNER Joins, LEFT Joins, RIGHT Joins, and FULL Joins (also known as FULL OUTER Joins). If you are just learning about SQL Joins, we would recommend you watch our first video: “SQL Joins Explained.” https://www.youtube.com/watch?v=9yeOJ0ZMUYw Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instr...

SQL Joins let you fetch data from 2 or more tables in your database. We will cover the more common types of Joins: Inner Joins, Left Joins, Right Joins, and Full Joins (also called ‘Full Outer Joins’). We will introduce these 4 kinds of Joins and prepare you for our next video where we will cover many examples. Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written ...

In SQL, the DELETE query is used to delete a row from a table. In this tutorial we will show you how to use the delete command to remove one or more rows from a table. The key is to carefully test your query and make sure your WHERE clause targets exactly those desired rows. To do this, we will first write the DELETE query, comment it out using one of the two ways to write a comment in SQL, test the WHERE with a SELECT, then finally execute the DELETE. The song data used in this tutorial can be downloaded from Github: https://github.com/socratica/data Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ...

The UPDATE SQL statement is used to make changes to data in a database. You can make changes to one more columns for multiple rows in a single query. Today we will work an elite database of internationally known spies to practice making UPDATEs and checking our work. Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written & Produced by Kimberly Hatch Harrison (@k...

Hello Socratica Friends! We’re here to help you be a great student! Want a real challenge for your memory? How many digits of Pi do you think you can learn? In school, we first learned about how Pi is the ratio of a circle’s circumference to its diameter. It’s also in the formula for the Area of a circle. But Pi just kept coming up over and over in math and physics. We used it so much, we almost accidentally learned about 6 digits by heart. But you can learn more - a LOT more! In this video, we share 3 of our favourite techniques for memorizing digits of Pi. We’ve even found a method for quickly memorizing 100 digits of Pi! Impress your friends on Pi Day (March 14th) 3-14 is Pi Day, which people celebrate by walking in circles, eating Pie, and reciting digits of Pi. Do you have another method for learning the digits of Pi? Tell us about it in the comments! We have a FREE App to Learn Digits of Pi: http://bit.ly/Pi_App In this video, we mentioned this book as a source: Secrets of Ment...

The INSERT INTO SQL statement is used to add data to a database. You can add one or more rows to a table in a single query. These two approaches are similar in appearance but very different in speed. We will also write a Python program to insert 20,000 rows into a database using two different INSERT INTO techniques, and see which one is faster. Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mo...

In this tutorial, we continue to explore the SQL SELECT statement. In addition to the standard SELECT, FROM, WHERE, ORDER BY, and LIMIT statements, we will also us the SELECT DISTINCT, LIKE, and BETWEEN statements. The data used in this video is available as a CSV from Socratica on Github. You can download the data here: https://github.com/socratica/data The file is earthquake.csv Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios —————————...

The SELECT statement in SQL is how you fetch data from your database. In this SQL tutorial we give an introduction on how to write a SELECT query. We will cover the SELECT, FROM, WHERE, ORDER BY, and LIMIT statements with many examples. The data used in this video is available as a CSV from Socratica on Github. You can download the data here: https://github.com/socratica/data Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————...

Today we show you how to install PostgreSQL (aka “Postgres”). In addition to installing the database, we will install the pgAdmin GUI tool. Once Postgres and pgAdmin are installed, we will take a tour of the pgAdmin interface and learn how to create a new database. Our SQL playlist starts here: ↪http://bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ http://bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written & Produced by Michael Harrison and Kimberly...

When learning SQL, you first need a database. In this video, we help you make your choice. There are many free, open-source options: MySQL, PostgreSQL, MariaDB, Sqlite, and many others. You can also choose an established commercial option like Oracle, SQL Server, or DB2. Better still, you can run the database on your own server or in the cloud! ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written & Produced by Michael Harrison and Kimberly Hatch Harrison View on YouTube

SQL is a powerful language for working with databases. Today, we take you on a quick tour of SQL space and highlight the main features of the language. This will give you a bird’s eye view of what you will learn from this series. Subscribe to Socratica for more videos like this: ↪ http://bit.ly/SocraticaSubscribe You may also be interested in our Python playlist: ↪http://bit.ly/PythonSocratica ——————————————— »» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at: … ​Patreon​: https://www.patreon.com/socratica … Paypal: https://www.paypal.me/socratica … Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank​ ​you!! ——————————————— »» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on: ...​ ​Twitter:​ ​@socratica … ​Instagram:​ ​@SocraticaStudios … ​Facebook:​ ​@SocraticaStudios ——————————————— SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written by Michael Harrison (@mlh496 on Twitter) Produced by Kimberly Hatch Harrison & Michael Harrison View on YouTu...