Brief Introduction
Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in the data science field.
Description
Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and extracting various data types from databases. A working knowledge of databases and SQL is necessary to advance as a data scientist or a machine learning specialist. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment.
The emphasis in this course is on hands-on, practical learning. As such, you will work with real databases, real data science tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs, you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and Python.
No prior knowledge of databases, SQL, Python, or programming is required.
Knowledge
- Learn and apply foundational knowledge of the SQL language
- How to create a database in the cloud
- How to use string patterns and ranges to query data
- How to sort and group data in result sets and by data type
- How to analyze data using Python
JavaScript Algorithms and Data Structures Masterclass
- 4.8
-
![]()
![]()
![]()
![]()
![]()
The Missing Computer Science and Coding Interview Bootcamp Updated in November 2018 with brand new section on Dynamic Programming! We cover the ins and outs of Recursion....
Data Mining - Clustering/Segmentation Using R, Tableau
- 3.9
-
![]()
![]()
![]()
![]()
![]()
Learn Data Mining - Clustering Segmentation Using R,Tableau Course is structured to start with introduction to the tool & the principles behind Clustering Using R tool....
Exploratory Data Analysis with MATLAB
- 4.8
-
![]()
![]()
![]()
![]()
![]()
In this course, you will learn to think like a data scientist and ask questions of your data. g. , histograms, averages, standard deviation, curve fitting, interpolation)....
The Python Programming A-Z Definitive Diploma in 2021
- 4.3
-
![]()
![]()
![]()
![]()
![]()
The Hands-On Guide to Master Modern Python and Data, to Advance your Dev and Data Career in no time! Hi, Welcome to The Python Programming A-Z Definitive Diploma in 2021....
