SQL database skills are consistently among the most sought after in the world of data science. Master the skills needed for data science project specialists, and develop a solid foundation of knowledge for working with SQL engineers.
Discover how your SQL knowledge applies to data science projects.
Construct an expanded skill set optimized for data science work.
Expand your knowledge into related tool sets and platforms.
Learn how to use SQL to manage your database. Explore beginner-level tutorials on creating tables, defining relationships, and manipulating strings with SQL and SQLiteStudio.
3h • COURSE
Learning SQL Programming with Scott Simpson
Learn the basics of SQL, the programming language for retrieving and editing data from databases such as SQL Server, MySQL, MariaDB, and PostgreSQL.
1h 27m • COURSE
SQL: Data Reporting and Analysis with Emma Saunders
Get the data you need for analysis and reporting by writing your own SQL code. Learn how to write basic SQL queries, sort and filter data, and join results from different tables.
2h 17m • COURSE
Advanced NoSQL for Data Science with Dan Sullivan
Explore the fundamentals of NoSQL. Learn the differences between NoSQL and traditional relational databases, discover how to perform common data science tasks with NoSQL, and more.
1h 56m • COURSE
SQL Tips, Tricks, & Techniques with Ben Sullins
Get Ben Sullins's 12 must-have SQL techniques for data science pros—engineers, DevOps, data miners, programmers, and other systems specialists.
59m 23s • COURSE
NoSQL for SQL Professionals with Lynn Langit
Learn how to choose a NoSQL database solution that's right for your organization, including options that work with Microsoft SQL Server and on the cloud.
3h 26m • COURSE
Presto Essentials: Data Science with Ben Sullins
Get up to speed with Presto, the open-source SQL query engine developed by Facebook. Learn the key concepts of Presto and how to use them to take full advantage of your modern big data system.
1h 48m • COURSE
You'll learn master SQL for data science with these experts
Bill Weinman is a tech advocate, entrepreneur, and expert in a programming languages such as C++ and Python.
Bill Weinman is the author of several books and online courses on the technical aspects of the World Wide Web. He has earned a reputation for his ability to explain complex topics in clear, concise terms. Mr. Weinman built his first computer in 1973, and has been involved with technology ever since. He has run a successful consulting practice, been a computer manufacturer, and most recently headed a hosting company. An accomplished guitarist, Bill performs and records music when he's not writing about computers. You can learn more about Bill, his projects and his music at http://bw.org/.
Scott Simpson has a master's in education and currently creates technology courses as an author at LinkedIn.
Scott has been interested in computers since he was about seven years old, and for most of that time, he's been teaching friends, family, and strangers how to use them. This geeky hobby turned into a job with Apple during college, and after completing his master's degree in education at San Diego State University, he has helped to shape the Developer segment here at lynda.com as a content producer. Scott enjoys building web apps and exploring new technologies. He can be found on Twitter at @scotty82.
Emma Saunders is a freelance data consultant specializing in data visualization on the web.
A graduate of Oxford University, Emma has 15 years of business experience, starting on the Shell graduate scheme, and moving to Credit Suisse, the UK financial regulator, and even working a brief spell as a journalist at the Financial Times in London. She has never worked in an IT department, but taught herself coding skills as they have become useful from job to job. She also ran her own online business for a few years from 2006, and coded an ecommerce site for that venture. She is available professionally via http://vizdata.co.uk.
Dan Sullivan, PhD, is an enterprise architect and big data expert.
Dan specializes in data architecture, analytics, data mining, statistics, data modeling, big data, and cloud computing. In addition, he holds a PhD in genetics, bioinformatics, and computational biology. Dan works regularly with Spark, Oracle, NoSQL, MongoDB, Redis, R, and Python. He has extensive writing experience in topics including cloud computing, big data, Hadoop, and security.
As a lifelong data geek, Ben Sullins dedicates his time to helping others use data wisely.
Ben makes information meaningful and has fun doing it. His background affords him a unique set of knowledge that sets him apart in the data community. Since the late 1990s, he has consulted many high-tech companies, including Facebook, Microsoft, LinkedIn, Cisco, Mozilla, Pluralsight, and Genentech, on democratizing data in their organizations. Moreover, Ben spent three months leading the charge at Facebook to grow its data culture by demonstrating proper tool implementation and data visualization techniques using Tableau. And with this expertise, Ben aims to provide exceptional service to his customers by enriching their lives with impactful smart data.
Lynn Langit is a cloud architect who works with Amazon Web Services and Google Cloud Platform.
Lynn specializes in big data projects. She has worked with AWS Athena, Aurora, Redshift, Kinesis, and the IoT. She has also done production work with Databricks for Apache Spark and Google Cloud Dataproc, Bigtable, BigQuery, and Cloud Spanner.
Lynn is also the cofounder of Teaching Kids Programming. She has spoken on data and cloud technologies in North and South America, Europe, Africa, Asia, and Australia.