Mastering Introductory SQL Made Easy Training Tutorial

Mastering Introductory SQL Made Easy Training Tutorial, available at $44.99, has an average rating of 4.2, with 46 lectures, based on 18 reviews, and has 99 subscribers.

You will learn about Understand the basics of the SQL language Extract, add, update, and delete data within a database Understand the core or essential statements within SQL Use Microsoft Access or SQLite to practice the concepts discussed in the tutorial Use the provided classroom manuals for additional images and practice exercises This course is ideal for individuals who are Anyone wanting to learn SQL or Those who want a brush up on the basics of the SQL database language It is particularly useful for Anyone wanting to learn SQL or Those who want a brush up on the basics of the SQL database language.

Enroll now: Mastering Introductory SQL Made Easy Training Tutorial

Summary

Title: Mastering Introductory SQL Made Easy Training Tutorial

Price: $44.99

Average Rating: 4.2

Number of Lectures: 46

Number of Published Lectures: 46

Number of Curriculum Items: 46

Number of Published Curriculum Objects: 46

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Understand the basics of the SQL language
Extract, add, update, and delete data within a database
Understand the core or essential statements within SQL
Use Microsoft Access or SQLite to practice the concepts discussed in the tutorial
Use the provided classroom manuals for additional images and practice exercises

Who Should Attend

Anyone wanting to learn SQL
Those who want a brush up on the basics of the SQL database language

Target Audiences

Anyone wanting to learn SQL
Those who want a brush up on the basics of the SQL database language

Learn SQL with this video training course from TeachUcomp, Inc. Mastering Introductory SQL Made Easy features 43 video lessons with over 3 hours of expert instruction. SQL is a standardized programming language that is used to create, edit and delete databases and database objects. It is also the language that is used to extract, add, update, and delete data within a database. SQL is used in nearly every aspect of database interactions. Watch, listen and learn as your instructor guides you through the “core,” or essential, statements within SQL. Variations of the core statements for the specific database systems of MySQL 5.7, SQL Server 2012, and Access 2013 will also be referenced by hyperlinks to the associated online documentation for each system. The goal of this course to give the student the knowledge of which SQL statement they will need to use to accomplish specific tasks within a database, as well as provide links to database-specific implementations of those core statements. Reinforce your learning with the text of our printable classroom instruction manual, additional images and practice exercises.

Whether you are completely new to SQL or are simply in need of a refresher or excellent reference source, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch the easy-to-use interface, click to start a video lesson or open the manual and you are on your way to mastering SQL.

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Course Introduction

Chapter 2: Introduction to Databases and SQL

Lecture 1: Overview of a Database

Lecture 2: The ‘Flat-File’ Method of Data Storage

Lecture 3: The Relational Model of Data Storage

Lecture 4: Tips for Creating a Relational Database

Lecture 5: What is SQL?

Lecture 6: Using SQL in Access 2013

Chapter 3: Data Definition Language

Lecture 1: The CREATE Statement

Lecture 2: The CREATE DATABASE Statement

Lecture 3: The CREATE TABLE Statement

Lecture 4: The CREATE INDEX Statement

Lecture 5: SQL Constraints

Lecture 6: The DROP Statement

Lecture 7: The ALTER TABLE Statement

Lecture 8: NULL Values in SQL

Lecture 9: Data Types in SQL

Lecture 10: Auto-Increment in SQL

Chapter 4: Data Manipulation Language

Lecture 1: The INSERT Statement

Lecture 2: The UPDATE Statement

Lecture 3: The DELETE Statement

Lecture 4: The SELECT Statement

Lecture 5: The WHERE Clause

Lecture 6: Criteria Notation & Wildcard Characters in WHERE Clause

Lecture 7: The ORDER BY Clause

Lecture 8: The GROUP BY Clause and Aggregate Functions

Lecture 9: The JOIN Clause

Lecture 10: The UNION Operator

Lecture 11: The SELECT INTO Statement

Lecture 12: The INSERT INTO SELECT Statement

Lecture 13: Subqueries

Chapter 5: Data Control Language

Lecture 1: The CREATE USER and CREATE ROLE Statements

Lecture 2: Privileges

Lecture 3: The GRANT Statement

Lecture 4: The REVOKE Statement

Lecture 5: The ALTER USER and ALTER ROLE Statements

Lecture 6: The DROP USER and DROP ROLE Statements

Chapter 6: Transaction Control Language

Lecture 1: The TRANSACTION Statement

Chapter 7: SQL Functions and Aliases

Lecture 1: Understanding SQL Functions

Lecture 2: Calculated Fields and Column Aliases

Lecture 3: Table Aliases

Chapter 8: Views

Lecture 1: About Views

Lecture 2: The CREATE VIEW Statement

Lecture 3: The ALTER VIEW Statement

Lecture 4: The DROP VIEW Statement

Chapter 9: Conclusion

Lecture 1: Course Conclusion

Chapter 10: Instruction Manual

Lecture 1: Introductory SQL Manual

Instructors

TeachUcomp, Inc.
Quality Software Training

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 3 votes
4 stars: 5 votes
5 stars: 10 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!

Menu