735 SQL courses delivered Online

Advance your data skills by mastering Spark programming in Python. This beginner's level course will help you understand the core concepts related to Apache Spark 3 and provide you with knowledge of applying those concepts to build data engineering solutions.

Duration 2 Days 12 CPD hours This course is intended for This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases Overview This course is designed to teach you how to: Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. Implement Db2 Self Tuning Memory management for specific database memory areas. This course is designed to teach you how to Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. Implement Db2 Self Tuning Memory management for specific database memory areas. Course Outline Advanced Monitoring Db2 Table Space Management Db2 Database Memory Management Database rebuild supportDb2 database and tablespace relocation Db2 Incremental Backup Additional course details: Nexus Humans CL464G IBM Db2 11.1 Advanced Database Administration 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 CL464G IBM Db2 11.1 Advanced Database Administration 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.

Are you tired of companies making decisions that seem to have no rhyme or reason? Do you want to be part of the solution? Introducing our Business Intelligence Analyst course - designed to equip you with the skills and knowledge to help businesses make better decisions. Learning Outcomes: Upon completion of the Business Intelligence Analysts course, you can expect to: Gain a comprehensive understanding of business intelligence principles and concepts. Develop the ability to analyse real-time data for informed decision-making. Acquire the fundamentals of statistics and data science to drive actionable insights. Master the basics of SQL for efficient data manipulation and analysis. Learn essential techniques for effective database management. Explore data warehouse concepts and their role in business intelligence. In today's fast-paced business landscape, data is king. The ability to harness and analyse data effectively has become a crucial skill for professionals looking to make a significant impact. Our comprehensive Business Intelligence Analyst course is designed to equip you with the knowledge and expertise to drive better decision-making within organisations. Through a series of engaging and practical modules, you'll embark on a journey to unlock the power of business intelligence. From understanding the fundamentals and concepts to discovering real-time data analysis techniques, you'll gain invaluable insights into the world of data-driven decision-making. Our Business Intelligence Analysts course takes a deep dive into statistics and data science, arming you with the necessary knowledge to extract meaningful insights from complex datasets. You'll also learn the fundamentals of SQL, enabling you to manipulate and analyse data efficiently. Database management essentials and data warehouse concepts will further enhance your understanding of the role data plays in business intelligence. Enrol right now! Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The target audience for the Business Intelligence Analysts course is: Aspiring data analysts seeking to specialise in business intelligence. Professionals looking to enhance their decision-making abilities through data analysis. Managers and executives aiming to gain a deeper understanding of data-driven strategies. Entrepreneurs and business owners eager to leverage data for improved business outcomes. Career path This Business Intelligence Analysts course will help you to pursue a range of career paths, such as: Business Intelligence Analyst: £30,000 - £60,000 per annum Data Analyst: £25,000 - £45,000 per annum Business Analyst: £35,000 - £65,000 per annum Database Administrator: £30,000 - £55,000 per annum Data Scientist: £40,000 - £80,000 per annum Analytics Manager: £45,000 - £90,000 per annum

Duration 3 Days 18 CPD hours This course is intended for Anyone starting to write SAS programs Overview Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs. Access SAS, Microsoft Excel, and text data. Explore and validate data. Prepare data by subsetting rows and computing new columns. Analyze and report on data. Export data and results to Excel, PDF, and other formats. Use SQL in SAS to query and join tables. This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. Essentials The SAS programming process. Using SAS programming tools. Understanding SAS syntax. Accessing Data Understanding SAS data. Accessing data through libraries. Importing data into SAS. Exploring and Validating Data Exploring data. Filtering rows. Formatting columns. Sorting data and removing duplicates. Preparing Data Reading and filtering data. Computing new columns. Conditional processing. Analyzing and Reporting on Data Enhancing reports with titles, footnotes, and labels. Creating frequency reports. Creating summary statistics reports. Exporting Results Exporting data. Exporting reports. Using SQL in SAS Using Structured Query Language in SAS. Joining tables using SQL in SAS. Additional course details: Nexus Humans SAS Programming 1 - Essentials 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 SAS Programming 1 - Essentials 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.

