SQL Querying - Basic
Register ➥
In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.
This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.
|
Thu - Feb 4, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+sql-querying-basic.html
Fri - Feb 5, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
SQL Querying - Basic
Register ➥
In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.
This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.
|
Mon - Feb 15, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+sql-querying-basic.html
Tue - Feb 16, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
SQL Querying - Advanced
Register ➥
In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries.
This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.
|
Thu - Feb 18, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+advanced-sql-querying.html
Thu - Feb 18, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
MySQL Workbench: Data Modeling & Development
Register ➥
MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The course covers the interface and explains how to accomplish each step by illustrating best practices visually.
Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling.
Complete coverage Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances
|
Tue - Mar 2, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+mysql-administration-development.html
Fri - Mar 5, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
SQL Querying - Basic
Register ➥
In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.
This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.
|
Wed - Mar 3, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+sql-querying-basic.html
Thu - Mar 4, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
Administering Microsoft SQL Server 2012/14/16 Databases (70-462)
Register ➥
This course is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access.
This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.
Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.
|
Mon - Mar 8, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+sql-2012-70-462.html
Fri - Mar 12, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
Microsoft SQL Server 2012/14/16 Reporting Services (SSRS)
Register ➥
This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role.
In this course you will learn to: Plan for, install, configure, and customize SQL Server 2012 Reporting Services; Retrieve data with SELECT queries; Generate reports from the Report Wizard and from scratch; Enhance your reports with charts, images, gauges, and maps; Add value to reports through summarizing, totaling, and interactivity; Build reusable report templates; Embed Visual Basic, .NET functions and subreports into your reports; Enable end-user access to reports via the Report Server and its Report Manager web interface; Integrate SSRS reports with your own websites and custom applications
This course is taught with 2012 software, however, 2014 and 2016 users can attend due to the similarities.
Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.
|
Mon - Mar 8, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+sql-server-2012-ssrs.html
Fri - Mar 12, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
SQL Querying - Basic
Register ➥
In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.
This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.
|
Mon - Mar 15, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+sql-querying-basic.html
Tue - Mar 16, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
Querying Microsoft SQL Server 2012/14/16 (70-461)
Register ➥
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are seeking to prove their skills and knowledge in writing queries.
This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.
Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.
|
Mon - Mar 22, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+sql-2012-70-641.html
Fri - Mar 26, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
SQL Querying - Basic
Register ➥
In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.
This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.
|
Thu - Apr 1, 2021
|
Course Details: https://www.certstaff.com/trainingcatalog/course+id+sql-querying-basic.html
Fri - Apr 2, 2021
|
Certstaffix Training Your Home/Work, US
|
|
Live Online Remote Instructor |
|
|