Your Cart Is Empty
Desktop Applications >
SQL Querying >
SQL - Advanced Querying Training
This instructor-led SQL-Advanced Querying Training course will give you a more advanced understanding of the Transact-SQL language which is used by all SQL Server-related disciplines.
This one day instructor-led SQL Advanced Querying Training course will give you a more advanced understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.In the SQL - Advanced Querying course, you will create advanced SQL queries to manipulate and index tables. This course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
Upon successful completion of the SQL - Advanced Querying Training course, you will be able to: • Use subqueries to generate query output • Manipulate table data by inserting and updating records in a table and deleting records from a table • Manipulate the table structure • Create views, manipulate data through views, modify the view structure, and drop views • Create indices on table columns and drop inefficient indices • Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.
Lesson 1: Using Subqueries to Perform Advanced QueryingTopic 1A: Search Based on Unknown ValuesTopic 1B: Compare a Value with Unknown ValuesTopic 1C: Search Based on the Existence of RecordsTopic 1D: Generate Output Using Correlated SubqueriesTopic 1E: Filter Grouped Data Within SubqueriesTopic 1F: Perform Multiple‐Level SubqueriesLesson 2: Manipulating Table DataTopic 2A: Insert DataTopic 2B: Modify DataLesson 3: Manipulating the Table StructureTopic 3A: Create a Simple TableTopic 3B: Create a Table with ConstraintsTopic 3C: Add and Drop Table ColumnsTopic 3D: Add and Drop ConstraintsTopic 3E: Modify the Column DefinitionTopic 3F: Back Up TablesTopic 3G: Delete TablesLesson 4: Working with ViewsTopic 4A: Create a ViewTopic 4B: Manipulate Data in ViewsTopic 4C: Create AliasesTopic 4D: Modify and Drop Views
Lesson 5: Indexing DataTopic 5A: Create IndicesTopic 5B: Drop IndicesLesson 6: Managing TransactionsTopic 6A: Create TransactionsTopic 6B: Commit TransactionsAppendix A: Structure of the Bookstore Database
MCSA: SQL Server 2012/2014MCSA: SQL 2016 Database Development
To ensure your success, we recommend you first attend the following course, or have equivalent knowledge: • SQL - Fundamentals of Querying
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323