Loading Events

« All Events

  • This event has passed.

SQL Query: Fundamentals/Advanced

March 11 @ 8:30 am - March 12 @ 4:00 pm

| $795.00

SQL: Fundamentals of Querying

During this course, students will connect to a database, query the database, modify the query and then save and execute the saved query. You will search using a simple condition; compare column values, search using multiple conditions, search for a range of values and null values and retrieve data based on patterns. Perform date calculations, calculate other data and manipulate string values. Sort and group data; filter the grouped data and summarize grouped data. Combine results of two queries; retrieve data by joining tables, check for unmatched records, and retrieve information from a table using joins. Customize and save the query result and generate an HTML report.

SQL: Advanced

During this Advanced level the student will s earch based on an unknown value and on multiple unknown values. Compare a value with unknown values. Search based on the existence of records. Generate output using correlated subqueries. Filter grouped data within subqueries. Perform multiple-level subqueries. Insert, modify and delet data. Create a simple table and a table with constraints. Add or drop table columns. Add or drop constraints. Modify the column definition and delete tables. Create a view, manipulate data in views and modify and drop views. Create and drop indexes. Rollback transactions and commit transactions.

Register for this Class Now!

Details

Start:
March 11 @ 8:30 am
End:
March 12 @ 4:00 pm
Cost:
$795.00

Venue

DCG
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Phone:
630.717.8400
Website:
dcg-inc.com

Organizer

DCG