Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Startup Business Plan Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-04 15:55:54
30-Day Money-Back Guarantee
Development Database Design & Development SQL

SQL Basics 2-Hour Crash Course

Learn SQL in this 2-hour crash course! Get hands-on practice with a Microsoft Certified Trainer!
Rating: 4.6 out of 54.6 (17 ratings)
311 students
Created by Webucator Training
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Master the basics of data manipulation using SQL!
  • Start from the beginning with relational database concepts.
  • Get comfortable pulling data with simple SELECT queries.
  • Work with advanced SELECTs and data manipulation.
  • Leverage more complex data retrieval by using subqueries, joins, outer joins, and unions.
  • Use CASE statements to specify conditions when retrieving data.
  • Maintain your records with INSERT, UPDATE, and DELETE.
  • Learn one of the most marketable and important languages in today's data-driven world.

Course content

7 sections • 55 lectures • 2h 43m total length

  • Class Files
    433.0 kB
  • Preview01:59

  • Preview06:25
  • Brief History of SQL
    00:42
  • Relational Databases
    02:06
  • Popular Databases
    01:13
  • SQL Statements
    01:03

  • Introduction to the Northwind Database
    01:28
  • Exploring the Tables
    00:55
  • SELECTing Specific Columns
    00:16
  • Preview06:15
  • SELECTing Specific Columns (Exercise)
    01:42
  • Sorting Records
    01:32
  • Sorting Demo
    05:06
  • Sorting Results
    02:15
  • The WHERE Clause and Operator Symbols
    01:31
  • WHERE Clause Demo
    06:51
  • Using the WHERE clause to check for equality or inequality
    01:34
  • Using the WHERE clause to check for greater or less than
    01:12
  • Checking for NULL
    00:44
  • Using WHERE and ORDER BY Together
    00:58
  • The WHERE Clause and Operator Words
    02:20
  • WHERE Clause Operators Demo
    05:51
  • More SELECTs with WHERE
    01:28
  • Checking Multiple Conditions
    01:40
  • Multiple Conditions Demo
    07:20
  • Writing SELECTs with Multiple Conditions
    00:52

  • Calculated Fields
    01:30
  • Calculated Fields Demo
    07:34
  • Calculating Fields
    00:54
  • Aggregate Functions and Grouping
    02:40
  • Aggregate Functions Demo
    06:54
  • Working with Aggregate Functions
    00:55
  • Built-in Data Manipulation Functions
    03:03
  • Data Manipulation Demo
    09:35
  • Data Manipulation Functions
    01:37

  • Subqueries
    01:20
  • Subquery Demo
    06:21
  • Subqueries (Exercise)
    01:20
  • Joins
    02:29
  • Using Joins Demo
    08:43
  • Using Joins
    01:37
  • Outer Joins
    02:34
  • Unions
    01:09
  • Outer Joins and Unions
    08:34
  • Working with Unions
    00:52

  • Using CASE
    01:43
  • Using Case Demo
    08:18
  • Working with CASE
    00:19

  • INSERT
    01:19
  • INSERT Demo
    05:43
  • Inserting Records
    02:09
  • UPDATE and DELETE
    01:42
  • UPDATE and DELETE Demo
    05:54
  • Updating and Deleting Records
    01:13

Requirements

  • None.

Description

Need to start writing SQL queries fast? This is your course.

Delivered by Microsoft Certified SQL Server Trainer Bruce Gordon, this course includes video demonstrations, 16 hands-on exercises, and printable readings.

This course is designed for students who are brand-new to writing SQL queries. We leave out the advanced stuff and focus on the concepts that you actually need.   

The SQL learned in the course is applicable to nearly all major databases.

Who this course is for:

  • Beginners who need SQL skills to manage and manipulate data.

Instructor

Webucator Training
Global training company. Trained over 26,000 students. Thousands of student testimonials.
Webucator Training
  • 4.2 Instructor Rating
  • 66 Reviews
  • 13,025 Students
  • 7 Courses
  • 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?
  • We care about delivering great training. Really, that's why.
  • View Our Client Testimonials.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.