- Don't Skip the Lecture!
- Getting Started (Downloading a Text Editor!) - All OS
- Grand Tour of Your SQL Editor + How to Preview Data
- POP QUIZ
Online
₹ 3,499
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
A structured query language is a programming language used to extract data from and insert it into a database system. Queries are built using a command language that allows users to select, insert, update, and locate information. A Course You'll Actually Finish - A Course Series, David Kim - Head of Growth @ Volt Equity, and Peter Sefton - Data Analyst at Plaid developed the SQL for NEWBS: Weekender Crash Course online certification, which is available on Udemy.
SQL for NEWBS: Weekender Crash Course online classes offer 3.5 hours of self-paced learning resources supported by 4 articles and quizzes which focus on providing applicants with a solid understanding of the foundational concepts of SQL. With SQL for NEWBS: Weekender Crash Course online training, applicants will learn about strategies and concepts related to cohort analysis, MySQL, and SQL queries to make data-driven decisions for marketing activities.
The highlights
- Certificate of completion
- Self-paced course
- 3.5 hours of pre-recorded video content
- 4 articles
- Learning resources
- Quizzes
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
certificate availability
certificate providing authority
What you will learn
After completing the SQL for NEWBS: Weekender Crash Course certification, applicants will gain a better understanding of the concepts and methodologies involved with SQL. In this SQL certification, applicants will explore the fundamentals of MySQL and will acquire knowledge of the methodologies to make data-driven decisions using SQL to develop marketing strategies. In this SQL course, applicants will also learn about strategies involved with SQL querying and cohort analysis.
The syllabus
Welcome!
Intro to MySQL
- What the heck is a relational database?
- [QUIZ] What the heck is a relational database?
- Da SQL Basics: Skeleton of a Query
- SQL Query Skeleton
- [Brainbuster] Build Your First Query!
Basic Queries
- COUNT() and GROUP BY
- Brainbuster TWEAK
- COUNT() and GROUP BY
- [Brainbuster] Organize movies by rating!
- Connecting Tables
- Connecting Tables (Warm-up for Brainbuster)
- [Brainbuster] Connect Tables
- [Brainbuster] Finding your best selling products (Rental Count by Movie)
- Having trouble understanding "connecting tables"?
- Arithmetic & Order By
- [Brainbuster] Finding Your Top-Performing Store
- LEFT(), MIN() AND MAX()
- [Brainbuster] Finding Your Active Users - Last Rental Time by Customer
- [Brainbuster] Finding Month over Month Revenue Growth
- DISTINCT
- [Brainbuster] Find Distinct Films Rented Each Month
- IN()
- Comparison Operators and HAVING
- [Brainbuster] Breaking Down Revenue by Store and Rating
- Nested Queries
- PSA: Temporary Tables on SQLSnack
- Nested Queries vs. Temporary Tables
- Add your new skills to LinkedIn!
BONUS Lectures
- BONUS: JOINs
- [Brainbuster] BONUS: JOINs
- What is a Cohort Analysis?
- Cohort Analysis Query: Setting the Stage
- Cohort Analysis Query: SQL Fanciness
- Cohort Analysis Query: Finishing Touches
Appendix A: Alternative Installation
- Installation Guide
- Getting Set Up: (Installation) - Mac Version
- Getting Set Up (Installation) - Windows 32-bit Version
Instructors
Mr Peter Sefton
Data Scientist
Udemy
Other Bachelors