SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
What you'll learn
- Understand the core SQL syntax and concepts
- Be able to install MySQL & PostgreSQL + different clients
- Perform SQL CRUD operations
- Query and filter (simple and complex) data
- Normalize data and split data across multiple tables
- Merge data and perform data aggregation operations
Requirements
- NO prior SQL or database knowledge is required!
- NO programming experienced is required!
Description
SQL is THE most important query language you can learn!
It's used by many popular relational database management systems like MySQL or PostgreSQL. Additionally it's also used by data analysis and big data frameworks and tools like Apache Spark.
Knowing SQL opens up an endless amount of opportunities and jobs - no matter if you're going to work with relational databases or if you're becoming a data scientist, knowing SQL will be key!
This course teaches you SQL from the ground up and in extremely high detail! In addition, this course comes with two main paths that you can take:
The "Complete Course" path where you go through the entire course, step by step, learning about ALL the key features and concepts you have to know
The "Quick Summary" path where you will learn the key SQL essentials within a few hours
Both paths are included in this course (i.e. with one single purchase) and you can switch between them or take both - simply as it makes most sense for you! Just dive into the free first course section to learn all about this course and these two paths (and how to take them).
SQL is a standardized language and therefore learning SQL will help you apply it in all kinds of contexts. Nonetheless, different database systems also support different aspects of SQL or bring their own variations of the SQL language. Therefore, this course dives into SQL by exploring all key features at the example of the two most popular database systems: MySQL and PostgreSQL. All query and command examples are shown for both database systems, ensuring that you feel comfortable working with SQL in either environment!
This course will enable you to write your own (simple or complex) SQL queries, create basic or advanced databases and table structures and work with data of different shape and complexity!
In detail, you will learn:
What exactly SQL is and how the core syntax looks like
How to write SQL commands
How to install MySQL & PostgreSQL as well as various clients
How to create and structure database tables
Which data types you may use and when to use which data type
How to perform CRUD operations: Create, Read, Update & Delete Data
How to insert data into tables
How to query and filter data
Why you should split data across multiple tables (and how to do that)
How to join (merge) data into combined result sets
How to write basic and more complex queries
How to aggregate and group data
How to use built-in database functions to work with numbers, text or dates
How to optimize databases with indexes
And much, much more!
Explore the full course curriculum to get a thorough overview of the course content and watch the free preview section to learn how this course will help you!
This course also comes with a 30 day refund period, so that you can try it risk-free :)
We'd love to welcome you on board of this course and explore SQL together with you!
Who this course is for:
- Beginner SQL developers or data scientists
- (Web) developers who want to incorporate SQL into their applications
- Data analysts and scientists
Instructors
- 4.6 Instructor Rating
- 738,574 Reviews
- 3,063,932 Students
- 47 Courses
Bundling the courses and know how of successful instructors, Academind strives to deliver high quality online education.
Online Education, Real-Life Success - that's what Academind stands for. Learn topics like web development, data analyses and more in a fun and engaging way.
We've taught more than 2,000,000 students on a broad variety of topics. We'd love to teach you as well! :)
Keep learning!
- 4.6 Instructor Rating
- 1,143,100 Reviews
- 3,100,711 Students
- 62 Courses
Experience as (Web) Developer
Starting out at the age of 12 I never stopped learning new programming skills and languages. Early I started creating websites for friends and just for fun as well. Besides web development I also explored Python and other non-web-only languages. This passion has since lasted and lead to my decision of working as a freelance web developer and consultant. The success and fun I have in this job is immense and really keeps that passion burningly alive.
Starting web development on the backend (PHP with Laravel, NodeJS, Python) I also became more and more of a frontend developer using modern frameworks like React, Angular or VueJS in a lot of projects. I love both worlds nowadays!
I also build full-stack applications and acquired expert DevOps and cloud computing knowledge - proven by the many AWS certifications I hold (incl. the top-level Solutions Architect Professional certification).
As a self-taught developer I had the chance to broaden my horizon by studying Business Administration where I hold a Master's degree. That enabled me to work in a major strategy consultancy as well as a bank. While learning, that I enjoy development more than these fields, the time in this sector greatly improved my overall experience and skills.
Experience as Instructor
As a self-taught professional I really know the hard parts and the difficult topics when learning new or improving on already-known languages. This background and experience enables me to focus on the most relevant key concepts and topics. My track record of many 5-star rated courses and more than 2,000,000 students on Udemy is the best proof for that.
Whether working as development instructor or teaching Business Administration I always received great feedback. The most rewarding experience is to see how people find new, better jobs, build awesome web applications, acquire amazing projects or simply enjoy their hobby with the help of my content.
Together with Manuel Lorenz, I founded Academind to offer the best possible learning experience to our more than 2,000,000 students.
- 4.6 Instructor Rating
- 142,481 Reviews
- 1,386,978 Students
- 12 Courses
Having worked as a business analyst in both a major consultancy and an investment bank, I always found myself confronted with both various and complex problem sets and challenging client demands. The rapid development of technology and business requirements forces everyone to constantly adapt and to continue learning.
Being an early adopter of new and quickly evolving tools, I always enjoyed both learning these tools and passing on my knowledge to my colleagues and fellow students.
Since working as a business analyst implies a high affinity to programming, I also enjoy working as a web developer. It's that combination of self-taught knowledge and its application in a highly competitive consulting environment for various clients which gave me the ability to evaluate solutions from an industry perspective as well as from a learner's perspective. The latter also allows me to identify the pain points students might hit when learning these tools.
Since I always found it hard to find high quality, understandable and comprehensive learning materials, I decided to create such materials on my own. Together with Maximilian Schwarzmüller I founded Academind to offer the best possible learning experience on web development and data science to our more than 2.000,000 students.