A large portion of the world's information is stored in databases. SQL (or Structured Query Language) is an extremely powerful programming language that can be used to communicate with and manipulating data within databases. An understanding about databases as well as SQL is essential for anyone looking to pursue an occupation with Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence. The goal for this class is to assist you acquire and apply the basic and intermediate understanding about the SQL language and to become acquainted with a variety of related database (RDBMS) concepts throughout the course. The course will begin by performing the basic Create, Read, Update and delete (CRUD) operations with CREATE, SELECT, INSTERT UPDATE, DELETE and CREATE statements. Then, you will learn how to filter, arrange, sort and then aggregate data. You will use functions, execute sub-selects and queries that are nested, and JOIN data from multiple tables. Additionally, you will work with VIEWS as well as transactions, and also develop stored procedure. The focus of the course lies on practical, real-world learning. In this way, you'll be working with real databases and tools and work with real-world data. You will build an instance of a database in the cloud. Through an array of hands-on exercises you will learn to build as well as running SQL queries. After the course, you'll use and demonstrate your knowledge through a final project. The SQL abilities you acquire during this course are useful for a range of RDBMSes like MySQL, PostgreSQL, IBM Db2, Oracle, SQL Server, and many more. A basic understanding about databases SQL or programming skills is necessary, but some basic knowledge of data literacy is helpful.
