While it's important to understand that your database system will have a unique set of features and usages, this course aims to prepare you by providing a solid foundation in standard SQL.
This course covers standard SQL, so that you're well prepared for whatever environment you'll be using. The syntax used by your system may vary from the standard, and some standard features may be missing, and other non-standard features may be common practice.
Most database systems predate the standard by many years, they may need to support a lot of non-standard legacy code. Keep in mind that other database systems will be different. SQLite comes pre-installed on most platforms including most web servers, mobile devices, and even most desktop operating systems, and the entire database is stored in a single cross-platform file. SQLite follows the standard more closely than most other database systems. SQLite is likely different from your database system and that's okay, every database system is different and each has their own variations of SQL. This course uses SQLite for all the demonstrations. Beginning with a brief introduction, instructor Bill Weinman teaches the major features of SQL he offers a solid working knowledge of the language, and how to retrieve and manage data efficiently. Some of these variations deviate from the standard. SQL Essential Training is designed to help users understand the most common language for database wranglingSQL. Because most modern database systems were developed before SQL was standardized, each system tends to use variations of the language. The goal of this course is to provide you with the basic knowledge that you need to use standard SQL in your applications.