Introduction to SQL Training

This SQL training course is designed for students new to writing SQL queries. Build applications and generate reports.
5 reviews
TAUGHT BY
  • Webucator Training Global training company. Trained over 26,000 students. Thousands of student testimonials.
    • Founded in 2003.
    • Webucator provides technical and business training.
    • Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS)
    • Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for its training courses.
    • Webucator has a GSA Contract (GS-35F-0556S).
    • We have provided training to over 70% of the Fortune 100 companies (See Partial Client List).
    Why should you choose us?
WHAT'S INSIDE
  • Lifetime access to 55 lectures
  • 3+ hours of high quality content
  • A community of 200+ students learning together!
SHARE

Introduction to SQL Training

This SQL training course is designed for students new to writing SQL queries. Build applications and generate reports.
5 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

Learn and practice real-world skills and achieve your goals.

COURSE DESCRIPTION

Introduction to SQL

Have you found yourself interested in learning all of the basics of writing SQL queries? We have the course for you. Designed by Webucator, a global training partner, this course covers all of the best activities to get you started. And it's packed with readings, trainer presentations, and exercises!

This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports.

For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

Class Goals
  • Understand how relational databases work
  • Learn to use SQL to output reports
  • Learn to write queries getting data from multiple tables.

This engaging course also comes with template exercise files ready to start using right away. To download, visit: http://www.webucator.com/portal/wiki/index.cfm/SQL101.

    • Over 55 lectures and 3.5 hours of content!

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • 1
    Class Files
    422.82 KB
  • 2
    Course Introduction
    01:59
  • SECTION 1:
    Relational Database Basics
  • 3
    Brief History of SQL
    Text
    Brief History of SQL In 1970, Dr. E.F. Codd published "A Relational Model of Data for Large Shared Data Banks," an article that outlined a model for storing and manipulating data using tables. Shortly after Codd's article was published, IBM began working on creating a relational database. Between 19…
  • 4
    Relational Databases
    Text
    Relational Databases A relational database at its simplest is a set of tables used for storing data. Each table has a unique name and may relate to one or more other tables in the database through common values. Tables A table in a database is a collection of rows and columns. Tables are also known…
  • 5
    Popular Databases
    Text
    Popular Databases Commercial Databases Oracle Oracle is the most popular relational database. It runs on both Unix and Windows. It used to be many times more expensive than SQL Server and DB2, but it has come down a lot in price. SQL Server SQL Server is Microsoft's database and, not surprisingly, o…
  • 6
    SQL Statements
    Text
    SQL Statements Database Manipulation Language (DML) DML statements are used to work with data in an existing database. The most common DML statements are: SELECT INSERT UPDATE DELETE Database Definition Language (DDL) DDL statements are used to structure objects in a database. The most common DDL st…
  • 7
    Relational Database Concepts
    06:25
  • SECTION 2:
    Simple SELECTs
  • 8
    Introduction to the Northwind Database
    Text
    Introduction to the Northwind Database The Northwind database is a sample database used by Microsoft to demonstrate the features of some of its products, including SQL Server and Microsoft Access. The database contains the sales data for Northwind Traders, a fictitious specialty foods export-import…
  • 9
    Exploring the Tables
    Text
    Exploring the Tables Duration: 10 to 20 minutes. In this exercise, you will explore all the data in the Northwind database by selecting all the rows of each of the tables. Select all columns of all rows from the tables below. The number of records that should be returned is indicated in parentheses…
  • 10
    SELECTing Specific Columns
    Text
    SELECTing Specific Columns The following syntax is used to retrieve specific columns in all rows of a table. Syntax SELECT table_name.column_name, table_name.column_name FROM table; -- OR SELECT column, column FROM table; Code Sample: SimpleSelects/Demos/SelectCols.sql /* Select the FirstName and La…
  • 11
    Using SELECT Demo
    06:15
  • 12
    SELECTing Specific Columns (Exercise)
    Text
    SELECTing Specific Columns Duration: 5 to 15 minutes. In this exercise, you will practice selecting specific columns from tables in the Northwind database. Select  CategoryName  and  Description  from the  Categories  table. Select  ContactName ,  CompanyName ,  ContactTitle  and  Phone  from the  C…
  • 13
    Sorting Records
    Text
    Sorting Records The  ORDER BY  clause of the  SELECT  statement is used to sort records. Sorting By a Single Column To sort by a single column, simply name that column in the  ORDER BY  clause. Syntax SELECT column, column FROM table ORDER BY column; Note that columns in the  ORDER BY  clause do not…
  • 14
    Sorting Demo
    05:06
  • 15
    Sorting Results
    Text
    Sorting Results Duration: 5 to 15 minutes. In this exercise, you will practice sorting results in  SELECT  statements. Select  CategoryName  and  Description  from the  Categories  table sorted by  CategoryName . Select  ContactName ,  CompanyName ,  ContactTitle , and  Phone  from the  Customers  t…
  • 16
    The WHERE Clause and Operator Symbols
    Text
    The WHERE Clause and Operator Symbols The  WHERE  clause is used to retrieve specific rows from tables. The  WHERE  clause can contain one or more conditions that specify which rows should be returned. Syntax SELECT column, column FROM table WHERE conditions; The following table shows the symbolic o…
  • 17
    WHERE Clause Demo
    06:51
  • 18
    Using the WHERE clause to check for equality or inequality
    Text
    Using the WHERE clause to check for equality or inequality Duration: 5 to 15 minutes. In this exercise, you will practice using the  WHERE  clause to check for equality and inequality. Create a report showing all the company names and contact names of Northwind's customers in Buenos Aires. Create a…
  • 19
    Using the WHERE clause to check for greater or less than
    Text
    Using the WHERE clause to check for greater or less than Duration: 5 to 15 minutes. In this exercise, you will practice using the  WHERE  clause to check for values greater than or less than a specified value. Create a report that shows the employee id, order id, customer id, required date, and ship…
  • 20
    Checking for NULL
    Text
    Checking for NULL Duration: 5 to 15 minutes. In this exercise, you will practice selecting records with fields that have  NULL  values. Create a report that shows the company name, contact name and fax number of all customers that have a fax number. Create a report that shows the first and last name…
  • 21
    Using WHERE and ORDER BY Together
    Text
    Using WHERE and ORDER BY Together Duration: 5 to 15 minutes. In this exercise, you will practice writing  SELECT  statements that use both  WHERE  and  ORDER BY . Create a report that shows the company name, contact name and fax number of all customers that have a fax number. Sort by company name. C…
  • 22
    The WHERE Clause and Operator Words
    Text
    The WHERE Clause and Operator Words The following table shows the word operators used in WHERE conditions. SQL Word Operators Operator Description BETWEEN Returns values in an inclusive range IN Returns values in a specified subset LIKE Returns values that match a simple pattern NOT Negates an opera…
  • 23
    WHERE Clause Operators Demo
    05:51
  • 24
    More SELECTs with WHERE
    Text
    More SELECTs with WHERE Duration: 5 to 15 minutes. In this exercise, you will practice writing  SELECT  statements that use  WHERE  with word operators. Create a report that shows the first and last names and birth date of all employees born in the 1950s. Create a report that shows the product name…
  • 25
    Checking Multiple Conditions
    Text
    Checking Multiple Conditions AND AND  can be used in a  WHERE  clause to find records that match more than one condition. Code Sample: SimpleSelects/Demos/Where-And.sql /* Create a report showing the first and last name of all sales representatives whose title of courtesy is "Mr.". */ SELECT FirstNa…
  • 26
    Multiple Conditions Demo
    07:20
  • 27
    Writing SELECTs with Multiple Conditions
    Text
    Writing SELECTs with Multiple Conditions Duration: 5 to 15 minutes. In this exercise, you will practice writing  SELECT  statements that filter records based on multiple conditions. Create a report that shows the first and last names and cities of employees from cities other than Seattle in the stat…
  • SECTION 3:
    Advanced SELECTs
  • 28
    Calculated Fields
    Text
    Calculated Fields Calculated fields are fields that do not exist in a table, but are created in the  SELECT  statement. For example, you might want to create  FullName  from  FirstName  and  LastName . Concatenation Concatenation is a fancy word for stringing together different words or characters.…
  • 29
    Calculated Fields Demo
    07:34
  • 30
    Calculating Fields
    Text
    Calculating Fields Duration: 10 to 20 minutes. In this exercise, you will practice writing  SELECT  statements with calculated fields. Create a report that shows the unit price, quantity, discount, and the calculated total price using these three fields. Note for SQL Server users only: You will be u…
  • 31
    Aggregate Functions and Grouping
    Text
    Aggregate Functions and Grouping Aggregate Functions Aggregate functions are used to calculate results using field values from multiple records. There are five common aggregate functions. Common Aggregate Functions Aggregate Function Description COUNT() Returns the number of rows containing non-NULL…
  • 32
    Aggregate Functions Demo
    06:54
  • 33
    Working with Aggregate Functions
    Text
    Working with Aggregate Functions Duration: 10 to 20 minutes. In this exercise, you will practice working with aggregate functions. Create a report that returns the following from the Order_Details table. The report should only return rows for which  TotalUnits  is less than 200. 2. Create a report t…
  • 34
    Built-in Data Manipulation Functions
    Text
    Built-in Data Manipulation Functions In this section, we will discuss some of the more common built-in data manipulation functions. Unfortunately, the functions differ greatly between databases, so you should be sure to check your database documentation when using these functions. The tables below s…
  • 35
    Data Manipulation Demo
    09:35
  • 36
    Data Manipulation Functions
    Text
    Data Manipulation Functions Duration: 10 to 20 minutes. In this exercise, you will practice using data manipulation functions. Create a report that shows the units in stock, unit price, the total price value of all units in stock, the total price value of all units in stock rounded down, and the tot…
  • SECTION 4:
    Subqueries, Joins and Unions
  • 37
    Subqueries
    Text
    Subqueries Subqueries are queries embedded in queries. They are used to retrieve data from one table based on data in another table. They generally are used when tables have some kind of relationship. For example, in the Northwind database, the  Orders  table has a  CustomerID  field, which referenc…
  • 38
    Subquery Demo
    06:21
  • 39
    Subqueries (Exercise)
    Text
    Subqueries Duration: 20 to 30 minutes. In this exercise, you will practice writing subqueries. Create a report that shows the product name and supplier id for all products supplied by Exotic Liquids, Grandma Kelly's Homestead, and Tokyo Traders. You will need to escape the apostrophe in "Grandma Kel…
  • 40
    Joins
    Text
    Joins How can we find out Which products are provided by which suppliers? Which customers placed which orders? Which customers are buying which products? Such reports require data from multiple tables. Enter joins. Syntax SELECT table1.column, table2.column FROM table1 JOIN table2 ON (table1.column=…
  • 41
    Using Joins Demo
    08:43
  • 42
    Using Joins
    Text
    Using Joins Duration: 25 to 40 minutes. In this exercise, you will practice using joins. 1. Create a report that shows the order ids and the associated employee names for orders that shipped after the required date. It should return the following. There should be 37 rows returned. 2. Create a report…
  • 43
    Outer Joins
    Text
    Outer Joins So far, all the joins we have worked with are inner joins, meaning that rows are only returned that have matches in both tables. For example, when doing an inner join between the  Employees  table and the  Orders  table, only employees that have matching orders and orders that have match…
  • 44
    Unions
    Text
    Unions Unions are used to retrieve records from multiple tables or to get multiple record sets from a single table. Code Sample: SubqueriesJoinsUnions/Demos/Unions.sql /* Get the phone numbers of all shippers, customers, and suppliers */ SELECT CompanyName, Phone FROM Shippers UNION SELECT CompanyNa…
  • 45
    Outer Joins and Unions
    08:34
  • 46
    Working with Unions
    Text
    Working with Unions Duration: 10 to 20 minutes. In this exercise, you will practice using  UNION . Create a report showing the contact name and phone numbers for all employees, customers, and suppliers. Solution: SubqueriesJoinsUnions/Solutions/Unions.sql /****************************** SQL Server S…
  • SECTION 5:
    Conditional Processing with CASE
  • 47
    Using CASE
    Text
    Using CASE CASE  functions contain one or more  WHEN  clauses as shown below. Syntax --OPTION 1 SELECT CASE column WHEN VALUE THEN RETURN_VALUE WHEN VALUE THEN RETURN_VALUE WHEN VALUE THEN RETURN_VALUE WHEN VALUE THEN RETURN_VALUE ELSE RETURN_VALUE END AS ColumnName FROM table --OPTION 2 SELECT CASE…
  • 48
    Using Case Demo
    08:18
  • 49
    Working with CASE
    Text
    Working with CASE Duration: 10 to 15 minutes. In this exercise you will practice using  CASE . Create a report that shows the company names and faxes for all customers. If the customer doesn't have a fax, the report should show "No Fax" in that field as shown below. Solution: Case/Solutions/Case.sql…
  • SECTION 6:
    Inserting, Updating and Deleting Records
  • 50
    INSERT
    Text
    INSERT To insert a record into a table, you must specify values for all fields that do not have default values and cannot be  NULL . Syntax INSERT INTO table (columns) VALUES (values); The second line of the above statement can be excluded if all required columns are inserted and the values are list…
  • 51
    INSERT Demo
    05:43
  • 52
    Inserting Records
    Text
    Inserting Records Duration: 5 to 15 minutes. In this exercise, you will practice inserting records. Insert yourself into the  Employees  table. Include the following fields:  LastName ,  FirstName ,  Title ,  TitleOfCourtesy ,  BirthDate ,  HireDate ,  City ,  Region ,  PostalCode ,  Country ,  Home…
  • 53
    UPDATE and DELETE
    Text
    UPDATE The  UPDATE  statement allows you to update one or more fields for any number of records in a table.  You must be very careful not to update more records than you intend to! Syntax UPDATE table SET field = value, field = value, field = value WHERE conditions; Code Sample: InsertsUpdatesDelete…
  • 54
    UPDATE and DELETE Demo
    05:54
  • 55
    Updating and Deleting Records
    Text
    Updating and Deleting Records Duration: 5 to 15 minutes. In this exercise, you will practice updating and deleting records. Update your record in the  Employees  table to include some  Notes . Raise the unit price of all products in the  Products  table by 10% for all products that are out of stock.…

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students

RATING

  • 2
  • 3
  • 0
  • 0
  • 0
AVERAGE RATING
NUMBER OF RATINGS
5

REVIEWS

  • Jeff Long
    Easy to follow, self paced

    I like both formats of the videos and the follow up exercises. For an intro course, just perfect amount of info; able to write queries after finishing the first half of the course. Wish Udemy offered an intermediate course!

  • Tzyy-Jye Doong

    It is very simple and easy to follow

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED: