- 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
- 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.
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:
- Fundamentals of Developing Queries for Microsoft SQL Server
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Data and Functions
- Using DML to Modify Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Fundamentals of Developing Subqueries
- Using Table Expressions
- Using Set Operators
- 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]-->
<!--[endif]-->
Please enquire our Consultants for more information
- 0 Reviews
- 0 Students
- 17 Courses
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.
Write a public review