MS SQL Server

This is the SQL practice to let me understand how this works in a very efficient way!

---

Day 24 MS SQL Server -Create Procedure

Day 24 MS SQL Server -View:

Day 23 MS SQL Server -View- Create a View

Day 23 MS SQL Server -EXIST- NOT EXIST

Day 23 MS SQL Server - Nest query

Day 22 MS SQL Server - Character Functions - Substring, replace, replicate

Day 21 MS SQL Server - LIKE, N'%i%

Day 20 MS SQL Server - Date Time

Day 19 MS SQL Server - Aggregates funtions _Count, _AVG, _MIN, _Max

---

Day 18 MS SQL Server - TOP(20)/ TOP(20) TIES WITH

Day 18 MS SQL Server - GROUP BY

Day 17 MS SQL Server - ORDER BY

Order by 1 , 2 (Column number)

Day 16 MS SQL Server - Join

Day 16 MS SQL Server - IN Between AND

---

Day 15 MS SQL Server - > AS[name] is different as AS name

WHERE clause

Case Then Else

when String is null, return null

As[]and AS name

Day 14 MS SQL Server - > Insert INTO, UPDATE SET

Day 13 MS SQL Server - > github samples

Day 12 MS SQL Server: Installation, Stored Procedure

---

Day 11 IN, Order by

---

Day 10 LIKE '% c %' '% c ' 'c %'

Day 9 + - x / as

---

Day 8 Where (equals =) (equals and greater than >=) (equals and less than <=) (not equals to !=)

---

Day 7 Order by

---

Day 6 LIMIT

---

Day 5

---

---

Udacity Course 1

Day 1, May 10:

1. Creating a table and insert data into it.

2. Select all the movies.

3. Add a second query after the first, that retrieves only the movies that were released in the year 2000 or later, not before. Sort the results so that the earlier movies are listed first.

4. Select the SUM of minutes it will take to do all of the items on your TODO list.

Day2 May 11:(aggregate functions)

1. SUM COUNT AVERAGE

a, Add another SELECT that uses OR to show the titles of the songs that have an 'epic' mood or a release date after 1990. b, Add another SELECT that uses AND to show the titles of songs that are 'epic', and released after 1990, and less than 4 minutes long.

Day 3 May 12:(Querying IN subqueries)

Day 4 May 14:(Having, Group by)