This is an intermediate course from the standpoint of the SQL interface used. It merely references the DB and SQL interface used but provides no information on how to retrieve the BAK file, convert it to DB or set up and use the SQL interface. (Note - This is a large problem with LinkedIn Learning courses with so many instructors using different editor / interface apps. e.g.; SQLite vs MS SQL Server)
SQL Tips and Tricks for Data Science
With Ben Sullins
Liked by 10,390 users
Duration: 59m
Skill level: Intermediate
Released: 11/29/2016
Course details
Get Ben Sullins's 12 must-have SQL techniques for data science pros—engineers, DevOps, data miners, programmers, and other systems specialists. Ben's tips focus on practical applications of SQL queries for data analysis. Learn how to retrieve data, join tables, calculate rolling averages and rankings, work with dates and times, use window functions, aggregate and filter data, and much more. Each tip is short, relevant, and up to date with current industry best practices—making this the perfect course for busy analysts who normally struggle to find time to build their skills.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Arthur Miller
Arthur Miller
Systems Engineer | Data Analyst / BI | Application Support | Customer Support | Excel | UNIX | Oracle DB | SQL
-
-
Adam Markiewicz
Adam Markiewicz
[Systems & Solutions Architect] [ASQai - AI on Blockchain Developer] [GravityGen & ASQai Aerospace Industries]
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 1 quiz
- Learn on the go Access on tablet and phone
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.