Practical SQL Skills
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course is designed to give a detailed introduction to using and understanding structured query language (SQL) for manipulating business data. More and more companies rely on IT systems that store information in databases. This information is typically retrieved using SQL and its use is becoming widespread amongst not just IT teams but business users also.
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 is laid out over 3 levels starting with the very basics and assumes no prior SQL knowledge, right up to level 3 where we will be looking at Microsoft SQL Server specific functionality to really harness the power of a SQL database.
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.
And the unconditional, Udemy backed, 30 day money-back guarantee is not just any old guarantee, it's my personal promise to you that you will succeed ... just like my thousands of other Udemy students.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction and Getting Started|
|Introduction to the course and a summary of what we will be covering.|
|Run OS X on an iMac or Macbook? Can you run MSSQL on it? Well Yes and No, this video explores your options.|
Where to download Microsoft SQL Server 2008 Express edition and sample data. Be sure to check out the Links document which has all the download links.
|We'll go through the installation process for getting MSSQL setup on your machine.|
|Having installed MSSQL we now need to setup the AdventureWorks sample database before we can progress.|
If you are having trouble with your local instance of Adventureworks use Management Studio you downloaded to connect to a remote instance. This lecture shows you how.
|Section 2: Level 1 Introduction to SQL|
|Just some key points to consider before we begin.|
|We'll take a quick look at Management Studio which is the tool we will be using to write our SQL.|
|Here we will start writing our first piece of SQL|
|Using the ORDER BY clause we can sort our data.|
|How to aggregate data and group it using the GROUP BY command.|
|We will look at the two most common types of join to join 2 tables in one query.|
|Here we look at using UNION to join the results of two tables together.|
|Section 3: Level 2 - Sub-queries, Views and Modifying Data|
|A look at using IN and EXISTS with sub-queries.|
|Using the CASE statement we can perform transformation of data.|
|Staying with the CASE statement we look at how to turn rows into columns with our data.|
|Here we look at creating a VIEW and why you would use one.|
|This lecture looks at how to add records to a table using the INSERT command.|
|We can modify existing data in a table using the UPDATE command and we look at examples of how to do this.|
|Use with caution! This is how we DELETE data from our database.|
|Section 4: Level 3 - Stored Procedures, Functions, Triggers and Cursors|
|We'll look at writing our first stored procedure using TransactSQL.|
|Here we look at 2 types of functions and how they are used within SQL Server.|
|Finally cursors, what they, why you use them and how you use them.|
|Section 5: Course Wrap-Up|
|Summary of what we covered.|
|Section 6: Bonus Section|
|We take a quick look at using dynamic SQL.|
|This is an example of using the PIVOT command.|
|Here we combine using dynamic SQL with the PIVOT command.|
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.