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 Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching 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 Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 8 hours on-demand video
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development SQL

Introduction to SQL Databases - SQL for Beginners

Mastering the language of databases - learning Structured Query Language using Microsoft SQL Server.
Rating: 4.5 out of 54.5 (94 ratings)
313 students
Created by David Medlock
Last updated 1/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • SQL Database Development with MIcrosoft SQL Server
  • Relational Database Management Systems (RDBMS)
  • Structured Query Language (SQL)
  • Microsoft SQL Server
  • Database Queries
  • Database Design using ERDs

Course content

11 sections • 64 lectures • 7h 52m total length

  • Preview03:50
  • Preview01:35
  • Preview01:41
  • Preview02:49

  • Preview05:33
  • Preview01:39
  • Preview02:09

  • Installing SQL Server
    05:56
  • Installing SQL Server Management Studio
    03:06
  • SQL Server Management Studio (SSMS) Tour
    17:24
  • Creating our First Database
    02:38

  • Database Building Blocks Overview
    04:04
  • Tables & Primary Keys
    04:37
  • LAB 1: Tables & Identity Field Primary Keys
    09:12
  • LAB 2: Tables & Composite Primary Keys
    09:34
  • LAB 3: Tables & GUID/UUID Primary Keys
    09:20
  • Columns
    04:10
  • LAB 4: Column Data Type Documentation
    06:40
  • LAB 5: Specifying Column Data Types
    12:37
  • LAB 6: Column Data Type Sizes & Differents
    10:41
  • LAB 7: Mismatched Data Types in Columns
    06:16
  • Got It? Columns and Data Types
    4 questions
  • Foreign Keys
    02:41
  • LAB 8: Foreign Keys & Referential Integrity
    14:23
  • LAB 9: Foreign Keys Within the Same Table
    11:40
  • Naming Our Database Objects & Reserved Words
    06:14
  • Standardizing Naming Conventions
    07:10

  • Introduction to SQL
    07:27
  • LAB 10: Generating SQL with SQL Management Studio
    10:29
  • LAB 11: More SQL Exploration
    13:07
  • Mid-Course Break
    00:45

  • Planning & Designing Our Database
    01:52
  • Database Requirements for Data Dweebs V1
    03:13
  • Database Design Approach
    03:33
  • Entity Relationship Diagrams (ERDs) and Other Key Terms
    06:21
  • LAB 12: Creating Our Entity Relationship Diagram (ERD)
    16:50

  • LAB 13: Creating Our Database Structure in SSMS
    08:46
  • LAB 14: GitHub Repository for the Course
    01:40
  • LAB 15: SQL Fiddle
    03:29
  • EXERCISE: Create the Database Schema
    01:34
  • LAB 16: Database Schema Exercise Review
    08:23

  • LAB 17: INSERT Statements Part 1
    05:04
  • LAB 18: INSERT Statements Part 2
    17:41
  • LAB 19: Seeding our Project Database
    09:31

  • LAB 20: SELECT Statements
    12:04
  • Got It? Basic SELECT Statements
    4 questions
  • LAB 21: WHERE Clauses, Part 1
    24:29
  • LAB 22: WHERE Clauses, Part 2
    07:07
  • LAB 23: Multiple Criteria in WHERE Clauses with AND/OR
    15:27
  • Got It? WHERE Clauses
    5 questions
  • Introduction to JOINs
    04:38
  • LAB 24: INNER JOINs
    12:45
  • LAB 25: LEFT and RIGHT OUTER JOINs
    11:08
  • LAB 26: FULL JOINs and CROSS JOINs
    08:07
  • LAB 27: Sorting Query Results with ORDER BY Clauses
    10:47
  • LAB 28: Aggregate Functions & Grouping
    23:38
  • LAB 29: TOP Statements
    04:56
  • LAB 30: DISTINCT Statements
    03:43
  • LAB 31: CASE Statements
    15:10
  • EXERCISE: Utilization Report Requirements
    00:53
  • EXERCISE: Utilization Report Solution
    04:33
  • EXERCISE: Invoice Report Requirements
    00:32
  • EXERCISE: Invoice Report Solution
    07:50

  • LAB 32: UPDATE Statements
    09:09
  • LAB 33: DELETE Statements
    03:53

Requirements

  • No prior knowledge or experience required

Description

Structured Query Language (SQL or "Sequel") is the way we communicate with a relational database. It's an intuitive and powerful language and mastering it is rapidly becoming a prerequisite for career paths outside of software development.


SQL has been one of the most common skill sets required by employers for software developers for years, according to research published by Indeed. That fact is not likely to change any time soon, as businesses have woken up to the reality that the data they capture, generate, and store has tremendous business value to improve performance and efficiency and uncover new paths for growth.


If you're a software developer just getting started, a Business Analyst, a Test Engineer, Project Manager looking to augment your technical skill set, or a data or financial analyst who works primarily with spreadsheets, you'll benefit from taking this course to learn how you can power up your data skills. We start from the ground up to teach you what a relational database is, how to plan and build a database structure, how to get data into your database, and then how to work with it to retrieve meaningful insights using SQL.


In this course, you will learn:

  • What a Relational Database is

  • How to install Microsoft SQL Server and SQL Server Management Studio on your local computer

  • How to use SQL Server Management Studio to create, explore, and query a database

  • How to research SQL Server functionality using the online documentation

  • Database Design Techniques including how to diagram a database using an Entity Relationship Diagram (ERD)

  • The basic database structures: tables, columns, data types, primary keys, and foreign key relationships

  • Best practices for how to name your database elements (objects)

  • How to learn SQL by automatically generating queries and SQL statements with SQL Server Management Studio

  • Inserting data into tables using the INSERT statement

  • Retrieving and filtering data using SELECT statements and WHERE clauses

  • Extracting data from multiple tables with a single query using INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and CROSS JOIN statements

  • Sorting query results

  • Aggregating data with aggregate functions like SUM and COUNT and GROUP BY clauses (very important for building reports and summarizing data!)

  • Updating and deleting data with UPDATE and DELETE statements


This course is very hands on! It is structured as a series of lectures to help you understand what we'll do with labs, exercises, and quizzes along the way so that you're involved right from the start.

Who this course is for:

  • Beginning Developers who need to use SQL in their applications
  • Business Analysts, Project Managers, or Test Engineers/Analysts who want to extend their skill set and advance their careers
  • Data and Financial Analysts who want to use SQL databases to level up their game
  • Anyone interested in a career in data analytics, data science, or software development

Instructor

David Medlock
CTO, Founder, and Instructor
David Medlock
  • 4.5 Instructor Rating
  • 94 Reviews
  • 313 Students
  • 1 Course

I have over 20 years of experience developing software for companies large and small, including 10 years of experience leading software development teams. My experience has taught me that learning is a never-ending endeavor and that being able to apply what you learn in practical ways is critical to success. I'm excited to help you learn new skills to advance your career!

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