English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 5 Hours | 2.65 GB
Come and discover in this 4-hour course how to quickly make your first queries in Transact SQL.
Are you a (very) big beginner on SQL, and you want to learn quickly how to make queries in TSQL?
This course will therefore be ideal for you.
After having installed SQL server on your computer, we will approach in this course in the order:
- The creation and definition of a table
- Selecting, updating, deleting and inserting data (with SELECT, UPDATE etc…)
- Select a certain number of lines with the TOP, remove duplicates with the DISTINCT.
- The operators BETWEEN, AND, OR,HAVING,PRINT,GROUP BY etc…).
- Go even further in Transact SQL with UNION and UNION ALL, TRIM/LTRIM/RTRIM and UPPER/LOWER, etc…
- Copy a table via SELECT INTO and comparison operators = != etc…
- Aggregate functions: MIN, MAV and AVG
- A long chapter of 1h 30 on joins! (INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN etc…)
Once this course is over, believe me that you will be much more comfortable with SQL and I also made sure that the videos don’t exceed 10 minutes, so that it won’t be too soporific
What you’ll learn
- Set up your environment by installing Management Studio and SQL Server.
- Creating, deleting and modifying a database
- Create, delete and modify a table.
- Learning how to select data with the SELECT,Updating data with the UPDATE,Deleting data with DELETE and INSERT
- Rename columns with aliases and Select a certain number of lines with the TOP
- The usefulness of square brackets and comments on SQL
- The IN, NOT IN, IS and IS NOT operators and Comparison operators = !=
- Sort the data with the ORDER BY and Aggregate functions: MIN, MAV and AVG
- Remove duplicates with the DISTINCT and Copying a table via SELECT INTO
- AND and OR,BETWEEN operators and the HAVING.
- Let’s combine the data with GROUP BY and the PRINT command.
- A long chapter on SQL joins (INNER JOIN, LEFT and RIGHT JOIN, FULL OUTER JOIN,and so on).
Table of Contents
Let’s Set Up our working environment installing Management Studio and SQL Server
1 Small explanation on the subtitles
2 Presentation and overview
3 Definition of SQL Server
4 Tools for working
5 Installation of SQL Server
6 Installation of Management Studio
7 First use of Management Studio
Let’s create our first wonderful database !
8 What is a Database
9 Demo How to create a database in SQL Server
10 Demo How to delete and modify the name of a database
11 Database Exercise
12 Corrected Exercise on the database
Let’s create our first fantastic table !
13 What is a table
14 Démo How to create a table
15 Démo How to modify and delete a table
16 Exercice on the table
17 Corrected for the exercise on the table
Let’s start playing with data with SELECT,UPDATE,INSERT and DELETE
18 Démo Let’s learn how to insert data with INSERT
19 Démo Discover the SELECT statement
20 Démo Discover the UPDATE statement
21 Démo let’s talk about DELETE statement in this vidéo
22 Démo How to make an UPDATE on two columns
23 Démo The comments and square brackets utility on SQL
24 Démo How to INSERT several identical values at once
Exercise 1 to 5 on SELECT,UPDATE,INSERT,DELETE
25 Exercise 1
26 Exercise 2
27 Exercise 3
28 Exercise 4
29 Exercise 5
Correction Exercise 1 to 5 on SELECT,UPDATE,INSERT,DELETE
30 Correction Exercise 1
31 Correction Exercise 2
32 Correction Exercise 3
33 Correction Exercise 4
34 Correction Exercise 5
35 Focus on previous sessions
Let’s go a little further in the SQL transact part 1 (DISTINCT,LIKE and so on..)
36 Démo Discover the column aliases
37 Démo Tackle the secrets of LIKE
38 Démo Do you know the usefulness of the TOP
39 Démo Remove duplicates with the DISTINCT
40 Demo Comparison operators = != and so on
41 Demo The IN, NOT IN, IS and IS NOT operators
42 Démo How to copy a table with the SELECT INTO
Exercise 6 to 16 on Transact SQL Part 1 (DISTINCT,LIKE …)
43 Exercise 6
44 Exercise 7
45 Exercise 8
46 Exercise 9
47 Exercise 10
48 Exercise 11
49 Exercise 12
50 Exercise 13
51 Exercise 14
52 Exercise 15
53 Exercise 16
Correction Exercise 6 to 16 on part 1 (DISTINCT,LIKE…..)
54 Correction Exercise 6 to 16 on part 1 (DISTINCT,LIKE…..)
Let’s go even further with Transact SQL Part 2 (AND,OR, MIN,MAX and so on…)
55 What are we going to discuss in this second part on the Transact SQL
56 Démo Let’s talk about the AND,OR operators
57 Démo Sort your data with ORDER BY
58 Démo Discover aggregate functions with MIN MAX and AVG
59 Démo Let’s discover the COUNT and SUM
60 Démo How to SELECT a range of data with the BETWEEN
61 Démo Group several results with the GROUP BY
62 Démo Let’s discover the specificities of HAVING
63 Démo Let’s talk about the PRINT
64 BETWEEN UK
Exercise 17 to 25 on Part 2 (AND,OR, MIN,MAX…)
65 Exercise 17
66 Exercise 18
67 Exercise 19
68 Exercise 20
69 Exercise 21
70 Exercise 22
71 Exercise 23
72 Exercise 24
73 Exercise 25
Correction Exercise 17 to 25 on part 2 (AND,OR, MIN,MAX…)
74 Correction Exercise 17 to 25 on part 2 (AND,OR, MIN,MAX…)
Learn to combine data with the power of JOINS
75 Introduction on the Joins
76 Démo INNER JOIN
77 Démo LEFT and RIGHT JOIN
78 Démo FULL OUTER JOIN
79 Démo The CROSS JOIN
80 Démo The CROSS APPLY and OUTER APPLY
81 Démo How to make a join with several tables
82 Démo Update a table with JOIN
83 Démo LEFT JOIN VS NOT IN VS NOT EXISTS
84 Démo Do you know EXECPT and INTERSECT
85 Démo Do You know the HINT on the joins
Exercise 26 to 33 on the joins
86 Set up exercises on the joins
87 Exercise 26
88 Exercise 27
89 Exercise 28
90 Exercise 29
91 Exercise 30
92 Exercise 31
93 Exercise 32
94 Exercise 33
Correction Exercise 26 to 33 on the joins
95 Correction Exercise 26 to 33 on the joins
Resolve the captcha to access the links!