This course helps you master SQL with a focus on Microsoft SQL Server, starting from the basics up to advanced techniques, making it perfect for anyone looking to handle business data more effectively.
SQL: Now learn key SQL skills with SQL Server to boost your career and/or make you more productive in your current job
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.
Construct SQL queries to retrieve data
Understand how relational databases work
Harness the power of Microsoft SQL Server
6 Lectures
7 Lectures
7 Lectures
4 Lectures
1 Lectures
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...
Good quick overview of concepts and functionality.
Some exercises and elaboration on best practices and use cases would be good.
Eg. How run efficient queries, how to write good syntax/layout, Where and why subqueries and views are used, Good practices on update and insert and delete with actual production and analytic DBs,
Real examples of where stored procedures, custom functions, triggers and cursors are used - in Production Apps and BI/analytic enviroments.
The course was good, but instructor should slow down and not flip through the screens quickly. I spend a lot of tine scrolling back to see a step that I didn't catch on to.
Many great hands-on examples of the various T-SQL functions even if this course is a bit old. The connection to the remote server for testing is still working as of this writing.
The only things I miss are more focus on best practice conventions when writing SQL, and when to use the different functions (especially missing in Section 4).
All in all the course delivers what's promised: many hands-on examples to see various functions of T-SQL in action.
There is not a lot of explanation regarding the queries, this course just jumps to using databases, should explain a bit more the beginning of a query and what to look for in a database to construct the query
Lots of very good information with clear and concise examples.
Getting hold of the db is a pain, so that's the reason for 4.5 and not 5
Outdated and not working.
Link not working for adventure file redirected
I felt like the course, particularly being titled as "beginner", moved faster than it should on a few portions that should take longer to explain so that the student feels more comfortable with. In that sense, I think the instructor assumed some portions of the information as known in a shorter time span than it should. Specifically, I believe that the JOIN portion and the aliases should have more time on the board, as well as the sub-queries.
Your email address will not be published. Required fields are marked *
Prasad A.
Sound is an issue. Had a difficult time listening to the tutor.