Ultimate SQL Bootcamp 2024: Master Database Queries
Focused View
4:54:11
1 - Introduction.mp4
05:27
2 - Installation SQL Server and Management Studio Download with First Query.mp4
16:48
3 - Why SQL is the Best.mp4
06:05
4 - SQL Statements and Commands.mp4
15:40
5 - Overview of SQL.mp4
09:28
6 - SELECT Clause.mp4
12:43
7 - SELECT DISTINCT Clause.mp4
05:20
8 - SELECT DISTINCT WHERE Clause.mp4
05:22
9 - ORDER BY Clause.mp4
02:49
10 - SELECT WHERE Clause.mp4
05:18
11 - BETWEEN Clause.mp4
11:03
12 - IN Clause.mp4
06:09
13 - Count Clause.mp4
04:45
14 - Count Where Clause.mp4
07:33
15 - Absolute Function.mp4
02:39
16 - Square Root Function.mp4
03:39
17 - Concatenation.mp4
05:39
18 - Substring.mp4
10:15
19 - Text Functions.mp4
06:04
20 - Union.mp4
08:35
21 - Union All.mp4
01:12
22 - Intersect.mp4
04:11
23 - Except.mp4
02:22
24 - Basic Joins.mp4
28:40
25 - Left Outer Joins.mp4
09:17
26 - Right Outer Join.mp4
05:33
27 - Full Outer Join.mp4
03:35
28 - Cross Join.mp4
03:48
29 - Self Join.mp4
06:42
30 - Data Types.mp4
08:29
31 - Primary Keys.mp4
03:34
32 - Foreign Keys.mp4
07:22
33 - Constraints.mp4
01:42
34 - Query Editor.mp4
22:44
35 - Group By.mp4
07:18
36 - Group By WHERE.mp4
06:44
37 - Group By Multiple Conditions.mp4
02:43
38 - Average.mp4
01:42
39 - MAX.mp4
01:17
40 - MIN.mp4
01:48
41 - HAVING Clause.mp4
07:18
42 - HAVING With Multiple Conditions.mp4
04:49
More details
Course Overview
Transform from SQL novice to expert with this comprehensive bootcamp. Learn to install SQL Server, write powerful queries, and extract valuable insights from databases through hands-on exercises and real-world applications.
What You'll Learn
- Install and configure SQL Server with Management Studio
- Master SELECT, WHERE, and other fundamental clauses
- Apply advanced string functions and arithmetic operations
Who This Is For
- SQL enthusiasts looking to build professional skills
- Data analysts seeking database query expertise
- Beginners with no prior technical experience
Key Benefits
- No prerequisites - start from absolute basics
- Learn through practical query examples
- Master JOINs, aggregations, and data modeling
Curriculum Highlights
- SQL Commands Fundamentals
- Advanced Arithmetic & String Functions
- JOINs and Data Relationships
Focused display
Category
- language english
- Training sessions 42
- duration 4:54:11
- Release Date 2025/06/03
