Learn T-SQL Syntax

Focused View

Robert Baakel

4:11:44

115 View

1. Install Sample Database

1. Install SQL Server.mp4

04:49

2. Install Sample Database.mp4

02:23

2. Introduction to SQL

1. Select Statement.mp4

06:23

2. Aliases.mp4

08:36

3. Select Top.mp4

05:23

4. Min Max.mp4

04:58

5. Upper Lower.mp4

01:36

6. Count Avg Sum.mp4

04:21

7. Concat Function.mp4

02:12

8. SubString.mp4

03:05

9. Quizzes.html

10. Quiz 1 Answers.mp4

01:13

11. Quiz 2 Answers.mp4

02:20

3. Where Clause

1. Where.mp4

02:42

2. Where AND OR NOT.mp4

05:59

3. Where IN.mp4

05:38

4. Where LIke.mp4

08:39

5. Between.mp4

03:56

6. Quiz 3.html

7. Quiz 3 Answers.mp4

03:16

4. Grouping Ordering and Filtering

1. Order By.mp4

06:56

2. Group By.mp4

06:17

3. Having.mp4

05:09

4. Case Statement.mp4

04:41

5. Quiz 4.html

6. Quiz 4 Answers.mp4

01:58

5. SQL Joins

1. Primary Key & Foreign Key.mp4

08:37

2. Join.mp4

02:44

3. Inner Join.mp4

04:56

4. Left Join.mp4

03:23

5. Right Join.mp4

05:24

6. Full Join.mp4

09:15

7. Quiz 5 Answers.mp4

04:43

6. SubQuery

1. Where Exists.mp4

08:23

2. Sub Query.mp4

14:10

3. Quiz 6 Answers.mp4

02:51

7. Intermediate Topics

1. Literals.mp4

15:05

2. Unions.mp4

13:49

3. Stored Procedures.mp4

12:57

4. Quiz 7 Answers.mp4

01:40

8. Create Update and Delete

1. Oops! What do I do.mp4

02:10

2. Views.mp4

03:52

3. Update.mp4

05:23

4. Insert Into.mp4

09:17

5. Delete.mp4

02:52

6. Create and Drop a Database.mp4

04:43

7. Create and Drop a Table.mp4

04:31

8. Alter Table.mp4

05:20

9.1 SQLCourseFiles.zip

9. Quiz 8 Answers.mp4

03:09

Description

Learn to code with confidence

What You'll Learn?

Introduction to T-SQL syntax

Who is this for?

Beginner programmers

More details

Description
This course is based on writing syntax for T-SQL.Â It is strictly code base and will not cover database architecture or performance.Â You will learn the basics and step into intermediate SQL code. You will learn some real life applications of using the SQL code. Quiz will be based on real life scenarios so that you can start to learn to think like a SQL Developer.Â Â
You can get started and follow along in the course using the free SQL Server addition which will replicate an actual working environment that you can then expand on on your own.
You do not need any prior experience to take this course.Â If you are not using Microsoft T-SQL not all of the modules will work exactly as in the video course.
The course will start with basic syntax and functions.Â Â The course will then move to the where clause and some intermediate topics.Â
With the explosion of data I believe SQL will be the backbone of the IT industry for years to come.Â This course will help you get the ball rolling and establish a good foundation if you are a beginner.Â If you are a business user or even a full stack developer having strong SQL skills can improve your individual worth and team's performance.Â
Who this course is for:
Beginner programmers

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Robert Baakel

Instructor's Courses

Hi I'm Robert BaakelI have over 15 years of experience using SQL as Business Intelligence and Database Developer. I have used BIRT in many different areas from custom built Java applications, integrated into Maximo, integrated into Tririga, and stand alone on Tomcat. My experience with BIRT also includes teaching BIRT for Maximo in corporate training settings. I also have experience with other BI/ETL tools such as Cognos, MS BI, and Tableau.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.