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 CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation 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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
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
Development Database Design & Development SQL

SQL Database MasterClass: Go From Pupil To Master!

This is a SQL MasterClass that gets you immediate hands on experience with a database. From design to Mastery Class!
Rating: 4.5 out of 54.5 (406 ratings)
14,254 students
Created by Rico Rodriguez
Last updated 3/2016
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Design a Complex Database For Any Line Of Business Application
  • Understand Primary and Foreign Keys
  • Understand Simple and Complex SQL Statements

Course content

17 sections • 49 lectures • 6h 2m total length

  • Preview05:28
  • Hit the High Def Button Please
    00:06
  • Section 1 quiz
    3 questions

  • Preview05:57
  • Preview07:33
  • Preview15:04
  • Section 2 quiz
    5 questions

  • How to Create Keys In SQL And Why
    10:18
  • Look What Keys Buy You
    01:50
  • Section 3 quiz
    3 questions

  • Adding Data To Your Database
    11:35

  • Select Statement In SQL
    10:13
  • Preview03:45
  • Select Exercises to Help You Learn SQL Faster
    03:50
  • Preview17:05
  • Lets Talk About The Order By Clause In SQL
    06:54
  • Where Clause Deep Dive
    07:15
  • Lets Discuss The Like and the In Statements
    08:02
  • Preview11:25
  • More Complex Analytics: Group By Clause
    07:48
  • Section 5 quiz
    7 questions

  • Preview09:27
  • Section 6 quiz
    1 question

  • Course Slides and Material Up To Now
    39 pages

  • Inner Join
    15:33
  • Preview07:27
  • Section 8 quiz
    1 question

  • Preview02:06
  • Scalar Functions
    10:22
  • Scalar Functions SQL Statments
    00:08
  • Table Functions
    04:52
  • Table Functions SQL Statements
    00:24
  • Section 9 quiz
    2 questions

  • Lets Talk About Views
    05:24
  • View SQL Statements
    00:06

Requirements

  • We teach you how to download SQL Server Management Studio 2014 Express.

Description

  • Do you want to SKY ROCKET your Income?
  • Do you want to master the skill of SQL.
  • Do you have an Interview coming up where you know SQL would look amazing on your resume?

Low pay SQL developers make $60,000 per year. In this course you will learn the skills necessary to rock out SQL Statements, Views, Stored Procedures and more.

In this course you will Design a database from scratch so that you understand the thought process that goes into such a design. We will then bring in the basic skills of SQL and give you example upon example of how to use this skill while building on those basic skills adding in more technique and more difficulty until they become more advanced. You will learn skills that even you average DBA doesn't do properly.

  • SQL Statements
  • Views
  • Stored Procedures
  • Triggers
  • User Defined Functions
  • and a lot more!

When you are done with this course, you will be able to walk into a interview with a calm confidence and show them that you know what you are doing and apply these skills to build the database back end for an application that will stand the test of time.

If you want a better career take this course you will not be disappointed.

Enroll with confidence! Your enrollment is backed by Udemy's 30-day, no-questions-asked, money-back guarantee!



Who this course is for:

  • If You have never Seen a Database You Should Take this course
  • If you want to know how to speed up Queries you should take this course.

Instructor

Rico Rodriguez
SQL Architect, Senior Software Developer, Project Manager
Rico Rodriguez
  • 4.0 Instructor Rating
  • 750 Reviews
  • 23,176 Students
  • 6 Courses

I have spent my life teaching others how to be better developers and master the art that is Software Engineering.

I have designed many Enterprise level applications as well as IOS and Android Applications. The skills I teach in my courses is the same skills that I use every day to do everything from running my teams to consulting on Enterprise level projects.

In my career I have found classes like this to be helpful in advancing my career and I wanted to make courses for people that really showed you end to end classes that weren't as simple as "Hello World". My goal as an instructor is to drive you to the next level in your careers, and if you want to do that, it takes 3 things. Knowledge, Leadership, Ingenuity. These are the 3 skills that i have used to take my career to the next level.

I have also been a father for 9 years. Throughout those years I have learned so much about myself and raising children. I have been on both sides of the fence from raising step-children and now raising my own son. It has been the experience of a lifetime and I would love to share any of my experiences with you so that you don't have to go through all the same learning curves that I did.

  • 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.