96 Microsoft SQL Server courses

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites * Basic understanding of relational databases. * Basic Windows knowledge. MODULE 1: INTRODUCTION TO TRANSACT-SQL * What is Transact-SQL * The SELECT statement * The WHERE clause * Sorting results * Calculations * CASE expressions MODULE 2: JOINING TABLES WITH TRANSACT-SQL * The JOIN clause * Inner joins * Outer joins * Self joins and cross joins MODULE 3: FILTERING AND SORTING RESULTS * Implement the ORDER BY clause * Filter data with the WHERE clause * Limit the number of rows returned by a query * Implement NULL logic MODULE 4: SQL SERVER DATA TYPES * Understand data types * Implement string data types * Implement temporal data types MODULE 5: INSERTING, UPDATING AND DELETING DATA * Insert new records * Update existing records * Delete data MODULE 6: USING SQL SERVER FUNCTIONS WITH TRANSACT-SQL * Understand function types in SQL Server * Convert data using functions * Implement logical functions * Work with NULL data using functions MODULE 7: AGGREGATING DATA WITH TRANSACT-SQL * Implement aggregation in SQL Server * Group records in SQL Server * Filter aggregated data MODULE 8: IMPLEMENT SUBQUERIES WITH TRANSACT-SQL * Implement scalar and multi-valued sub-queries * Implement correlated subqueries * Implement existence checks with subqueries MODULE 9: CREATE QUERIES THAT USE TABLE EXPRESSIONS * Create views * Create table-valued functions * Implement derived tables * Implement common table expressions MODULE 10: USE UNION, INTERSECT, EXCEPT AND APPLY ON MULTIPLE SETS OF DATA * Write queries with the UNION operator * Write queries with the INTERSECT and EXCEPT operators * Write queries with the APPLY operator MODULE 11: IMPLEMENT WINDOW FUNCTIONS IN QUERIES * Understand window functions * Impement window functions MODULE 12: USE PIVOT AND GROUPING SETS IN QUERIES * Implement PIVOT in queries * Implement grouping sets in queries MODULE 13: USE STORED PROCEDURES IN QUERIES * Query data with stored procedures * Interact with stored procedures using input and output parameters * Write simple stored procedures * Pass dynamic SQL to SQL Server MODULE 14: IMPLEMENT PROGRAMMING FEATURES IN TRANSACT-SQL * Understand T-SQL programming elements * Implement loops and conditions in T-SQL queries MODULE 15: ADD ERROR HANDLING TO QUERIES * Understand SQL Server error handling * Implemet structured exception handling MODULE 16: USE TRANSACTIONS IN QUERIES * Understand database transactions * Implement transactions in T-SQL

In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. You will learn and explore various databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE * Two Approaches to SQL Programming * TSQL Data Retrieval in an Analytics / Business Intelligence Environment * The Database Engine * SQL Server Management Studio and the CarDeal Sample Database * Identifying Variables in Tables * SQL is a Declarative Language * Introduction to the SELECT Query * Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY * Turning Columns into Variables for Analysis * Column Expressions, Data Types, and Built-in Functions * Column aliases * Data type conversions * Built-in Scalar Functions * Table Aliases * The WHERE clause * ORDER BY * Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS * Primary Keys, Foreign Keys, and Joins * Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product * Understanding Joins, Part 2: The INNER JOIN * Understanding Joins, Part 3: The OUTER JOINS * Understanding Joins, Part 4: Joining more than two tables * Understanding Joins, Part 5: Combining INNER and OUTER JOINs * Combining JOIN Operations with WHERE and ORDER BY * Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY * Identifying required aggregation level and granularity * Aggregate Functions * GROUP BY * HAVING * Order of operations in SELECT queries * Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS * Non-correlated and correlated subqueries * Derived tables * Common table expressions * Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC * Views * Table-valued functions * Stored procedures * Creating objects for read-access users * Creating database accounts for analytical client tools * Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT * Connecting to SQL Server and Submitting Queries from Client Tools * Connecting and running SELECT queries from: * Excel * PowerBI * RStudio * Exporting datasets to files using * Results pane from SSMS * The bcp utility * The Import/Export Wizard * Lab 1: Getting Your Dataset to the Client ADDITIONAL COURSE DETAILS: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

