SQL for Beginners: A Complete Course

Focused View

Sanem Aydın Yayla

3:04:12

71 View

1. Introduction

1. Introduction of the Instructor.mp4

06:16

2. Introduction to SQL Programming

1. Introduction to SQL Programming.mp4

01:54

3. How to Install MS SQL Server

1. How to Install MS SQL Server and Management Studio.mp4

01:51

4. How to Log In to SQL Management Studio

1. How to log in to SQL Management Studio.mp4

03:43

5. Database Transactions

1. How to create a database.mp4

02:54

2. How to delete a database.mp4

01:47

3. How to use an external database.mp4

03:43

6. Table Transactions

1. How to create a table by writing a query.mp4

06:16

2. How to create a table by using management console interface.mp4

05:18

7. Main SQL Commands

1. SELECT Command.mp4

03:47

2. INSERT Command.mp4

07:31

3. UPDATE Command.mp4

02:52

4. DELETE Command.mp4

01:33

5. WHERE Command.mp4

03:27

6. AND Command.mp4

04:04

7. OR Command.mp4

02:50

8. AS Command.mp4

02:45

9. IN Command.mp4

02:43

10. LIKE Command.mp4

03:30

11. BETWEEN Command.mp4

02:45

12. DISTINCT Command.mp4

02:49

13. ORDER BY Command.mp4

02:41

8. Mathematical Functions

1. MAX, MIN, AVG and SUM Functions.mp4

06:02

2. COUNT Function.mp4

03:10

9. String Functions

1. UPPER Function.mp4

02:21

2. LOWER Function.mp4

01:44

3. SUBSTRING Function.mp4

02:03

10. Constraints

1. NOT NULL Constraint.mp4

05:25

2. UNIQUE Constraint.mp4

03:37

3. CHECK Constraint.mp4

02:07

4. DEFAULT Constraint.mp4

03:35

5. PRIMARY KEY Constraint.mp4

03:46

6. FOREIGN KEY Constraint.mp4

06:25

11. Stored Procedures

1. How to create a Stored Procedure.mp4

05:40

2. How to INSERT data by using Stored Procedure.mp4

03:48

3. How to UPDATE data by using Stored Procedure.mp4

03:05

4. How to DELETE data by using Stored Procedure.mp4

02:40

5. How to use PARAMETER in Dynamic Stored Procedures.mp4

05:03

6. How to INSERT data with DYNAMIC STORED PROCEDURE.mp4

05:27

7. How to UPDATE data with DYNAMIC STORED PROCEDURE.mp4

04:02

8. How to DELETE a data from a table by using a DYNAMIC STORED PROCEDURE.mp4

02:48

12. Triggers

1. How to use TRIGGERS.mp4

04:15

2. Trigger Example Tables Preparation.mp4

03:45

3. Trigger Example 1.mp4

08:24

4. Trigger Example 2.mp4

04:03

13. Joins

1. How to use JOINS.mp4

06:07

14. Group By

1. How to use Group By.mp4

03:17

15. Closing Notes and Professional Advices

1. Closing Notes And Professional Advice.mp4

04:34

Description

Master the Fundamentals of SQL, Learn to Manage Data, Create Databases, and Generate Reports

What You'll Learn?

You will learn about the basics of SQL, the data types and basic SQL statements.
You will learn about basic SQL queries, such as how to select, insert, update, and delete data in databases.
You will learn about advanced SQL queries, such as how to use Joins, Constraints, Triggers, Stored Procedures and Functions
By the end of this training, you will be able to manage databases, writing queries and generate reports.

Who is this for?

Anyone interested in learning SQL and Databases

What You Need to Know?

No programming knowledge is required. You will learn everything you need to know.

A PC or Mac

Internet connection

More details

Description
SQL is a programming language designed for managing data in relational database management systems (RDBMS). SQL is used to perform tasks such as creating, reading, updating, and deleting data in databases. It can also be used to query data and generate reports.
SQL is a powerful language that can be used to manage large amounts of data. It is also relatively easy to learn, making it a good choice for beginners.
If you are interested in learning SQL, this training program is for you. It will teach you the basics of SQL and how to use it to manage data in databases. By the end of this tutorial, you will be able to:
Create and manage databases
Insert, update, and delete data in databases
Query data and generate reports
This tutorial is divided into three parts:
In Part 1, you will learn about the basics of SQL, including the different types of data that can be stored in databases, the different types of SQL statements, and the basic syntax of SQL.
In Part 2, you will learn about basic SQL queries, such as how to select, insert, update, and delete data in databases.
In Part 3, you will learn about advanced SQL queries, such as how to use joins, functions, constraints, and stored procedures to query data in complex ways.
This training program is designed for beginners, but it also includes some advanced topics for those who want to learn more about SQL.
If you are interested in learning SQL, I encourage you to take this tutorial. It is a great way to learn the basics of SQL and how to use it to manage data in databases.
Here are some of the benefits of learning SQL:
SQL is a widely used language, so there are many job opportunities available for SQL developers.
SQL is a relatively easy language to learn, so you can start using it to manage data in databases right away.
SQL is a powerful language that can be used to manage large amounts of data.
SQL is a versatile language that can be used in a variety of different industries.
I hope this article has aroused your curiosity about SQL. If you are interested in learning more, I encourage you to start this program today.
Who this course is for:
Anyone interested in learning SQL and Databases

User Reviews

Rating

average 0

Total votes0

Focused display

I am an IT Professional with +25 years of professional experience as an IT Channel Manager. With over +25 years of experience in the IT divisions at Telco and the Finance sector, I have developed a strong foundation and a deep understanding of Digital Channels. Throughout my career, I have had the privilege of working with diverse teams, leading projects, and delivering exceptional results I completed my graduate degree in Economics (İstanbul) and my postgraduate degree in Master of Business (Australia). At the moment, I have been studying Computer Programming. You may see some of my awards: - The first Call Steering enabled IVR channel in Turkey in 2011. - The first Full Speech-enabled IVR channel in Turkey in 2015 - The winner of the 2015 Contact Center Worlds Top Performers Awards in the world contest. - The project manager of the Voice Verification system with 16 million voice prints (the world record) - The winner of the 2009 Contact Center World Top Performers Awards in the world.I am genuinely excited about joining Udemy as an instructor and contributing to Udemy users in their self-improvement journey. I am confident that my technical skills, experience, and passion for learning lifetime.Respectfully,Sanem Aydın Yayla

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.