Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database.

This is a hands-on course which will take you from installing SQL Server 2016 to learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL. The course covers most of the requirements to take Microsoft's certification (98-364), the Microsoft Technology Associate. During each meeting, you will be assessed for your knowledge, competency and proficiency in SQL.

This course is an introduction to SQL. It teaches you how to query or update data in a relational database management system (RDBMS). In this class, you learn the concepts of relational databases and the powerful SQL programming language, all in a practical and hands-on environment. Learn to:

• Run complex queries to retrieve data from multiple tables

• Run data manipulation language (DML) statements to update data in a database

• Run data definition language (DDL) statements to create and manage schema objects

• Identify the major components of Oracle Database and MySQL database

• Retrieve row and column data from tables with the SELECT statement

• Create reports of sorted and restricted data

• Employ SQL functions to generate and retrieve customized data

Benefits to you: This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. You can use SQL Developer to access an Oracle database or MySQL Workbench to access a MySQL database. You can also experience using SQL*Plus to access an Oracle database or MySQL command-line client to access a MySQL database. You will see SQL statements that are identical in both Oracle database and MySQL database, and also see the variations in output or syntax between the databases in some statements.