***24 Hour Limited Time Flash Sale*** Level 2 Certificate in Understanding Coding Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Level 2 Certificate in Understanding Coding Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Level 2 Certificate in Understanding Coding bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Level 2 Certificate in Understanding Coding Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Level 2 Certificate in Understanding Coding Career Bundle: Course 01: Coding with Scratch Course 02: Coding with HTML, CSS, & Javascript Course 03: Python Programming for Everybody Course 04: Ultimate PHP & MySQL Web Development & OOP Coding Course 05: jQuery: JavaScript and AJAX Coding Bible Course 06: C++ Development: The Complete Coding Guide Course 07: HTML Web Development for Beginners Course 08: SQL Programming Masterclass Course 09: JavaScript Foundations for Everyone Course 10: Basic Node.JS Course 11: Master JavaScript with Data Visualization Course 12: Ionic & Angular JS: Mobile and Web Development Course 13: Building a TodoMVC Application in Vue, React and Angular Course 14: Encryption Course 15: Web Application Penetration Testing Course 16: Secure Programming of Web Applications - Developers and TPMs Course 17: Microsoft SQL Server Development for Everyone Course 18: The Complete MySQL Server from Scratch: Bootcamp Course 19: Bash Scripting, Linux and Shell Programming Course 20: JavaScript Project - Game Development with JS Course 21: R Programming for Data Science Course 22: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 23: CompTIA A+ (220-1002) Course 24: Cyber Security Awareness Training Course 25: Cyber Security Advanced Training Course 26: Cyber Security Incident Handling and Incident Response Course 27: Basics of Network Security Course 28: IT Support Technician Course 29: Functional Skills IT Course 30: Complete Windows 10 Troubleshooting for IT HelpDesk With a Level 2 Certificate in Understanding Coding, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Level 2 Certificate in Understanding Coding today and take the first step towards achieving your goals and dreams. Why buy this Level 2 Certificate in Understanding Coding? Free CPD Accredited Certificate upon completion of Level 2 Certificate in Understanding Coding Get a free student ID card with Level 2 Certificate in Understanding Coding Lifetime access to the Level 2 Certificate in Understanding Coding course materials Get instant access to this Level 2 Certificate in Understanding Coding course Learn Level 2 Certificate in Understanding Coding from anywhere in the world 24/7 tutor support with the Level 2 Certificate in Understanding Coding course. Start your learning journey straightaway with our Level 2 Certificate in Understanding Coding Training! Level 2 Certificate in Understanding Coding premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Level 2 Certificate in Understanding Coding is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Level 2 Certificate in Understanding Coding course. After passing the Level 2 Certificate in Understanding Coding exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Level 2 Certificate in Understanding Coding course is ideal for: Students seeking mastery in Level 2 Certificate in Understanding Coding Professionals seeking to enhance Level 2 Certificate in Understanding Coding skills Individuals looking for a Level 2 Certificate in Understanding Coding-related career. Anyone passionate about Level 2 Certificate in Understanding Coding Requirements This Level 2 Certificate in Understanding Coding doesn't require prior experience and is suitable for diverse learners. Career path This Level 2 Certificate in Understanding Coding bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Get ready for an exceptional online learning experience with the Big Data Analysis, Data Science, Fintech & Python for Data Analyst bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Big Data Analysis, Data Science, Fintech & Python for Data Analyst is a dynamic package, that blends the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Data Analysis package has something for everyone. As part of the Big Data Analysis, Data Science, Fintech & Python for Data Analyst package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Data Analysis bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This bundle comprises the following courses: CPD Quality Standards Courses: Big Data Analytics with PySpark Power BI and MongoDB Big Data Analytics with PySpark Tableau Desktop and MongoDB Building Big Data Pipelines with PySpark MongoDB and Bokeh Develop Big Data Pipelines with R & Sparklyr & Tableau Develop Big Data Pipelines with R, Sparklyr & Power BI Learn Python, JavaScript, and Microsoft SQL for Data Science SQL for Data Science, Data Analytics, and Data Visualization Excel Data Analysis Introduction to Data Analytics with Tableau Business and Data Analytics for Beginners Google Data Studio: Data Analytics Basic Data Analysis FinTech Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Data Analysis Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with Data Analysis. Build a strong knowledge base in your chosen course via Data Analysis. Benefit from the flexibility and convenience of online learning. With the Data Analysis package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Big Data Analysis, Data Science, Fintech & Python for Data Analyst, a rich anthology of 15 diverse courses. Each course in the Data Analysis bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisBig Data Analysis, Data Science, Fintech & Python for Data Analyst bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Big Data Analysis, Data Science, Fintech & Python for Data Analyst bundle offers you the flexibility and convenience to learn at your own pace. Make the Data Analysis package your trusted companion in your lifelong learning journey. CPD 35 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Big Data Analysis, Data Science, Fintech & Python for Data Analyst bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Big Data Analysis, Data Science, Fintech & Python for Data Analyst bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Data Analysis bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Unlock the potential of business intelligence with our specialized Business Intelligence Analyst Course. Learn to analyze data, extract insights, and drive strategic decisions to optimize business performance. Gain practical skills in data visualization, reporting, and predictive analytics using industry-leading tools and techniques. Whether you're a business professional or aspiring analyst, this course equips you with the expertise to excel in leveraging data for business intelligence.

