Learn SQL in One Day - Fast Track Your SQL Skills

SQL = Language taught in the book Database queries = Task covered in the book Table creation = Process explained in the book Data manipulation = Concept discussed in the book

'To-the-point' style = Presentation of concepts in the book Clear examples = Method used for explaining complex topics Immediate output = Benefit provided for testing examples Complete project guidance = Final task at the end of the book

Learn SQL in one day = Book's promise to readers Examples for all concepts taught = Approach to learning SQL in the book Flow carefully planned for easy understanding = Book's organization strategy Application of all concepts in a project = Final challenge in the book

Database creation = Task explained in detail Start coding immediately = Outcome after learning from the book Easily master SQL = Goal of using this book Follow along easily = Book's approach to teaching SQL

ROUND = Rounds a number to a specified number of decimal places MOD = Returns the remainder of n divided by m SQRT = Returns the square root of a number

SELECT ROUND(10.415, 1) = 10.4 SELECT MOD(12, 5) = 2 SELECT SQRT(25) = 5

CONCAT = Concatenates multiple expressions into a single string FORMAT = Formats a number into a specific format with a certain number of decimal places

SELECT CONCAT('how', 'to', 'join', 'words'); = 'howtojoinwords' SELECT CONCAT('The result is ', 10+10); = 'The result is 20'

12 MOD 5 = 2 18 % 5 = 3

MOD stands for modulus = Returns the remainder of division Use of MOD in an online store scenario = To control the number of rows displayed based on a fixed number per page

SELECT CONCAT('any value', NULL); = NULL SELECT CONCAT('The number is ', 24); = 'The number is 24'

Placing strings next to each other = Each expression must be a string

15.3 - FORMAT = Formats a number into the specific format specified FORMAT( number, decimal_places ) = Rounds the number to the specified decimal places and returns the result as a string

If all expressions are nonbinary strings, it returns a nonbinary string. = CONCAT function It formats a number into the specific format desired. = FORMAT function

Give an individual a mid-year raise = Increase their salary by 10% in the most recent year Calculate the average salary across all employees = In the most recent year in the database Create a Stored Procedure = To make calculations based on a parameter inputted as the year Determine employees who made more than the average salary = In the most recent year within each Title

MySQL knowledge = Applicable to many fields and disciplines Data-driven world participation = Understanding the role of data in everyday lives Powerful set of skills acquisition = Can be applied to personal projects or business Appreciation for data's role = Understanding of important concepts

Join and subquery needed = To determine employees making more than average salary within each Title Stored Procedure creation = For making calculations based on inputted parameter (year)

Impressive MySQL knowledge = Equipping yourself with fundamental skills Becoming part of data-driven world = Being involved in a revolutionary field

Updating individual's salary by 10% = Giving them a mid-year raise Calculating average salary across all employees = Determining overall salary trend

LEFT = Extracts a substring from a string starting from the left-most character RIGHT = Extracts a substring from a string starting from the right-most character CHARINDEX = Returns the position of a substring within a string LEN = Returns the length of the specified string

string = The string that you wish to extract from number_of_characters = The number of characters to extract starting from the left-most character LEFT('Hello', 1) = 'H' LEFT('HelloThereGoodbyeNow', 10) = 'HelloThere'

string = The string that you wish to extract from number_of_characters = The number of characters to extract starting from the right-most character RIGHT('GoodbyeNow', 3) = 'Now' RIGHT('HelloThereGoodbyeNow', 100) = 'HelloThereGoodbyeNow'

SELECT LEFT('Hello', 1); = 'H' SELECT LEFT('HelloThere', 5); = 'Hello' SELECT RIGHT('GoodbyeNow', 3); = 'Now' SELECT RIGHT('HelloThereGoodbyeNow', 10); = 'GoodbyeNow'

Extracts characters from the left side of a string = LEFT function Extracts characters from the right side of a string = RIGHT function Returns the position of a specified substring within a string = CHARINDEX function Returns the length of the specified string = LEN function

What is returned if number_of_characters exceeds the length of string in LEFT function? = string What is returned if number_of_characters exceeds the length of string in RIGHT function? = string Example: SELECT LEFT('HelloThereGoodbyeNow', 10); Result: 'HelloThere' = LEFT function Example: SELECT RIGHT('GoodbyeNow', 3); Result: 'Now' = RIGHT function