SQL Deep Dive

Focused View

Chris Behrens

1:50:32

22 View

1. Getting Started

1. Course Introduction.mp4

01:46

2. About the Training Architect.mp4

00:47

2. Database Setup

1. Creating an Azure SQL Database.mp4

04:18

3. Client Setup

1. Setting Up Visual Studio Code.mp4

03:07

4. Database Basics

1. What Is an RDBMS.mp4

03:43

2. What Is ANSI SQL (and What Is It Not).mp4

02:44

5. Retrieving Data (Basic)

1. Selecting.mp4

03:36

1. `WHERE` Clauses.mp4

2. `HAVING` Clauses.mp4

4. Sorting Results.mp4

02:49

5. `NULL` Values.mp4

6. Retrieving Data (Advanced)

1. Selecting Ranges.mp4

06:54

2. Fuzzy Lookups.mp4

03:27

3. `WHERE` Operators.mp4

4. Aliases.mp4

07:33

5. Joins.mp4

07:56

6. Joins (Advanced).mp4

08:05

7. Logic Conditions.mp4

02:46

Exercise Files.zip

7. Changing Data

1. Inserting.mp4

06:33

2. Updating.mp4

03:38

3. Deleting.mp4

03:12

8. Manipulating Objects

1. Database.mp4

02:06

2. Table.mp4

07:52

3. Index.mp4

04:41

4. View.mp4

03:27

9. Safeguarding Our Database

1. SQL Injection.mp4

03:27

2. Performance.mp4

14:28

10. Final Steps

1. Whats Next.mp4

01:37

Description

Learn about SQL and how to leverage it, including selecting, updating, and deleting information and creating and altering database objects.

What You'll Learn?

SQL is a powerful language for data retrieval and manipulation. Utilized in databases of every size, it is an industry-standard for working with data. In this course, we are going to discover what SQL is and how to leverage it. This includes selecting, updating, and deleting information, as well as creating and altering database objects. Familiarity with the SQL language is an asset to your career, whether you're a programmer, sysadmin, DBA, or analyst. And it's quite fun! I look forward to diving into SQL with you.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Chris Behrens

Instructor's Courses

Acloud Guru

View courses Acloud Guru

A Cloud Guru is an online training platform for people interested in Information Technology. Most of the courses offered prepare students to take certification exams for the three major cloud providers.