709 Courses

Give a compliment to your career and take it to the next level. This SQL (Structured Query Language) will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this coursewill help you keep ahead of the pack. The course incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this SQL (Structured Query Language) will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the SQL (Structured Query Language), you can equip yourself with the essentials to keep you afloat into the competition. Along with this SQL (Structured Query Language) course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This Bundle Consists of the following Premium courses: Course 01: SQL Server for Beginners Course 02: Microsoft SQL Server Development for Everyone Course 03: Python for Data Analysis Course 04: Coding with HTML, CSS, & JavaScript Course 05: Modern Web Designing - Level 2 Course 06: Diploma in PHP Web Development Course 07: Front End Web Development Diploma Course 08: Secure Programming of Web Applications Course 09: Linux for Absolute Beginners! Course 10: Ethical Hacking Course 11: Creativity and Problem Solving Skills So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this SQL (Structured Query Language): One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills 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 (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum of the Bundle Course 01: SQL Server for Beginners Introduction Setup Basic queries Security MSSQL and different drivers Files General Course 02: Microsoft SQL Server Development for Everyone Introduction Manipulating Tables and Data Relationships Foreign Keys Group By and Aggregate Functions Advanced Server Objects and Concepts Course 03: Python for Data Analysis Welcome, Course Introduction & overview, and Environment set-up Python Essentials Python for Data Analysis using NumPy Python for Data Analysis using Pandas Python for Data Visualization using matplotlib Python for Data Visualization using Seaborn Python for Data Visualization using pandas Python for interactive & geographical plotting using Plotly and Cufflinks Capstone Project - Python for Data Analysis & Visualization Python for Machine Learning (ML) - scikit-learn - Linear Regression Model Python for Machine Learning - scikit-learn - Logistic Regression Model Python for Machine Learning - scikit-learn - K Nearest Neighbors Python for Machine Learning - scikit-learn - Decision Tree and Random Forests Python for Machine Learning - scikit-learn -Support Vector Machines (SVMs) Python for Machine Learning - scikit-learn - K Means Clustering Python for Machine Learning - scikit-learn - Principal Component Analysis (PCA) Recommender Systems with Python - (Additional Topic) Python for Natural Language Processing (NLP) - NLTK - (Additional Topic) Course 04: Coding with HTML, CSS, & Javascript Welcome HTML 5 CSS 3 Bootstrap Project 1 - Design a Landing Page Project 2 - Business Website SProject 3 - Portfolio Course 05: Modern Web Designing - Level 2 Module: 01 1.1 Intro 1.2 Install the Tools and Get Started Module: 02 2.1 Intro to HTML 2.2 What is HTML 2.3 Start a New HTML File & Use Tags 2.4 Header Tags 2.5 Edit Text 2.6 Links 2.7 Images 2.8 Lists 2.9 Challenge 2.10 HTML Outro Module: 03 3.1 CSS Intro 3.2 Add CSS Styles 3.3 Classes and IDs 3.4 Borders 3.5 Sizing 3.6 Padding and Margin 3.7 Text Styles 3.8 DIVs 3.9 Postioning 3.10 Hover 3.11 Easily Center Elements 3.12 Fonts 3.13 Challenge 3.14 CSS Outro Module: 04 4.1 Intro to Bootstrap 4.2 Install Bootstrap 4.3 Indenting and Containers 4.4 The Grid System 4.5 Images 4.6 Buttons 4.7 Challenge 4.8 Bootstrap Outro Module: 05 5.1 Landing Page Intro 5.2 Sketch Your Landing Page 5.3 The Top Section 5.4 Polish the Top Section 5.5 Adding Images 5.6 The Main Points Section 5.7 Collecting Emails With an Opt-In Form 5.8 Challenge 5.9 Landing Page Outro Module: 06 6.1 Business Site Intro 6.2 Sketch Up 6.3 Using Fancy Font Logo 6.4 Carousel Basics 6.5 Carousel Extras 6.6 Text on Images 6.7 Phone Number Icon 6.8 Google Maps 6.9 Font Awesome 6.10 Challenge 6.11 Business Site Outro Module: 07 7.1 Intro 7.2 Portfolio Sketch 7.3 Jumbotron 7.4 Nav Bar 7.5 Panels 7.6 Challenge 7.7 Portfolio Outre Module: 08 8.1 Hosting 8.2 Bluehost 8.3 Uploading 8.4 Tips 8.5 Hosting Outro Course 06: Diploma in PHP Web Development Unit 01: Introduction Unit 02: Environment Configuration Unit 03: PHP Basics and Syntax Unit 04: PHP Forms and MySQL and User Authentication Course 07: Front End Web Development Diploma Welcome to the course! Web Development Basics - HTML Advanced HTML Concepts Introduction to Cascading Style Sheets (CSS) Advanced CSS JavaScript for Begeinners More JavaScript Concepts Getting Started with jQuery More jQuery Bootstrap Basics Project #2 - Pipboy from Fallout 4 Project #3 - Google Chrome Extension BONUS - Coding Another Google Chrome Extension Course 08: Secure Programming of Web Applications Section 01: Introduction Section 02: Well-known Vulnerabilities and Secure Programming Section 03: Conclusion and Summary Course 09: Linux for Absolute Beginners! Introduction to Linux Linux Installation Linux Command Line Interface (CLI) Essentials Advanced CLI Usage Linux Development Tools Web Development Project Web Server Setup, Host Cofiguration and App Deployment Linux User Management Linux Network Administration Course 10: Ethical Hacking Introduction to Ethical Hacking Reconnaissance - Surveying the Attack Surface Scanning and Enumeration - Getting Down to Business Network Presence Attacking Web Hacking Social Engineering - Hacking Humans Course 11: Creativity and Problem Solving Skills Getting Started The Problem Solving Method Information Gathering Problem Definition Preparing for Brainstorming Generating Solutions (I) Generating Solutions (II) Analyzing Solutions Selecting a Solution Planning Your Next Steps Recording Lessons Learned CPD 135 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this SQL (Structured Query Language) bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our SQL (Structured Query Language) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (SQL Server for Beginners) 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.

Are you ready to embark on an enlightening journey of wisdom with the SQL bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - SQL Programming. Delve into eight immersive CPD Accredited courses, each a standalone course: The Complete SQL from Scratch: Bootcamp The Complete MySQL Server from Scratch: Bootcamp SQL for Data Science, Data Analytics and Data Visualization Python Programming from Scratch with My SQL Database Building Web Applications with Django and PostgreSQL Ultimate PHP & MySQL Web Development Course & OOP Coding Programming AutoCAD with SQL Server Database Using C# Microsoft SQL Server Development for Everyone! Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the SQL Programming bundle illuminate your path to wisdom. The SQL Programming bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the SQL Programming package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the SQL bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the SQL Programming community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the SQL bundle. Establish robust bases across each course nestled within the SQL bundle. Decipher intricate concepts through the articulate content of the SQL bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the SQL bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The SQL bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the SQL bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The SQL bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the SQL bundle allows learners to make meaningful contributions to their chosen fields. Embark on the SQL journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the SQL bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the SQL bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

SQL Azure is Microsoft's cloud database service. Based on SQL Server database technology and built on Microsoft's Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change.  This Azure - SQL focuses primarily on Azure SQL Database as a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software. Learn how to deploy relational and non-relational databases in the cloud and explore the breadth of Azure's data services, from a single database instance to a massive scale data warehouse for working with Big data. You'll gain an understanding of how to configure firewall rules, manage log-ins and users, as well as roles and permissions, perform a database restore, and generally secure an Azure SQL database. Finally, you'll be introduced to Azure SQL Data Warehouse, a fully managed and scalable cloud service, that is compatible with other Azure offerings, such as Machine Learning and Data Factory, as well as existing SQL Server tools. What Will I Learn? Overview and provision Azure SQL Connect to Azure SQL DB and Migrate DB to Azure Work with SQL security and metrics Configure SQL DB auditing Copy and export a database Use DB Self-Service Restore and SQL DB Geo-Replication Who is the target audience? Students wanting an understanding of Azure SQL and to build their skills. Requirements Basic understanding of Azure and SQL concepts Introduction Introduction FREE 00:02:00 Azure SQL Azure SQL 00:02:00 Provisioning Azure SQL 00:06:00 Connecting to Azure SQL DB 00:08:00 Migrating to Azure DB 00:06:00 Understanding SQL Security 00:03:00 Understanding SQL DB Metrics and Auditing 00:05:00 Backing Up and Protecting your Database 00:05:00 Using SQL DB Geo-Replication 00:03:00 Conclusion Course Recap 00:02:00 Course Certification

**Trust The 35000+ Students Who Are Learning with Us & Kick Starting Their Career!** Deal Price is Active; Save Now- £405! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Basic Microsoft SQL Server Course might help you get there! Expand your expertise with high-quality training - study the Basic Microsoft SQL Server and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Basic Microsoft SQL Server online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this training course in around 4 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The Basic Microsoft SQL Server course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this Basic Microsoft SQL Server course. With this comprehensive Basic Microsoft SQL Server course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with this program. Learning Outcomes of Basic Microsoft SQL Server: Instant access to verified and reliable information Participation in inventive and interactive training exercises Quick assessment and guidance for all subjects CPD accreditation for proof of acquired skills and knowledge Freedom to study in any location and at a pace that suits you Expert support from dedicated tutors committed to online learning Why Prefer thisBasic Microsoft SQL Server Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Basic Microsoft SQL Server course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this Basic Microsoft SQL Server course and take a step toward a brighter future! ****Course Curriculum**** ***Basic Microsoft SQL Server*** Introduction Introduction Setup SQL server setup SQL server management studio setup Databases and tables Basic queries INSERT SELECT UPDATE DELETE Filter and sort Variables Logic Security Authentication Connection strings Vulnerability assessment MSSQL an different drivers Stored procedure Example: attendee registry c# Python Files File table Stored procedures General Functions Import data Export data Jobs Backup Database email Job notifications Assessment Process Once you have completed all the modules in the Basic Microsoft SQL Server course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Show off Your New Skills with a Certification of Completion The learners have to complete the assessment of this Basic Microsoft SQL Server course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.

The innovative SQL Queries for Beginner has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.  This popular SQL Queries for Beginner has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique SQL Queries for Beginner course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The SQL Queries for Beginner is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the SQL Queries for Beginner consists of a range of educational modules that allow study sessions to be organised at any time and any place. When the final assessment of the SQL Queries for Beginner has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the SQL Queries for Beginner course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the SQL Queries for Beginner has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

This video course will teach you the basics of Structured Query Language (SQL), such as writing SQL queries, creating and updating tables, and importing and exporting data from comma separated values (CSV) and Excel files. You'll also learn about the SQL and database skills you need to become a self-sufficient digital analyst or marketer who can extract marketing data from the backend without assistance.

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. SQL for Data Analytic - Beginner Level Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 SQL for Data Analytic - Intermediate Level Module: 07 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 08 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 09 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 10 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 11 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 12 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 13 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 14 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 15 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 SQL for Data Analytic - Advanced Level Module: 16 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 17 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 18 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 19 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00

“Master SQL programming and database management with MySQL. Learn to create, manage, and analyze data with SQL’s powerful tools in this comprehensive online course.”

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.