Introduction to SQL

Introduction to SQL, available at Free, has an average rating of 4.35, with 33 lectures, based on 139 reviews, and has 5547 subscribers.

You will learn about Learn exactly what is a database and how it is used Learn the general syntax for SQL queries Learn how to use various SQL clauses Learn about the inbuilt functions within SQL Learn how to create and drop a database table Learn how to insert, update and delete data in a database Learn about constraints and how they can be used Learn about the different types of table joins Have an introduction to real-world scenarios using SQL This course is ideal for individuals who are This is a SQL course designed for users with no prior knowledge or experience of the language and its uses. The course progresses from a basic to intermediate level. Although touching on more advanced queries, this course is not designed for the advanced or power user. It is particularly useful for This is a SQL course designed for users with no prior knowledge or experience of the language and its uses. The course progresses from a basic to intermediate level. Although touching on more advanced queries, this course is not designed for the advanced or power user.

Enroll now: Introduction to SQL

Summary

Title: Introduction to SQL

Price: Free

Average Rating: 4.35

Number of Lectures: 33

Number of Published Lectures: 18

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 18

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Learn exactly what is a database and how it is used

Learn the general syntax for SQL queries

Learn how to use various SQL clauses

Learn about the inbuilt functions within SQL

Learn how to create and drop a database table

Learn how to insert, update and delete data in a database

Learn about constraints and how they can be used

Learn about the different types of table joins

Have an introduction to real-world scenarios using SQL

Who Should Attend

This is a SQL course designed for users with no prior knowledge or experience of the language and its uses. The course progresses from a basic to intermediate level. Although touching on more advanced queries, this course is not designed for the advanced or power user.

Target Audiences

This is a SQL course designed for users with no prior knowledge or experience of the language and its uses. The course progresses from a basic to intermediate level. Although touching on more advanced queries, this course is not designed for the advanced or power user.

What Is This Course:Introduction to SQL

An introduction to the Structured Query Language. Although based around T-SQL this course is suitable for other variations of the language.

_________________________________________________________________________

What’s Included In This Course:

· Practice Examples:Each topic includes easy to follow examples.

· Real World Scenarios: Scenarios taken from real examples

· High Quality Content: Over 3+ hours of high quality videos.

· Support: On hand support to cover everything introduced in the course.

_________________________________________________________________________

What You Will Learn In This Course:

What are servers, databases and tables and why do we use them.

What is SQL and how can it be used to manipulate data within a database table.

What is a SQL query

How can we create, edit and remove database tables.

What types of SQL queries can we use to interrogate a database table

A look at how we can install a database and associated components in both a Windows PC environment as well as MAC OS environment

The basics of using operators which we can then use to construct more complex queries

The various SQL constraints are introduced and we look at how and why these are used and how we can use them within our queries to ensure data integrity.

The practice questions and scenarios provide a useful way to test what you have learnt in each module and consolidate your knowledge. These increase in difficulty and refer back to previous tutorials so you build on your existing knowledge.

_________________________________________________________________________

I hope this course is able to provide all you need to begin your experience of SQL.

Michael Da Costa

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Course Introduction

Chapter 2: Introducing SQL and the Database Management System

Lecture 1: What is SQL

Lecture 2: What is a database

Lecture 3: Tables and where they sit in a RDBMS

Chapter 3: Basic SQL clauses

Lecture 1: Select Clause

Lecture 2: Where Clause

Lecture 3: Operators

Chapter 4: More advanced SQL clauses

Lecture 1: And / OR Clauses

Lecture 2: Import

Chapter 5: SQL Constraints

Lecture 1: Not Null / Unique / Primary Key

Lecture 2: Foreign Key

Lecture 3: Auto Increment

Lecture 4: Update Constraints

Lecture 5: Naming / Dropping Constraints

Chapter 6: Table Joins

Lecture 1: Table Join Basics

Lecture 2: Types of Table Join

Lecture 3: Table Join Example 1

Lecture 4: Table Join Example 2

Instructors

Michael Da Costa
Business Analyst

Rating Distribution

1 stars: 4 votes

2 stars: 5 votes

3 stars: 23 votes

4 stars: 43 votes

5 stars: 64 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!