Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Datacamp - Data Analyst in SQL Track

This class was created by Brainscape user Parker A. Visit their profile to learn more about the creator.

By: Parker A
Start Studying

Decks in this class (6)

Introduction to SQL - Relational Databases
Before writing any SQL queries, it’s important to understand the underlying data. In this chapter, we’ll discover the role of SQL in creating and querying relational databases. Using a database for a local library, we will explore database and table organization, data types and storage, and best practices for database construction.
26  cards
Introduction to SQL - Introducing Queries
Learn your first SQL keywords for selecting relevant data from database tables! After practicing querying skills in a database of books, you’ll customize query results using aliasing and save them as views so they can be shared. Finally, you’ll explore the differences between SQL flavors and databases such as PostgreSQL and SQL Server.
28  cards
Intermediate SQL - Selecting Data
In this first chapter, you’ll learn how to query a films database and select the data needed to answer questions about the movies and actors. You'll also understand how SQL code is executed and formatted.
17  cards
Intermediate SQL - Filtering Records
Learn about how you can filter numerical and textual data with SQL. Filtering is an important use for this language. You’ll learn how to use new keywords and operators to help you narrow down your query to get results that meet your desired criteria and gain a better understanding of NULL values and how to handle them.
30  cards
Intermediate SQL - Aggregate Functions
SQL allows you to zoom in and out to better understand an entire dataset, its subsets, and its individual records. You'll learn to summarize data using aggregate functions and perform basic arithmetic calculations inside queries to gain insights into what makes a successful film.
15  cards
Intermediate SQL - Sorting and Grouping
This final chapter teaches you how to sort and group data. These skills will take your analyses to a new level by helping you uncover critical business insights and identify trends and performance. You'll get hands-on experience to determine which films performed the best and how movie durations and budgets changed over time.
24  cards

More about
Datacamp - Data Analyst in SQL Track

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Parker A's Datacamp - Data Analyst in SQL Track flashcards now!

How studying works.

Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.

Learn more about spaced repetition

Add your own flashcards.

Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!

What's Brainscape anyway?

Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.

We use an adaptive study algorithm that is proven to help you learn faster and remember longer....

Looking for something else?

Data Analyst Unit 4 Vocabulary
  • 1 decks
  • 29 flashcards
  • 166 learners
Decks: Unit 4 Vocabulary, And more!
Data Camp - Data Science Track
  • 8 decks
  • 75 flashcards
  • 57 learners
Decks: Intro To Python For Data Science, Intermediate Python For Data Science, Python Data Science Tool Box 1, And more!
DataCamp
  • 4 decks
  • 85 flashcards
  • 8 learners
Decks: Writing Functions, Iterators List Comprehensions, Importing Flat Files Other Data, And more!
SQL
  • 5 decks
  • 81 flashcards
  • 271 learners
Decks: Sql Basics, Fetch Data Insert Edit Rows And Tables, Filter Queries Operators And Wildcards, And more!
Find Flashcards
Make Flashcards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions