SQL 101: Master the Language of Data, From Fundamentals to Advanced Techniques

Van 7.26 € /h

If you've ever looked at a database and thought, "Where do I even start?"—this course is for you. I'm going to teach you SQL from the ground up, no fluff, no jargon, just the real stuff you need to get confident writing queries that actually do something useful.

We'll start with the basics—how to pull data from a table—and build up to more advanced topics like joins, aggregations, subqueries, and even window functions. You’ll learn how to ask the right questions, write clean, readable queries, and solve real-world problems with data.

Locatie

Online vanuit India

Leeftijd

Kinderen (7-12 jaar oud)

Tieners (13-17 jaar oud)

Volwassenen (18-64 jaar oud)

Senioren (65+ jaar oud)

Niveau van de leerling

Beginner

Gemiddeld

Gevorderden

Duur

60 minuten

De les wordt gegeven in

Engels

Vaardigheden

Microsoft sql server

Database

Beschikbaarheid typische week

(GMT -05:00)

New York

Online via webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Python 101: Master the Language of Programming, From Basics to Advanced Concepts

7.26 € /h

In this course, you'll learn Python from the ground up, starting with the basics and progressing to more advanced concepts. You'll gain hands-on experience writing Python code, working with data structures, and using libraries to solve real-world problems. By the end of the course, you'll be confident in your ability to write Python programs, automate tasks, and tackle challenges in various domains.

Lees meer

Corinne

5.0

(2)

Learn how to use and create a database with Access in a simple way using logic rather than memorization.
- creation of tables
- the different types of controls with their properties and their input masks
- choice lists
- the 1st and 2nd keys
- creation of relationships between tables
- referential integrity
- filtering and sorting
- creation of queries (selection, table addition, update, deletion, table addition, cross analysis)
- calculated fields
- different displays (creation mode, data mode to be encoded, personalized displays, adding to groups ...)
- creation of forms
- creation of reports
- external data (import and export)
- compaction
- linked source tables
- etc ...

Aziz

5.0

(2)

Social media is now fully integrated in the business world. No company can do without it and in the media it plays an even more important role. Online Media and classic media are becoming more and more integrated with each other. As a professional in the media landscape, knowledge of social media has therefore become indispensable. In this semester you will learn step by step how social media can be used as a channel within the future field of work. The lessons start with the introduction of social media and teach you to better understand how it has developed and how it should be approached and used as a professional. You learn to conduct targeted research into the company, the market and finally the target group. You learn to create and implement an appropriate content plan through research. Fully tailored to the purpose for which the relevant social media wants to be used.

Shiwanie

5.0

(2)

Making data transparent is becoming increasingly important. In this Microsoft Power BI training you will learn how to create your own dashboards or reports from scratch. Microsoft Power BI is a free program that you can install on your own laptop.

You learn:
- Creating a report or dashboard based on an Excel dataset
- Applying visualization techniques to present your figures in a clear way
- Storytelling: create your own data story by combining visualizations

Sar

5.0

(2)

I am the author of a book that is currently at the top of the best sellers on Amazon, This course is designed to teach programming and the creation of small programs using Java. I offer in-person lessons to students studying software development. Drawing from my experience of over a decade as a Software Engineer, I also cover topics such as relational databases.

Throughout this course, you will begin writing code right from the start. This approach enables you to immediately test the concepts you learn. Each lesson concludes with an assignment, providing you with the opportunity to apply what you've learned in your own time and solve problems independently.

Mohamed

5.0

(2)

Dive into the world of SQL databases with this comprehensive course designed for learners of all levels. Whether you are new to databases or seeking to expand your expertise to advanced concepts like distributed systems, this course has you covered.

What You can Learn:
- Fundamentals of relational databases and SQL syntax.
- Designing robust databases using normalization and entity relationships.
- Writing complex queries, joins, and subqueries.
- Database optimization techniques for performance tuning.
- Implementing stored procedures, triggers, and views.
- Managing transactions and ensuring data integrity.
- Understanding and working with distributed database systems like Distributed PostgreSQL

Bert

5.0

(2)

English: Do you want to learn programming or take your skills to the next level? I am an experienced software developer and tutor with in-depth knowledge of languages such as Java, JavaScript, Python, HTML, SQL, and more. Whether you are an absolute beginner, a child just starting out, or already have experience, I’m here to assist you with clear explanations, hands-on exercises, and personalized guidance.

My approach is flexible and tailored to your learning style. Whether you want to build a solid foundation, need help with a specific project, or want to better understand complex concepts – together, we’ll make programming fun and accessible!

Contact me, and let’s get started. 🚀

Evelien

5.0

(2)

Excel is much used in the daily work life. It's an amazing tool if you know how to work with it. Otherwise, it sill only take a lot of your time. I will learn you everything that excel can offer you and also how to work with it. I can also help you with finding errors in data.