Practical SQL Skills from Intermediate to Advanced
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
- Preview04:24
- Preview01:07
- Preview02:36
- Preview02:06
- 03:38Installing Our Large Dataset (Nile Trading) Database
- 02:23Generating a Large Amount of Data
- 07:19Coding and Style Conventions
Instructor
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.