Whether you use SQL Server, Oracle, MySQL, SQLLite, PostgreSQL, or another relational database you need to know how to use Structured Query Language (SQL). In this course you are guided step-by-step to building SQL to read, order, filter, and modify data in a relational database. The course also shows you how to aggregate data, build subqueries, join two or more tables, and group data. You also learn to create stored procedures, user-defined functions, and views. The most widely used date, math, string, conversion, and JSON manipulation functions are also covered. Several methods of importing and exporting data into and out of a database are illustrated. Finally, you learn the basics of query optimization using built-in tools, indexes, and writing efficient queries. Throughout the course you are provided with the best practices of how these apply to application development.
Developer Courses
I have been training developers for over 30 years and my "From Zero to ..." courses have been very popular with developers over the years. I am available to teach these courses either live on-site or live via a web conference. The list below contains a list of my set of courses that I can teach to you and your team. I have several more specialized topics, so if you don't see what you are looking for, please contact me and ask. I may be able to accommodate you.
Courseware Licensing
All of my courseware is available for licensing by training companies. Contact me for more information.
Total Courses: 1