Course catalog

Categories

Showing 7,641-7,660 of 8,871 items.

SQL Data Science Code Challenges (218634)

Want to test—and develop—your SQL data-engineering skills? Do you fancy yourself pretty skilled at SQL and want to see just how sharp you are? Then check out this installment of the Code Challenges series, as instructor Harshit Tyagi presents a number of challenges requiring you to write SQL queries to solve problems and answer questions. The challenges start at a relatively low level of difficulty—column selection, filtering rows from data, sorting and grouping query results—and get progressively tougher, testing you on topics like handling missing and invalid data, calculating moving window average, and data transformations. The challenges are all a few minutes long, and use a single database, so you can jump around from challenge to challenge or watch the entire course. So, if you want to see if you’re equal to the tasks, try out these SQL challenges.

SQL Essential Training

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.

SQL for Exploratory Data Analysis Essential Training

Learn how to use SQL to understand the characteristics of data sets destined for data science and machine learning.

SQL for Non-Programmers

This course provides a straightforward, concise resource for non-developers to learn enough about relational databases and SQL syntax to write simple queries.

SQL for Statistics Essential Training

Learn how to use SQL for descriptive statistics: to summarize data sets, derive insights, and make predictions.

SQL for Testers

Ground yourself in the basic approaches to testing SQL queries and gain the ability to do deep testing and analysis of back-end problems.

SQL Queries Made Easy

Get up and running with database tables using SQL. This course helps beginners not only learn key concepts, but also practice working on real-world business scenarios.

SQL Server 2008 Essential Training

Explores all the major features of SQL Server 2008, beginning with core concepts.

SQL Server 2012: Designing Database Solutions

Learn how to design databases, secure databases, and keep them in tip-top shape, with SQL Server 2012.

SQL Server 2014 Essential Training

Learn everything you need to know to start building databases with SQL Server.

SQL Server 2014: Developing Databases

Learn how to develop databases with SQL Server 2014.

SQL Server 2014: Installation and Administration

Get up to speed on installing and administering the world's most popular database, Microsoft SQL Server 2014.

SQL Server 2016: Administer a Database Infrastructure

Learn how to administer SQL Server 2016, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam.

SQL Server 2016: Provision a Database

Learn the key skills you need to provision SQL Server instances both on premises and using the cloud-based Azure service.

SQL Server 2017: Linux, Docker, and macOS

SQL Server is not just for Windows anymore. Learn how to install and connect to SQL Server 2017 on Linux, from Docker containers, and from macOS.

SQL Server 2017: What's New

See what's new and notable in SQL Server 2017, including Linux compatibility and Python scripting.

SQL Server Database Triggers

Learn how to use SQL Server database triggers to automate routine tasks and facilitate a more consistent, reliable, and predictable system.

SQL Server Integration Services

Learn how to extract, transform, and load data (and create ETL packages) with SQL Server Integration Services, one of the core add-on components to SQL Server.

SQL Server Machine Learning Services: Python

Learn how to analyze SQL Server data with Python. Discover how to perform statistical analyses, generate graphics, and process tabular data—directly in SQL Server.

SQL Server Machine Learning Services: R

Learn how to execute R code directly on SQL Server with Machine Learning Services.