Developing Queries with Microsoft SQL Sever

Job focused training - This instructor-led 2 days or 4 evenings training course provides delegates with the technical skills needed to write basic Transact-SQL (T-SQL) queries with Microsoft SQL Server and SQL Server Management Studio (SSMS) as an input into a Machine Learning modelling process.

Beginner 0(0 Ratings) 0 Students enrolled
Created by PAIRVIEW LIMITED Last updated Thu, 24-Jun-2021 English
What will i learn?
  • At the end of this course, you will be able to: Describe the basic architecture and concepts of Microsoft SQL Server 2019
  • Understand the similarities and differences between Transact-SQL and other computer languages
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Achieve Certificate in Developing Queries with Microsoft SQL Server upon completion of the course

Webinar Details
Date: 13 Jul, 2021 10:00:00 AM
  • Basic working knowledge of Windows operating systems and Microsoft Office.
  • Loving to work with numbers and aspiring to build a career in Business Analytics.
  • An academic background related to numeracy, technology, science, or economics is advisable
  • An education background in business studies, administration and management is also suitable.
+ View more

This course is the foundation for all SQL Server-related disciplines including Database Administration, Database Development and Business Intelligence. This course is suitable to professionals who are working or aim to work in data- or analytics-related roles in such departments as Marketing, Customer Insight, Business Intelligence, IT, Finance and so on.

Course Curriculum:

  1. Fundamentals of Developing Queries for Microsoft SQL Server 
  2. Introduction to T-SQL Querying  
  3. Writing SELECT Queries  
  4. Querying Multiple Tables
  5. Sorting and Filtering Data   
  6. Data and Functions 
  7. Using DML to Modify Data   
  8. Using Built-In Functions  
  9. Grouping and Aggregating Data    
  10. Fundamentals of Developing Subqueries 
  11. Using Table Expressions
  12. Using Set Operators   
  13. Using Window Ranking, Offset and Aggregate Functions

Training Deliver Method:

  • Virtual Classroom Platform (Online) - Daytime: 9:30am - 4:30pm (2 Full Days), or Evening: 6:30pm - 9:30pm (4 Half Days).
  • (Compulsory) Course Assignments: 10-15 Days

Additional Services Related To This Course (available for signing up)

  • (Optional) Hands-on Work Experience: Acquire work experience by undertaking real-life projects. Delegates will be able to work on some of the most popular problems businesses across industry sectors are facing and need urgent solutions.
  • (Optional) Career Support: Our optional Career Support Package will give you a further leverage to get to your dream job and achieve your career ambition in the shortest time. The Package including CV Surgery and Interview Consultancy is available for subscription as an additional service to this training programme.

<!--[if !supportLineBreakNewLine]-->

Please enquire our Consultants for more information

+ View more
Other related courses
04:20:18 Hours
5 5 ₦5,000
00:00:00 Hours
Updated Mon, 28-Jun-2021
0 0 ₦5,000
01:46:28 Hours
0 4 ₦5,000
03:59:03 Hours
0 4 ₦5,000
06:00:12 Hours
0 0 ₦5,000
About the instructor
  • 0 Reviews
  • 0 Students
  • 17 Courses
+ View more

Pairview was established in 2009 as a business analytics consultancy and technology training company. Pairview is headquartered in London and rapidly expanding across the EMEA region. Pairview drives big data, analytics, and performance innovation within organisations through its range of products and services. Pairview works alongside businesses as a trusted partner, enhancing expertise, closing skills gaps and developing their Analytics Centre of Excellence to drive improvements to productivity, profitability and business growth. We also work with ambitious individuals to transform their careers by offering highly specialised training programmes and recruitment services in data and analytics.

We take pride in having a strong team of industry experts and certified technology specialists who are thought leaders in digital and analytical transformation and have extensive experience in major industry sectors including banking, financial services, insurance, telecommunications, energy, business services, and so on. Our expert knowledge, flexibility, and tailored supportive approach sets us apart in our quest to offer the highest quality services to our clients.

Student feedback
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Buy now
  • Full lifetime access
  • Certificate of completion
  • Compare this course with another