Learn from Silicon Valley: SQL
Learn from Silicon Valley: SQL, available at $49.99, has an average rating of 4.7, with 55 lectures, based on 46 reviews, and has 384 subscribers.
You will learn about Learn from a Silicon Valley expert who uses SQL everyday to solve some of the toughest problems with billion-dollar clients Go from a complete beginner to an expert in SQL How to derive actionable insights from your data and make data-driven decisions Practice your new skill in scenarios inspired by real-world business cases Add SQL / PostgreSQL as a skill on your CV This course is ideal for individuals who are Beginners looking to pick up their first technical language or Non-technical students looking to expand their skillset or Managers looking to become more technically literate or Developers who want to learn more about data It is particularly useful for Beginners looking to pick up their first technical language or Non-technical students looking to expand their skillset or Managers looking to become more technically literate or Developers who want to learn more about data.
Enroll now: Learn from Silicon Valley: SQL
Summary
Title: Learn from Silicon Valley: SQL
Price: $49.99
Average Rating: 4.7
Number of Lectures: 55
Number of Published Lectures: 55
Number of Curriculum Items: 55
Number of Published Curriculum Objects: 55
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will Learn
- Learn from a Silicon Valley expert who uses SQL everyday to solve some of the toughest problems with billion-dollar clients
- Go from a complete beginner to an expert in SQL
- How to derive actionable insights from your data and make data-driven decisions
- Practice your new skill in scenarios inspired by real-world business cases
- Add SQL / PostgreSQL as a skill on your CV
Who Should Attend
- Beginners looking to pick up their first technical language
- Non-technical students looking to expand their skillset
- Managers looking to become more technically literate
- Developers who want to learn more about data
Target Audiences
- Beginners looking to pick up their first technical language
- Non-technical students looking to expand their skillset
- Managers looking to become more technically literate
- Developers who want to learn more about data
Do you want to learn SQL but don’t know where to start?
Do you want to learn how to analyze complex data?
Do you want to learn from a data professional from Silicon Valley?
If you answered yes to any of those questions, then this course is built for you! SQL is one of the most in-demand skills and is the most popular language for data work today. It’s used in almost every company – from tech giants like Google, Facebook, Amazon and Netflix to even non-tech focused companies like Bank of America or Accenture.
Regardless of your career and background, learning SQLallow you to leverage the power of data to answer some of the most complex business problems. I would know, because I use SQL every day to make data-driven decisions for multi-billion dollar companies.
And now, I’ve compiled a ton of my learnings into this very course, building practical examples that you can learn from and apply your knowledge to hit the ground running! Learn from an actual data professional from Silicon Valleyand get that unfair advantage!
What’s included:
-
Learn how to run an SQL query within the first 5 minutes!
-
Pick up everything you need to know about SQL syntax
-
Join the big data revolution – analyze large datasets
-
Filter your data to get the most relevant information
-
Understand why data types are so important and how to convert them
-
Summarize your data with aggregate functions
-
Combine data from multiple sources using SQL Joins
-
Vertically append data with SQL Unions
-
Execute conditional and logical functionsand add flow control logic to your toolkit
-
Write super organized code that will make you stand out with Common Table Expressions
-
Impress your team with complex analysis using Window Functions
-
A one-pager cheat sheet that summarizes everything you need to know about SQL
-
Get your hands dirty with writing SQL for a mock e-commerce company!
-
And a ton of other learnings!
Level up your career!
You’re reading this for a reason – whether you want to add a new skill, pivot into a new role or get a pay bump. So congratulations! Most people don’t have the same bravery for venturing into the unknown, and you’ve already taken the first step (:
I’ve built this course to be the SQL course I wish I had when I first started – a big part of it was born from the many mistakes I made while starting out in the hyper competitive tech world in Silicon Valley. And now you will have the chance to learn from it and build up practical experience writing code all by yourself!
That is pretty awesome, and I’d be guiding you every step of the way.
So let’s do this together – Enroll today and let’s learn SQL!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: Installation of PostgreSQL and PgAdmin
Lecture 3: Setting up the SportsNow Database
Chapter 2: SQL Fundamentals
Lecture 1: Understanding Data & SQL
Lecture 2: SELECT and SELECT *
Lecture 3: SELECT Practice
Lecture 4: WHERE (Part 1)
Lecture 5: WHERE (Part 1) Practice
Lecture 6: WHERE (Part 2)
Lecture 7: WHERE (Part 2) Practice
Lecture 8: WHERE (Part 3)
Lecture 9: WHERE (Part 3) Practice
Lecture 10: ORDER BY
Lecture 11: LIMIT
Lecture 12: Order By & Limit Practice
Lecture 13: Alias
Chapter 3: Data Types
Lecture 1: Intro to Datatypes
Lecture 2: Numeric
Lecture 3: Character
Lecture 4: Temporal
Lecture 5: Boolean
Lecture 6: Type Casting
Lecture 7: Datatypes (Practice)
Chapter 4: Aggregations
Lecture 1: Aggregations
Lecture 2: Group By & Aggregation Functions
Lecture 3: Group By & Aggregation Functions (Practice)
Lecture 4: Having
Lecture 5: Having (Practice)
Chapter 5: Joins & Unions
Lecture 1: Joins – ERDs
Lecture 2: Inner Joins
Lecture 3: Inner Joins (Practice)
Lecture 4: Left Joins
Lecture 5: Left Joins (Practice)
Lecture 6: Right Joins
Lecture 7: Full Outer Joins
Lecture 8: Self Joins
Lecture 9: Joins (Practice)
Lecture 10: Unions
Lecture 11: Union (Practice)
Chapter 6: Conditional Operators
Lecture 1: Case
Lecture 2: Case (Practice)
Lecture 3: Nullif
Lecture 4: Coalesce
Lecture 5: Nullif Coalesce (Practice)
Chapter 7: SubQueries
Lecture 1: SubQueries
Lecture 2: SubQueries (Practice)
Lecture 3: Common Table Expressions (CTEs)
Lecture 4: CTEs (Practice)
Chapter 8: Window Functions
Lecture 1: Introduction to Window Functions
Lecture 2: Aggregation Window Functions
Lecture 3: Ranking Window Functions
Lecture 4: Positional Window Functions
Lecture 5: Frame Clause
Lecture 6: Window Functions (Practice)
Chapter 9: Cheat Sheet (Final Summary!)
Lecture 1: Cheat Sheet
Instructors
-
Yi Zhuan Foong
Solutions Engineering Lead @ CodeSignal
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 1 votes
- 3 stars: 0 votes
- 4 stars: 6 votes
- 5 stars: 39 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024