SQL and Databases Fundamentals
Master SQL and database fundamentals to enhance your data querying and management skills.
- of video
- 3.4 h
- lectures
- 67
- sections
- 11
$49.97one payment
Lifetime access. 15-day money-back guarantee.
Want a mentor as well? The Academy gives you every course on Amigoscode plus code reviews, daily live calls and interview prep, for $129/month. Compare →
What you'll learn
By the end of this course
- Database Creation and Table Design - Learn how to create databases and design tables for efficient data storage.
- Data Insertion, Retrieval, and Sorting - Master the techniques for inserting, retrieving, and sorting data in your database.
- Advanced Data Filtering and Grouping - Explore advanced methods for filtering and grouping data to extract meaningful insights.
- Working with Operators and Handling NULLs - Understand how to use operators and handle NULL values in SQL queries.
- Managing Dates and Timestamps - Learn to manage and manipulate date and timestamp data effectively.
- PostgreSQL Constraints - Discover how to implement and manage constraints in PostgreSQL to ensure data integrity.
- CRUD Operations - Gain proficiency in performing Create, Read, Update, and Delete operations on your database.
- Data Relationships - Understand how to define and manage relationships between different tables in your database.
- Foreign Keys and Join Operations - Learn to use foreign keys and perform join operations to combine data from multiple tables.
- Data Export to CSV - Master the process of exporting data from your database to CSV files for further analysis.
Curriculum
11 sections, 67 lectures
3.4 h of video. Open any section to see its lectures.
1Intro2 lectures · 1 min
- 1Recommended Courses
- 2Slides
2Important stuff7 lectures · 27 min
- 1Sql Commands2 min
- 2Semi Column For Sql Commands2 min
- 3Sql Upper Vs Lowercase4 min
- 4Naming Convention3 min
- 5Query Buffer9 min
- 6Execute Queries From File7 min
- 7Quiz
3Insert and query data7 lectures · 26 min
- 1Insert8 min
- 2Query Data With Select4 min
- 3Alias3 min
- 4Sample Data3 min
- 5Sorting Data Using Order By5 min
- 6Disctinct4 min
- 7Quiz
4Filtering data12 lectures · 45 min
- 1The Where Clause2 min
- 2Is Null And Is Not Null2 min
- 3Fetch Limit And Offset3 min
- 4Quiz
- 5Filter Data With Where3 min
- 6Comparison Operators4 min
- 7Understanding Booleans4 min
- 8Logical And Or Explained8 min
- 9Where With And And Or3 min
- 10In And Not In4 min
- 11Between3 min
- 12Like And Ilike7 min
5Grouping and aggregate functions9 lectures · 24 min
- 1Grouping And Aggreate Functions1 min
- 2Quiz
- 3New Data Set
- 4Group By And Count6 min
- 5Sum3 min
- 6Min Max Avg2 min
- 7Filtering With Having6 min
- 8Very Important4 min
- 9Aggreate Functions Docs2 min
6Mathematical operators and functions3 lectures · 10 min
- 1Mathematical Operators4 min
- 2Mathematical Operators And Functions On Columns5 min
- 3More Mathematical Functions2 min
7Modifying data5 lectures · 18 min
- 1Modifying Data3 min
- 2Deleting Records5 min
- 3Updating Records7 min
- 4Crud2 min
- 5Quiz
8Relationships4 lectures · 17 min
- 1What Relationships And Different Types5 min
- 2Adding Primary And Fofeign Keys7 min
- 3Assigning Car To People5 min
- 4Quiz
9Joins12 lectures · 33 min
- 1Joins3 min
- 2Join With Using5 min
- 3Joins Cheat Sheet
- 4Quiz
- 5Join Aka Inner Join6 min
- 6Left Join2 min
- 7Left Join With Null Check2 min
- 8Right Join5 min
- 9Right Join With Null Check2 min
- 10Full (Outer) Join2 min
- 11Other Types Of Join2 min
- 12Using * For Selecting Columns3 min
10Order of SQL4 lectures · 3 min
- 1Sql Order And Execution3 min
- 2Diagram 1
- 3Diagram 2
- 4Quiz
11Next steps2 lectures · 1 min
- 1Feedback
- 2Next Course
Choose how you learn
Learn on your own, or with people who check your work
The course is yours to keep. The Academy is this course and every other one, plus the people who get you hired.
SQL and Databases Fundamentals
The course, on your own
$49.97one payment
- 67 lectures, 3.4 h of video
- Subtitles on every video
- 6 months of IntelliJ IDEA Ultimate
- Lifetime access to the course and its updates
15-day money-back guarantee
The Academy
The courses, plus the people
$129/monthcancel anytime
This course, plus
- Every course on Amigoscode 50+ in the Zero to Hired Roadmap
- Daily live calls and 1:1 instructor time
- Code reviews and pair programming on what you build
- Interview prep mock interviews, System Design Lab, CV and LinkedIn review
- Land an interview in 90 days or we coach you 1:1 free until you do.
7-day money-back guarantee · Secure checkout on Skool
“Nelson was teaching 90% of my job. I was already implementing everything I learnt from it.”
“I was a totally different person. More confident as a developer, more prepared for my job.”
GabrielaSoftware Engineer at Mercado Livre“I studied biomedicine and psychology. I found Nelson's Java tutorials while looking for a course for my brother. I was hooked and now here I am, a software engineer at IKEA.”
NajmaSoftware Engineer at IKEAAbout this course
Who is this course for?
Level: All (Junior, Mid, Senior Engineers).
How long will it take?
There are about 3 hours of video. Most people finish in a week at 5 hours a week, plus the time you spend building along.
Do I keep access?
Yes. You pay once and keep the course for life, including updates.
What if it isn't for me?
Email us within 15 days of buying and we'll refund you in full.
Should I buy the course or join the Academy?
Buy the course if you only want this topic and you learn well on your own. Join the Academy if you want to get hired or move up: you get every course on Amigoscode, this one included, plus daily live calls, code reviews and interview prep, for $129/month. The course is $49.97 once.