In this course, you will learn about: basic queries and joins, data definition language (DDL), and data manipulation language (DML), maintaining tables, and using stored procedures, along with basic database security.
This is the third course in the SQL series. In this class you will learn how programming objects work in SQL Server and tackle key topics such as error handling.
In this course, participants will create reports by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, charting data, and preparing reports for printing and exporting.
In this course, participants will create reports by connecting to a database and manipulate the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, charting data, and preparing reports for printing and exporting.