Brainscape's Knowledge GenomeTM

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


See full index

MYSQL

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

By: Kelvin Waters
Start Studying

Decks in this class (19)

Retrieving data from a single table
True or false sql is case sensiti...,
Use 2,
Select 3
60  cards
Retrieving data from multiple tables
In mysql what is the default join...,
What two types of join s are avai...,
When selecting a column that s pr...
35  cards
Inserting, updating, and deleting data
In column attributes what is the ...,
Pk describes what in column attri...,
Nn represents what in column attr...
46  cards
Summarizing data
What are the aggregate functions ...,
What is this query returning 2,
What is this sql query returning 3
26  cards
Writing complex query
In this complex query which will ...,
True or false a subquery is limit...,
Exercise in sql_hr database find ...
32  cards
Essential MYSQL functions
Round 573 1,
Round 57345 within two digits fro...,
Truncate 57345 two digits past th...
48  cards
Views
What is the syntax for creating a...,
True or false the create view cla...,
True or false views in sql can be...
16  cards
Stored procedures
Cite a main problem with mixing s...,
What is considered the body of th...,
What is the syntax for creating a...
28  cards
Triggers and events
0  cards
Transactions and concurrency
0  cards
Data types
0  cards
Designing databases
0  cards
Indexing for high performance
0  cards
Securing databases
0  cards
String functions
Returns the ascii value for the s...,
Returns the length of a string in...,
Returns the length of a string in...
33  cards
Numerical functions
Abs 1,
Acos 2,
Asin 3
35  cards
Date functions
Adddate 1,
Addtime 2,
Curdate 3
48  cards
Advanced functions
Returns a binary representation o...,
Converts a value to a binary stri...,
Goes through conditions and retur...
19  cards
Keywords
Add 1,
Add constraint 2,
Alter 3
79  cards

More about
MYSQL

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Kelvin Waters's MYSQL flashcards for their Flatiron School class 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?

MySQL
  • 9 decks
  • 268 flashcards
  • 35 learners
Decks: Section 1 Introduction, Section 3 Creating Databases And Tables, Section 4 Inserting Data, And more!
MySQL 8.0 Certification Exam
  • 9 decks
  • 588 flashcards
  • 21 learners
Decks: Mysql Options Mysqldump And Mysqlpump, Mysql Basics, Mysql Architecture, And more!
Find Flashcards
Make Flashcards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions