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

Decks in this class (19)

Retrieving data from a single table
True or false sql is case sensitive,
Use,
Select
60  cards
Retrieving data from multiple tables
In mysql what is the default join...,
What two types of joins are avail...,
When selecting a column thats pre...
35  cards
Inserting, updating, and deleting data
Varchar char,
Pk is what in column attributes,
Nn represents what in column attr...
46  cards
Summarizing data
What are the aggregate function i...,
What is this query returning sele...,
What is this sql query returning
26  cards
Writing complex query
In this complex query which will ...,
True or falsea subquery is limite...,
Exercise in sql_hr database find ...
32  cards
Essential MYSQL functions
Round 573,
Round 57345 within two digits fro...,
Truncate 57345 two digits past th...
48  cards
Views
What is the syntax for creating a...,
True or falsethe create view clau...,
True or falseviews 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,
Acos,
Asin
35  cards
Date functions
Adddate,
Addtime,
Curdate
48  cards
Advanced functions
Returns a binary representation o...,
Converts a value to a binary string,
Goes through conditions and retur...
19  cards
Keywords
Add,
Add constraint,
Alter
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.

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!
Make Flashcards