SQL is the language of data. And most tech/non tech companies will have a SQL round if you're interviewing for a data science or data engineering position. Here are 5 concepts that SQL interviews will often ask. I based this off the top tips Eric Weber shared on linkedin. Here are the first 5... Feel free to check out the list here. 1. CASE WHEN. Shows up all the time. 2. Self joins. Common in product. 3. DISTINCT and GROUP BY 4. Left vs outer joins. 5. UNION. Rarely discussed but frequent. 0:00 Intro 0:58 Tip #1 Self Joins 2:34 Tip #2 Running Totals With and Without Window Functions 3:47 Tip #3 Using A SUM And A CASE Clause Together 5:17 Tip #4 Pros And Cons Of Indexes 7:04 Tip #5 Knowing The Difference Between Having And Where https://www.linkedin.com/posts/eric-weber-060397b7_data-datascience-sql-activity-6780300222632407040-kwSo If you need data consulting help, then reach out to our team here: https://www.theseattledataguy.com/ Also, if you'd like to read up on my updates about the data field, then you can sign up for our newsletter here. https://seattledataguy.substack.com/ Check out my Medium here: https://medium.com/@SeattleDataGuy​ ... https://www.youtube.com/watch?v=X6-VNKe3XVM

According to a recent survey by Statista, the data market is expected to grow 175 zettabytes in volume by the year 2025. In order to dive in further into big data, we need to understand how one can work on it — and that’s where data engineering comes in. Simply put, data engineering is all about managing big datasets and extracting information from them efficiently and accurately. What’s a Data Engineer? A data engineer is someone who’s responsible for maintaining and building the architecture of data in a DS project. Some of the main roles and responsibilities of a data engineer include having to ensure an uninterrupted flow of data between server and application, integrating new data management software, improving data foundational processes, and building data pipelines. The truth is there are lots of various technologies and concepts that data engineers need to take on — working with cloud computing, ETLs, data warehouses, and so much more. The requirement of data engineers is constantly expanding, and thus we constantly need to continue learning what is changing in the technology world. In this video, we’ll talk about the top courses you can take to understand how data engineering works. 0:00 Intro 0:46 - Youtube: WiseOwl 3:16 - Youtube: Airflow Apache w/Tuan Vu 4:06 - Udemy: Data Warehouse Fundamentals for Beginners 6:40 - Udemy: Big Data on Amazon web services (AWS) 8:43 - Udemy: Taming Big Data with Apache Spark and Python - Hands On! 10:40 - Coursera: Introduction to Designing Data Lakes on AWS 12:15 - Vote For What Course I Should Take Next? WiseOwl https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw Airflow Apache https://www.youtube.com/watch?v=AHMm1wfGuHE Data Warehouse Fundamentals for Beginners https://www.udemy.com/course/data-warehouse-fundamentals-for-beginners/ Big Data on Amazon web services (AWS) https://www.udemy.com/course/big-data-on-amazon-web-services-aws-cloud-2018/ Taming Big Data with Apache Spark and Python - Hands On! https://www.udemy.com/course/taming-big-data-with-apache-spark-hands-on/ Introduction to Designing Data Lakes on AWS https://www.coursera.org/learn/introduction-to-designing-data-lakes-in-aws If you need data consulting help, then reach out to our team here: https://www.theseattledataguy.com/​​​​ Also, if you'd like to read up on my updates about the data field, then you can sign up for our newsletter here. https://seattledataguy.substack.com/​​​​ Check out my Medium here: https://medium.com/@SeattleDataGuy​​​ Watch our video on the skills you need to be a data engineer then you can watch the one below https://www.youtube.com/watch?v=LgSHaOvNodA&t=5s ... https://www.youtube.com/watch?v=lVj0RlSxTXk

There have been a lot of companies in the modern data stack adding in a reverse ETL component. It makes a lot of sense as they try to create stickier products that manage more data flows. But what is a reverse ETL? And why do you care? Also, special thanks to Rudderstack for sponsoring this video. If you want to read more about their Reverse ETL product check out the link below. https://www.rudderstack.com/product/reverse-etl/ If you enjoyed this video, check out some of my other top videos. Top Courses To Become A Data Engineer In 2022 https://www.youtube.com/watch?v=kW8_l57w74g What Is The Modern Data Stack - Intro To Data Infrastructure Part 1 https://www.youtube.com/watch?v=-ClWgwC0Sbw If you would like to learn more about data engineering, then check out Googles GCP certificate coursera.pxf.io/rn1rGv If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here. https://seattledataguy.substack.com/​​ Or check out my blog https://www.theseattledataguy.com/ And if you want to support the channel, then you can become a paid member of my newsletter https://seattledataguy.substack.com/subscribe Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio _____________________________________________________________ Subscribe: https://www.youtube.com/channel/UCmLGJ3VYBcfRaWbP6JLJcpA?sub_confirmation=1 _____________________________________________________________ About me: I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data. *I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you. ... https://www.youtube.com/watch?v=pkoSi8DjTl4

Whether you're a data engineering consultant trying to sell a project. Or you work internally and need to get buy-in for a project. Learning how to sell your services and ideas is an important skill I believe most data engineers should learn. Especially if they want to grow in their careers. That's why I asked Josalyn Annette, who has been selling in the data and tech space for over a decade to provide some tips! See you there! ... https://www.youtube.com/watch?v=eZkU9WbH7yw