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
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Figure Drawing Canva
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation 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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing 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
IT & Software Other IT & Software SQL

Practical SQL Skills from Intermediate to Advanced

Improve your SQL skills and step up to the next level to learn more and take full command of SQL
Rating: 3.6 out of 53.6 (248 ratings)
1,419 students
Created by Gary Kind
Last updated 1/2016
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Understand more advanced SQL Server features
  • How to apply these techniques to real world problems
  • Enhance your SQL Skills

Requirements

  • A good understanding of basic SQL
  • Microsoft SQL Server Express (free download and the course explains everything)

Description

This course is designed to further your understanding of structured query language (SQL) for manipulating business data.

Once you have the basics mastered you can take your knowledge to the next level to fully harness the power of Microsoft SQL Server as well as look at how to maximise the performance of any SQL that you write.

The course contains walk through videos, printed documents of the course material as well as links to resources you need to be able to carry out the course.

The course does assume a good working knowledge of SQL to get the most out of this course. If you want an introductory course then I have also authored a course for beginners (https://www.udemy.com/practical-sql-skills-from-beginner-to-intermediate/).

If you need to access any data be it online or within your own company then this course is for you. Financial systems form the hub of any business these days and many job roles require some level of SQL ability. This course will equip you with the knowledge you need to perform these tasks within your business or employment to improve your prospects.

Most business systems utilise some form of SQL database, typically Microsoft SQL Server which is why this course focuses on that particular product. Additionally we can download a free 'express' version of the product to work through the course.

Who this course is for:

  • Those looking to build upon their basic SQL skills
  • Employees looking to increase their knowledge and add value to a business
  • Business owners looking to full harness the data within their business

Course content

11 sections • 35 lectures • 3h 48m total length

  • Preview04:24
  • Preview01:07
  • Preview02:36
  • Preview02:06
  • Installing Our Large Dataset (Nile Trading) Database
    03:38
  • Generating a Large Amount of Data
    02:23
  • Coding and Style Conventions
    07:19

  • Self JOINs
    03:32
  • CROSS Joins
    05:33

  • INSERT with SELECT
    06:57
  • UPDATE with JOIN
    04:08
  • DELETE with JOIN
    01:38

  • Import data from CSV
    11:41
  • Using MERGE Statement
    15:07

  • ROLLUP and CUBE
    06:41
  • GROUPING SETS
    04:43

  • Indexing and Index Types
    07:47
  • Primary and Foreign Keys
    05:14
  • Constraints
    05:01

  • VIEWs
    05:13
  • Common Table Expressions Part 1
    05:48
  • Common Table Expressions Part 2
    08:11
  • RANK and ROWNUMBER
    08:13
  • Deciles and Quartiles with NTILE
    04:01

  • Introducing Triggers
    19:37
  • Temporary Tables
    06:17

  • Writing TransactSQL Part 1
    04:59
  • Writing TransactSQL Part 2 (transactions and try/catch)
    10:09
  • Table Functions
    06:37
  • Scalar Functions
    17:31

  • Basic Optimisation Tips
    10:24
  • More Optimisation
    07:03
  • Indexed Views
    08:14

Instructor

Gary Kind
Techie with Marketing and Business Startup Knowledge
Gary Kind
  • 4.1 Instructor Rating
  • 1,807 Reviews
  • 57,151 Students
  • 9 Courses

Gary Kind is a highly experienced IT professional and business owner with over 25 years in and around software development and 20+ years running businesses as an individual and in partnerships.

He has a wide spread of business knowledge working in the SME sector as well as delivering KPI and financial reporting for large corporations. He has spent the past few years combining marketing with IT to cover areas such as pay per click, copywriting and conversion optimisation.

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