Earn up to 100k as a 'coder' or Your 100% Money Back Did you know the UK tech sector is booming, with a projected 1.2 million job openings by 2025? The demand for skilled coders is soaring, with an average salary in the UK sitting comfortably above £51,000 annually, with some roles reaching over £100,000! Are you ready to join this exciting field and unlock your earning potential? This Coding Job Guarantee Programme equips you with the essential skills and knowledge sought after by employers. Our Coding Job Guarantee Programme is your all-in-one solution to learn coding from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job as a coder. By choosing our Coding Job Guarantee Programme, you're not just gaining skills; you're gaining a lifelong career partner. Our mission is simple - to be your trusted partner every step of the way, from training to employment. In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Programmers, so we can help you get your foot in the door. If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Coding Job Guarantee Programme today and start your journey to becoming a successful Coding Programmer! Why Choose Us? So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Certified Coding Job Guarantee Programme: Personalised Guidance: We believe in the power of individual attention. Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some Coding experience, we will guide you towards honing your skills and developing a strong foundation in Coding. One-On-One Consultation: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Coding field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Certified Coding Job Guarantee Programme. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Interview Preparation: No more stress over unexpected interview questions. We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Courses we will provide once you enrol in the program: Course 01: Coding with HTML, CSS, & Javascript Course 02: Python Programming for Everybody Course 03: Ultimate PHP & MySQL Web Development & OOP Coding Course 04: jQuery: JavaScript and AJAX Coding Bible Course 05: C++ Development: The Complete Coding Guide Course 06: HTML Web Development for Beginners Course 07: SQL Programming Masterclass Course 08: JavaScript Foundations for Everyone Course 09: Basic Node.JS Course 10: Master JavaScript with Data Visualization Course 11: Ionic & Angular JS: Mobile and Web Development Course 12: Building a TodoMVC Application in Vue, React and Angular Course 13: Encryption Course 14: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 15: CompTIA A+ (220-1002) Course 16: Web Application Penetration Testing Course 17: Secure Programming of Web Applications - Developers and TPMs Course 18: Microsoft SQL Server Development for Everyone Course 19: The Complete MySQL Server from Scratch: Bootcamp Course 20: Bash Scripting, Linux and Shell Programming Course 21: JavaScript Project - Game Development with JS Course 22: R Programming for Data Science Course 23: Cyber Security Awareness Training How Can We Offer Job Guarantees? HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector. The Coding Job Guarantee Programme is completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the Coding Job Guarantee Training program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied. After you enrol in the Program, you will get lifetime access to 23 Premium Courses related to Coding. These courses will teach you the knowledge and skills required to become a successful Coding Prgrammer. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing! Step 2: Initial One-On-One Counselling Session Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path. Step 3 - Certification upon Course Completion After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 4: CV Revamping Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the programming/development industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Step 5: Building Network and Submitting CV We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile. Step 6: Interview Preparation With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills. Step 7: Securing Job Interviews Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want. Step 8: Post-Interview Support Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job. Step 9: Celebrate Your New Job! Once you've secured your dream job in Coding, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role. We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful career in Coding begins with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Coding Job Guarantee Programme Course is suitable for: Beginners with no prior programming experience who are looking to enter the world of coding. Intermediate programmers who wish to expand their skills and explore Coding's extensive usage. IT professionals seeking to diversify their skill sets and stay relevant in today's tech-driven market. Data analysts and scientists who want to leverage PCoding's powerful libraries for their data processing needs. Students and recent graduates looking to enhance their employability in the thriving tech industry. Entrepreneurs who wish to understand and utilise Coding to automate tasks and analyse data for their businesses. Anyone with a keen interest in Coding and a desire to delve into its applications in diverse fields like web development, data science, machine learning, and more. Requirements No experience required. Just enrol & start learning. Career path This Coding Job Guarantee Programme will help you get a job in different roles, such as: Full-Stack Developer: £35,000 - £100,000 annually Front-End Developer: £25,000 - £70,000 annually PHP Developer: £30,000 - £80,000 annually JavaScript Developer: £30,000 - £90,000 annually C++ Software Engineer: £40,000 - £100,000 annually Cyber Security Analyst: £40,000 - £100,000 annually Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included Student ID Card Digital certificate - Included

Duration 5 Days 30 CPD hours This course is intended for This class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices. Targeted at: DBAs and Architects, and appropriate for Analysts, Support Engineers, and other IT professionals Overview Please refer to overview This is an immersive 5-day class that offers hands-on labs and combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration into a one-week class, with significant savings over list price. Upon course completion, you will be prepared to manage mission critical PostgreSQL installations, and perform core administration tasks with confidence and skill. Course Outline 1 - POSTGRES SYSTEM ARCHITECTURE 2 - INSTALLATION AND GETTING STARTED 3 - CONFIGURATION, CREATING, MANAGING DATABASES 4 - USER TOOLS ? USING PSQL 5 - GUI TOOLS - USING PGADMIN 4 6 - SECURITY BASICS 7 - SQL PRIME BACKUP AND RECOVERY 8 - ROUTINE MAINTENANCE 9 - POSTGRES DATA DICTIONARY 10 - MOVING DATA 11 - SQL TUNING 12 - PERFORMANCE TUNING 13 - STREAMING REPLICATION 14 - TABLE PARTITIONING 15 - EXTENSION MODULES 16 - MONITORING 17 - UPGRADING BEST PRACTICES

This course will help you explore the world of Big Data technologies and frameworks. You will develop skills that will help you to pick the right Big Data technology and framework for your job and build the confidence to design robust Big Data pipelines.