-40%

Learn Introductory SQL Video Training Tutorial DVD & Digital Professional Course

$ 7.91

Availability: 89 in stock
  • Return shipping will be paid by: Buyer
  • Brand: TeachUcomp, Inc.
  • Condition: Brand New
  • MPN: TUSQLC01
  • All returns accepted: Returns Accepted
  • Refund will be given as: Money Back
  • Type: Software Training/IT Tutorials
  • Platform: PC or MAC
  • UPC: 815474011809
  • Item must be returned within: 30 Days

    Description

    Learn Introductory SQL Video Training Tutorial DVD & Digital Professional Course
    Learn Introductory SQL Video Training Tutorial DVD & Digital Professional Course
    Learn Introductory SQL Video Training Tutorial DVD-ROM Professional Course
    Learn Introductory SQL Video Training Tutorial Digital Professional Course
    Mastering Introductory SQL Made Easy Digital Self-Study Training Course
    DVD-ROM and Digital Course. We grant you fast access while your DVD-ROM is shipped.
    Within one business day following purchase, you will receive a message from us through the eBay messaging system that contains your login credentials and instructions to download your course from our site. The course downloads to your PC or Mac and is yours to keep. You will also receive one year online access to the course that you can view from any computer or mobile device with an internet connection. We will then ship a hard copy of your DVD-ROM to your confirmed eBay shipping address.
    Product Details:
    Product Name:
    Mastering SQL Made Easy
    Manufacturer:
    TeachUcomp, Inc.
    Course Length:
    3 Hours
    Video Lessons:
    43
    Instruction Manuals:
    1 (PDF)
    Product Type:
    DVD-ROM, Download & Online Access
    Learn Introductory SQL with this comprehensive 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.
    Topics Covered:
    Introduction to Databases and SQL
    1. Overview of a Databse
    2. The "Flat-File" Method of Data Storage
    3. The Relational Model of Data Storage
    4. Tips for Creating a Relational Database
    5. What is SQL?
    6. Using SQL in Access 2013
    Data Definition Language
    1. The CREATE Statement
    2. The CREATE DATABASE Statement
    3. The CREATE TABLE Statement
    4. The CREATE INDEX Statement
    5. SQL Constraints
    6. The DROP Statement
    7. The ALTER TABLE Statement
    8. NULL Values in SQL
    9. Data Types in SQL
    10. Auto-Increment in SQL
    Data Manipulation Language
    1. The INSERT Statement
    2. The UPDATE Statement
    3. The DELETE Statement
    4. The SELECT Statement
    5. The WHERE Clause
    6. Criteria Notation and Wildcard Characters in WHERE Clause
    7. The ORDER BY Clause
    8. The GROUP BY Clause and Aggregate Functions
    9. The UNION Operator
    10. The SELECT INTO Statement
    11. The SELECT INTO Statement
    12. The INSERT INTO SELECT Statement
    13. Subqueries
    Data Control Language
    1. The CREATE USER and CREATE ROLE Statements
    2. Privileges
    3. The GRANT Statement
    4. The REVOKE Statement
    5. The ALTER USER and ALTER ROLE Statements
    6. The DROP USER and DROP ROLE Statements
    Transaction Control Language
    1. The TRANSACTION Statement
    SQL Functions and Aliases
    1. Understanding SQL Functions
    2. Calculated Fields and Column Aliases
    3. Table Aliases
    Views
    1. About Views
    2. The CREATE VIEW Statement
    3. The ALTER VIEW Statement
    4. The DROP VIEW Statement
    Minimum System Requirements:
    1 GHz Intel Pentium Processor or equivalent
    Windows or MAC
    DVD-ROM Drive
    1 GB RAM
    256 color SVGA capable of 1024x768 resolution
    Speakers or headphones
    High-Speed Internet Connection
    Payment
    Shipping
    Returns
    Contact
    We accept
    PayPal
    for all orders.
    Please pay as soon as possible after winning an auction, as that will allow us to ship your item to you sooner!
    We offer
    FREE shipping
    on all U.S. orders.
    Your order will be shipped within 1 business day of receiving payment (Monday-Friday).
    In the very unlikely event that your item is lost or damaged during shipment, please be sure to let us know. We will issue either a full refund or replacement.
    If you are not 100% satisfied with your purchase, you can return the product and get a full refund (minus any shipping costs) or exchange the product for another one.
    You can return a product for up to 30 days from the date you purchased it.
    Any product you return must be in the same condition you received it and in the original sealed packaging.
    Please use the eBay message center to contact us. This assures that we receive your message. We are open Monday through Friday 9-5 Eastern and will answer you within one business day.
    We're always happy to answer questions. We want to make your buying experience as pleasurable as possible.
    Listing and template services provided by inkFrog Open.
    Payment
    Shipping
    Returns
    Contact
    We accept
    PayPal
    for all orders- the safest way to shop on eBay.
    Digital Items:
    No shipping means fast access to your course.
    Within one business day following purchase, you will receive a message from us through the eBay messaging system that contains your login credentials and instructions to access your course from our site.
    Physical Products:
    We offer
    FREE shipping
    U.S. orders.
    Your order will be shipped within 1 business day of receiving payment (Monday-Friday).
    In the very unlikely event that your item is lost or damaged during shipment, please be sure to let us know. We will issue either a full refund or replacement.
    If you are not 100% satisfied with your purchase, you can return the product and get a full refund (minus any shipping costs) or exchange the product for another one.
    You can return a product for up to 30 days from the date you purchased it.
    Any physical product you return must be in the same condition you received it and in the original sealed packaging.
    Please use the eBay message center to contact us. This assures that we receive your message. We are open Monday through Friday 9-5 Eastern and will answer you within one business day.
    We're always happy to answer questions. We want to make your buying experience as pleasurable as possible.
    Listing and template services provided by inkFrog