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.
If you are a programmer or a budding database administrator, you need to know SQL Server. SQL Server is one of the most popular database systems in use today. This course teaches what you need to know in order to efficiently create a database design to support online transaction processing (OLTP) applications. You learn the T-SQL language to create database tables and other objects and to retrieve and modify data.