SUPPORTING MICROSOFT SHAREPOINT COURSE DESCRIPTION A concise hands on course enabling delegates to manage and administer a SharePoint site. WHAT WILL YOU LEARN * Perform initial farm configuration. * Use stsadm commands. * Manage content. * Secure SharePoint. * Customise SharePoint search. * Monitor and performance tune SharePoint. SUPPORTING MICROSOFT SHAREPOINT SERVER COURSE DETAILS * Who will benefit: Anyone working with Microsoft SQL server * Prerequisites: SharePoint Administrators. * Duration 2 days SUPPORTING MICROSOFT SHAREPOINT COURSE CONTENTS * SharePoint Introduction A SharePoint installation. Initial farm configuration. Creating a site collection. * Administering SharePoint Stsadm commands, automation with PowerShell. * Managing content Lists, libraries, items and documents * Security SecureStore, Users and groups, roles and role assignments. Permission levels. * SharePoint search Configure search, refine search. * SharePoint performance Diagnostic logging, logging levels, Health anaylzer, performance bottlenecks.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for professional web developers who use Microsoft Visual Studio in an individual-based or team-based, small-sized to large development environment. Candidates for this course are interested in developing advanced web applications and want to manage the rendered HTML comprehensively. They want to create websites that separate the user interface, data access, and application logic. Overview Describe the Microsoft Web Technologies stack and select an appropriate technology to use to develop any given application. Design the architecture and implementation of a web application that will meet a set of functional requirements, user interface requirements, and address business models. Configure the pipeline of ASP.NET Core web applications using middleware, and leverage dependency injection across applications. Develop a web application that uses the ASP.NET Core routing engine to present friendly URLs and a logical navigation hierarchy to users. Create Views in an application that display and edit data and interact with Models and Controllers. Connect an ASP.NET Core application to a database using Entity Framework Core. Implement a consistent look and feel across an entire web application. Write JavaScript code that runs on the client-side and utilizes the jQuery script library to optimize the responsiveness of an web application. Add client side packages and configure Task Runners. Run unit tests and debugging tools against a web application in Visual Studio 2022. Write an application that authenticates and authorizes users to access content securely using Identity. Build an application that resists malicious attacks. Use caching to accelerate responses to user requests. Use SignalR to enable two-way communication between client and server. Describe what a Web API is and why developers might add a Web API to an application. Describe how to package and deploy an ASP.NET Core web application from a development computer to a web server. In this 5-day course, professional web developers will learn to develop advanced ASP.NET Core applications using .NET tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. MODULE 1: EXPLORING ASP.NET CORE * Introducing of Microsoft Web Technologies * Getting Started with Razor Pages in ASP.NET Core * Introducing ASP.NET Core MVC MODULE 2: DESIGNING ASP.NET CORE MVC WEB APPLICATIONS * Planning in the Project Design Phase * Designing Models, Controllers and Views MODULE 3: CONFIGURE MIDDLEWARE AND SERVICES IN ASP.NET CORE * Configuring Middlewares * Configuring Services MODULE 4: DEVELOPING CONTROLLERS * Writing Controllers and Actions * Configuring Routes * Writing Action Filters MODULE 5: DEVELOPING VIEWS * Creating Views with Razor Syntax * Using HTML Helpers and Tag Helpers * Reusing Code in Views MODULE 6: DEVELOPING MODELS * Creating MVC Models * Working with Forms * Validating User Input MODULE 7: USING ENTITY FRAMEWORK CORE IN ASP.NET CORE * Introduction to Entity Framework Core * Working with Entity Framework Core * Use Entity Framework Core to connect to Microsoft SQL Server MODULE 8: USING LAYOUTS, CSS AND JAVASCRIPT IN ASP.NET CORE * Using Layouts * Using CSS and JavaScript * Using JavaScript Libraries MODULE 9: CLIENT-SIDE DEVELOPMENT * Applying Styles and Responsive Design * Using Task Runners * Looking at ASP.NET Core Blazor MODULE 10: TESTING AND TROUBLESHOOTING * Testing ASP.NET Core Applications * Implementing an Exception Handling Strategy * Logging ASP.NET Core Applications MODULE 11: MANAGING SECURITY * Authentication in ASP.NET Core * Authorization in ASP.NET Core * Defending from Common Attack MODULE 12: PERFORMANCE AND COMMUNICATION IMPLEMENTING A CACHING STRATEGY * Managing State * Supporting Two-way Communication MODULE 13: IMPLEMENTING WEB APIS * Introducing Web APIs * Developing a Web API * Calling a Web API MODULE 14: HOSTING AND DEPLOYMENT * Hosting and Deploying On-premises * Deploying to Microsoft Azure * Looking at Microsoft Azure Fundamentals

Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.

