Master SQL fundamentals by building a hardware store database. Ideal for beginners, this online course covers queries, stored procedures, and more.
This course is all about diving into SQL basics while you create a mock database for a hardware store. You'll get your hands dirty with practical examples, videos, and loads of PDF resources to help you understand everything clearly.
Learn the fundamentals of SQL as you build a database for a fictitious hardware store
Learn the fundamentals of SQL for beginners as you build a database for a fictitious hardware store, covering customers, and stock and orders in this online SQL training course. Follow the real-time videos to see exactly how to build a complex database and the methods used to extract meaningful information via queries, stored procedures, scalar functions and views. 60+ pages of step by step PDF documentation complements the online sql training course, which can be done with either the full or FREE Express version of Microsoft SQL Server 2008 or 2012.
Written by a senior SQL developer at a major global company, the online SQL training course is based on practices used on a daily basis, rather than classroom theory. This is the ideal SQL training course for beginners (with some database experience) or if you need to learn SQL for a job interview in a short space of time, or need practical examples of a SQL database in use.
By the end of this course you will be able to build SQL databases and create Stored Procedures, Foreign Key Relationships, Insert Statements, Joins & Diagrams, Queries With Aggregate Functions, work with Scalar and Inline Table Functions.
2 Lectures
6 Lectures
1 Lectures
Boolean Logical was set up with the aim to provide software training based on practices used on a daily basis, rather than classroom theory. Nick Ioannou, one of the founding directors has over 20 years IT experience, in multimedia, training and systems support. Nick's IT Tips blog features over 500 posts of free software and advice.
Best class so far teaching SQL. Easy to understand.
It was amazing.Thank you for the opportunity
Lectures are not good for beginners
IT'S VERY GOOD, THOUGH NOT YET UNDERSTOOD. IT'S VERY CONFUSING. THE INSTRUCTOR SHOULD SLOW THE SPEED A BIT
The presenter speaks clearly and at a perfect pace. Also, having the entire lesson in downloadable pdf files is extremely helpful.
Im Learning a lo from this course, very helpful. Instructions are clear.
Les démonstrations sont beaucoup trop rapides et les commandes sont rarement bien expliquées. Il explique la raison d'une commande mais il n'explique pas vraiment chaque fonction utilisée alors difficile d'appliquer ses exemples dans un autre contexte.
Needs to define the terms
NA
Your email address will not be published. Required fields are marked *
Rbanfi
It's good for practice but it doesn't explain the theory of the basic concepts