Enhance your skills with this beginner SQL course designed for analysts. Learn to create databases, manage data, and effectively communicate with developers.
This course is all about getting you comfy with SQL and Relational Databases, making you a superstar in your team! You'll practice creating databases, updating data, and writing queries the easy way. It's perfect for beginners—you'll get to learn at your own pace and have fun doing it!
Learn basic SQL so you can communicate better with DBAs and Developers, and increase your value as a team member.
This course teaches the principles of Relational Databases and the SQL language. It is intended for "Analysts". Knowledge of Relational Databases and SQL is one of the most valued technical skills an analyst can have. It will make you a more valued member of any team.
This course is suitable for a novice. I start by explaining how Relational Databases relate to your experience in the everyday world. When you have completed the course and exercises you will have created a database containing several related tables, updated the data they contain and written many queries which extract and summarise that data.
I teach using a mixture of lectures, demonstrations and exercises. You will learn by seeing, hearing and doing. With each step you build your knowledge using what you have learned already. An on-line course sets you free to work at your own pace and to review and revisit earlier material, even after you have completed the course.
By the end of the course you will have created databases, containing several tables and associated objects.
You will have added, updated and deleted data in those tables.
You will have created report queries which retrieve and manipulate that data.
6 Lectures
5 Lectures
4 Lectures
7 Lectures
4 Lectures
2 Lectures
5 Lectures
4 Lectures
4 Lectures
4 Lectures
5 Lectures
3 Lectures
3 Lectures
I'm Tom Gillies and I have been a Business and Technical Analyst in the Information Technology industry for the past thirty years. My courses are based on my real-world experiences. I am teaching as I wish I had been taught. My objective is to give you enough knowledge to make you reasonably self-sufficient, and enough experience to give you reasonable...
very good for educational purpose..thank you
Awesome teaching
It was a good course
Yes, clear and straight to the point and good illustration.
Very slow moving and the example is entirely too simple for what a database is.
Good explainations, repeating task and lectures meant that items are memorised. Logical themes .
This course teaches the principles, not just 'this is how you use it.'
A good foundation course for SQL. Though there are sections like DCL could have been elaborated more with demonstrations Eg. Create Statement, backup and restore functions.
Over all at a minimal cost one gains good amount of querying knowledge through this course.
Very well organized, very interesting, sets the stage for what we will be doing.
Your email address will not be published. Required fields are marked *
Arsalan S.
because, it explained everything except where to take the data from
as i am on primary level.