SQL 101: A quick and easy reference

by David Rojas, Mikaela Rojas (Editor)

Overview

Are you new to SQL? Do you need some answers without having to read a 200 page book? Then you came to the right place, this eBook covers the top 33 questions any beginning SQL developer wants to know. Stop searching through blogs and random web sites that are just full of ads and get your own copy today!

The basics of T-SQL (Microsoft)


-- How to update a table
-- How to declare variables
-- How to update variables
-- How to get first of month or last day of month
-- How to get Monday/Sunday of previous week
-- How to get monday of current week
-- How to create a temp table
-- How to insert into a table
-- How to insert into a table from another table
-- How to join two tables
-- How to select n number of rows
-- How to select rows in ascending order
-- How to select rows in descending order
-- How to select unique vales (no dups)
-- How to write IF statements
-- How to write Loops
-- How to write a case statement within an update
-- How to check for NULL values
-- How to write an update statement with a sub query
-- How to use the Keyword "IN"
-- How to count all of the rows in a table
-- How to delete contents of a table
-- How to select the smallest/largest value in a column
-- How to pause for n number of seconds
-- How to string match
-- How to dynamically select a column using a CASE statement
-- How to unhighlight key words
-- How to permanently delete a table
-- How to do perform a boolean check
-- How to use the length function
-- How to check if column is numeric
-- How to find tables in database
-- How to find columns in database

Tags: sql, structured query language, tsql, sql crash course, tsql programming, sql introduction, sql recipes

Product Details

BN ID:	2940157922771
Publisher:	David Rojas
Publication date:	04/03/2016
Sold by:	Barnes & Noble
Format:	eBook
File size:	12 KB

About the Author

David Rojas is a data enthusiast and Python evangelist. Currently, he is enjoying his time as a consultant in the data world. He lives in the Silicon Valley and is active within the data community. After receiving a degree from the University of Florida as an industrial and systems engineer and obtaining a minor in sales engineering, he received his state license as an engineer in training. Soon thereafter, he pursued a career change to the IT world as a data analyst and discovered his passion for data using various tools in order to manage and analyze data in a better way. After many years of working in a wide range of odd data roles, such as reporting, gathering requirements, writing documentation, working with databases, and working with flat files, he decided to make his love for data a reality and started his own business (www.hedaro.com). You will often find his work being cited by various professors and other data enthusiasts around the Bay Area.