3 1
Sign in to rate

SQL basics

0.01MB. 0 audio & 0 images. Updated 2015-10-06.

Description

Questions about SQL. These are basic syntax questions for learning querying in the computer language SQL, mostly learned and tested using SQL Server 2014 Management Studio. Resources used are codeacademy's highly recommended free SQL course: https://www.codecademy.com/courses/learn-sql and Joes2Pros SQL book: http://www.joes2pros.com/

Sample (from 54 notes)

Cards are customizable! When this deck is imported into the desktop program, cards will appear as the deck author has made them. If you'd like to customize what appears on the front and back of a card, you can do so by clicking the Edit button, and then clicking the Cards button.
Name How do you edit a row in a database table?
Front How do you edit a row in a database table?
Back UPDATE celebsSET age = 22WHERE id = 1;
Tags
Name What is an aggregate function?
Front What is an aggregate function?
Back They help organize data into groups.COUNT() is an aggregate function
Tags
Name How to enumerate over a set with a query for multiple values?
Front How to enumerate over a set with a query for multiple values? Or, how to write an OR statement on one line...
Back SELECT * FROM EmployeeWHERE FirstName IN ('Lisa', 'David')
Tags

After the file is downloaded, double-click on it to open it in the desktop program.

At this time, it is not possible to add shared decks directly to your AnkiWeb account - they need to be added from the desktop then synchronized to AnkiWeb.

Reviews

on 1538026665
Explains the most important things in SQL.