Fall into Savings. Enjoy the biggest price fall this Autumn! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Database course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Database bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Database course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Database and help you along your learning journey. Advanced audio-visual learning modules of these Database courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Database, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Database Bundle Consists of the following Premium courses: * Course 01: Microsoft SQL Server Development for Everyone * Course 02: SQL Programming Masterclass * Course 03: SQL NoSQL Big Data and Hadoop * Course 04: Python Programming for Everybody * Course 05: Data Science with Python * Course 06: JavaScript Foundations for Everyone * Course 07: C# Programming - Beginner to Advanced * Course 08: R Programming for Data Science * Course 09: Three.js & WebGL 3D Programming Course for Beginners * Course 10: Basic Google Data Studio * Course 11: Data Analytics with Tableau * Course 12: Spatial Data Visualization and Machine Learning in Python Level 4 * Course 13: Cyber Security Incident Handling and Incident Response * Course 14: Learn Ethical Hacking From A-Z: Beginner To Expert Enrol now in Database to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Database expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Microsoft SQL Server Development for Everyone * Introduction * Manipulating Tables and Data * Relationships Foreign Keys * Group By and Aggregate Functions * Advanced SQL Server Objects and Concepts The detailed curriculum of the Database bundle is given in the resources section. How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. * PDF Certificate: Free (For The Title Course ) * Hard Copy Certificate: Free (For The Title Course ) CPD 160 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone from any background can enrol in this Database bundle. REQUIREMENTS Our Database course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. CAREER PATH Having this Database expertise will increase the value of your CV and open you up to multiple job sectors. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included CERTIFICATE OF COMPLETION Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

The easy way to store your data and retrieve it when you need it! Database training is vital for success if you want to work in the technology business. Companies are looking for experts who can use databases effectively and have a solid understanding of them. Our course can assist you in developing the skills and information required to flourish in the computer business. This well-designed course can teach you the fundamentals of database design, including creating and managing databases, manipulating data, and developing data-driven applications. You'll gain knowledge of several database types, including relational, object-oriented, distributed, and NoSQL. Along with measures to protect data security, you will learn about database performance and optimisation. Our course is a fantastic method to get started in the profession or obtain expertise for a present position. Many businesses are looking for candidates with good database knowledge and effective usage skills. You may differentiate yourself from the competition by enrolling in a course and gaining the skills and knowledge you need. Along with this Database Course, you will get 11 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. So, don't wait up. Enrol now! This Database Bundle Consists of the following Premium courses: Courses are included in this Database Bundle? * Course 01: Microsoft SQL Server Development for Everyone * Course 02: SQL Programming Masterclass * Course 03: SQL NoSQL Big Data and Hadoop * Course 04: Python Programming for Everybody * Course 05: Data Science with Python * Course 06: JavaScript Foundations for Everyone * Course 07: C# Programming - Beginner to Advanced * Course 08: R Programming for Data Science * Course 09: Three.js & WebGL 3D Programming Course for Beginners * Course 10: Basic Google Data Studio * Course 11: Data Analytics with Tableau Learning Outcomes * Have a fundamental understanding of database design, implementation, and upkeep. * Be able to query databases and learn the SQL language. * To preserve data, use security procedures and backup procedures. * Examine database performance and note any enhancements. * Be familiar with approaches for database normalisation and optimisation. * Create web services and database applications. * Use DBMS software for managing and storing data. * Identify technologies and trends in databases. These 11 courses cover programming and data science topics such as SQL, Python, JavaScript, C#, R, Three.js, WebGL, Google Data Studio, and Tableau. They teach skills in database management, data analysis, manipulation, visualization, and reporting for beginners to advanced learners. The bundle incorporates skills to shed some light on your way and boost your career. Hence, you can strengthen your Database Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: * PDF Certificate: Free (Previously it was £6*11 = £66) * Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 120 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? * Individuals interested in learning programming and data science skills * Professionals seeking to enhance their knowledge and skill set * Entrepreneurs or business owners wanting to understand and manage data effectively * Students or graduates in computer science, data science, or related fields * Anyone looking to start a career in programming or data science * Data analysts, data scientists, or data engineers looking to expand their skill set REQUIREMENTS There is no time limit for completing this course; it can be studied in your own time at your own pace. CAREER PATH People tend to pursue their careers in the following professions in the database sector * Database Administrator * Database Developer * Database Architect * Database Analyst * Database Designer The salary range for a Database Professional in the UK is typically between £25,000 and £50,000 per annum. CERTIFICATES CERTIFICATE OF COMPLETION Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Microsoft SQL Server Development for Everyone) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. CERTIFICATE OF COMPLETION Digital certificate - Included

In this course, you will learn C# programming for desktop applications. These lessons assume no prior knowledge of programming or the C# language and will have you up and running in no time. By the end of this course, you will have enough knowledge to build a functional Windows Forms application, connected to a Microsoft SQL Server database, with all your program code and changes being tracked on GitHub.

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. MODULE 1: INTRODUCTION TO DATABASES * Introduction to Relational Databases * Other Databases and Storage * Data Analysis * SQL Server Database Languages MODULE 2: DATA MODELING * Data Modelling * Designing a Database * Relationship Modeling MODULE 3: NORMALIZATION * Fundamentals of Normalization * Normal Form * Denormalization MODULE 4: RELATIONSHIPS * Introduction to Relationships * Planning Referential Integrity MODULE 5: PERFORMANCE * Indexing * Query Performance * Concurrency MODULE 6: DATABASE OBJECTS * Tables * Views * Stored Procedures, Triggers and Functions