SQL Crash Course For Beginners – Learn SQL with PostgreSQL
What you'll learn
- Use SQL to answer real questions
- Write advanced queries, like joins, groups and subqueries
- Become comfortable putting SQL and PostgreSQL on your resume
- Use available functions and operators in SQL
- Understand important database concepts
- Create your own databases
Requirements
- NO programming or technical experience required
- bring your Windows, Mac or Linux computer
- complete beginners for database, SQL, or PostgreSQL are welcome
Description
Let me take you back to 2009:
Back then, I thought I had it all figured out. I had just finished my master's degree and thought, "Now I'm ready to work on any data project and be the best.
But then I joined my first project and walked into a meeting where I heard so many words that I had no idea what they meant. I began to feel insecure.
The month didn't get better. In fact, it got worse. By the time the on-boarding was over, I was sitting there with all these tools, terms, tasks, and I was really frustrated.
Fortunately, I met some great people along the way who had the willingness and talent to share their knowledge about things that just seemed weird to me. So I found help in simple words and precise examples. Finally, I began to understand.
Can you relate to my story? Maybe you are at this point now. Then I want this for you.
I would love to be one of those coaches on your journey to mastering data, SQL, and databases.
What can you expect to learn in this course?
We will start at zero, 0, null. Promised!
Use lots of examples and small steps to build your skills.
Sprinkle in a lot of exercises and repetition.
If you ever get stuck, don't hesitate to send me a message.
We can walk this path together.
I really look forward to seeing you in this course!
Who this course is for:
- Business Analysts
- Data Scientists
- Developers
- Marketers
- Researchers
Instructor
=== English ===
Hello, my name is Samuel.
I am a data solution developer and started working in this field in 2009. Since then I have built many challenging and exciting data warehouse projects.
My specialities are ETL, data integration, databases, SQL and Java. Over the last few years, the tool stack has continued to grow. It now includes AWS, Python, JSON, Big Data and NoSQL as well.
This allows me to combine data from many sources in a structured and useful manner. So that ultimately, companies can make better decisions.
I’m happy to share some of my knowledge here with you now.
Happy learning
=== Español ===
Hola, mi nombre es Samuel.
Soy desarrollador de soluciones de datos y empecé a trabajar en este campo en 2009. Desde entonces he construido muchos proyectos de almacén de datos desafiantes y emocionantes.
Mis especialidades son ETL, integración de datos, bases de datos, SQL y Java. En los últimos años, la pila de herramientas ha seguido creciendo. Ahora incluye también AWS, Python, JSON, Big Data y NoSQL.
Esto me permite combinar datos de muchas fuentes de forma estructurada y útil. Para que, en última instancia, las empresas puedan tomar mejores decisiones.
Estoy feliz de compartir algunos de mis conocimientos aquí contigo ahora.
Feliz aprendizaje
=== Deutsch ===
Hallo, mein Name ist Samuel.
Ich bin Entwickler von Datenlösungen und habe 2009 in diesem Bereich gestartet. Seitdem habe ich viele anspruchsvolle und spannende Data-Warehouse-Projekte entwickelt.
Meine Spezialgebiete sind ETL, Datenintegration, Datenbanken, SQL und Java. In den letzten Jahren hat sich der Tool-Stack weiter vergrößert. Er umfasst jetzt auch AWS, Python, JSON, Big Data und NoSQL.
Dies ermöglicht es mir, Daten aus vielen Quellen strukturiert und sinnvoll zu kombinieren. So können Unternehmen letztendlich bessere Entscheidungen treffen.
Ich freue mich, einen Teil meines Wissens nun hier mit dir zu teilen.
Viel Spaß beim Lernen